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. |