allocationschedule
The AllocationSchedule table manages predefined schedules for financial allocations, ensuring consistent cost distribution over time.
Columns
| Name | Type | References | Description |
| accountingbook | String | The accounting book that is associated with this allocation schedule. This field ensures that the allocation is applied within the correct financial ledger, supporting multi-book accounting and regulatory compliance. | |
| accountsfromsource | Boolean | Indicates whether accounts are derived from the allocation source. This setting allows dynamic account selection based on the originating transaction, ensuring flexibility in cost distribution. | |
| allocationmode | String | The method that is used to allocate expenses or revenue. This field defines whether the allocation is based on predefined percentages, statistical measures, or actual transaction values, ensuring consistency in financial planning. | |
| creditaccount | String | The general ledger account that will receive the allocated credit amount. This field ensures that financial distributions are correctly recorded in the accounting system. | |
| creditclass | String | The classification that is assigned to the credit portion of the allocation. This classification helps track financial data by class, enabling better financial analysis and reporting segmentation. | |
| creditdepartment | String | The department that is associated with the credit side of the allocation. This field ensures that financial transactions are attributed to the correct department for budgeting and expense tracking. | |
| creditentity | String | The entity or subsidiary receiving the allocated credit amount. This field is essential for multi-entity organizations to track intercompany transactions and allocations accurately. | |
| creditlocation | String | The physical or operational location associated with the credit portion of the allocation. This location ensures that expenses and revenues are properly tracked across different business locations. | |
| datebasis | String | The basis for determining the allocation date. This field defines whether the allocation is based on the transaction date, period-end date, or another reference point, ensuring accurate financial timing. | |
| externalid | String | The unique identifier (Id) assigned to this allocation schedule by an external system. This Id facilitates integration with third-party financial applications, ensuring consistent data synchronization. | |
| frequency | String | The recurrence pattern for the allocation schedule. This pattern defines how often the allocation process runs, such as monthly, quarterly, or annually, ensuring timely cost distribution. | |
| inactive | Boolean | Indicates whether the allocation schedule is inactive. This setting prevents the schedule from being used in future allocations while retaining historical data for reporting. | |
| name | String | The official name of the allocation schedule. This field provides a meaningful reference for users to identify and manage different allocation processes within the system. | |
| nextdate | Date | The next scheduled date for running the allocation process. This date ensures timely execution of financial allocations based on predefined schedules. | |
| remindforever | String | Indicates whether reminders for this allocation schedule will continue indefinitely. This field helps maintain visibility into recurring allocations that require review or adjustments. | |
| subsequentdate | Date | The date of the next allocation after the initially scheduled allocation. This date supports tracking recurring allocations to ensure they align with financial planning requirements. | |
| subsidiary | String | The subsidiary that is associated with this allocation schedule. This information ensures that financial transactions are correctly assigned to the appropriate legal entity in multi-subsidiary organizations. | |
| unitlabel | String | The label that is assigned to the units used in the allocation process. This label helps clarify the measurement basis for allocations, such as hours, square footage, or revenue percentages. | |
| unitstype | String | The type of unit used in the allocation calculation. This field defines the metric for distributing costs or revenue, ensuring accurate allocation based on relevant business drivers. | |
| weightsinpercentage | Boolean | Indicates whether allocation weights are expressed as percentages. This setting ensures clarity in cost distribution calculations, allowing users to allocate amounts proportionally. | |
| weightsource | String | The source of the allocation weight. This field determines whether allocation percentages are based on historical data, fixed values, or dynamically calculated factors, ensuring accuracy in financial allocations. |