Column Descriptions in the Planned Maintenance Template

Column Name* (Format, Maximum number of Characters): Description of column

• Source* (Text, 50 max. characters): Should contain information about the requestor of the change, for example the person’s name or the name of the company and the department.
• woNumber (Text, 20 max. characters): A number assigned to the work order by the service provider (different than the Tracking Number).
• Caller (Text, 100 max. characters): Requestor of services. If keywords (ServiceID or revised) are used then caller field is updated with special value that can be reused for provider/trade/location combination (there are no time limits). (Note: ServiceID is standard part of IVR check in/out process and can be used by any provider/subscriber. It is 8 digit number with a leading zero [ex: 01234567].)
• AutoInvoice (Text, 3 max. characters): Type YES if the work order should be auto-invoiced, or NO if not.
• Trade* (Text, 50 maximum characters): The trade related to the work order.
• ProviderID* (Text, 10 max. characters): Each service provider is assigned a Provider ID. You can find the Provider ID for Service Providers in your network on the Providers page in the Admin module.
• ProviderName (Text, 100 max. characters): The name of the service provider.
• SubscriberID* (Text, 10 max. characters): Your assigned Subscriber ID. Contact your Account Executive for your Subscriber ID.)
• StoreID* (Text, 50 max. characters): Store Number assigned to the work order.
• Tax* (Numeric with 2 decimal places, 10 max. characters): The dollar amount of tax to be charged on the work order. (Note: When the PM Template is uploaded, the system will add Tax + Price to ensure the total cost does not exceed the NTE amount, as configured in Service Automation.)
• Price* (Numeric with 2 decimal places, 10 max characters): The cost of the work order, before taxes. (Note: When the PM Template is uploaded, the system will add Price + Tax to ensure the total cost does not exceed the NTE amount, as configured in Service Automation.)
• CallDate* (Date/Time, 20 max. characters): The start date of the service.
• ScheduledDate* (Date/Time, 20 max. characters): The scheduled time the service provider is expected to be on site. (Note: ScheduledDate must be present.)
• Description* (Text, 2000 max. characters): The explanation of the requested service.
• Status (Text, 50 max. characters): When left blank, the work orders are created with OPEN status. When “COMPLETED” is used, the work orders are created with the COMPLETED status and the completion date of today’s date. When a date is used (mm/dd/yyyy), the work orders are created with the COMPLETED status and the completed date of the date specified.
• AutoDispatch (Text, 5 max. characters): Enter TRUE (or leave blank) to notify the service provider of the work order. (Note: Work order notifications are dispatched at night; unlike a standard work order, which dispatches immediately).
• Category (Text, 30 max. characters): The category must be one of the existing categories for the subscriber, otherwise, the row will return an error. If left blank, the category “Maintenance” will be used.
• Priority* (Text, 30 max. characters): The priority must be one of the existing priorities for the subscriber. If left blank, the lowest available priority for the subscriber will be used.
• Quantity (Integer, 2 max. characters): Number of work orders to be created. If left blank, one work order will be created. Max quantity 30.
• Currency (Text, 3 max. characters): USD or CAD – for US or Canadian Dollars. If left blank, USD is assumed.
• Tax2 Type (Text, 3 max. characters): Used for Canadian Taxes. The values can be “PST”, “HST” or “QST”
• Tax2 (Numeric with 2 decimal places, 10 max. characters): The value for the Canadian Taxes.
• CallerIDMatch (Text, 5 max. characters): True/False. This flag will override the default for the subscriber. For example, if the subscriber requires a caller ID match for all work orders, but for this work order, no match is needed.
• AssetUpdateFlag (Text, 5 max. characters): True/False. When the flag is set to True, the provider will need to update the asset record for the location during the confirmation process.
• ExpirationDate* (Date/ Time, 20 max. characters): The Expiration Date of the work order. If left blank, the scheduled date becomes the expiration date. The work order must have both a scheduled and an expiration date; otherwise, the template returns an error.
• GracePeriod (Integer, 2 max. characters): Number of days after the expiration date the service provider is allowed to check into the work order.
• AutoComplete (Text, 5 max. characters/Numeric, 1 max. character): True/False. When the flag is set to TRUE, the work order will be autocompleted. (Note: You can type 1 instead of True, and 0 instead of False).
• PoNumber (Text, 20 max. characters): Work order PO Number.
• ExtendedStatus (Text, 50 max. characters): Extended Status (it will be verified if it’s valid for the main status)
• AutoApprovedBy (Text, 50 max. characters): If the auto-invoice flag is set to true/yes, this field can be used to indicate if the invoice should be auto-approved (value of this column: ex Tomasz P will go into approved by field on invoice record.
• Area (Text, 255 max. characters): Dashboard Area.
• ProblemType (Text, 256 max. characters): Dashboard Problem Type.
• Equipment (Text, 256 max. characters): Dashboard Equipment.
• ProblemCode (Text, 256 max. characters): Dashboard Problem Code.
• MasterTrackingNumber (Integer,     10 max. characters): Master Tracking Number to link/create a follow-up work order.
• ExtendedAreaName (text, up to 50 characters): Additional dashboard area (sub-area) — not validated upon upload.
• AdditionalFieldName (text, up to 50 characters): Additional dashboard field name, for example, Quantity.
• AdditionalFieldValue (text, up to 50 characters): Additional dashboard date to correspond to the field name, for example, 2 for Quantity.
• EquipmentTagID (Text, 50 max. characters): TagID from equipment module for given location and trade. It will also add equipment related info (physical area, tagID, ModelNo and SerialNo) to the problem description.
• ApprovalCode (Text, 40 max. characters): ApprovalCode that will be associated with newly created work order.
• Label: Allows you to add a 'tag' on all work orders generated through Planned Maintenance, so you can filter and sort them in the Work Order module.
• AdditionalApprovalCode (text, up to 50 characters): Additional Approval Code name as specified in your Admin settings. The code should be active, and its category should match the WO category.
• AdditionalApprovalCodeValue (text, up to 300 characters): Value for the required Additional Approval Code.