FUN_BAL_RESULTS_T
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: FUN
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| GROUP_ID | NUMBER | Yes | Oracle internal use only. | ||
| LEDGER_ID | NUMBER | 18 | Yes | Oracle internal use only. | |
| LE_ID | NUMBER | 18 | Oracle internal use only. | ||
| BAL_SEG_VAL | VARCHAR2 | 25 | Primary segment value of the account combination . | ||
| BAL_SEG_VAL2 | VARCHAR2 | 25 | Secondary balancing segment value for the account combination. | ||
| BAL_SEG_VAL3 | VARCHAR2 | 25 | Third balancing segment value of the account combination. | ||
| ENTERED_AMT_DR | NUMBER | Oracle internal use only. | |||
| ENTERED_AMT_CR | NUMBER | 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. | ||
| ACCOUNTED_AMT_DR | NUMBER | Credit amount for the balancing line in the accounted currency. | |||
| ACCOUNTED_AMT_CR | NUMBER | Credit amount for the balancing line in the accounted currency. | |||
| JGZZ_RECON_STATUS | VARCHAR2 | 1 | Balancing segment value of the debit account. | ||
| JGZZ_RECON_DATE | DATE | Balancing segment value of the credit account. | |||
| JGZZ_RECON_ID | NUMBER | 18 | Account code combination identifier. | ||
| JGZZ_RECON_REF | VARCHAR2 | 240 | Chart of accounts structure identifier. | ||
| JGZZ_RECON_CONTEXT | VARCHAR2 | 30 | Oracle internal use only. | ||
| DR_BSV | VARCHAR2 | 25 | Balancing segment value of the debit account. | ||
| CR_BSV | VARCHAR2 | 25 | Balancing segment value of the credit account. | ||
| INTER_RULE_ID | NUMBER | 18 | Oracle internal use only. | ||
| INTRA_RULE_ID | NUMBER | 18 | Oracle internal use only. | ||
| BALANCING_TYPE | VARCHAR2 | 1 | Oracle internal use only. | ||
| CCID | NUMBER | 18 | Account code combination identifier. | ||
| CHART_OF_ACCOUNTS_ID | NUMBER | 18 | Chart of accounts structure identifier. |