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.