< back

BalanceAAP > File Structure Details / User-defined Reference Tables

Optional User-defined Tables

Drilldown (User-defined)

Field Name Data TypeLengthRequired Master Plan Required
Drilldown FieldText255Yes*Yes*
DescriptionText255NoNo
Zip CodeText5No 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 NameData TypeLengthRequiredMaster Plan Required
Rollup Field Text255N/AYes
DescriptionText255NoNo
Zip CodeText5NoNo
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.