DW_CONTRACT_HEADER_D

This table stored the contract header level details.

Details

Module: Project Costing

Key Columns

CONTRACT_HEADER_ID, MAJOR_VERSION

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CONTRACT_HEADER_ID NUMBER 38 0 True Unique identifier of the contract header.    
MAJOR_VERSION NUMBER 38 0 True Major Version Number of the Contract.    
SOURCE_RECORD_ID VARCHAR2 128     System generated Unique Identifier.    
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.    
CONTRACT_NUMBER VARCHAR2 128     Contract number of contract.    
CONTRACT_TYPE_ID NUMBER 38 0   User defined type of contract like Project or Service.    
STATUS_CODE VARCHAR2 32     User status of the contract.    
START_DATE DATE       Start date of contract.    
END_DATE DATE       End date of contract.    
BILL_TO_PARTY_ID NUMBER 38 0   Bill to Party ID.    
BILL_TO_CUSTOMER_ACCOUNT_ID NUMBER 38 0   Bill to Account (Customer Account) for Sell Intent contracts.    
BILL_TO_LOCATION VARCHAR2 256     Bill to Site use identifier    
BILL_TO_LOCATION_ID NUMBER 38 0   Bill to Site (Customer Account Site Use) Location identifier for Sell Intent contracts.    
BILL_TO_SITE_USE_ID NUMBER 38 0   Bill to Site (Customer Account Site Use) Use identifier for Sell Intent contracts.    
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     Ship to 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.    
SOLD_TO_PARTY_ID NUMBER 38 0   Sold to Party ID.    
SOLD_TO_CUSTOMER_ACCOUNT_ID NUMBER 38 0   Sold to Account (Customer Account) for Sell Intent contracts.    
SOLD_TO_LOCATION VARCHAR2 256     Sold to Site use identifier    
SOLD_TO_LOCATION_ID NUMBER 38 0   Sold to Site (Customer Account Site Use) Location identifier for Sell Intent contracts.    
SOLD_TO_SITE_USE_ID NUMBER 38 0   Sold to Site (Customer Account Site Use) Use identifier for Sell Intent contracts.