AccountingPeriodsLOV
Lists period details (for example, open, closed) within a specified accounting calendar, aiding period-based reporting and reconciliation.
Columns
| Name | Type | SupportedFinders | Description |
| PeriodNameId [KEY] | String | PrimaryKey, AttrRowFinder | The unique identifier for the period name in the AccountingPeriodsLOV table, used to reference specific accounting periods. |
| PeriodSetNameId [KEY] | String | PrimaryKey, AttrRowFinder | 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 | EncumPeriodsFinder, ActualOpenPeriodRowFinder | 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 | EncumPeriodsInBatchFinder, ActualOpenPeriodsInBatchFinder | 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 | PeriodsByPeriodSetTypeFinder, ActualOpenPeriodsInBatchFinder, EncumPeriodsInBatchFinder, EncumPeriodsFinder, ActualOpenPeriodRowFinder | The variable representing the period set name ID, used to bind and identify the period set in queries and operations. |
| PeriodTypeVar | String | ActualOpenPeriodRowFinder, EncumPeriodsFinder, ActualOpenPeriodsInBatchFinder, EncumPeriodsInBatchFinder, PeriodsByPeriodSetTypeFinder | The variable representing the period type, used in dynamic queries or operations to specify the period type for filtering. |
| SearchTerm | String | ActualOpenPeriodsInBatchFinder, EncumPeriodsFinder, PeriodsByPeriodSetTypeFinder, ActualOpenPeriodRowFinder, EncumPeriodsInBatchFinder, KeywordFinder | A user-defined search term used to filter accounting periods, often used for locating specific records in the AccountingPeriodsLOV table. |