W_PAYMENT_D
Data Mapping
Field | Description | Data Type |
---|---|---|
PAYMENT_OBJECT_ID | Unique Key. This table is 1 to 1 w/ W_PAYMENT_F, joining on this column | NUMBER(19) |
CHECKNUMBER | Check Number Sequence | NUMBER(19) |
CONTRACT_OBJECT_ID | Foreign Key to W_CONTRACT_D | NUMBER(19) |
DATE_CREATED | Date Payment file was created | 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 |
DATE_SUBMITTED_TO_BANK | Date Payment was Submitted to Bank | DATE |
DISBURSED_DATE | Date Payment was Disbursed from TPM | DATE |
DISCOUNT_TAKEN | Amount of Discount on Payment | NUMBER |
DISPLAYCODE | Payment Type (Partial, ACH, Manual, Split, TPA) | VARCHAR2(100) |
FROM_ORG_NAME | General Contractor Organization | VARCHAR2(2000) |
FUNDED | Payment has been funded (True, False) | VARCHAR2(10) |
MATURE | Maturity Payment (True/False) | VARCHAR2(10) |
PAY_FROM_ORG_ID | Organization Funding Payment | NUMBER(19) |
PAY_TO_ORG_ID | Organization Receiving Payment | NUMBER(19) |
PROJECT_OBJECT_ID | Foreign Key to W_T_PROJECT_D table | NUMBER(19) |
TAX_AMOUNT | Tax Amount | NUMBER |
TO_ORG_NAME | Organization Receiving Payment | VARCHAR2(2000) |
Last Published Tuesday, February 6, 2024