DW_CONTRACT_HEADER_D

This table stored the contract header level details.

Details

Module: Project Billing

Key Columns

MAJOR_VERSION, CONTRACT_HEADER_ID

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     This column is for Oracle Internal use only. 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.    
CONTRACT_BUSINESS_UNIT_ID NUMBER 38 0   Indicates the identifier of the business unit associated to the row.    
CONTRACT_ORGANIZATION_ID NUMBER 38 0   Identifies the Business Unit (that has the Projects function enabled) that will be responsible for developing this contract. Only applies to a contract type with project lines.    
CREATION_DATE TIMESTAMP       Who column: indicates the date and time of the creation of the row.    
APPROVED_DATE DATE       Date when contract was approved.    
SIGNED_DATE DATE       Date when contract was signed.    
TERMINATED_DATE DATE       Effective date on which the contract will be terminated.    
TRN_CODE VARCHAR2 32     Termination Reason code.    
CONTRIBUTION_PERCENT NUMBER       When multiple contracts are used to fund a single project simultaneously (instead of sequentially), each contract will contribute a Pre-specified percentage. Default to 100%. This contribution percentage should only be applicable to contracts with project lines with rate based billing.    
BILL_SEQUENCE NUMBER 38 0   When multiple contracts are used to fund a single project sequentially, each contract should be assigned a user entered sequence which will determine the order of consumption. This sequence should only be applicable to contracts with project lines with rate based billing.    
CUST_PO_NUMBER VARCHAR2 256     Free form text referring to Customer PO Number, Wire or Check.    
NET_INVOICE_FLAG VARCHAR2 16     Flag to net invoice.    
CURRENCY_CODE VARCHAR2 16     Contract's transaction currency.    
LEGAL_ENTITY_ID NUMBER 38 0   This attribute is always derived from the Business Unit's Default Legal Context.User can change the legal entity.    
TRANSACTION_TYPE_ID NUMBER 38 0   Receivables Transaction Type for Invoices and Credit Memos. Displayed for sell intent only.    
INTER_COMPANY_FLAG VARCHAR2 16     InterCompany Flag    
INTER_PROJECT_FLAG VARCHAR2 16     InterProject Flag    
UNDER_AMEND_VERSION_FLAG VARCHAR2 16     Y or NULL - if under amendment with versioning, N if version wasn't created for amendment Always NULL if the contract is not UA    

Copyright © 2019, 2024, Oracle and/or its affiliates.