Mapping Data

  1. In Reporting and Analytics, click Admin, click Data Mapping, and then click Data Mapping.
  2. Click the Choose Org Level drop-down list and select the organization.
  3. Click the Choose Mapping Category drop-down list and select the data category.
  4. Click Add.
  5. In the External Reference field, type the external reference value.

    As a System Sales Summary report example, you selected the CashTotals data category, so you type Cash in the External Reference field.

    As an example for exporting data for a third-party application, you type 100 because that is the value the application uses to define an item such as hamburgers.

  6. Click the Info Source Type drop-down list and select the category information source.

    If you are mapping data for System Sales Summary reports, select the source according to the following table:

    Category Source

    CashTotals

    Tender Media

    Deposits

    Tender Media

    PaidIn

    Tender Media

    PaidOut

    Tender Media

    TipsPaidSVC

    Service Charge

    TipsPaidTender

    Tender Media

    GiftCards

    Menu Item

    GiftCards

    Service Charge

  7. In the By POS Ref field, type the workstation reference number to map it to the external reference value.

    As a System Sales Summary report example, you specified Cash as the external reference and you selected Tender Media as the information source. If the workstation reference number for the Cash key is 101, type 101 in the By POS Ref field.

    As an example for exporting data for use by a third-party application, type 1015 because that is the value the workstation uses to define an item such as hamburgers.

  8. Click Save.