AccountingPeriodsLOV
Lists period details (for example, open, closed) within a specified accounting calendar, aiding period-based reporting and reconciliation.
Columns
| Name | Type | Description |
| PeriodNameId [KEY] | String | The unique identifier for the period name in the AccountingPeriodsLOV table, used to reference specific accounting periods. |
| PeriodSetNameId [KEY] | String | The unique identifier for the period set name in the AccountingPeriodsLOV table, indicating the set of periods this record belongs to. |
| PeriodType | String | The type of accounting period, as defined in the AccountingPeriodsLOV table, such as 'Monthly' or 'Yearly'. |
| AdjustmentPeriodFlag | Bool | A flag indicating whether the period is an adjustment period. True means it's an adjustment period, and false means it's a regular period. |
| StartDate | Date | The start date for the accounting period, marking the beginning of the period in the AccountingPeriodsLOV table. |
| EndDate | Date | The end date for the accounting period, marking the conclusion of the period in the AccountingPeriodsLOV table. |
| EnteredPeriodName | String | The name of the period as entered in the AccountingPeriodsLOV table, representing how the period is labeled for user interaction. |
| PeriodYear | Long | The year of the accounting period, as recorded in the AccountingPeriodsLOV table, used for categorization and financial year tracking. |
| PeriodNumber | Long | The unique number assigned to the accounting period within a given year, helping to order and identify the period. |
| AccessSetIdVar | Long | The unique identifier for the access set, used to determine which users or roles can access the period data within the AccountingPeriodsLOV table. |
| BindJeBatchId | Long | The unique identifier for the journal entry batch linked to the accounting period in the AccountingPeriodsLOV table. |
| Finder | String | A searchable term or identifier used in the AccountingPeriodsLOV table to locate specific periods based on user queries. |
| PeriodSetNameIdVar | String | The variable representing the period set name ID, used to bind and identify the period set in queries and operations. |
| PeriodTypeVar | String | The variable representing the period type, used in dynamic queries or operations to specify the period type for filtering. |
| SearchTerm | String | A user-defined search term used to filter accounting periods, often used for locating specific records in the AccountingPeriodsLOV table. |