Account dimension: BPDACCOUNT

The BPDACCOUNT account dimension is used for chart of accounts plus additional figures or measures of sub plans, including statistical accounts that are used as drivers for allocations.

Accounts have specialized attributes to determine financial handling within the Infor EPM business applications. For that reason, source data is loaded to a staging table and stored procedures are used to validate the staged data and transform it into a format that can be readily imported into Infor EPM.

The process uses these tables and stored procedures:

  • The staging table is DAT_BPDACCOUNT_STAGE.
  • The stored procedure to validate staged data is depm_integration_bp_account_prepare_staging.
  • The stored procedure to process staged data is depm_integration_bp_account.
  • The output tables are:
    • DIM_BPDACCOUNT_ELEMENTS
    • DIM_BPDACCOUNT_PARENTS
    • DIM_BPDACCOUNT_ATTRIBUTES
    • DIM_BPDACCOUNT_HIERARCHIES

This table describes DAT_BPDACCOUNT_STAGE:

Field Required Description
ID Y Account ID; must be a unique identifier; Natural account (GL nominal account) is recommended.
TYPE N

N (numeric, this is the typical value)

S (string)

H (hierarchy)
NAME Y Caption for the element. Unique names are recommended.
HIERARCHY N Hierarchy name; normally the name of the dimension, BPDACCOUNT.
PARENT N Parent Account IDs; the default value is TOTAL_ACCOUNT.

An account can be associated with multiple parents.
WEIGHT Y Weighting used for rolling up purposes; typically set to 1.
CHILDSORT N Sequence of child elements beneath parent.
ACCOUNT_TYPE Y One-character code for Infor EPM account types:
  • A = Asset
  • L = Liability
  • Q = Equity
  • R = Revenue
  • E = Expense
  • S = Statistical, currency-related, no roll up over time. For example, Average Price.
  • T = Statistical, currency-related, aggregated over time. For example, KPI's.
  • M = Statistical, currency is N.A., no roll up over time. For example, Headcount.
  • O = Statistical, currency is N.A., aggregated over time. For example, Sales Volume.

All accounts must be assigned to an account type, otherwise they are not available for Budgeting & Planning.
SCHEDULE N One-character code for assignment to finance schedule details. If schedule is assigned, detail planning must be done for the account as part of Infor EPM application. The standard schedules are:
  • A = Assets
  • B = Receivables
  • C = Cash
  • D = Liabilities
  • E = Equity
CUSTOM_DETAIL N Unique name for element within BPDDETAIL.
LINE_DETAIL N Indicates whether account allows line detail entry in Infor EPM. Either 1 = yes or 0 = no. The default is 0.
INTERCOMPANY N Indicates whether account allows intercompany transactions; if so, detail planning done in Infor EPM. Either 1 = yes or 0 = no. The default is 0.
SEGMENT_1 N Indicates whether account allows segment 1 values; if so, detail planning done. Either 1 = yes or 0 = no. The default is 0.
SEGMENT_2 N Indicates whether account allows segment 2 values; if so, detail planning done. Either 1 = yes or 0 = no; default is 0.
SEGMENT_3 N Indicates whether account allows segment 3 values; if so, detail planning done. Either 1 = yes or 0 = no. The default is 0.
CURRENCY_METHOD_1 N One or two-character code for the exchange rate type. Used for method 1 currency conversions, usually assigned to actuals. The exchange rate types are:
  • F = Closing Rate or Periodic End Rate; typical for asset, liability and equity accounts.
  • H = Historical Account Rate.
  • HI = Historical Intercompany Rate.
  • PA = Periodic Average Rate. Typical for revenue and expense accounts.
  • N = No translation.
CURRENCY_METHOD_2 N One or two-character code for the exchange rate type. Used for method 2 currency conversions; usually assigned to budgets.
CURRENCY_METHOD_3 N One or two-character code for the exchange rate type. Used for method 3 currency conversions if applicable.
CURRENCY_METHOD_4 N One or two-character code for the exchange rate type Used for method 4 currency conversions if applicable.
LANG_CS N Account name translated into Czech.
LANG_DA N Account name translated into Danish.
LANG_DE N Account name translated into German.
LANG_EN N Account name translated into English.
LANG_ES N Account name translated into Spanish.
LANG_FR N Account name translated into French.
LANG_IT N Account name translated into Italian.
LANG_JA N Account name translated into Japanese.
LANG_NL N Account name translated into Dutch.
LANG_NO N Account name translated into Norwegian.
LANG_PL N Account name translated into Polish.
LANG_PT_BR N Account name translated into Brazilian Portuguese.
LANG_RU N Account name translated into Russian.
LANG_SV N Account name translated into Swedish.
LANG_ZH_CHS N Account name translated into Simplified Chinese.
SORT N Sequence of accounts in a dimension.