COMPLIANCE_MGR String 71 - The full name of the user who is responsible for the O / O checking all Compliance requirements ISSUE_DATE Date 23 - yyyy/mm/dd The date the contract was issued M / M hh:mm:ss EXPIRY_DATE Date 23 - yyyy/mm/dd The date the contract expires O / O hh:mm:ss KPI_START_DATE Date 23 - yyyy/mm/dd The date that KPI statistics start processing O / M hh:mm:ss SCHEDULE String 10 - The id for the schedule of rates which apply to the order. O / M SUPPLIER String 70 - The name of the supplier company engaged this M / M contract. VENDOR_NO String 20 - The Vendor number of the Supplier Company O / M PAYMENT_TERMS Number 2 - The payment terms applying to the contract O / M SUPPLIER_ABN String 11 The Supplier company ABN O / O SUPPLIER String 71 - The full name of the user who is identified as primary O / M _CONTACT_NAME Supplier Contact STAR_RATING Number 1 - On a scale of 1-5, the calculated rating of supplier O / O performance OVERRIDE_STAR_RATING Number 1 - On a of 1-5, the manual override rating of supplier O / O performance DATA_REFRESH_DATE Date 23 - yyyy/mm/dd Data propagates from the application to the Datamart at M / M hh:mm:ss defined intervals. This field indicates the date at which this record was read from the application. (Mandatory column indicates whether the is mandatory or optional at the database and application levels) Design Rules: Only the customer contracts will be included in the Extract this includes contracts issued to the customer as well as contracts raised by the – customer The details of the Contract which are extracted to the Datamart are the latest values stored against the Contract at processing time.
COMPLIANCE_MGR String 71 - The full name of the user who is responsible for the checking all Compliance requirements O / O ISSUE_DATE Date 23 - yyyy/mm/dd hh:mm:ss The date the contract was issued M / M EXPIRY_DATE Date 23 - yyyy/mm/dd hh:mm:ss The date the contract expires O / O KPI_START_DATE Date 23 - yyyy/mm/dd hh:mm:ss The date that KPI statistics start processing O / M SCHEDULE String 10 - The id for the schedule of rates which apply to the order. O / M SUPPLIER String 70 - The name of the supplier company engaged this contract. M / M VENDOR_NO String 20 - The Vendor number of the Supplier Company O / M PAYMENT_TERMS Number 2 - The payment terms applying to the contract O / M SUPPLIER_ABN String 11 The Supplier company ABN O / O SUPPLIER _CONTACT_NAME String 71 - The full name of the user who is identified as primary Supplier Contact O / M STAR_RATING Number 1 - On a scale of 1-5, the calculated rating of supplier performance O / O OVERRIDE_STAR_RATING Number 1 - On a of 1-5, the manual override rating of supplier performance 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 field indicates the date at which this record was read from the application. M / M (Mandatory column indicates whether the is mandatory or optional at the database and application levels) Design Rules: Only the customer contracts will be included in the Extract – this includes contracts issued to the customer as well as contracts raised by the customer The details of the Contract which are extracted to the Datamart are the latest values stored against the Contract at processing time.
ConSol_Datamart_Specification_v6.0.docx