XLA_BAL_CTRL_LINES

Details

Schema: FUSION
Object owner: XLA
Object type: TABLE

Primary Key

Name	Columns
XLA_BAL_CTRL_LINES_GT_PK	AE_HEADER_ID, AE_LINE_NUM

Columns

Name
LINE_ROWIDROWIDYesNumber that identifies a unique line row. AE_HEADER_IDNUMBER18YesSubledger journal entry identifier. AE_LINE_NUMNUMBER18YesSubledger journal entry line number. 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. PERIOD_NAMEVARCHAR215YesFiscal period a company uses to report financial results, such as a calendar month or fiscal period. A portion of time in which the accounting calendar may be divided. Accounting periods make up an accounting calendar. PERIOD_YEARNUMBER18YesFiscal year a company uses to report financial results. EFFECTIVE_PERIOD_NUMNUMBER18YesOracle internal use only. ACCOUNTING_ENTRY_STATUS_CODEVARCHAR230YesOracle internal use only. CODE_COMBINATION_IDNUMBER18YesOracle internal use only. PARTY_TYPE_CODEVARCHAR21YesOracle internal use only. PARTY_IDNUMBER18YesOracle internal use only. PARTY_SITE_IDNUMBER18YesOracle internal use only. ACCOUNTED_DRNUMBEROracle internal use only. ACCOUNTED_CRNUMBEROracle internal use only. BALANCE_STATUS_CODEVARCHAR21Oracle internal use only. BALANCE_STATUS_EFF_PER_NUMNUMBER18Oracle internal use only.

Name

LINE_ROWIDROWIDYesNumber that identifies a unique line row.

AE_HEADER_IDNUMBER18YesSubledger journal entry identifier.

AE_LINE_NUMNUMBER18YesSubledger journal entry line number.

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.

PERIOD_NAMEVARCHAR215YesFiscal period a company uses to report financial results, such as a calendar month or fiscal period. A portion of time in which the accounting calendar may be divided. Accounting periods make up an accounting calendar.

PERIOD_YEARNUMBER18YesFiscal year a company uses to report financial results.

EFFECTIVE_PERIOD_NUMNUMBER18YesOracle internal use only.

ACCOUNTING_ENTRY_STATUS_CODEVARCHAR230YesOracle internal use only.

CODE_COMBINATION_IDNUMBER18YesOracle internal use only.

PARTY_TYPE_CODEVARCHAR21YesOracle internal use only.

PARTY_IDNUMBER18YesOracle internal use only.

PARTY_SITE_IDNUMBER18YesOracle internal use only.

ACCOUNTED_DRNUMBEROracle internal use only.

ACCOUNTED_CRNUMBEROracle internal use only.

BALANCE_STATUS_CODEVARCHAR21Oracle internal use only.

BALANCE_STATUS_EFF_PER_NUMNUMBER18Oracle internal use only.

Indexes

Index	Uniqueness	Columns
XLA_BAL_CTRL_LINES_GT_N1	Non Unique	APPLICATION_ID, LEDGER_ID, EFFECTIVE_PERIOD_NUM
XLA_BAL_CTRL_LINES_GT_U1	Unique	AE_HEADER_ID, AE_LINE_NUM