W_PAYMENT_F
Data Mapping
Field | Description | Data Type |
|---|---|---|
PAYMENT_OBJECT_ID | Primary key. Foreign key to W_PAYMENT_D | NUMBER(19) |
AMOUNT | Payment amount | NUMBER |
CONTRACT_OBJECT_ID | Foreign key to W_CONTRACT_D | NUMBER(19) |
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 |
DISCOUNTEDPAYMENTAMOUNT | Calculated/estimated discount payment amount | NUMBER |
DISCOUNTPAYMENTAMOUNT | Discount payment amount received from funder | NUMBER |
INVOICE_OBJECT_ID | Foreign key to W_INVOICE_D | NUMBER(19) |
PAYMENTAMOUNT | Payment amount | NUMBER |
PAYMENTTAXAMOUNT | Payment amount including tax | NUMBER |
PROJECT_OBJECT_ID | Foreign key to W_T_PROJECT_D | NUMBER(19) |
SETTLEMENT_OBJECT_ID | Foreign key to W_PAYMENT_PROGRAM_D | NUMBER(19) |
TAXAMOUNT | Tax amount | NUMBER |
TPA_EFFECTIVE_DATE | Effective date of accelerated payment to subcontractor | TIMESTAMP |
TPA_FEE_AMOUNT | Subcontractor TPA fee amount | NUMBER (16,2) |
TPA_FUNDING_ACCOUNT | Account debited for accelerated paymennt | VARCHAR2(15) |
TPA_MATURITY_ACCOUNT | Account credited for maturity payment | VARCHAR2(15) |
TPA_PROGRAM_NUMBER | System generated TPA program number associated with payment | VARCHAR2(20) |
Last Published Tuesday, February 6, 2024