VARIATION_ACCEPTANCE String 10 - - The variation status of the Item (n/a, New, Agreed, O / M Partial or Rejected) SNAPSHOT_DETAIL String 2000 - - The snapshot type where the order item details can O / O be viewed through the application SNAPSHOT_CREATE_DATE Date 23 - yyyy/mm/dd Date and Time of Snapshot creation O / M hh:mm:ss UPDATE_USER String 71 - - The full name of the user who triggered the recording O / M of the History log record for respective item version record VERSION TYPE String 10 - The Item Version type (see item version type O / M above 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 field indicates the date at which this record was read from the application. Should this be last row as per other extracts? (Mandatory column indicates whether the is mandatory or optional at the database and application levels) Design Rules: The extract will include duplicate lines for every Item that has one or more snapshots generated or invoice activity during the processing window Item History records for items that no longer exist will be removed from this extract. Item Variation Extract Delta This is a table of all Item details for items where an item variation occurred Data Dictionary Mandatory Field Name Type Precision Format Description DB / App
VARIATION_ACCEPTANCE String 10 - - The variation status of the Item (n/a, New, Agreed, Partial or Rejected) O / M SNAPSHOT_DETAIL String 2000 - - The snapshot type where the order item details can be viewed through the application O / O SNAPSHOT_CREATE_DATE Date 23 - yyyy/mm/dd hh:mm:ss Date and Time of Snapshot creation O / M UPDATE_USER String 71 - - The full name of the user who triggered the recording of the History log record for respective item version record O / M VERSION TYPE String 10 - The Item Version type (see item version type above O / M 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. Should this be last row as per other extracts? M / M (Mandatory column indicates whether the is mandatory or optional at the database and application levels) Design Rules: The extract will include duplicate lines for every Item that has one or more snapshots generated or invoice activity during the processing window Item History records for items that no longer exist will be removed from this extract. Item Variation Extract Delta This is a table of all Item details for items where an item variation occurred Data Dictionary Field Name Type Precision Format Description Mandatory DB / App
ConSol_Datamart_Specification_v5.1.docx