DW_CONTRACT_TYPE_D (Preview)

This table requires activation of Procurement Contracts functional area. This table stores contract types information used to create contracts.

Details

Module: Procurement Contracts

Key Columns

CONTRACT_TYPE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CONTRACT_TYPE_ID NUMBER 38 0 True Contract Type Identifier    
SOURCE_RECORD_ID NUMBER 38 0   System Identifier    
CONTRACT_CLASS VARCHAR2 32     Contract Class DW_OKC_CONTRACT_CLASS_LKP_TL OKC_CONTRACT_CLASS_CODE
START_DATE DATE       Contract type start date.    
END_DATE DATE       Contract type end date.    
ALLOW_LINES_FLAG VARCHAR2 16     Flag to indicate lines are allowed for a contract type.    
INTENT VARCHAR2 32     Intent of the contract type. DW_OKC_SETUP_INTENT_LKP_TL OKC_SETUP_INTENT_CODE

Copyright © 2019, 2023, Oracle and/or its affiliates.