GL_MULTI_BAL_SEG_GT
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
GL_MULTI_BAL_SEG_GT_PK |
TEMPLATE_ACCOUNT_CODE, LEDGER_ID, JE_HEADER_ID, BAL_SEG_VALUE_1, BAL_SEG_VALUE_2, BAL_SEG_VALUE_3, CURRENCY_CODE, BAL_SEG_VALUE_4, BAL_SEG_VALUE_5 |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CHART_OF_ACCOUNTS_ID | NUMBER | 18 | Yes | This column is used in internal processing only | |
| LEDGER_ID | NUMBER | 18 | Yes | This column is used in internal processing only | |
| BAL_SEG_VALUE_1 | VARCHAR2 | 150 | Yes | This column is used in internal processing only | |
| BAL_SEG_VALUE_2 | VARCHAR2 | 150 | Yes | This column is used in internal processing only | |
| BAL_SEG_VALUE_3 | VARCHAR2 | 150 | Yes | This column is used in internal processing only | |
| BAL_SEG_VALUE_4 | VARCHAR2 | 150 | Yes | Oracle internal use only | |
| BAL_SEG_VALUE_5 | VARCHAR2 | 150 | Yes | Oracle internal use only | |
| TEMPLATE_ACCOUNT_CODE | VARCHAR2 | 30 | Yes | This column is used in internal processing only | |
| TEMPLATE_ACCOUNT_CCID | NUMBER | 18 | This column is used in internal processing only | ||
| REVALUATION_ID | NUMBER | 18 | This column is used in internal processing only | ||
| BALANCING_ACCOUNT_CCID | NUMBER | 18 | This column is used in internal processing only | ||
| ERROR_CODE | VARCHAR2 | 25 | This column is used in internal processing only | ||
| ERROR_TEXT | VARCHAR2 | 250 | This column is used in internal processing only | ||
| ACCOUNT_COMBINATION | VARCHAR2 | 2000 | This column is used in internal processing only | ||
| EFFECTIVE_DATE | DATE | This column is used in internal processing only | |||
| JE_HEADER_ID | NUMBER | 18 | Yes | This column is used in internal processing only | |
| NEW_ACCOUNT_FLAG | VARCHAR2 | 1 | This column is used in internal processing only | ||
| CURRENCY_CODE | VARCHAR2 | 25 | Yes | Oracle internal use only. | |
| LEDGER_CURRENCY_CODE | VARCHAR2 | 15 | Ledger Currency Code defining column. | ||
| MIN_PERIOD_YEAR | NUMBER | 18 | Minimum Period Year defining column. | ||
| MGT_SEG_VALUE_1 | VARCHAR2 | 150 | Oracle internal use only. | ||
| OPENING_PERIOD_AGGREGATE | NUMBER | End of day balance of the last day of the previous period. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| GL_MULTI_BAL_SEG_GT_U1 | Unique | TEMPLATE_ACCOUNT_CODE, LEDGER_ID, JE_HEADER_ID, BAL_SEG_VALUE_1, BAL_SEG_VALUE_2, BAL_SEG_VALUE_3, CURRENCY_CODE, BAL_SEG_VALUE_4, BAL_SEG_VALUE_5 |