XLA_BAL_CTRL_CTRBS

Details

Schema: FUSION
Object owner: XLA
Object type: TABLE

Primary Key

Name	Columns
XLA_BAL_CTRL_CTRBS_GT_PK	APPLICATION_ID, LEDGER_ID, EFFECTIVE_PERIOD_NUM, CODE_COMBINATION_ID, PARTY_TYPE_CODE, PARTY_ID, PARTY_SITE_ID

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. EFFECTIVE_PERIOD_NUMNUMBER18YesEffective period number of the latest period for which the opening of the balances has been completed successfully for the ledger, application and balance source. CODE_COMBINATION_IDNUMBER18YesUnique identifier of an accounting flexfield segment. PARTY_TYPE_CODEVARCHAR21YesCode that is used to categorize a party. For example, organization, individual, group, or relationship. PARTY_IDNUMBER18YesIdentifier of additional party that participates in a business relationship. PARTY_SITE_IDNUMBER18YesIdentifier that refers to the name given to represent the location where a person or organization can be reached. PERIOD_NAMEVARCHAR215YesFiscal period that reports financial results, such as a calendar month or fiscal period. PERIOD_YEARNUMBER18YesFiscal year a company uses to report financial results. CONTRIBUTION_DRNUMBEROracle internal use only. CONTRIBUTION_CRNUMBEROracle internal use only. CONTRIBUTION_DRAFT_DRNUMBEROracle internal use only. CONTRIBUTION_DRAFT_CRNUMBEROracle internal use only. NET_CONTRIBUTION_DRNUMBEROracle internal use only. NET_CONTRIBUTION_CRNUMBEROracle internal use only. NET_CONTRIBUTION_DRAFT_DRNUMBEROracle internal use only. NET_CONTRIBUTION_DRAFT_CRNUMBEROracle internal use only. BALANCE_STATUS_EFF_PER_NUMNUMBER18YesOracle internal use only.

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.

EFFECTIVE_PERIOD_NUMNUMBER18YesEffective period number of the latest period for which the opening of the balances has been completed successfully for the ledger, application and balance source.

CODE_COMBINATION_IDNUMBER18YesUnique identifier of an accounting flexfield segment.

PARTY_TYPE_CODEVARCHAR21YesCode that is used to categorize a party. For example, organization, individual, group, or relationship.

PARTY_IDNUMBER18YesIdentifier of additional party that participates in a business relationship.

PARTY_SITE_IDNUMBER18YesIdentifier that refers to the name given to represent the location where a person or organization can be reached.

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

PERIOD_YEARNUMBER18YesFiscal year a company uses to report financial results.

CONTRIBUTION_DRNUMBEROracle internal use only.

CONTRIBUTION_CRNUMBEROracle internal use only.

CONTRIBUTION_DRAFT_DRNUMBEROracle internal use only.

CONTRIBUTION_DRAFT_CRNUMBEROracle internal use only.

NET_CONTRIBUTION_DRNUMBEROracle internal use only.

NET_CONTRIBUTION_CRNUMBEROracle internal use only.

NET_CONTRIBUTION_DRAFT_DRNUMBEROracle internal use only.

NET_CONTRIBUTION_DRAFT_CRNUMBEROracle internal use only.

BALANCE_STATUS_EFF_PER_NUMNUMBER18YesOracle internal use only.

Indexes

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