DW_CONTRACT_PROJECT_LINK_CF

This table stores contract project linkage records.

Details

Module: Project Costing

Key Columns

MAJOR_VERSION, LINK_ID

Columns

Columns
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