FUN_BAL_LE_BSV_MAP_GT

This is a temporary table which is used internally by Oracle.

Details

• Schema: FUSION

• Object owner: FUN

• Object type: TABLE

Columns

Name

GROUP_IDNUMBERYesOracle internal use only. LEDGER_IDNUMBER18YesOracle internal use only. LE_IDNUMBER18Oracle internal use only. BAL_SEG_VALVARCHAR225YesOracle internal use only. BAL_SEG_VAL2VARCHAR225Oracle internal use only. BAL_SEG_VAL3VARCHAR225Oracle internal use only. GL_DATEDATEOracle internal use only. DRIVING_DR_BSVVARCHAR225Oracle internal use only. DRIVING_CR_BSVVARCHAR225Oracle internal use only. INTRACOMPANY_MODENUMBER5Oracle internal use only. INTRA_RULE_IDNUMBER18Oracle internal use only. INTER_RULE_IDNUMBER18Oracle internal use only. BALANCE_BYVARCHAR21Oracle internal use only. CLEARING_OPTIONVARCHAR22Oracle internal use only. JE_SOURCE_NAMEVARCHAR225Oracle internal use only. JE_CATEGORY_NAMEVARCHAR225Oracle internal use only. CLEARING_BSVVARCHAR225Oracle internal use only. DR_CR_DEBIT_CCIDNUMBER18Oracle internal use only. DR_CR_CREDIT_CCIDNUMBER18Oracle internal use only. CR_DR_DEBIT_CCIDNUMBER18Oracle internal use only. CR_DR_CREDIT_CCIDNUMBER18Oracle internal use only. BAL_SEG_COLUMN_NUMBERNUMBER2Oracle internal use only. BAL_SEG_COLUMN_NUMBER2NUMBER2Oracle internal use only. BAL_SEG_COLUMN_NUMBER3NUMBER2Oracle internal use only. INTERCOMPANY_COLUMN_NUMBERNUMBER2Oracle internal use only. CHART_OF_ACCOUNTS_IDNUMBER18Oracle internal use only. MANY_TO_MANY_OPTIONVARCHAR22Oracle internal use only.

Indexes

Index	Uniqueness	Columns
FUN_BAL_LE_BSV_MAP_GT_N1	Non Unique	GROUP_ID, LEDGER_ID, LE_ID, BAL_SEG_VAL
FUN_BAL_LE_BSV_MAP_GT_N2	Non Unique	INTRACOMPANY_MODE