Schedules
The Schedules and Schedule Details consolidation contains schedules for these accounts:
- Assets and depreciation
- Accounts receivables
- Accounts payables
- Accruals
- Equity
Schedules categorize financial data and schedule details provide detail of financial data. For each schedule, you can define schedule details and then assign schedules to accounts. Schedule details are typically used, for example, to split data into movements, write-offs, or corrections. In Financial Consolidation, schedules have a system-created opening balance and closing balance details but only if the use of opening balances is configured for schedules.
The use of business data from the Schedules business object is optional in Budgeting & Planning and Financial Consolidation. In Workforce Budgeting, that data is not used.
This table shows the properties of the Schedules business object and uses these abbreviations:
- BP: Budgeting & Planning
- WB: Workforce Budgeting
- CO: Financial Consolidation
- R: Required
- U: Used but optional
| Field | Description | Type | BP | WB | CO |
|---|---|---|---|---|---|
| ID | Unique identifier of a schedule or subschedule. For example: A,
B, or A1. Cannot be left blank. For subschedules, the parent ID in the Schedule property must be specified. Custom schedules, other than the default schedules, are supported. |
nvarchar | R | R | |
| Name | Schedule or subschedule name. For example, Assets, Receivables,
Payables, Accruals, or Equity. Cannot be left blank. |
nvarchar | R | R | |
| OrderPosition | Position of an element in the resulting dimension. | integer | U | U | |
| SubscheduleOf | ID of a parent schedule for a subschedule. For example, for assets, these values must be specified:
Left blank in case of a schedule. Note: One subschedule
can be linked with only one schedule.
|
nvarchar | U | U | |
| DefaultSubschedule | ID of a subschedule in which to load an opening balance. Used only if a schedule has multiple subschedules with an opening balance. Must be left blank for subschedules. |
nvarchar | U | U | |
| HasOpeningBalance | Indicates whether a schedule contains an opening
balance. These values can be specified:
Left blank for schedules with subschedules because such schedules do not store schedule details. |
boolean | U | U | |
| LangEN | Name translated into English. | nvarchar | U | U | |
| LangDE | Name translated into German. | nvarchar | U | U | |
| LangFR | Name translated into French. | nvarchar | U | U | |
| LangES | Name translated into Spanish. | nvarchar | U | U | |
| LangJA | Name translated into Japanese. | nvarchar | U | U | |
| LangPT_BR | Name translated into Portuguese (Brazilian). | nvarchar | U | U | |
| LangRU | Name translated into Russian. | nvarchar | U | U | |
| LangIT | Name translated into Italian. | nvarchar | U | U | |
| LangZH_CHS | Name translated into Chinese (Simplified). | nvarchar | U | U | |
| LangCS | Name translated into Czech. | nvarchar | U | U | |
| LangNL | Name translated into Dutch. | nvarchar | U | U | |
| LangDA | Name translated into Danish. | nvarchar | U | U | |
| LangSV | Name translated into Swedish. | nvarchar | U | U | |
| LangNO | Name translated into Norwegian. | nvarchar | U | U | |
| LangPL | Name translated into Polish. | nvarchar | U | U | |
| LangTH | Name translated into Thai. | nvarchar | U | U | |
| LangFI | Name translated into Finnish. | nvarchar | U | U | |
| LangKO | Name translated into Korean. | nvarchar | U | U | |
| LangMS | Name translated into Malaysian. | nvarchar | U | U | |
| LangFR_CA | Name translated into French (Canadian). | nvarchar | U | U | |
| LangZH_TW | Name translated into Chinese (Traditional). | nvarchar | U | U | |
| LangID | Name translated into Indonesian. | nvarchar | U | U | |
| LangVI | Name translated into Vietnamese. | nvarchar | U | U |