XLA_MERGE_SEG_MAPS_GT

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

Details

  • Schema: FUSION

  • Object owner: XLA

  • Object type: TABLE

Primary Key

Name Columns

XLA_MERGE_SEG_MAPS_GT_PK

APPLICATION_ID, LEDGER_ID, SEGMENT_CODE, FROM_VALUE

Columns

Name

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

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

SEGMENT_CODEVARCHAR230YesAbbreviated name for a building block of chart of accounts in general ledger.

FROM_VALUEVARCHAR225YesInitial range value from which segment is merged from.

TO_VALUEVARCHAR225YesLast range value from which segment is merged from.

CHART_OF_ACCOUNTS_IDNUMBER18Identifier of the account structure your organization uses to record transactions and maintain account balances.

Indexes

Index Uniqueness Columns
XLA_MERGE_SEG_MAPS_GT_U1 Unique APPLICATION_ID, LEDGER_ID, SEGMENT_CODE, FROM_VALUE