W_BILLING_F
Data Mapping
Field | Description | Data Type |
---|---|---|
BILLING_OBJECT_ID | Primary Key. Foreign Key to W_INVOICE_D | NUMBER(19) |
CONTRACT_OBJECT_ID | Foreign Key to W_CONTRACT_D | NUMBER(19) |
CURRENT_MANUAL_HOLDS | Count of active manual holds | NUMBER |
CURRENT_SYSTEM_HOLDS | Count of active system holds | NUMBER |
CURR_DAYS_ON_HOLD | Total Number of days Invoice is On Hold | NUMBER |
DATE_CREATED | Date subcontractor was invited to the Draw | 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 |
DAYS_ON_HOLD | Number of days the Invoice has been held for | NUMBER |
DAYS_PAST_DUE | Number days between Disbursement and Payment Due Date | NUMBER |
DAYS_TO_APPROVE | Number of days the Invoice with the General Contractor for Approval | NUMBER |
DAYS_TO_AUTHORIZE | Number of days from Draw Period to Date to Authorization | NUMBER |
DAYS_TO_DISBURSE_AFTER_HOLD | Number of days Disbursed after release of Hold | NUMBER |
DAYS_TO_PAY | Number of days from Draw Period to Date to Disbursement | NUMBER |
DAYS_TO_SUBMIT | Number of days the Invoice was with the Subcontractor before submitting to General Contractor. | NUMBER |
MANUAL_HOLDS_PLACED | Number of Holds placed by a User | NUMBER |
MANUAL_HOLDS_RELEASED | Number of Holds released by a User | NUMBER |
PAST_DAYS_ON_HOLD | Average hold length for invoice (sum of days on hold/# of released holds) | NUMBER |
PENDINGDISBURSEMENT | Net Invoice Amount Pending Disbursement | NUMBER |
PENDINGPAYMENT | Net Invoice Amount Pending Maturity | NUMBER |
PROJECT_OBJECT_ID | Foreign Key to W_T_PROJECT_D | NUMBER(19) |
RESUBMISSIONS | Number of times the Invoice was submitted to the General Contractor | NUMBER |
SELFMATERIALSTORED | Materials Stored this period by Prime Subcontractor | NUMBER |
SELFRETENTIONHELD | Retention Held this period by Prime Subcontractor | NUMBER |
SELFRETENTIONPAYMENT | Retention Paid to Prime Subcontractor | NUMBER |
SELFRETENTIONTAXHELD | Retention Held with Tax by Prime Subcontractor | NUMBER |
SELFRETENTIONTAXPAYMENT | Retention Payment with Tax by Prime Subcontractor | NUMBER |
SELFTAXPAYMENT | Tax Payment by Prime Subcontractor | NUMBER |
SELFWORKCOMPLETE | Worked completed this period by Prime Subcontractor | NUMBER |
SYSTEM_HOLDS_PLACED | Hold set by the system | NUMBER |
SYSTEM_HOLDS_RELEASED | Hold released by the system | NUMBER |
TOTALAMOUNTPAID | Amount paid including Subtier payments | NUMBER |
TOTALMATERIALSTORED | Materials Stored including Subtier materials | NUMBER |
TOTALRETENTIONHELD | Retention Held including Subtier retention held | NUMBER |
TOTALRETENTIONPAYMENT | Retention Paid including Subtier retention payment | NUMBER |
TOTALRETENTIONTAXHELD | Retention Held with Tax including Subtier billing | NUMBER |
TOTALRETENTIONTAXPAYMENT | Retention Tax Payment including Subtier billing | NUMBER |
TOTALTAXPAYMENT | Total Tax Payment including Subtier billing | NUMBER |
TOTALWORKCOMPLETE | Total Work Completed including Work Completed of Subtiers | NUMBER |
TOTAL_HOLD_COUNT | Number of Holds created against invoice | NUMBER |
Last Published Tuesday, February 6, 2024