W_BUDGET_F
Data Mapping
The Unique Key on this table is a combination of CONTRACT_OBJECT_ID and CHANGE_ORDER_OBJECT_ID. This is not a Primary key as CHANGE_ORDER_OBJECT_ID is nullable.
Field | Description | Data Table |
|---|---|---|
CONTRACT_OBJECT_ID | Unique Key (This is not a Primary Key as CHANGE_ORDER_OBJECT_ID is nullable). Foreign Key to W_CONTRACT_D | NUMBER(19) |
CHANGE_ORDER_OBJECT_ID | Unique Key. Foreign Key to W_CHANGE_ORDER_D | NUMBER(19) |
BALANCE | Remaining Contract Balance (Current Contract Amount – Paid, Pending, & Retention Balance) | NUMBER |
BUDGET_AMOUNT | Current Contract Value including Change Orders | NUMBER |
CHANGE_ORDER_AMOUNT | Value of Change Order | NUMBER |
DATE_CREATED | Date Contract 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 |
ORIGINAL_BUDGET_AMOUNT | Original Subcontract Amount including Hidden Change Orders | NUMBER |
PROJECT_OBJECT_ID | Foreign Key to to W_T_PROJECT_D | NUMBER(19) |
TOTAL_SUB_CONTRACT_AMOUNT | Sum of subcontracts on a project | NUMBER |
TOTALMATERIALSTORED | Total Stored Materials against the Contract | NUMBER |
TOTALRETENTIONHELD | Total Retention Held against the Contract | NUMBER |
TOTALRETENTIONPAYMENT | Total Retention Requested against the Contract | NUMBER |
TOTALWORKCOMPLETE | Total Work Completed against the Contract | NUMBER |
Last Published Tuesday, February 6, 2024