FUN_BAL_RESULTS_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	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			Oracle internal use only.
BAL_SEG_VAL2	VARCHAR2	25			Oracle internal use only.
BAL_SEG_VAL3	VARCHAR2	25			Oracle internal use only.
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				Oracle internal use only.
ACCOUNTED_AMT_CR	NUMBER				Oracle internal use only.
JGZZ_RECON_STATUS	VARCHAR2	1			Oracle internal use only.
JGZZ_RECON_DATE	DATE				Oracle internal use only.
JGZZ_RECON_ID	NUMBER		18		Oracle internal use only.
JGZZ_RECON_REF	VARCHAR2	240			Oracle internal use only.
JGZZ_RECON_CONTEXT	VARCHAR2	30			Oracle internal use only.
DR_BSV	VARCHAR2	25			Oracle internal use only.
CR_BSV	VARCHAR2	25			Oracle internal use only.
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		Oracle internal use only.
CHART_OF_ACCOUNTS_ID	NUMBER		18		Oracle internal use only.

Indexes

Index	Uniqueness	Columns
FUN_BAL_RESULTS_GT_N1	Non Unique	GROUP_ID, LE_ID, CR_BSV
FUN_BAL_RESULTS_GT_N2	Non Unique	GROUP_ID, CCID