FUN_BAL_INTER_INT_GT
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: FUN
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| GROUP_ID | NUMBER | Oracle internal use only. | ||
| LEDGER_ID | NUMBER | 18 | Oracle internal use only. | |
| GL_DATE | DATE | Oracle internal use only. | ||
| STATUS | VARCHAR2 | 5 | Oracle internal use only. | |
| DRIVING_DR_LEDGER_ID | NUMBER | 18 | Oracle internal use only. | |
| DRIVING_CR_LEDGER_ID | NUMBER | 18 | Oracle internal use only. | |
| DRIVING_DR_LE_ID | NUMBER | 18 | Oracle internal use only. | |
| DRIVING_CR_LE_ID | NUMBER | 18 | Oracle internal use only. | |
| INTERCOMPANY_MODE | NUMBER | 5 | Oracle internal use only. | |
| LE_ID | NUMBER | 18 | Oracle internal use only. | |
| ENTERED_CURRENCY_CODE | VARCHAR2 | 15 | Oracle internal use only. | |
| ACCOUNTED_AMT_CR | NUMBER | Oracle internal use only. | ||
| ACCOUNTED_AMT_DR | NUMBER | Oracle internal use only. | ||
| ENTERED_AMT_CR | NUMBER | Oracle internal use only. | ||
| ENTERED_AMT_DR | NUMBER | Oracle internal use only. | ||
| REC_ACCT | NUMBER | 18 | Oracle internal use only. | |
| PAY_ACCT | NUMBER | 18 | Oracle internal use only. | |
| REC_BSV | VARCHAR2 | 25 | Oracle internal use only. | |
| PAY_BSV | VARCHAR2 | 25 | Oracle internal use only. | |
| EXCHANGE_DATE | DATE | Oracle internal use only. | ||
| EXCHANGE_RATE | NUMBER | Oracle internal use only. | ||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Oracle internal use only. | |
| TYPE | VARCHAR2 | 1 | Oracle internal use only. | |
| DRIVING_DR_LE_BSV | VARCHAR2 | 25 | Oracle internal use only. | |
| DRIVING_CR_LE_BSV | VARCHAR2 | 25 | Oracle internal use only. | |
| LINE_LE_BSV | VARCHAR2 | 25 | Oracle internal use only. | |
| JE_SOURCE_NAME | VARCHAR2 | 25 | Oracle internal use only. | |
| JE_CATEGORY_NAME | VARCHAR2 | 25 | Oracle internal use only. | |
| TRX_TYPE_ID | NUMBER | 18 | Oracle internal use only. | |
| BAL_SEG_VAL2 | VARCHAR2 | 25 | Oracle internal use only. | |
| BAL_SEG_VAL3 | VARCHAR2 | 25 | Oracle internal use only. | |
| INTER_RULE_ID | NUMBER | 18 | Oracle internal use only. |
Indexes
| Index | Uniqueness | Columns | Status |
|---|---|---|---|
| FUN_BAL_INTER_INT_GT_N1 | Non Unique | GROUP_ID | Obsolete |
| FUN_BAL_INTER_INT_GT_N2 | Non Unique | INTERCOMPANY_MODE | |
| FUN_BAL_INTER_INT_GT_N3 | Non Unique | GROUP_ID, LEDGER_ID, LE_ID, LINE_LE_BSV, BAL_SEG_VAL2, BAL_SEG_VAL3 | |
| FUN_BAL_INTER_INT_GT_N4 | Non Unique | GROUP_ID, DECODE("INTERCOMPANY_MODE", 1, DECODE("LE_ID", "DRIVING_CR_LE_ID", "LE_ID"), 2, DECODE("TYPE", 'C', "LE_ID", "DRIVING_DR_LE_ID"), 3, DECODE("TYPE", 'D', "DRIVING_CR_LE_ID", "LE_ID"), NULL), DECODE("INTERCOMPANY_MODE", 1, "DRIVING_DR_LE_BSV", 2, DECODE("TYPE", 'C', "DRIVING_DR_LE_BSV", "LINE_LE_BSV"), 3, DECODE("TYPE", 'D', "LINE_LE_BSV", "DRIVING_CR_LE_BSV"), NULL) | |
| FUN_BAL_INTER_INT_GT_N5 | Non Unique | GROUP_ID, LEDGER_ID, LINE_LE_BSV, LE_ID, BAL_SEG_VAL2, BAL_SEG_VAL3 |