Schedule Details

The Schedule Details integration table stores detailed information for schedules from the Schedules business object.

Schedule details may come from a source system, or they may be configured in Infor EPM. Identical schedule details can be displayed in multiple schedules.

The use of schedule details is optional in Financial Consolidation. Schedule details are not used in Workforce Budgeting. In Budgeting & Planning, you cannot currently create schedules and their details.

Note: Currently, you can load data into Business Modeling and use it in Financial Consolidation. In a future release, it will be possible to use that data in Budgeting & Planning.

This table shows the properties of the Schedule Details 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 detail. For example, 40 or 50.

Cannot be left blank.

nvarchar R
Name Schedule detail name. For example, Assets can be broken down into Increase Depreciation, Decrease Depreciation, or Revaluation Depreciation.

Cannot be left blank.

nvarchar R
OrderPosition Position of an element in the resulting dimension. integer U
Rate Exchange rate type for a schedule detail.

These values are possible:

  • !: Use an account rate type instead of a specific exchange rate type.
  • A: Average rate.
  • F: Closing rate.
  • H: Historical rate.
  • WA: Weighted average.
Note: WA and H rates are not used in Financial Consolidation.
nvarchar U
Basis Exchange rate basis.

These values are possible:

  • B: Base rate. Used for details that are converted with the rate of the base period. For example, this rate can be used as a setting for an opening balance detail.
  • C: Current period. Used for details that are converted with the rate of the current period. For example, increases details or decreases details.

Used only in Financial Consolidation for cube rule calculations.

nvarchar U
GroupToEntityDetail Used to map details when the subgroup data is being copied and transferred from a specific subgroup to an assigned entity.

Can be used if an entity and subgroup use different details.

Used only in Financial Consolidation.

nvarchar 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