Accounting Calendar Periods

The accounting calendar periods view object contains information about the accounting periods. Each row includes the start date and end date of the period, period type, fiscal year, period number, and other information. The combination of PeriodPeriodSetName and PeriodPeriodName forms the unique identifier of the Accounting Calendar Periods view object.

Data Store Key : FscmTopModelAM.FinExtractAM.GlBiccExtractAM.FiscalPeriodExtractPVO

Primary Keys : PeriodPeriodName, PeriodPeriodSetName

Initial Extract Date : PeriodCreationDate

Incremental Extract Date : PeriodLastUpdateDate

Attributes

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

Name Description
AccountingCalendarDescription The description of the AccountingCalendar entity object provided by the user or source application.
AccountingCalendarPeriodSetName The name of the AccountingCalendar entity object.
AccountingCalendarSecurityFlag Indicates whether the calendar setup definition is secured. A list of accepted values is defined in the lookup type YES_NO.
PeriodAdjustmentPeriodFlag Indicates whether the accounting period is an adjusting period. It can have two possible values: Y and N. Y indicates that the period is an adjustment period and N indicates that the period is a standard period.
PeriodAttribute1 A segment for the Accounting Calendar Periods descriptive flexfield.
PeriodAttribute2 A segment for the Accounting Calendar Periods descriptive flexfield.
PeriodAttribute3 A segment for the Accounting Calendar Periods descriptive flexfield.
PeriodAttribute4 A segment for the Accounting Calendar Periods descriptive flexfield.
PeriodAttribute5 A segment for the Accounting Calendar Periods descriptive flexfield.
PeriodAttribute6 A segment for the Accounting Calendar Periods descriptive flexfield.
PeriodAttribute7 A segment for the Accounting Calendar Periods descriptive flexfield.
PeriodAttribute8 A segment for the Accounting Calendar Periods descriptive flexfield.
PeriodAttributeCategory The descriptive flexfield context name for the Accounting Calendar Periods descriptive flexfield.
PeriodAttributeDate1 A segment for the Accounting Calendar Periods descriptive flexfield.
PeriodAttributeDate2 A segment for the Accounting Calendar Periods descriptive flexfield.
PeriodAttributeDate3 A segment for the Accounting Calendar Periods descriptive flexfield.
PeriodAttributeDate4 A segment for the Accounting Calendar Periods descriptive flexfield.
PeriodAttributeDate5 A segment for the Accounting Calendar Periods descriptive flexfield.
PeriodAttributeNumber1 A segment for the Accounting Calendar Periods descriptive flexfield.
PeriodAttributeNumber2 A segment for the Accounting Calendar Periods descriptive flexfield.
PeriodAttributeNumber3 A segment for the Accounting Calendar Periods descriptive flexfield.
PeriodAttributeNumber4 A segment for the Accounting Calendar Periods descriptive flexfield.
PeriodAttributeNumber5 A segment for the Accounting Calendar Periods descriptive flexfield.
PeriodConfirmationStatus A segment for the Accounting Calendar Periods descriptive flexfield.
PeriodCreatedBy The user who created the accounting calendar period.
PeriodCreationDate The date and time when the accounting calendar period was created.
PeriodDescription The description of the accounting calendar period provided by the user.
PeriodEndDate The date when the accounting calendar period ends.
PeriodEnteredPeriodName The name of the accounting calendar period that the user entered.
PeriodGlobalAttribute1 A segment for the GL Periods Regional Information global descriptive flexfield.
PeriodGlobalAttribute10 A segment for the GL Periods Regional Information global descriptive flexfield.
PeriodGlobalAttribute11 A segment for the GL Periods Regional Information global descriptive flexfield.
PeriodGlobalAttribute12 A segment for the GL Periods Regional Information global descriptive flexfield.
PeriodGlobalAttribute13 A segment for the GL Periods Regional Information global descriptive flexfield.
PeriodGlobalAttribute14 A segment for the GL Periods Regional Information global descriptive flexfield.
PeriodGlobalAttribute15 A segment for the GL Periods Regional Information global descriptive flexfield.
PeriodGlobalAttribute16 A segment for the GL Periods Regional Information global descriptive flexfield.
PeriodGlobalAttribute17 A segment for the GL Periods Regional Information global descriptive flexfield.
PeriodGlobalAttribute18 A segment for the GL Periods Regional Information global descriptive flexfield.
PeriodGlobalAttribute19 A segment for the GL Periods Regional Information global descriptive flexfield.
PeriodGlobalAttribute2 A segment for the GL Periods Regional Information global descriptive flexfield.
PeriodGlobalAttribute20 A segment for the GL Periods Regional Information global descriptive flexfield.
PeriodGlobalAttribute3 A segment for the GL Periods Regional Information global descriptive flexfield.
PeriodGlobalAttribute4 A segment for the GL Periods Regional Information global descriptive flexfield.
PeriodGlobalAttribute5 A segment for the GL Periods Regional Information global descriptive flexfield.
PeriodGlobalAttribute6 A segment for the GL Periods Regional Information global descriptive flexfield.
PeriodGlobalAttribute7 A segment for the GL Periods Regional Information global descriptive flexfield.
PeriodGlobalAttribute8 A segment for the GL Periods Regional Information global descriptive flexfield.
PeriodGlobalAttribute9 A segment for the GL Periods Regional Information global descriptive flexfield.
PeriodGlobalAttributeCategory The descriptive flexfield context name for the GL Periods Regional Information global descriptive flexfield.
PeriodGlobalAttributeDate1 The descriptive flexfield context name for the GL Periods Regional Information global descriptive flexfield.
PeriodGlobalAttributeDate2 The descriptive flexfield context name for the GL Periods Regional Information global descriptive flexfield.
PeriodGlobalAttributeDate3 The descriptive flexfield context name for the GL Periods Regional Information global descriptive flexfield.
PeriodGlobalAttributeDate4 The descriptive flexfield context name for the GL Periods Regional Information global descriptive flexfield.
PeriodGlobalAttributeDate5 The descriptive flexfield context name for the GL Periods Regional Information global descriptive flexfield.
PeriodGlobalAttributeNumber1 The descriptive flexfield context name for the GL Periods Regional Information global descriptive flexfield.
PeriodGlobalAttributeNumber2 The descriptive flexfield context name for the GL Periods Regional Information global descriptive flexfield.
PeriodGlobalAttributeNumber3 The descriptive flexfield context name for the GL Periods Regional Information global descriptive flexfield.
PeriodGlobalAttributeNumber4 The descriptive flexfield context name for the GL Periods Regional Information global descriptive flexfield.
PeriodGlobalAttributeNumber5 The descriptive flexfield context name for the GL Periods Regional Information global descriptive flexfield.
PeriodLastUpdateDate The date when the accounting calendar period row was last updated.
PeriodLastUpdateLogin The session login associated with the user who last updated the accounting calendar period.
PeriodLastUpdatedBy The user who last updated the accounting period calendar.
PeriodObjectVersionNumber The number of times the accounting calendar period row has been updated.
PeriodPeriodName The accounting period associated with the journal. This is a foreign key of the Period view object.
PeriodPeriodNum The unique period number of the accounting calendar period year.
PeriodPeriodSetName The name of the accounting calendar.
PeriodPeriodType The type of the accounting period based on the calendar. For example, Weekly, Monthly, Quarterly, Yearly, and so on, as selected by the user.
PeriodPeriodYear The year for the accounting calendar period represented by a numeric value, such as 2020.
PeriodQuarterNum The quarter number for the accounting calendar period.
PeriodQuarterStartDate The date when the quarter containing this accounting period starts.
PeriodStartDate The date when the accounting period begins.
PeriodYearStartDate The date when the year containing this accounting period starts.