FUN_BAL_LEDGER_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. | |
| LE_ID | NUMBER | 18 | Oracle internal use only. | |
| BAL_SEG_VAL | VARCHAR2 | 25 | Oracle internal use only. | |
| BAL_SEG_VAL2 | VARCHAR2 | 25 | Oracle internal use only. | |
| BAL_SEG_VAL3 | VARCHAR2 | 25 | Oracle internal use only. | |
| ENTERED_CURRENCY_CODE | VARCHAR2 | 15 | 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. | |
| GL_DATE | DATE | Oracle internal use only. | ||
| DRIVING_DR_BSV | VARCHAR2 | 25 | Oracle internal use only. | |
| DRIVING_CR_BSV | VARCHAR2 | 25 | Oracle internal use only. | |
| INTRACOMPANY_MODE | NUMBER | 5 | Oracle internal use only. | |
| BALANCE_BY | VARCHAR2 | 1 | Oracle internal use only. | |
| CLEARING_BSV | VARCHAR2 | 25 | Oracle internal use only. | |
| INTRA_RULE_ID | NUMBER | 18 | Oracle internal use only. | |
| CLEARING_OPTION | VARCHAR2 | 2 | Oracle internal use only. | |
| INTER_RULE_ID | NUMBER | 18 | Oracle internal use only. | |
| DR_CR_DEBIT_CCID | NUMBER | 18 | Oracle internal use only. | |
| DR_CR_CREDIT_CCID | NUMBER | 18 | Oracle internal use only. | |
| CR_DR_DEBIT_CCID | NUMBER | 18 | Oracle internal use only. | |
| CR_DR_CREDIT_CCID | NUMBER | 18 | 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. | ||
| TYPE | VARCHAR2 | 1 | Oracle internal use only. | |
| BAL_SEG_COLUMN_NUMBER | NUMBER | 2 | Oracle internal use only. | |
| BAL_SEG_COLUMN_NUMBER2 | NUMBER | 2 | Oracle internal use only. | |
| BAL_SEG_COLUMN_NUMBER3 | NUMBER | 2 | Oracle internal use only. | |
| INTERCOMPANY_COLUMN_NUMBER | NUMBER | 2 | Oracle internal use only. | |
| CHART_OF_ACCOUNTS_ID | NUMBER | 18 | Oracle internal use only. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| FUN_BAL_LEDGER_INTER_INT_GT_N1 | Non Unique | GROUP_ID, LEDGER_ID, LE_ID, BAL_SEG_VAL |
| FUN_BAL_LEDGER_INTER_INT_GT_N2 | Non Unique | LEDGER_ID |