DW_CONTRACT_TERMS_MAP_G (Preview)

This table requires activation of Procurement Contracts functional area. This table stores contract terms associated with buy contracts.

Details

Module: Procurement Contracts

Key Columns

CONTRACT_TERM_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CONTRACT_TERM_ID NUMBER 38 0 True Contract term unique identifier.    
SOURCE_RECORD_ID NUMBER 38 0   This column is for Oracle Internal use only. Source record identifier.    
MAJOR_VERSION NUMBER 38 0   Major Version Number of the Contract Clause    
VERSION_TYPE VARCHAR2 16     Contract version type.    
DOCUMENT_ID NUMBER       Business document identifier.    
CREATION_TIMESTAMP TIMESTAMP       Contract Term creation date with timestamp    
AMENDMENT_OPERATION_CODE VARCHAR2 32     Operation performed during contract amendment. It contains DELETE, when clause is deleted during amend operation.    
ARTICLE_VERSION_ID NUMBER       Article version identifier.    
ARTICLE_VERSION_NUMBER NUMBER 38 0   Article version number of the clause.    
ARTICLE_ID NUMBER 38 0   Article Identifier DW_ARTICLES_D ARTICLE_ID
PROTECTED_CLAUSE_FLAG VARCHAR2 16     Flag to indicate whether the clause text can be modified on a business document DW_Y_N_D_TL CODE
ARTICLE_VERSION_DISPLAY_TITLE VARCHAR2 512     Displayed in a business document.    

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