GL_JE_ACCRUAL_REVERSAL_GT

This table is used for internal processing only.

Details

  • Schema: FUSION

  • Object owner: GL

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Length Precision Not-null Comments
LEDGER_ID NUMBER 18 Yes Oracle internal use only.
JE_SOURCE VARCHAR2 25 Yes Oracle internal use only.
JE_CATEGORY VARCHAR2 25 Yes Oracle internal use only.
PERIOD_NAME VARCHAR2 15 Yes Oracle internal use only.
EFFECTIVE_DATE DATE Yes Oracle internal use only.
ACCRUAL_REVERSAL_METHOD_CODE VARCHAR2 1 Oracle internal use only.
ACCRUAL_REVERSAL_PERIOD_NAME VARCHAR2 15 Oracle internal use only.
ACCRUAL_REVERSAL_DATE DATE Oracle internal use only.

Indexes

Index Uniqueness Columns
GL_JE_ACCRUAL_REVERSAL_GT_U1 Unique LEDGER_ID, JE_SOURCE, JE_CATEGORY, PERIOD_NAME, EFFECTIVE_DATE