XLA_FSN_ACCREV_GT

XLA_FSN_ACCREV_GT stores the identifier of the accrual journals that are to be reversed, the date and period on which they are to be reversed, the method to use to reverse them, and the identifier of the accrual reversal journals. It is used by the Accounting Engines' accrual reversal logic to do the necessary reversals.

Details

Schema: FUSION
Object owner: XLA
Object type: TABLE

Primary Key

Name	Columns
XLA_FSN_ACCREV_GT_PK	AE_HEADER_ID

Columns

Name
AE_HEADER_IDNUMBER18YesIdentifier of accrual subledger journal entry. ACCRUAL_REVERSAL_DATEDATEYesDate of the accrual reversal subledger journal entry. ACCRUAL_REVERSAL_PERIODVARCHAR215YesPeriod of the accrual reversal subledger journal entry. REVERSAL_METHODVARCHAR230YesMethod used to reverse an existing journal by switching debit and credit amount or by switching the sign. NEW_AE_HEADER_IDNUMBER18Identifier of accrual reversal journal entry.

Name

AE_HEADER_IDNUMBER18YesIdentifier of accrual subledger journal entry.

ACCRUAL_REVERSAL_DATEDATEYesDate of the accrual reversal subledger journal entry.

ACCRUAL_REVERSAL_PERIODVARCHAR215YesPeriod of the accrual reversal subledger journal entry.

REVERSAL_METHODVARCHAR230YesMethod used to reverse an existing journal by switching debit and credit amount or by switching the sign.

NEW_AE_HEADER_IDNUMBER18Identifier of accrual reversal journal entry.

Indexes

Index	Uniqueness	Columns
XLA_FSN_ACCREV_GT_U1	Unique	AE_HEADER_ID