BalanceAAP > File Structure Details / User-defined Reference Tables

RETURN TO: File Structure Details / Reference Tables

KEY TOPICS:

• Drilldowns
• Rollups

JUMP TO:

• File Structure Details / Data Tables

  KEY TOPICS:

  • Drilldowns
  • Rollups

  ---

  Optional User-defined Tables

  Note: The term "Required," as shown in the column headers below, refers to a system requirement for operation.

  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

  balanceAAP Help Cross-reference: 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

  balanceAAP Help Cross-reference: 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.