LOCATION_POSTCODE String 4 The postcode at which the work on the order is to be O / O carried out This field should be populated for all orders LOCATION_STATE String 3 The state in which the work on the order is to be O / O carried out This field should be populated for all orders WIP_EVENT String 4000 - The current WIP status of the order O / O WIP_EVENT_NO Integer 10 0 Foreign key. Unique identifier for each WIP Event (see O / O the WIP Master table) DATA_REFRESH_DATE Date 23 - yyyy/mm/dd Data propagates from the application to the Datamart M / M hh:mm:ss at defined intervals. This indicates the date at which this record was read from the application. ACCEPT_DATE Date 23 - yyyy/mm/dd The latest date and time that the order was accepted O / O hh:mm:ss by the Supplier TRANSMITTED_DATE Date 23 - yyyy/mm/dd The latest date and time that the order was transmitted O / O hh:mm:ss to the Supplier VERIFIED_DATE Date 23 - yyyy/mm/dd The latest date and time that the submitted was O / O hh:mm:ss verified INV_ENTITY_NAME String 60 - The name of the Invoiced Entity responsible for the O / M Order SUPP_REF_NR String 30 - The Supplier Reference Number input by the supplier O / O – on acceptance of the order and not visible to the customer MASTER_QUOTE_ID String 8 - The Master Quote Number that the Supplier quote was O / O issued from QUOTE_CLOSE_DATE Date 23 - yyyy/mm/dd The date that the has to be submitted by O / O hh:mm:ss PARENT_ORDER_ID String 8 - The Id of the that the current order was generated O / O from this could be as a copied order or as an – order.
LOCATION_POSTCODE String 4 The postcode at which the work on the order is to be carried out This field should be populated for all orders O / O LOCATION_STATE String 3 The state in which the work on the order is to be carried out This field should be populated for all orders O / O WIP_EVENT String 4000 - The current WIP status of the order O / O WIP_EVENT_NO Integer 10 0 Foreign key. Unique identifier for each WIP Event (see the WIP Master table) O / O DATA_REFRESH_DATE Date 23 - yyyy/mm/dd hh:mm:ss Data propagates from the application to the Datamart at defined intervals. This indicates the date at which this record was read from the application. M / M ACCEPT_DATE Date 23 - yyyy/mm/dd hh:mm:ss The latest date and time that the order was accepted by the Supplier O / O TRANSMITTED_DATE Date 23 - yyyy/mm/dd hh:mm:ss The latest date and time that the order was transmitted to the Supplier O / O VERIFIED_DATE Date 23 - yyyy/mm/dd hh:mm:ss The latest date and time that the submitted was verified O / O INV_ENTITY_NAME String 60 - The name of the Invoiced Entity responsible for the Order O / M SUPP_REF_NR String 30 - The Supplier Reference Number – input by the supplier on acceptance of the order and not visible to the customer O / O MASTER_QUOTE_ID String 8 - The Master Quote Number that the Supplier quote was issued from O / O QUOTE_CLOSE_DATE Date 23 - yyyy/mm/dd hh:mm:ss The date that the has to be submitted by O / O PARENT_ORDER_ID String 8 - The Id of the that the current order was generated from – this could be as a copied order or as an order. O / O
ConSol_Datamart_Specification_v5.1.docx