BalanceAAP > File Structure Details / User-defined Reference Tables
RETURN TO: File Structure Details / Reference Tables
KEY TOPICS:
- Drilldowns
- Rollups
RELATED TOPIC:
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 detailed instructions, 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 |