Schedule lines

Property or Attribute Required Required by the Import Wizard when Adding Members Required by the Import Wizard when Updating Members Notes Default set by Import Wizard if value is missing from import file
ID Required Optional Required (if Name not provided) The ID is automatically generated if not included.
Line Name Required Required Required (if ID not provided) The name can have up to 40 characters. Must be unique within the dimension. No default. User must supply.
Description Optional Optional Optional The description can have up to 255 characters. If not specified, defaults to the name.
Preceding Member Optional (used to derive a related required field, Mem_ Order) Optional Optional Specifies the line's position in a schedule.

Specify the line that will precede this line. Use the wild card character (*) to indicate the member is the first in the Schedule.

By default, lines are placed in the order in which they are added to the schedule.
Formula Optional Optional Optional The formula associated with the line. All formulas must be enclosed between the ~BeginFormula~ and ~EndFormula~ keywords. See "Import Formulas" for formula syntax and examples. The default is DATA.
Schedule Name Required Required Required Indicates the name of the schedule to which this line belongs. Choose the default value from the list or map to a column. No default. User must supply.
Natural Sign Required Optional Optional This attribute is used to mark the natural sign of the account. Specify C for credit or D for debit. Default based on Account Type.
Account Type Required Optional Optional
  • BA – Balance Sheet, Assets
  • BE – Balance Sheet, Equity
  • BL – Balance Sheet, Liabilities
  • BS – Balance Sheet, Statistic
  • PR – P&L, Revenues
  • PE – P&L, Expenses
  • PS – P&L, Statistic
The default is BA.
Precision Optional Optional Optional Specifies the precision in decimal places for this line. Must be a value from 0 to 9. If not specified, no special precision is set for the line. Null
Rate Required Optional Optional Identifies the rate to use when translating the account.

If the line is a Beginning Balance or Opening Balance line, the rate type must be Historical.

Default based on Account Type (see succeeding table)
Consolidate Required Optional Optional Some lines, ratios for example, should not be consolidated. This attribute lets you indicate this. Specify N -No if the line should not be consolidated or Y -Yes if it should be consolidated. N-No
Balanced Required Optional Optional
  • Y -Yes or Null indicates that the line requires a double-sided journal entry.
  • N -No indicates that the line is single-sided such as head count, ratio, or square footage.
Default based on Account Type (see succeeding table)
Usage Optional Optional Optional Indicates how the line is used in a schedule for financial reporting. Names for preset values include:

SUBTOTAL, GRDTOTAL, DATA, LEVEL1, LEVEL2, LEVEL3, LEVEL4, FORMULA, HEADER, and PERCENT.

Downfoot lines default to SUBTOTAL. Expr, Xcheck, and Allocation lines default to FORMULA. All others default to DATA.

The minimum format to add members to this dimension is:

  • Line Name, Schedule Name
  • Training Cost, Consolidation
  • Training Cost, Expenses
  • IT Allocation, Global Drivers
  • Fringe Rate, Consolidation
  • Fringe Rate, Expenses