Handyman Export: Orders Back office order number HS order number 1=Exclude order from invoicing, 0=Don't exclude 0=Work order (default), 1=Pick order, 2=Counting order, 3=Project picking order, 4=Production picking order, 10=Installatio order, 11=Repair order, 12=Service order, 13=Invoice order, 20=Counting Order (2), 21=Transfer Order, 22=Purchase receipt order New use from version 6.2.778 OBS! This field has unlimited length in Handyman, and you must make sure to cut it to the maximum length that is supported by your application. Order name - Visible in order lists and reports 0=Customer order, 1=Internal order Replaces Category element 1=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 0=Customer order, 1=Internal order NOT IN USE ANYMORE. Use InternalOrder Optional reference for order Optional reference for order Optional reference for order Unlimited length Customers description of problem on repair order. Will only be filled for repair orders (OrderType = 11) ID for Reason for Repair. Will only be filled for repair orders (OrderType = 11) Descriptive text for Reason for Repair. Will only be filled for repair orders (OrderType = 11) List of categories for order Only one occurrence of each type is allowed 1 : Order category 0: Free category on order 10: Priority 999: Free category on order Used together with CategoryID to identify record Priority value will be sendt in CategoryList with CategoryType = 10 Sendt from backoffice via Category import structure List of order elements to be available on the handheld device 0=not aviailable, 1= available 0=not aviailable, 1= available 0=not aviailable, 1= available 0=not aviailable, 1= available 0=not aviailable, 1= available 0=not aviailable, 1= available 0=not aviailable, 1= available 0=not aviailable, 1= available 0=No, 1=Yes Shown on client if Quote = 0 (Invoice with fixed price) 0=No, 1=Yes Planned start date Planned finish date Actual start date Actual finish date 0=Low, 1=Normal, 2=High [Entre: 0-99] NOT TO BE USED ANYMORE. Only kept for backward compability. Priority value will be sendt in CategoryList with CategoryType = 10 Employee no. of person responsible for order in office Route sequence, can be used to sort orderlist on client Documented in external module 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 when 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 List of allowed values for KB1, KB2, Phase 0=KB1, 1=KB2, 2=Phase Value will only be available to user when parent value is selected Fixed price for item Only if Handyman is set up for export of signatures Only if Handyman is set up for export of signatures Only if Handyman is set up for export of signatures 0=Customer have signed 2=Customer was not present 3=Customer refused to sign Only if Handyman is set up for export of signatures Only if Handyman is set up for export of signatures 0=Not controlled/approved, 1=Partially controlled/approved, 2=Controlled/approved, 3=Pre-approved, 4=Approved and highlited, 5=paused New from version 7.7.2 Optional name of address WGS84 format (in millionths of degree) WGS84 format (in millionths of degree) Will always be exported if setting to use extra address fields is active in Handyman Administrator Will always be exported if setting to use extra address fields is active in Handyman Administrator Country codes according to ISO 3166-1 alpha-2. Only exported if it has a value Invoice rules for this order. Based on information from contract 0=False, 1=True Should material on this order be invoiced Percentage discount on material on this order 0=False, 1=True Should salary codes defined as cost type="WorkHours" be invoiced on this order Percentage discount on workhours on this order 0=False, 1=True Should salary codes defined as cost type="Travel" be invoiced on this order 0=False, 1=True Should salary codes defined as cost type="Other" be invoiced on this order Turnoutfee defined in the contract for all orders of this contract Percentage ID of the contract that this order is a part of Starting date of contract Closing date of contract Settlement date of the contract Number of months for contract period 0=False, 1=True Number of months for contract renewal when automatic renewal is active OBS! This item is just kept for backward compatibility. Pleas use InstallationID under OrderHead in the future. ID of the installation of this order. If more than one Installation is connected to the order, the list below will have this information. Full information about this element will always be provided in the installation list structure. Internal id, if tag exists, use it instead of InstallationID OBS! This structure is just kept for backward compatibility. Pleas use InstallationList inder OrderHead in the future. List of installations connected to order. Only applies to order of type of installation,repair or service (10,11 and 12). ID of instalation. This may have been created in Handyman Internal id, if tag exists, use it instead of InstallationID ID of the installation of this order. If more than one Installation is connected to the order, the list below will have this information. Full information about this element will always be provided in the installation list structure. 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). ID of instalation. This may have been created in Handyman Internal id, keep this the backoffice system so that you can send updated InstallationID back to handyman Equipment must have a Site as parent Internal id 0=Equipment, 1=Site 0=Own (default), 1=Preinstalled 0=New (default for equipment), 1=Installed (default for site), 2=Paused, 3=Historical If 0, it is a new customer created on the client. 0=No, 1=Yes To indicate if this customer is a company. For information only Handyman 6.2: Only first address supported Handyman 7.x: All addresses will be exported OBS! First address is main address WGS84 format (in millionths of degree) WGS84 format (in millionths of degree) Will always be exported if setting to use extra address fields is active in Handyman Administrator Will always be exported if setting to use extra address fields is active in Handyman Administrator Country codes according to ISO 3166-1 alpha-2. Only exported if it has a value Handyman 6.2: Only first contact supported Handyman 7.x: All contacts will be exported First contact is main contact Handyman 7 only Handyman 7 only Handyman 7 only If 0, it is a new customer created on the client. 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 WGS84 format (in millionths of degree) WGS84 format (in millionths of degree) Will always be exported if setting to use extra address fields is active in Handyman Administrator Will always be exported if setting to use extra address fields is active in Handyman Administrator Country codes according to ISO 3166-1 alpha-2. Only exported if it has a value Handyman 6.2: Only first contact supported Handyman 7.x: All contacts will be exported First contact is main contact 0=No, 1=Yes Message form participant 0=No, 1=Yes Message read by official in charge 0=Not synchronised, 1=Synchronised (not activated), 2=Finished, 3=Activated, 4=Rejected Planned start date Planned finish date Actual start date Actual finish date Will be removed in the future, use ActualStartDate. Will be kept for backward compatibility. ID for rejection reason Rejection reason in clear text List of appointments for order participant. Unique ID in HS. Back office ID Planned start date Planned finish date Actual start date Actual finish date 0 = Not started, 1 = Started, 2 = Paused, 3 = Completed, 4 = Personal appointment, 5 = Active, 6 = Tentative. Personal appointments are not exported 0 = Not highlighted, 1 = highlighted. Meaning is up to each company Order specific contacts. Handyman 7 only Handyman internal contact id Unique ID in HS. Back office ID/line number 0=No, 1=Yes Descriptions marked internal should not be visible on invoice 0=No, 1=Delete record If used, the description is only for the specified user, otherwise for all ID of the installation connected to the description. Internal id, if tag exists, use it instead of InstallationID Unique ID in 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 This will be set to 1 if price is calculated in Handyman from either Customer settings or Contract settings Phase or point (determined by order) 0=No, 1=Yes Obsolete, use SerialNumberList 0=Not controlled/approved, 1=Controlled/approved, 3=Pre-approved, 4=Approved and highlited New from version 7.7.2 ID of the installation connected to the material. Internal id, if tag exists, use it instead of InstallationID 0=Not in pricelist, 3=Pricelist, 4=Customer price,5=Contract price 0=From registration, 3=Pricelist 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 in HS. Back office ID/line number 0=Hours, 1=Amount, 3=Kilometers Phase or point (determined by order) 0=No , 1=Yes Used to indicate if an external voucher exists for the registration If 0, then no rate is specified Date and time (No limit for length of registerd period) Date and time (No limit for length of registerd period) 0=Normal time, 1=Overtime, 2=Holiday, 3=Sick time, 4=Extra pay, 5=Quantity, 6=Other absence 0=Not controlled/approved, 1=Controlled/approved, 3=Pre-approved, 4=Approved and highlited New from version 7.7.2 ID of the installation connected to the salary code registration. Internal id, if tag exists, use it instead of InstallationID 0=SalaryCode, 1=Employee, 2=Customer, 3=Contract, 4=Agreed Customer Price, 5=Company Income Category, 6=Department Income Category, 7=Customer Income Category, 8=Contract Income Category 0=SalaryCode, 1=Employee, 2=Income Cateogry 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 Name of checklist type Name given by user for this checklist 0=No, 1=Declaration of conformacy is mandatory Phase or point (determined by order) 0=Not finished, 1=Finished in Handyman 1=Cannot be deleted on PDA Only if Handyman is set up for export of signatures Only if Handyman is set up for export of signatures Only if Handyman is set up for export of signatures 0=Customer have signed 2=Customer was not present 3=Customer refused to sign Only if Handyman is set up for export of signatures Only if Handyman is set up for export of signatures Text to display on handlheld machine when customer signature is captured Text to display on handlheld machine when user signature is captured 1 = Locked Changes to checklist definition cannot be done in Handyman Version number for checklist definition Footer text to be displayed on checklist report in Handyman ID of the installation connected to the checklist. Internal id, if tag exists, use it instead of InstallationID The category ID for Reason for checklist reject. The category name for Reason for checklist reject. 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 0 = Heading 1 = Not done/Done 2 = Yes/No 3 = OK/Discrepancy 4 = Text field 5 = Pick List 6 = Numeric field 7 = Date field Specifies type of data-input. Default is 1 if not specified DataType 1,2,3 are radio button groups 1 = Locked Item cannot be changed or change position in checklist if set Only valid for items with DataType=1,2,3 Datatype=1, 2=Done Datatype=2, 1=Yes, 2=No Datatype=3, 1=OK, 2=Discrepancy Specifies which answer that will activate following subitem items. 1 = Subitem Normally used on items following an item that specifies ActiveGroupResponse. Default 0 Specifies minimum input value for numeric fields (DataType=6) Default 0 Specifies maximum input value for numeric fields (DataType=6) 0 = floating point field 1 = Integer field Specifies input type for numeric fields (DataType=6) 0 = Date input 1 = Date + time input Specifies input type for date fields (DataType=7) 0 = Text input, list can be used 1 = List selection is required Specifies input type for pick list fields (DataType=5) 0=No, 1=Yes 0=No, 1=Yes 0=No, 1=Yes 0=No, 1=Yes 0=No, 1=Yes 0=No, 1=Yes 0=No, 1=Yes 0=No, 1=Yes 0=No, 1=Yes Supress printout for not relevant value Unique ID in HS. 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 Binary representation of document Used if created in Handyman Used if created in Handyman. File exstension to be used if file is not stored in backoffice database Phase or point (determined by order) AssetEditor connection AssetEditor connection 0=No,1=Yes Deleted in Handyman Node will not exist if document have been uploaded to Boligmappa.no. Available from version 6.3.978 Node will not exist if document have been uploaded to Boligmappa.no. Available from version 6.3.978 ID of the installation connected to the document. Internal id, if tag exists, use it instead of InstallationID 0=Order document,1=Supplier invoice Date/time for last change in the budget Backoffice id person who last changed the budget Backoffice id for controller. May have been updated in Handyman Unique ID in Handyman Name of budget item. In the default template this will be one of 7 values: Income, Warranty Cost, Material Cost, Subcontractor Cost, Salary Cost, Piecework cost, Project Manager Cost 0=Income, 1=Variable Cost, 2=Fixed Cost Describes type of budget item. Type 0 and 1 is affecting Contribution margin 1, type 2 is affecting Contribution margin 2 0=Salary code, 1=Material Used by the analysis report to define how to collect values form registrations on the orderconnected to this budget item Used to specify witch salary codes that will be accumulated in the report for this budget item. If empty, all salary codes will be accumulated unless used in any other budget item. Used to specify witch material item numbers that will be accumulated in the report for this budget item. If empty, all material item numbers will be accumulated unless used in any other budget item. Starting value for material item number range. Ending value for material item number range. Used to sort budeget items in user interface and report Origninal budget value Any addition to the budget value. May be positive or negative value. Extra work on the order. Comment is always required for items where Adjustement has value