1. Tables and Views for Sales, Fusion Service, and Field Service
  2. OKC_K_ART_VARIABLES_H

OKC_K_ART_VARIABLES_H

Document clause variable table. This will store clause variables used in a document through contract term

Details

  • Schema: FUSION

  • Object owner: OKC

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

OKC_K_ART_VARIABLES_H_PK

CAT_ID, MAJOR_VERSION, VARIABLE_CODE

Columns

Name Datatype Length Precision Not-null Comments
CAT_ID NUMBER 18 Yes It refers to the contract clause id. Part of the Primary Key.
MAJOR_VERSION NUMBER 18 Yes Major Version Number of the Contract Clause Variable
VERSION_TYPE VARCHAR2 1 Yes Version Type of the Object. It can have following values "C"urrent , "A"mendment and "H"istory.
VARIABLE_CODE VARCHAR2 30 Yes Variable Code for the Clause variable used
VARIABLE_TYPE VARCHAR2 1 Yes Variable Type of the Clause variable used
EXTERNAL_YN VARCHAR2 1 Yes Flag to identify whether the data entry be to allowed for external users
ATTRIBUTE_VALUE_SET_ID NUMBER Value Set Id of variables. The value for the variable will be sourced from this fnd value set
VARIABLE_VALUE_ID VARCHAR2 40 It refers to the id of the variable value. It applies to the LOVs and Choice Lists.
VARIABLE_VALUE VARCHAR2 2000 It refers to the value of the variable . It applies to free format.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
OVERRIDE_GLOBAL_YN VARCHAR2 1 Indicator to show whether the global value is overridden or not
GLOBAL_VARIABLE_VALUE VARCHAR2 2000 Stores value for global variable. This column is used for UI manipulations
GLOBAL_VARIABLE_VALUE_ID VARCHAR2 40 Stores id value for global variable. This column is used for UI manipulations
AMENDMENT_DESCRIPTION VARCHAR2 2000 It describes the amendment operation.
AMENDMENT_OPERATION_CODE VARCHAR2 30 It describes the amendment operation code, Values are "ADDED", "DELETED","UPDATED"
SUMMARY_AMEND_OPERATION_CODE VARCHAR2 30 It describes the summary amendment operation code, Values are "ADDED", "DELETED","UPDATED"

Foreign Keys

Table Foreign Table Foreign Key Column
OKC_K_ART_VARIABLES_H okc_k_articles_b CAT_ID

Indexes

Index Uniqueness Tablespace Columns
OKC_K_ART_VARIABLES_H_U1 Unique Default CAT_ID, MAJOR_VERSION, VARIABLE_CODE