DW_PROC_CONTRACT_HEADERS_CF (Preview)

This table requires activation of Procurement Contracts functional area. This table stores information for buy contracts.

Details

Module: Procurement Contracts

Key Columns

CONTRACT_HEADER_ID

Columns

Columns
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   This column is for Oracle Internal use only. 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.    

Notes

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