This table requires activation of Procurement Contracts functional area. This table stores contract terms associated with buy contracts.
Module: Procurement Contracts
CONTRACT_TERM_ID
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 | 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, 2023, Oracle and/or its affiliates.