1. Tables and Views for Financials
  2. GL_YEAR_END_BAL_GT

GL_YEAR_END_BAL_GT

GL_YEAR_END_BAL_GT contains debit or credit and equivalent amounts derived from GL_BALANCES table.

Details

  • Schema: FUSION

  • Object owner: GL

  • Object type: TABLE

Columns

Name

CODE_COMBINATION_IDNUMBER18YesOracle internal use only.

CURRENCY_CODEVARCHAR215YesOracle internal use only.

BALANCING_SEGMENTVARCHAR2150YesOracle internal use only.

CLOSING_ACCOUNTVARCHAR21YesOracle internal use only.

YEAR_TO_DATE_DRNUMBERYesOracle internal use only.

YEAR_TO_DATE_CRNUMBERYesOracle internal use only.

YEAR_TO_DATE_DR_BEQNUMBERYesYear-to-date debit equivalent amount.

YEAR_TO_DATE_CR_BEQNUMBERYesYear-to-date credit equivalent amount.

TRANSLATED_FLAGVARCHAR21Oracle internal use only.

BALANCING_SEGMENT_2VARCHAR2150Oracle internal use only.

BALANCING_SEGMENT_3VARCHAR2150Oracle internal use only.

BALANCING_SEGM_COMBVARCHAR24000Oracle internal use only.

LEGAL_ENTITY_IDNUMBER18Legal entity assigned to ledger and balancing segment value.