DW_ARTICLES_D (Preview)

This table requires activation of Procurement Contracts functional area. This table stores all the clauses that are used for an organization

Details

Module: Procurement Contracts

Key Columns

ARTICLE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ARTICLE_ID NUMBER 38 0 True Contract Clause Identifier
SOURCE_RECORD_ID NUMBER 38 0 This column is for Oracle Internal use only. System Identifier
ARTICLE_TITLE VARCHAR2 512 The Title for the clause.
ARTICLE_NUMBER VARCHAR2 256 Clause Number
STANDARD_FLAG VARCHAR2 16 Flag to indicate whether the clause is standard or non-standard.
ARTICLE_INTENT VARCHAR2 16 Clause intent DW_OKC_SETUP_INTENT_LKP_TL OKC_SETUP_INTENT_CODE
ARTICLE_TYPE VARCHAR2 32 This is the Clause Type DW_OKC_SUBJECT_LKP_TL OKC_SUBJECT_CODE