This table requires activation of Procurement Contracts functional area. This table stores information for buy contracts.
Module: Procurement Contracts
CONTRACT_HEADER_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
CONTRACT_HEADER_ID | NUMBER | 38 | 0 | True | Contract header unique identifier.#2 | DW_CONTRACT_HEADER_D_TL | CONTRACT_HEADER_ID |
SOURCE_RECORD_ID | NUMBER | 38 | 0 | Source record identifier. | |||
CONTRACT_MAJOR_VERSION | NUMBER | 38 | 0 | Contract version number. | |||
MASTER_CONTRACT_ID | NUMBER | 38 | 0 | Unique contract identifier used during creation for Purchase Document. | |||
CONTRACT_NUMBER | VARCHAR2 | 128 | Contract number | ||||
CONTRACT_TYPE_ID | NUMBER | 38 | 0 | This column stores the contract type used in contract. | DW_CONTRACT_TYPE_D | CONTRACT_TYPE_ID | |
LEGAL_ENTITY_ID | NUMBER | 38 | 0 | This column stores Legal entity used in contract | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID | |
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 | Accounting period type based on primary ledger of business unit. #1 | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE | ||
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 | Accounting calendar name based on primary ledger of business unit. #1 | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME | ||
LEDGER_ID | NUMBER | 38 | 0 | Business unit primary ledger identifier. | DW_LEDGER_D | LEDGER_ID | |
BUSINESS_UNIT_ID | NUMBER | 38 | 0 | Business unit identifier. | DW_INTERNAL_ORG_D | ORGANIZATION_ID | |
CONTRACT_ITEM_MASTER_ORGANIZATION_ID | NUMBER | 38 | 0 | Inventory Organization for the contract points. | DW_INV_ORGANIZATION_D | INV_ORGANIZATION_ID | |
CONTRACT_ASSIGNEE_ID | NUMBER | 38 | 0 | Current assignee of a contract. | DW_PARTY_D | PARTY_ID | |
CONTRACT_STATUS_CODE | VARCHAR2 | 32 | Status of the contract. | DW_OKC_STATUS_LKP_TL | OKC_STATUS_CODE | ||
CONTRACT_AP_PAYMENT_TERMS_ID | NUMBER | 38 | 0 | Payment term for a contract. | DW_AP_TERMS_D | PAYMENT_TERMS_ID | |
CONTRACT_FREIGHT_TERMS_CODE | VARCHAR2 | 256 | Determines the freight terms for the contract. | DW_FREIGHT_TERMS_LKP_TL | FREIGHT_TERMS_CODE | ||
CONTRACT_CARRIER_ID | NUMBER | 38 | 0 | Type of carrier used for a contract. | DW_PARTY_D | PARTY_ID | |
CONTRACT_FOB_CODE | VARCHAR2 | 256 | Determines the point of transfer of ownership. | DW_FOB_LKP_TL | FOB_CODE | ||
CONTRACT_ENCUMBRANCE_LEVEL | VARCHAR2 | 32 | This column stores level of restiction on agreement. | DW_OKC_AGR_ENCUMB_LEVEL_LKP_TL | OKC_AGR_ENCUMB_LEVEL_CODE | ||
CONTRACT_TERMINATION_REASON_CODE | VARCHAR2 | 32 | Closed reason for a contract. | DW_CONTRACT_TRN_CODE_LKP_TL | OKC_TRN_CODE | ||
CONTRACT_HOLD_REASON_CODE | VARCHAR2 | 32 | Hold Reason for a contract. | DW_OKC_APPLY_HOLD_REASON_LKP_TL | OKC_APPLY_HOLD_REASON_CODE | ||
CONTRACT_SOURCE_DOC_SYSTEM_CODE | VARCHAR2 | 32 | This column stores the source system details which helped to generate contract. | DW_ORA_OKC_SOURCE_SYSTEM_LKP_TL | ORA_OKC_SOURCE_SYSTEM_CODE | ||
CONTRACT_SOURCE_DOC_ID | NUMBER | 38 | 0 | Source document identified from where contract sourced from. | |||
CONTRACT_UNDER_AMEND_VERSION_FLAG | VARCHAR2 | 16 | It stores - N: if version wasn't created for amendment, Y or NOVALUE - if under amendment with versioning | DW_Y_N_D_TL | CODE_TYPE | ||
TXN_CURRENCY_CODE | VARCHAR2 | 16 | Transaction currency code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
CONTRACT_AMOUNT | NUMBER | Contract's total amount | |||||
CONTRACT_AGREEMENT_AMOUNT | NUMBER | Contract agreed amount - valid for agreement contract class. | |||||
CONTRACT_AGREEMENT_MIN_RELEASE_AMT | NUMBER | Contract minimum released amount - valid for agreement contract class. | |||||
CONTRACT_AGREEMENT_AMT_LIMIT | NUMBER | Contract amount limit - valid for agreement contract class. | |||||
GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 | Global currency code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
GLOBAL_CURRENCY_EXCH_RATE | NUMBER | Global currency conversion rate. | |||||
GLOBAL_CONTRACT_AMOUNT | NUMBER | Contract's total amount in global currency. | |||||
GLOBAL_CONTRACT_AGR_AMOUNT | NUMBER | Contract agreed amount - valid for agreement contract class in global currency. | |||||
GLOBAL_CONTRACT_AGR_MIN_RELEASE_AMT | NUMBER | Contract minimum released amount - valid for agreement contract class in global currency. | |||||
GLOBAL_CONTRACT_AGR_AMT_LIMIT | NUMBER | Contract amount limit - valid for agreement contract class in global currency. | |||||
CONTRACT_START_DATE | DATE | Start date of the contract. | DW_DAY_D | CALENDAR_DATE | |||
CONTRACT_END_DATE | DATE | End date of the contract. | DW_DAY_D | CALENDAR_DATE | |||
CONTRACT_CREATION_DATE | DATE | Who column: indicates the date of the creation of the row. | DW_DAY_D | CALENDAR_DATE | |||
CONTRACT_CREATION_TIMESTAMP | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||||
CONTRACT_SIGNED_DATE | DATE | Date when contract was signed. | DW_DAY_D | CALENDAR_DATE | |||
CONTRACT_TERMINATED_DATE | DATE | Effective date on which the contract will be terminated. | DW_DAY_D | CALENDAR_DATE | |||
CONTRACT_APPROVED_DATE | DATE | Date when contract was approved. | DW_DAY_D | CALENDAR_DATE | |||
CONTRACT_HOLD_UNTIL_DATE | DATE | Date until which the hold is effective on the contract. | DW_DAY_D | CALENDAR_DATE | |||
CONTRACT_LAST_UPDATE_TIMESTAMP | TIMESTAMP | Who column: indicates the date and time of the last update of the row. |
#1 In these cases to join with DW_FISCAL_DAY_D apart from FISCAL_PERIOD_TYPE and FISCAL_PERIOD_SET_NAME the relationship should be based on CONTRACT_START_DATE column.#2 In these cases the join should also be based on MAJOR_VERSION
Copyright © 2019, 2023, Oracle and/or its affiliates.