DW_CONTRACT_LINE_D

This table stored the contract line level details.

Details

Module: Project Costing

Key Columns

MAJOR_VERSION, CONTRACT_LINE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CONTRACT_LINE_ID NUMBER 38 0 True Unique identifier of the contract line.    
MAJOR_VERSION NUMBER 38 0 True Major Version Number of the Contract.    
SOURCE_RECORD_ID VARCHAR2 128     System generated Unique Identifier.    
CONTRACT_HEADER_ID NUMBER 38 0   ID of the contract to which this line belongs.    
VERSION_TYPE VARCHAR2 16     Version Type can have 3 values: Current, Amendment, and History. If the version type is not Current then no update is allowed on the entity.    
LINE_NUMBER VARCHAR2 256     Sequential line number.    
LINE_TYPE_ID NUMBER 38 0   Line type id refers to Line Types setup.    
STATUS_CODE VARCHAR2 32     User status of the contract.    
START_DATE DATE       The beginning of the active period, one second after midnight on the date indicated.    
END_DATE DATE       The end of the active period, one second before midnight on the date indicated.    
SHIP_TO_PARTY_ID NUMBER 38 0   Ship to Party ID.    
SHIP_TO_CUSTOMER_ACCOUNT_ID NUMBER 38 0   Ship to Account (Customer Account) for Sell Intent contracts.    
SHIP_TO_LOCATION VARCHAR2 256     Site use identifier    
SHIP_TO_LOCATION_ID NUMBER 38 0   Ship to Site (Customer Account Site Use) Location identifier for Sell Intent contracts.    
SHIP_TO_SITE_USE_ID NUMBER 38 0   Ship to Site (Customer Account Site Use) Use identifier for Sell Intent contracts.