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 Financial Consolidation. In Financial Reporting and Workforce Budgeting, that data is not used. In Budgeting & Planning, you cannot currently manage schedules.

This table shows the properties of the Schedules business object and uses these abbreviations:

  • BP: Budgeting & Planning
  • CO: Financial Consolidation
  • FR: Financial Reporting
  • WB: Workforce Budgeting
  • R: Required
  • U: Used but optional
Field Description Type BP CO FR WB
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
Name Schedule or subschedule name. For example, Assets, Receivables, Payables, Accruals, or Equity.

Cannot be left blank.

 nvarchar R
OrderPosition Position of an element in the resulting dimension. integer U
SubscheduleOf ID of a parent schedule for a subschedule.

For example, for assets, these values must be specified:

  • ID = A1
  • SubscheduleOf = A

Left blank in case of a schedule.

Note: One subschedule can be linked with only one schedule.
 nvarchar 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
HasOpeningBalance Indicates whether a schedule contains an opening balance.

These values can be specified:

  • 1: Contains an opening balance
  • 0: Does not contain an opening balance.

Left blank for schedules with subschedules because such schedules do not store schedule details.

 boolean U
LangEN Name translated into English. nvarchar U
LangDE Name translated into German. nvarchar U
LangFR Name translated into French. nvarchar U
LangES Name translated into Spanish. nvarchar U
LangJA Name translated into Japanese. nvarchar U
LangPT_BR Name translated into Portuguese (Brazilian). nvarchar U
LangRU Name translated into Russian. nvarchar U
LangIT Name translated into Italian. nvarchar U
LangZH_CHS Name translated into Chinese (Simplified). nvarchar U
LangCS Name translated into Czech. nvarchar U
LangNL Name translated into Dutch. nvarchar U
LangDA Name translated into Danish. nvarchar U
LangSV Name translated into Swedish. nvarchar U
LangNO Name translated into Norwegian. nvarchar U
LangPL Name translated into Polish. nvarchar U
LangTH Name translated into Thai. nvarchar U
LangFI Name translated into Finnish. nvarchar U
LangKO Name translated into Korean. nvarchar U
LangMS Name translated into Malaysian. nvarchar U
LangFR_CA Name translated into French (Canadian). nvarchar U
LangZH_TW Name translated into Chinese (Traditional). nvarchar U
LangID Name translated into Indonesian. nvarchar U
LangVI Name translated into Vietnamese. nvarchar U
Related topics