W_EXPORT_D
Data Mapping
Field | Description | Data Type |
---|---|---|
EXPORT_OBJECT_ID | Unique Key | INTEGER |
CONTRACT_OBJECT_ID | Foreign Key to W_CONTRACT_D | INTEGER |
INVOICE_OBJECT_ID | Foreign Key to W_INVOICE_D | INTEGER |
PROJECT_OBJECT_ID | Foreign Key to W_T_PROJECT_D | INTEGER |
JOBID_INVOICE | Textura Job Number for invoice export. | INTEGER |
JOBID_INVOICE_REJECTION | Textura Job Number for invoice rejection export. | INTEGER |
JOBID_PAYMENT | Textura Job Number for payment export. | INTEGER |
INVOICE_EXPORT_DATE | The date the invoice was exported. | DATE |
INVOICE_REJECTION_EXPORT_DATE | The date the invoice was rejected. | DATE |
PAYMENT_EXPORT_DATE | The date the payment was exported. | DATE |
INVOICE_NUMBER | Invoice number | VARCHAR2(750) |
CHECK_NUMBER | Check number sequence | INTEGER |
VENDOR_ID | Vendor ID assigned to Subcontractor. | VARCHAR2(50) |
PAYMENT_OBJECT_ID | Foreign Key to W_PAYMENT_D | INTEGER |
INVOICE_AMOUNT | Net invoice amount. | NUMBER(16,2) |
DATE_UPDATED | DATE_UPDATED is the date that this record was updated in the TPM Data Service database. For more information, see topic Managing Incremental Updates. | DATE |
Last Published Tuesday, February 6, 2024