Handyman Import: Orders Back office order number Handyman internal order number 0=No,1=Delete order 0=Not invoiced, 1=partially invoiced, 2=Fully invoiced 1=Exclude order from invoicing, 0=Don't exclude 0=Don't reactivate, 1=reactivate order for defined participants, 2=reactivate order for all participant Only applies to passive orders. Participants to be reactivated must be specified if 1 Not updated if order exists 0=Work order (default), 10=Installation order, 11=Repair order New use from version 6.2.778. Deprecated values: 1=Pick order, 2=Counting order, 3=Project picking order, 4=Production picking order, 20=Counting Order (2), 21=Transfer Order, 22=Purchase receipt order Order name - Visible in order lists and reports 0=Customer order, 1=Internal order Replaces Category tag 1=Free order If Handyman is used with a Scheduler licence, orders without participants are not automatically set to free. Use this tag to force an order to be a free order. 0=Order is finished when all PDA users are finished 1=Order is finished when all users are finished -1=No delay,>=0 = Send the order to PDA n days before start date Default if node is missing = -1 NOT TO BE USED ANYMORE. Use InternalOrder instead. Will still work, but if InternalOrder is sendt, this tag is ignored Optional reference for order OBS! Label is called "requisition", but XML element is called "requsition" Optional reference for order Optional reference for order 0=Don't show, 1= Show in calendar Updated also if order already exists. Resourceplanner licence must be active. ID of the contract for this order. Only relevant if order type = 11 (Repair order) and installation is connected to multiple active contracts. If not included, the newest active contract will be selected based on contract start date Handyman ID of the contract for this order. If this is used, ContractID is not necessary ID of the installation. Must be included on an order of type of installation or repair (10 and 11) Internal id, if tag exists, use it instead of InstallationID List of installations connected to order. Only applies to order of type of installation or repair (10 and 11). Info will be ignored for other order types. The node OrderHead.InstallationID is used to indicate the main Installation ID for the order and must still be provided. This node is for additional Installation ID's connected to the order. Unknown installation will be created automatically if InstallationID and Name is provided. Any extra field provided will update existing equipment with new realtions and values. If important data is not provided (Like customer, parent, department, site address etc), it wil be taken from the order if possible ID of instalation to connect to order. Any unknown ID, will be ignored 0=No,1=Delete installation from order Internal id, if tag exists, use it instead of InstallationID Equipment must have a Site as parent. Only Site may be without parent. Internal id, if tag exists, use it instead of InstallationIDParent If site/equipment is to be created automatically, the Name tag must be provided Owner of site/equipment. If not provided, customer number form order will be used instead 0=Equipment, 1=Site If not provided, Site will be used Not imported for sites Not imported for sites Not imported for sites Not imported for sites Not imported for sites Date the installation was set to installed. Imported if State > 0. In this case value is mandatory. Not updated if date exists in Handyman 0=Own (default), 1=Preinstalled Defaults apply if tag is not provided 0=New (default for equipment), 1=Installed (default for site), 2=Paused, 3=Historical Defaults apply if tag is not provided ID of the employee responsible for the installation, must exist in Handyman Customer defect description. Only read if OrderType = 11 (Repair order) List of categories for order 1 : Order category 0: Free category on order 999: Free category on order 10: Priority Used together with CategoryID to identify record Only one occurence of of each CategoryType (0,1,10 and 999) is allowed For CategoryType = 10 (Priority): Predefined values exists in the database: 0=Low, 1=Normal, 2=High For backoffice systems Entre/Bilanco/Agresso/IFS: 0=Normal Must exist in Handyman unless Name AND Label is provided, or CategoryType = 10 (Sendt via Category import structure) If both Name and Label is provided, the category will automatically be created if it does not exist. If categoryType = 10 (Priority), a category will be created if it does not exisit. 0=Visible for new orders 1=Not visible for new orders Default 0 if not provided For CategoryType 0,1 and 999: Specify department id to restrict category to the department. If empty or not provided, the category will be available for all departments Only effective if category is automatically created. List of order elements to be available on the handheld device 0=not aviailable, 1= available Default is 1=available if this node is not provided 0=not aviailable, 1= available Default is 1=available if this node is not provided 0=not aviailable, 1= available Default is 1=available if this node is not provided 0=not aviailable, 1= available Default is 1=available if this node is not provided 0=not aviailable, 1= available Default is 1=available if this node is not provided 0=not aviailable, 1= available Default is 1=available if this node is not provided 0=not aviailable, 1= available Default is 1=available if this node is not provided 0=not aviailable, 1= available Default is 1=available if this node is not provided Updated if information is provided, otherwise value in Handyman is kept Obsolete, use Location. If Location is used, this node does not need to exist. Updated if information is provided, otherwise value in Handyman is kept Updated if information is provided, otherwise value in Handyman is kept Updated if information is provided, otherwise value in Handyman is kept Updated if information is provided, otherwise value in Handyman is kept 0=No, 1=Yes Shown on client if Quote = 0 (Invoice with fixed price) If empty string, the the default VATRate will be used 0=No, 1=Yes If set to 1, force-complete the order and its participants. This value is imported to the order's planned start date. Updates to an existing order is dependent on setting UpdateOrderDates below. If StartDate = FinishDate and both are missing hours or hours = 00:00, hours will be set to opening hours This value is imported to the order's planned finish date. Updates to an existing order is dependent on setting UpdateOrderDates below. If FinishDate = StartDate and both are missing hours or hours = 00:00, hours will be set to opening hours 0=Low, 1=Normal, 2=High[Entre: 0-99] NOT TO BE USED ANYMORE. Only kept for backward compability. This value should now be sendt in CategoryList with CategoryType = 10 Employee no. of person responsible for order in office, also called official in charge (OIC) Route sequence, can be used to sort orderlist on client 0=No, 1=Yes Order will be enabled for semi-automatic dispatching in the scheduler Documented in external module 1=Do not set finished order to passive Use to avoid setting order to historical/passive in Handyman. If this tag has been used, the order should be resent without this tag when the backoffice system is ready to mark it as historical/passive. Will only have effect on finished or passive orders. Passive orders will be set to finished unless recativation flag is used 0 = Don't update 1 = Update and expand order date boundries, move what needs to be moved 2 = Move order based on new start date 3 = Move order based on new finished date Use to change order dates and related appointments. Calendar items will be adjusted according to the same rules as when using the sam functions in the Handyman Resource planner. Unlimited length Invoice text for order. Only used by Handyman Order Control module 0=No, 1=Yes If 1 cost unit can be added when description, hours, materiel, documents and checklists are registered 0=No, 1=Yes If 1 cost unit can be added when description, hours, materiel, documents and checklists are registered 0=No, 1=Phase, 2=Point A KB can be assigned when registering description, hours, materiel, documents and checklists if 1 or 2. Value determines label for input field 0=No, 1=Yes 1 = input is mandatory for KB1, KB2 and Phase Default value Default value Default value Label for KB heading. Overrides default label Label for KB1. Overrides default label Label for KB2. Overrides default label Label for Phase. Overrides default label List of allowed values for KB1, KB2, Phase 0=KB1, 1=KB2, 2=Phase Only 3 levels supported for the moment Value will only be available to user when parent value is selected Fixed price for item Not updated Not updated Not updated Not updated Not updated Optional name of address WGS84 format (in millionths of degree) WGS84 format (in millionths of degree) Country codes according to ISO 3166-1 alpha-2. Must be used if maps for addresses outside Scandinavia and Germany is to be fetched. Send if the address you are sending exists in boligmappa.no Send if the address you are sending exists in boligmappa.no Not updated after first import from backoffice, unless the tag UpdateDepartment=1 Use 1 to access the default department that is created during installation 1=Update department on existing order Use this tag to force update of department on existing orders 0=Don?t send, 1=Send, 2=Keep current setting in HS if customer exists, otherwise set to 1 0=No, 1=Yes To indicate if this customer is a company. For information only Handyman 6.2: Only first address will be imported Handyman 7.x: All addresses will be imported OBS! First address will be treated as main address Match will be done on AddressID if provided. If not, AddressName will be used for matching. If either of these tags are provided, all addresses sendt will be treated as new Optional name of address WGS84 format (in millionths of degree) WGS84 format (in millionths of degree) Country codes according to ISO 3166-1 alpha-2. Must be used if maps for addresses outside Scandinavia and Germany is to be fetched. Send if the address you are sending exists in boligmappa.no Send if the address you are sending exists in boligmappa.no List of extra contacts on order. Main order contact must be sent in OrderHead/ContactName and related fields. Match will be done on ContactID if provided. If not, ContactName will be used for matching. Handyman 7 only Handyman 7 only Handyman 7 only Handyman 7 only Only 1 occurrence supported Handyman 7 only 0=Don?t send, 1=Send, 2=Keep current setting in HS if customer exists, otherwise set to 1 0=No, 1=Yes To indicate if this customer is a company. For information only 0=No, 1=Yes Customer locked for change in Office 0=No, 1=Yes Customer to be used as invoice receiver OBS! First address will be treated as main address Match will be done on AddressID if provided. If not, AddressName will be used for matching. If either of these tags are provided, all addresses sendt will be treated as new Optional name of address WGS84 format (in millionths of degree) WGS84 format (in millionths of degree) Country codes according to ISO 3166-1 alpha-2 Send if the address you are sending exists in boligmappa.no Send if the address you are sending exists in boligmappa.no OBS! First contact will be treated as main contact Match will be done on ContactID if provided. If not, ContactName will be used for matching. Only 1 occurrence supported The same EmployeeNo can only appear once in the participantlist 0=No, 1=Yes Message form participant 0=No, 1=Yes Message read by official in charge This value is imported to the participant's planned start date on new orders. Not updated for existing orders. This value is imported to the participant's planned finish date on new orders. Not updated for existing orders. 0=No, 1=Yes If set to 1, the participant will be marked as finished if not already finished. If all participants are finished the ordrer is finsihed, and sent back as finished during next synchronisation List of appointments for order participant. Unique ID in HS. Back office ID Planned start date Planned finish date 0 = Not started, 1 = Started, 2 = Paused, 3 = Completed, 4 = Personal appointment, 5 = Active, 6 = Tentative. Default = 0 0 = Not highlighted, 1 = highlighted. Default = 0 Order specific contacts. Handyman 7 only Match will be done on ContactID if provided. If not, ContactName will be used for matching. 0=No,1=Delete contact from order Unique ID, for updates from HS Back office ID/line number Max length depends on setting in Handyman. Up to 4096 characters is available. For some integrations the licence information will be used to set the max length. 0=No, 1=Yes Phase or point (determined by order) 0=No, 1=Delete record If used, the description is only for the specified user, otherwise for all ID of the installation the description is connected to. Only for order type 10,11,12 Internal id, if tag exists, use it instead of InstallationID Unique ID, for updates from HS Back office ID/line number Price/Purchase if exists. VAT not incl. Price given for misc. items. VAT not incl. 0=No, 1=Yes Phase or point (determined by order) Obsolete, use SerialNumberList 0=No, 1=Yes Flag to decide whether registration should generate a store movement in Handyman 0=No, 1=Delete record 1=Reset sync status in Handyman 2=Reset sync status and controlled status in Handyman Setting this flags to "1" will result in Handyman sending the same item again on next export to the backoffice system. This makes easier to handle irregular situations in the backoffice system import without storing the transactions on the order that failed. Value "2" will also reset the controlled status for the registration and the order. (Normally used in simple integration mode) Increased from 20 to 255 in 9.4.4 ID of the installation the material is connected to. Only for order type 10,11,12 Internal id, if tag exists, use it instead of InstallationID Used to identify registration origin from wholsesaler purchase order. Must be used in combination with PurchaseOrderID and LineNumber Used to identify registration origin from wholsesaler purchase order Used to identify registration origin from wholsesaler purchase order 1=Exclude registration from invoicing, 0=Don't exclude \ 0=No, 1=Yes 0=No, 1=Yes Value for extra information field 1 Value for extra information field 2 Value for extra information field 3 Value for extra information field 4 Value for extra information field 5 Label for extra information field 1 Label for extra information field 2 Label for extra information field 3 Label for extra information field 4 Label for extra information field 5 0=No, 1=Yes Flag to tell whether this article was picked in the ERP system. Unique ID, for updates from HS Back office ID/line number If the registration is supposed to show in Handyman Administrator, a valid employee number must exist Phase or point (determined by order) 0=No, 1=Delete record 1=Reset sync status in Handyman 2=Reset sync status and controlled status in Handyman Setting this flags to "1" will result in Handyman sending the same item again on next export to the backoffice system. This makes easier to handle irregular situations in the backoffice system import without storing the transactions on the order that failed. Value "2" will also reset the controlled status for the registration and the order. (Normally used in simple integration mode) 0=No , 1=Yes Used to indicate if an external voucher exists for the registration If 0 or absent, no rate is specified Date and time (No limit for length of registerd period) Date and time (No limit for length of registerd period) ID of the installation the salarycode registration is connected to. Only for order type 10,11,12 Internal id, if tag exists, use it instead of InstallationID Customer price per unit. If new entry with CustomerPrice defined or existing entry and CustomerPrice is changed, then CustomerPrice is updated and PriceOrigin is set to = "Agreed customer price". Otherwise CustomerPrice is calculated according to rules in Handyman Office Cost price per unit. If new entry with CostPrice defined or existing entry and CostPrice is changed, then CostPrice is updated and CostOrigin is set to "Employee". Otherwise CostPrice is calculated according to rules in Handyman Office 1=Exclude registration from invoicing, 0=Don't exclude 0=No , 1=Yes 0=No , 1=Yes List of passenger names and kilometers/miles. Tab separated Number of kilomters/miles with trailer. Less than or equal to Amount Comment for use of trailer Number of kilomters/miles with bad road. Less than or equal to Amount Unique ID in HS. Back office ID/line number Date created Connected to checklist with HSChecklistID 0=No, 1=Yes Only description will be sendt to client if "No" Only used if original file came from backoffice system. May be used to send a folder path. DocumentData will then be empty. Binary representation of document Use this tag to send the data as binary data rather than a path to a file. If this tag exisists, the FileExtension tag must exist. FilePath is ignored if DocumentData exists. File extension for binary data. Must exist if DocumentData tag is used. Phase or point (determined by order) AssetEditor connection AssetEditor connection 0=No,1=Yes Delete in Handyman. (Not implemented yet. If this tag is 1, then item wil be skipped, not deleted) Send if the document you are sending exists in boligmappa.no Send if the document you are sending exists in boligmappa.no ID of the installation the document is connected to. Only for order type 10,11,12 Internal id, if tag exists, use it instead of InstallationID 0=Order document,1=Supplier invoice 1=Reset sync status in Handyman Setting this flags to "1" will result in Handyman sending the same item again on next export to the backoffice system. This makes easier to handle irregular situations in the backoffice system import without storing the transactions on the order that failed. If this tag is added, then Handyman will not add any further checklists automatically after the import. BackofficeID for the individual checklist ChecklistType (=template) to be used Name given by user for this checklist. If there are several checklists of the same type on an order they must have unique names. Phase or point (determined by order) ID of the installation the checklist is connected to. Only for order type 10,11,12 Internal id, if tag exists, use it instead of InstallationID 1=Not allowed to delete this checklist on the client. This means that the backoffice system can decide wich checklists that are mandatory on an order. 0=Not finished, 1=Finished in Handyman 1=Deleted 1=Customer signature is required for checklist 1=Reset sync status in Handyman Setting this flags to "1" will result in Handyman sending the same item again on next export to the backoffice system. This makes easier to handle irregular situations in the backoffice system import without storing the transactions on the order that failed. Use this tag to pre-fill acheckpoint with a specific answer For datatype = 1,2,3 (Radio button fields): = "Not done" "1" = "Yes" or "OK" "2" = "Done" or "No" or "Discrepancy" "3" = "Not relevant" For datatype = 6 (Numeric): Decimal point is always "." For datatype = 7 (Date): "DD.MM.YYYY HH:mm:SS" Other datatypes: Any string value OBS! Datatype and values has changed Backoffice invoice number. Existing items will be updated Total amaount for material Total amount for other costs Total cost for invoice Price presented to customer Any comment connected to the invoice 0=No, 1=Delete record Formatted invoice document. Must be PDF format. Customer node is optional. Used only if customer for invoice differs from order customer If 0, it is a new customer created on the client. 0=Don?t send, 1=Send, 2=Keep current setting in HS if customer exists, otherwise set to 1 0=No, 1=Yes To indicate if this customer is a company. For information only Handyman 6.2: Only first address will be imported Handyman 7.x: All addresses will be imported OBS! First address will be treated as main address Optional name of address WGS84 format (in millionths of degree) WGS84 format (in millionths of degree) Country codes according to ISO 3166-1 alpha-2. Must be used if maps for addresses outside Scandinavia and Germany is to be fetched. Handyman 6.2: Only first contact will be imported Handyman 7.x: All contacs will be imported OBS! First contact will be treated as main contact Handyman 7 only Handyman 7 only Handyman 7 only Only 1 occurrence supported Backoffice id for controller. User must exist in Handyman ItemList is only needed if ERP wants to send UnapprovedCost items for reporting. Unique ID in Handyman. Used to find correct item for unnaproved cost. Unapproved cost for the item. Item will be matched in Handyman by ID