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 |