XLA_BAL_STATUSES

Details

Schema: FUSION
Object owner: XLA
Object type: TABLE

Primary Key

Name	Columns
XLA_BAL_STATUSES_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_CODEVARCHAR21YesCode that identifies the type of balance. Valid values are A for Analytical balance and C for Control balance. BALANCE_STATUS_CODEVARCHAR21YesCode that identifies the status of the balance period. A indicates available for balance calculation+M719. indicates balance is currently processed by the recreation function in the second phase of the recreation. C indicates balance is currently processed by the recreation function; the recalculation phase is completed. O indicates balance is currently processed by the open period function. indicates balance is currently processed by the recreation function during the rebuild of the balances. indicates balance is currently processed by the recreation function in the first phase of the recreation. indicates balance is currently processed by the balance synchronization function. EFFECTIVE_PERIOD_NUMNUMBER18YesPeriod when a transaction is effective. NATURAL_ACCOUNT_SEGMENTVARCHAR225YesSegment that determines whether an account is an asset, liability, owners' equity, revenue, or expense account BALANCING_SEGMENTVARCHAR225YesAccounting flexfield segment used to automatically balance all journal entries for each value of this segment. ACCOUNT_TYPEVARCHAR21YesType of general ledger account.

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_CODEVARCHAR21YesCode that identifies the type of balance. Valid values are A for Analytical balance and C for Control balance.

BALANCE_STATUS_CODEVARCHAR21YesCode that identifies the status of the balance period. A indicates available for balance calculation+M719. indicates balance is currently processed by the recreation function in the second phase of the recreation. C indicates balance is currently processed by the recreation function; the recalculation phase is completed. O indicates balance is currently processed by the open period function. indicates balance is currently processed by the recreation function during the rebuild of the balances. indicates balance is currently processed by the recreation function in the first phase of the recreation. indicates balance is currently processed by the balance synchronization function.

EFFECTIVE_PERIOD_NUMNUMBER18YesPeriod when a transaction is effective.

NATURAL_ACCOUNT_SEGMENTVARCHAR225YesSegment that determines whether an account is an asset, liability, owners' equity, revenue, or expense account

BALANCING_SEGMENTVARCHAR225YesAccounting flexfield segment used to automatically balance all journal entries for each value of this segment.

ACCOUNT_TYPEVARCHAR21YesType of general ledger account.

Indexes

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