W_INVOICE_HOLD_D
Data Mapping
The Unique Key on this table is a combination of INVOICE_OBJECT_ID, HOLD_TYPE_OBJECT_ID, HOLD_PLACED_DATE, and MANUAL_CONTRACTOR_ID. This is not a Primary key as MANUAL_CONTRACTOR_ID is nullable.
Field | Description | Data Type |
|---|---|---|
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 |
INVOICE_OBJECT_ID | Part of Unique Key. Foreign Key to W_INVOICE_D | NUMBER(19) |
HOLD_TYPE_OBJECT_ID | Part of Unique Key. Id for Hold Type | NUMBER(19) |
HOLD_PLACED_DATE | Part of Unique Key. Date Hold Placed | DATE |
MANUAL_CONTRACTOR_ID | Part of Unique Key. | NUMBER(19) |
HOLD_PLACED_METHOD | Method the Hold was placed (Manual, System) | VARCHAR2(255) |
HOLD_RELEASED_DATE | Date Hold Released | DATE |
HOLD_RELEASED_METHOD | Method the Hold was released (Manual, System) | VARCHAR2(255) |
HOLD_TYPE_NAME | Name of Hold | VARCHAR2(255) |
MANUALLY_OVERRIDABLE | Identifies if the Hold can be released manually | VARCHAR2(10) |
PLACED_FIRST_NAME | First Name of user who set hold | VARCHAR2(100) |
PLACED_LAST_NAME | Last Name of user who set hold | VARCHAR2(100) |
PROJECT_OBJECT_ID | Foreign Key to W_T_PROJECT_D | NUMBER(19) |
RELEASED_FIRST_NAME | First Name of user who released hold | VARCHAR2(100) |
RELEASED_LAST_NAME | Last Name of user who released hold | VARCHAR2(100) |
Last Published Tuesday, February 6, 2024