# DW_CONTRACT_HEADER_D

This table stored the contract header level details.

## Details

Module: Project Billing

## 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 |  |  | 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, 2025, Oracle and/or its affiliates.