GL_MC_OPTIONS_GT
This table is used for internal processing only
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: Default
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
JE_SOURCE_NAME | VARCHAR2 | 30 | Yes | This column is used for internal processing only | |
JE_CATEGORY_NAME | VARCHAR2 | 30 | Yes | This column is used for internal processing only | |
ACTUAL_FLAG | VARCHAR2 | 1 | Yes | This column is used for internal processing only. | |
RELATIONSHIP_ID | NUMBER | 18 | Yes | This column is used for internal processing only | |
SOURCE_LEDGER_ID | NUMBER | 18 | Yes | This column is used for internal processing only | |
TARGET_LEDGER_ID | NUMBER | 18 | Yes | This column is used for internal processing only | |
JOURNAL_LEDGER_ID | NUMBER | 18 | Yes | This column is used for internal processing only | |
TARGET_CURRENCY_CODE | VARCHAR2 | 15 | Yes | This column is used for internal processing only | |
TARGET_LEDGER_SHORT_NAME | VARCHAR2 | 20 | Yes | This column is used for internal processing only | |
TARGET_LEDGER_CATEGORY_CODE | VARCHAR2 | 30 | Yes | This column is used for internal processing only | |
TARGET_LEDGER_CONSOLID_FLAG | VARCHAR2 | 1 | Yes | This column is used for internal processing only | |
SL_TYPE_CODE | VARCHAR2 | 30 | Yes | This column is used for internal processing only | |
RELATIONSHIP_TYPE_CODE | VARCHAR2 | 30 | Yes | Oracle internal use only | |
INHERIT_CREATION_USER_FLAG | VARCHAR2 | 1 | This column is used for internal processing only | ||
GL_JE_CONVERSION_SET_ID | NUMBER | 18 | This column is used for internal processing only | ||
CONVERSION_FLAG | VARCHAR2 | 1 | This column is used for internal processing only | ||
ALC_NO_RATE_ACTION_CODE | VARCHAR2 | 30 | This column is used for internal processing only | ||
ALC_DEFAULT_CONV_RATE_TYPE | VARCHAR2 | 30 | This column is used for internal processing only | ||
ALC_INHERIT_CONVERSION_TYPE | VARCHAR2 | 1 | This column is used for internal processing only | ||
SL_COA_MAPPING_ID | NUMBER | 18 | This column is used for internal processing only | ||
SL_AUTOMATIC_POST_FLAG | VARCHAR2 | 1 | This column is used for internal processing only |
Indexes
Index | Uniqueness | Columns |
---|---|---|
GL_MC_OPTIONS_GT_N1 | Non Unique | JE_SOURCE_NAME, JE_CATEGORY_NAME, JOURNAL_LEDGER_ID, TARGET_LEDGER_CATEGORY_CODE |
GL_MC_OPTIONS_GT_U1 | Unique | JE_SOURCE_NAME, JE_CATEGORY_NAME, SOURCE_LEDGER_ID, TARGET_LEDGER_CATEGORY_CODE, ACTUAL_FLAG, SL_TYPE_CODE, TARGET_LEDGER_ID |