1. Tables and Views for Financials
  2. XLA_BAL_RECREATE_GT

XLA_BAL_RECREATE_GT

Global temporary table for balance recreation.

Details

  • Schema: FUSION

  • Object owner: XLA

  • Object type: TABLE

Primary Key

Name Columns

XLA_BAL_RECREATE_GT_PK

LEDGER_ID, APPLICATION_ID, CODE_COMBINATION_ID, BALANCE_SOURCE_CODE

Columns

Name

LEDGER_IDNUMBER18YesSelf-contained accounting information set for single or multiple legal or management entities.

APPLICATION_IDNUMBER18YesFunctional area within a software suite of products. For example, Financials or Payroll.

CODE_COMBINATION_IDNUMBER18YesUnique identifier of an accounting flexfield segment.

BALANCE_SOURCE_CODEVARCHAR21YesType of balances. A indicates Analytical balance. C indicates Control balance.

Indexes

Index Uniqueness Columns
XLA_BAL_RECREATE_GT_U1 Unique LEDGER_ID, APPLICATION_ID, CODE_COMBINATION_ID, BALANCE_SOURCE_CODE