< back

BalanceAAP > File Structure Details / User-defined Reference Tables

RETURN TO: File Structure Details / Reference Tables

KEY TOPICS

  • Drilldowns
  • Rollups



Optional User-defined Tables

Drilldown (User-defined)

Field Name Data Type Length Required Master Plan Required
Drilldown Field Text 255 Yes* Yes*
Description Text 255 No No
Zip Code Text 5 No No

Note: If a Drilldown Field is user defined, the column will be added to all Data tables, where entries will be required. Refer to: Reporting Levels > Drilldowns. For more information, see BALANCEaap User Guide at: Drilldowns.

Rollup (User-defined, Master Plan)

Field Name Data Type Length Required Master Plan Required
Rollup Field Text 255 N/A Yes
Description Text 255 No No
Zip Code Text 5 No No
Note: If a Rollup Field is user defined, the column will be added to all Data tables. Refer to: Reporting Levels > Rollups. For detailed instructions, see BALANCEaap User Guide at: Rollups.