W_PAYMENT_PROGRAM_D
Data Mapping
Field | Description | Data Type |
|---|---|---|
SETTLEMENT_OBJECT_ID | Unique key | NUMBER(19) |
CONTRACT_OBJECT_ID | Foreign key to W_CONTRACT_D | NUMBER(19) |
TPA_CREDIT_ACCOUNT | Subcontractor TPA pay to account number (last 4 digits) | VARCHAR2(15) |
DATE_CREATED | Date program created | DATE |
DATE_SUBMITTED | Transmission date of TPA payment | DATE |
DATE_UPDATED | DATE_UPDATED is the date that this record was updated in the TPM Data Service database. For more information, view the Managing Incremental Updates section in Help. | DATE |
TPA_DEBIT_ACCOUNT | TPA pay from account number (last 4 digits) | VARCHAR2(15) |
DRAW_NUMBER | Draw number | NUMBER(19) |
FUNDED | Funded True/False | VARCHAR2(50) |
MATURITY_DATE | Maturity date of TPA invoice | DATE |
PROJECT_OBJECT_ID | Foreign key to W_T_PROJECT_D | NUMBER(19) |
SUBORGANIZATION_ID | Textura customer number of subcontractor | NUMBER(19) |
TPA_FILE_CREATION_DATE | Date the maturity bank file was created | DATE |
TPA_DATEPROCESSED | Date the subcontractor accelerated payment is submitted | DATE |
Last Published Tuesday, February 6, 2024