This table stored the contract header level details.
Module: Project Costing
CONTRACT_HEADER_ID, MAJOR_VERSION
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. |