This table stores contract project linkage records.
Module: Project Costing
MAJOR_VERSION, LINK_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
LINK_ID | NUMBER | 38 | 0 | True | Contract Project linkage ID | ||
MAJOR_VERSION | NUMBER | 38 | 0 | True | Major Version | ||
SOURCE_RECORD_ID | VARCHAR2 | 128 | System Generated Unique Identifier | ||||
VERSION_TYPE | VARCHAR2 | 16 | Version Type | ||||
CONTRACT_HEADER_ID | NUMBER | 38 | 0 | Contract Header ID | DW_CONTRACT_HEADER_D | CONTRACT_HEADER_ID | |
CONTRACT_LINE_ID | NUMBER | 38 | 0 | Contract Line ID | DW_CONTRACT_LINE_D | CONTRACT_LINE_ID | |
PROJECT_ID | NUMBER | 38 | 0 | Project ID | DW_PROJECT_D | PROJECT_ID | |
PROJECT_ELEMENT_ID | NUMBER | 38 | 0 | Project element ID | DW_PROJECT_ELEMENT_D | PROJ_ELEMENT_ID | |
FUNDING_AMOUNT | NUMBER | Funding Amount | |||||
BILLING_TYPE_CODE | VARCHAR2 | 32 | Billing Type Code | ||||
ACTIVE_FLAG | VARCHAR2 | 16 | Active Flag | ||||
PERCENT_COMPLETE | NUMBER | Percent Complete |