FUN_BAL_HEADERS_GT
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: FUN
-
Object type: TABLE
Primary Key
| Name | Columns |
|---|---|
|
FUN_BAL_HEADERS_GT_PK |
GROUP_ID |
Columns
| Name |
|---|
|
GROUP_IDNUMBERYesOracle internal use only. JE_SOURCE_NAMEVARCHAR225Oracle internal use only. JE_CATEGORY_NAMEVARCHAR225Oracle internal use only. TRX_TYPE_IDNUMBER18Oracle internal use only. GL_DATEDATEYesOracle internal use only. CLEARING_BSVVARCHAR225Oracle internal use only. STATUSVARCHAR25YesOracle internal use only. INTERCOMPANY_MODENUMBER1Oracle internal use only. DRIVING_DR_LEDGER_IDNUMBER18Oracle internal use only. DRIVING_CR_LEDGER_IDNUMBER18Oracle internal use only. DRIVING_DR_LE_IDNUMBER18Oracle internal use only. DRIVING_CR_LE_IDNUMBER18Oracle internal use only. LEDGER_COUNTNUMBER18Oracle internal use only. LE_COUNTNUMBER18Oracle internal use only. CURR_COUNTNUMBER18Oracle internal use only. UNMAPPED_BSV_LE_IDNUMBER18Oracle internal use only. ERROR_CODEVARCHAR230Oracle internal use only. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| FUN_BAL_HEADERS_GT_N1 | Non Unique | STATUS |
| FUN_BAL_HEADERS_GT_N2 | Non Unique | INTERCOMPANY_MODE |
| FUN_BAL_HEADERS_GT_U1 | Unique | GROUP_ID |