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