Period Statuses

The period statuses view object contains the statuses of the accounting periods. Each row includes the accounting period name, status and the relevant application identifier. The combination of GlPeriodStatusesPeriodName, GlPeriodStatusesLedgerId and GlPeriodStatusesApplicationId forms the unique identifier of the Period Statuses view object.

Data Store Key : FscmTopModelAM.FinExtractAM.GlBiccExtractAM.PeriodStatusExtractPVO

Primary Keys : GlPeriodStatusesLedgerId, GlPeriodStatusesApplicationId, GlPeriodStatusesPeriodName

Initial Extract Date : GlPeriodStatusesCreationDate

Incremental Extract Date : GlPeriodStatusesLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
GlPeriodStatusesAdjustmentPeriodFlag	Indicates whether the accounting period is an adjustment period. A list of accepted values is defined in the lookup type YES_NO.
GlPeriodStatusesApplicationId	The identifier of the application. This attribute is a part of the composite key of the Period Statuses view object.
GlPeriodStatusesAttribute1	A segment for the Open and Close Periods descriptive flexfield.
GlPeriodStatusesAttribute2	A segment for the Open and Close Periods descriptive flexfield.
GlPeriodStatusesAttribute3	A segment for the Open and Close Periods descriptive flexfield.
GlPeriodStatusesAttribute4	A segment for the Open and Close Periods descriptive flexfield.
GlPeriodStatusesAttribute5	A segment for the Open and Close Periods descriptive flexfield.
GlPeriodStatusesAttributeCategory	The descriptive flexfield context name for the Open and Close Periods descriptive flexfield.
GlPeriodStatusesClosingStatus	Identifies whether the period is open or closed. A list of accepted values is defined in the lookup type CLOSING_STATUS.
GlPeriodStatusesCreatedBy	The user who created the period status.
GlPeriodStatusesCreationDate	The date and time when the period status was created.
GlPeriodStatusesEffectivePeriodNum	The effective period number of the latest period for which the opening of the balances has been completed successfully for the ledger, application and balance source.
GlPeriodStatusesEndDate	The date when the accounting period ends.
GlPeriodStatusesLastUpdateDate	The date when the period status row was last updated.
GlPeriodStatusesLastUpdateLogin	The session login associated with the user who last updated the period status.
GlPeriodStatusesLastUpdatedBy	The user who last updated the period status.
GlPeriodStatusesLedgerId	The unique identifier of the ledgers view object. This is a foreign key of the Ledgers view object. This attribute is a part of the composite key of the Period Statuses view object.
GlPeriodStatusesObjectVersionNumber	The number of times the period status row has been updated.
GlPeriodStatusesPeriodName	The name of the accounting period. This attribute is a part of the composite key of the Period Statuses view object.
GlPeriodStatusesPeriodNum	The unique period number within an accounting calendar year.
GlPeriodStatusesPeriodType	The type of the accounting period. This attribute is a part of the composite key of the Period Statuses view object.
GlPeriodStatusesPeriodYear	The accounting calendar year represented by a numeric value, such as 2020.
GlPeriodStatusesQuarterNum	The quarter number for the accounting calendar period.
GlPeriodStatusesQuarterStartDate	The date when the quarter containing this accounting period starts.
GlPeriodStatusesSetOfBooksId	The unique identifier of the ledgers view object.
GlPeriodStatusesStartDate	The date when the accounting period begins.
GlPeriodStatusesYearStartDate	The date when the year containing this accounting period starts.