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. |