XLA_CTRL_BAL_INTERIM

Details

Schema: FUSION
Object owner: XLA
Object type: TABLE

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. CODE_COMBINATION_IDNUMBER18YesUnique identifier of an accounting flexfield segment. PARTY_TYPE_CODEVARCHAR21YesIndicates the type of the third party. C: customer; S: supplir. PARTY_IDNUMBER18YesParty identifier. Together with the PARTY_SITE_ID, these two columns make up the third party identification. PARTY_SITE_IDNUMBER18YesParty site identifier. Together with the PARTY_ID, these two columns make up the third party identification. Since PARTY_SITE_ID may be null, it is populated with -999 in this table. PERIOD_NAMEVARCHAR215Fiscal period that reports financial results, such as a calendar month or fiscal period. EFFECTIVE_PERIOD_NUMNUMBERYesPeriod when a transaction, such as an asset retirement, is effective. PERIOD_YEARNUMBERYesPeriod year defined in general ledger accounting period. PERIOD_BALANCE_DRNUMBERCurrent debit balance for the period that makes up of the period activity. PERIOD_BALANCE_CRNUMBERCurrent credit balance for the period that is made up of the period activity. BEGINNING_BALANCE_DRNUMBERBeginning debit balance for the period. BEGINNING_BALANCE_CRNUMBERBeginning credit balance for the period. PARTITION_GROUP_CODEVARCHAR215Partition grouping information which determines the database partition in which this control balance record will be stored.

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.

CODE_COMBINATION_IDNUMBER18YesUnique identifier of an accounting flexfield segment.

PARTY_TYPE_CODEVARCHAR21YesIndicates the type of the third party. C: customer; S: supplir.

PARTY_IDNUMBER18YesParty identifier. Together with the PARTY_SITE_ID, these two columns make up the third party identification.

PARTY_SITE_IDNUMBER18YesParty site identifier. Together with the PARTY_ID, these two columns make up the third party identification. Since PARTY_SITE_ID may be null, it is populated with -999 in this table.

PERIOD_NAMEVARCHAR215Fiscal period that reports financial results, such as a calendar month or fiscal period.

EFFECTIVE_PERIOD_NUMNUMBERYesPeriod when a transaction, such as an asset retirement, is effective.

PERIOD_YEARNUMBERYesPeriod year defined in general ledger accounting period.

PERIOD_BALANCE_DRNUMBERCurrent debit balance for the period that makes up of the period activity.

PERIOD_BALANCE_CRNUMBERCurrent credit balance for the period that is made up of the period activity.

BEGINNING_BALANCE_DRNUMBERBeginning debit balance for the period.

BEGINNING_BALANCE_CRNUMBERBeginning credit balance for the period.

PARTITION_GROUP_CODEVARCHAR215Partition grouping information which determines the database partition in which this control balance record will be stored.

Indexes

Index	Uniqueness	Columns
XLA_CTRL_BAL_INTERIM_GT_U1	Unique	APPLICATION_ID, LEDGER_ID, CODE_COMBINATION_ID, PARTY_TYPE_CODE, PARTY_ID, PARTY_SITE_ID, EFFECTIVE_PERIOD_NUM