Creating export report definitions for line items

The export report definition for line items is used to interpret and transfer budget data from the Pillar application's ASCII file to the data mart.

  1. From EB10, select a budget.
  2. Click Define Rpt. to show Line Item Reports (EB30.1).
  3. On EB30.1, click Budget Export Reports. The Budget Line Item Export (EB30.3) form is displayed.
  4. Specify this information:
    Budget Name

    Select your budget name.

    Report Name

    Select or enter the line item report name. The report name must match the name of the ASCII file you exported from the Pillar application. For example, if the ASCII file name is AU-ACCT-EXPORT.asc, the report name is AU-ACCT-EXPORT. Export report names and export file names should not contain spaces or special characters.

    Desciption
    Provide a short description for the line item.
    Type
    Select the Pillar application's report type:
    • Asset
    • Liabilities and equity
    • Revenue or Expense
    Fiscal Year

    Specify the fiscal year for the budget data that you are exporting. The budget data is mapped to the appropriate year in the data mart.

    Template

    Specify the line item report column template. This template defines the columns of the budget line item report.

    See Defining report column templates.

    Note: The template's columns must exactly match the columns in the Pillar application's export file.
    Header

    Specify whether the first record in the Pillar application's export file contains column headers.

    Amount Lines

    Specify whether the export file contains amount rows.

    Unit Lines

    Specify whether the export file contains unit rows.

    Rate Lines

    Specify whether the export file contains rate rows.

  5. Click Add or Change to save your selections.