MODIFY_DATE Date 23 - yyyy/mm/dd The date and time the attachment was or its O / O hh:mm:ss content modified. MODIFIER String 71 - The full name of the user who attached the O / O document STATUS String 20 - Document Review status O / O DOC_VERSION String 10 - Version of the attached document O / O DOC_SIZE Integer 12 - Size of the attached document (in bytes) DOC_TYPE String 50 Name of associated user managed document type, or internal types "INVOICE”, “Engagement, "Mobile, "Migrated”, "Batch”,"Field Completion Advice” etc VIEW_BY String 32 - Whether the document is viewable by customer O / O & supplier (SUPP), supplier only (SUPP_ONLY) or customer only (CUST) SUPPLIER_UPLOADED Number 1 - Whether the document was uploaded by a O / O supplier GPS_LONGITUDE Number 9 6 The Longitude co-ordinates from which the O / O document was attached from the mobile device GPS_LATITUDE Number 9 6 The Latitude co-ordinates from which the O / O document was attached from the mobile device GPS_DATE Date 23 - yyyy/mm/dd The date that the document was uploaded from M / M hh:mm:ss the mobile device. DATA_REFRESH_DATE Date 23 - yyyy/mm/dd Data propagates from the application to the M / M hh:mm:ss Datamart at defined intervals. This field indicates the date at which this record was read from the application. (Mandatory column indicates whether the field is mandatory or optional at the database and application levels)
MODIFY_DATE Date 23 - yyyy/mm/dd hh:mm:ss The date and time the attachment was or its content modified. O / O MODIFIER String 71 - The full name of the user who attached the document O / O STATUS String 20 - Document Review status O / O DOC_VERSION String 10 - Version of the attached document O / O DOC_SIZE Integer 12 - Size of the attached document (in bytes) DOC_TYPE String 50 Name of associated user managed document type, or internal types “Engagement, "INVOICE”, "Mobile, "Migrated”, "Batch”,"Field Completion Advice” etc VIEW_BY String 32 - Whether the document is viewable by customer & supplier (SUPP), supplier only (SUPP_ONLY) or customer only (CUST) O / O SUPPLIER_UPLOADED Number 1 - Whether the document was uploaded by a supplier O / O GPS_LONGITUDE Number 9 6 The Longitude co-ordinates from which the document was attached from the mobile device O / O GPS_LATITUDE Number 9 6 The Latitude co-ordinates from which the document was attached from the mobile device O / O GPS_DATE Date 23 - yyyy/mm/dd hh:mm:ss The date that the document was uploaded from the mobile device. M / 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. M / M (Mandatory column indicates whether the field is mandatory or optional at the database and application levels)
ConSol_Datamart_Specification_v6.0.docx