Search only in titles

---

W_INVOICE_D

Data Mapping

Field	Description	Data Type
INVOICE_OBJECT_ID	Unique Key	NUMBER(19)
APPROVED	True / False	VARCHAR2(750)
AUTHORIZED	True / False	VARCHAR2(750)
DATE_APPROVED	Date Invoice Approved	DATE
DATE_AUTHORIZED	Date Invoice Authorized	DATE
DATE_CREATED	Date Subcontractor Invited to Invoice	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	Date Invoice Submitted	DATE
DAYS_ON_HOLD	Days on Hold	NUMBER
DAYS_TO_APPROVE	Number of Days the Invoice was with the General Contractor pending Approval	NUMBER
DAYS_TO_PAY	Number of days to Pay calculated from Draw Period to Date	NUMBER
DAYS_TO_SUBMIT	Number of Days the Invoice was with the Subcontractor	NUMBER
DISBURSED_DATE	Date Invoice Disbursed	DATE
DRAW_DATE	Draw Due Date	DATE
DRAW_NUMBER	Draw Number	NUMBER(19)
HOURS_WORKED	Hours worked recorded against invoice	NUMBER(14,2)
INVOICE_NUMBER	Invoice Number	VARCHAR2(750)
IS_EPP	Identifies TPA payment type (True/False)	VARCHAR2(5)
IS_MANUAL	Identifies Manual Check payment type (True/False)	VARCHAR2(5)
IS_PRIOR_BILLING	Identifies Off-System payment (True/False)	VARCHAR2(5)
LAST_HOLD_PLACED	Date of Last Hold	DATE
LAST_HOLD_RELEASED	Date Last Hold was released	DATE
PAYMENT_DUE_DATE	Payment Due Date	DATE
PERIOD_TO	Draw Period to Date	DATE
PROJECT_OBJECT_ID	Foreign Key to W_T_PROJECT_D table	NUMBER(19)
SUBMISSION_COUNT	Number of times the invoice was submitted	NUMBER
STATE	TPA invoice status (Pending Approval, On Hold, Pending authorization, pending disbursement, EPP pending maturity, Paid)	VARCHAR2(50)
TPA_DATE_REMOVED_FROM_TPA	Date invoice was removed from TPA	DATE
TPA_REMOVAL_COMMENT	TPA removal comment entered by user	VARCHAR2(1000)
TPA_REMOVAL_REASON	TPA system generated removal reason	VARCHAR2(200)
TPA_REMOVAL_SOURCE	TPA system generated removal source	VARCHAR2(50)

---

Last Published Tuesday, February 6, 2024