ATTRIBUTE_TYPE_NO Integer 10 0 Foreign key. Uniquely identifies the attribute type. M / M (Mandatory column indicates whether the field is mandatory or optional at the database and application levels) Design Extract includes every line note written in ConSol application within the processing window. The ATTRIBUTE_NAME will be a truncated line note of the attribute whose value changed. The extract doesn’t include document attachments Document Details Extract Delta This is a table of all documents added to Project Views, Orders or Invoices within the processing window Data Dictionary Mandatory Field Name Type Length Precision Format Description DB / App DOC_NO Integer 15 Primary key. A unique identifier for attached M/M Document. ASSOC_ENTITY_TYPE String 20 Entity that document is associated with, e.g. O / M PROJECTVIEW, ORDER, INVOICE PROJ_VIEW_NO Integer 10 0 Foreign key. Unique identifier for the Project to O / O this document is attached or associated ORDER_ID String 8 - Foreign key. The unique ConSol ID to which O / O this document is attached, if it was attached at Order level, null otherwise. INVOICE_NO Integer 10 - Foreign key. The unique ConSol Invoice No to O / O which this document is attached, if it was attached at invoice level, null otherwise. DOC_NAME String 255 - File name of the attached document O / M DESCRIPTION String 500 - Description of attached document O / O
ATTRIBUTE_TYPE_NO Integer 10 0 Foreign key. Uniquely identifies the attribute type. M / M (Mandatory column indicates whether the field is mandatory or optional at the database and application levels) Design Extract includes every line note written in ConSol application within the processing window. The ATTRIBUTE_NAME will be a truncated line note of the attribute whose value changed. The extract doesn’t include document attachments Document Details Extract Delta This is a table of all documents added to Project Views, Orders or Invoices within the processing window Data Dictionary Field Name Type Length Precision Format Description Mandatory DB / App DOC_NO Integer 15 Primary key. A unique identifier for attached Document. M/M ASSOC_ENTITY_TYPE String 20 Entity that document is associated with, e.g. PROJECTVIEW, ORDER, INVOICE O / M PROJ_VIEW_NO Integer 10 0 Foreign key. Unique identifier for the Project to this document is attached or associated O / O ORDER_ID String 8 - Foreign key. The unique ConSol ID to which this document is attached, if it was attached at Order level, null otherwise. O / O INVOICE_NO Integer 10 - Foreign key. The unique ConSol Invoice No to which this document is attached, if it was attached at invoice level, null otherwise. O / O DOC_NAME String 255 - File name of the attached document O / M DESCRIPTION String 500 - Description of attached document O / O