Creating a Standard Transaction File

You can create a standard transaction file to transfer accounting data from PaymentNet to your organization’s accounting system in much the same way as a flex mapper. For more information about flex mappers, see Flex Mappers.

To create a standard transaction file:

  1. Select Administration > Mappers.

  2. Click Add New Mapper.

  3. Select Standard Transaction File from the Mapper Type list.

  4. Complete the fields and options that display. For a list of fields and options, see Standard Transaction File General Information Fields.

  5. Click Continue.

  6. On the Mapper Detail - Query screen, complete the Date Range fields.

    Field

    Select a value that identifies the field by which you want to search.

    Operation

    Select the operation that you want to use to measure the field value. You can select either Cycle Is, Is Between, Is Equal To, or Is Relative.

    Value

    The values that display vary based on the operation. Select the value by which you want to search.

  7. Click the Add button in the Criteria section and complete the added fields.

    Field

    Select the field you want to use for the query. The available fields are Central Bill Account Number, Company Number, Transaction Approval Status, and Transaction Export Status.

    Operation

    Select the operation that you want to use to measure the Field value.

    Value

    Specify the Field value.

    To add more criteria, click Add again and complete the added fields. Repeat this step as often as necessary to specify all the criteria for your search.

    To delete criteria, click the corresponding Delete button.

  8. To limit your query within the hierarchy, click the Add button in the Hierarchy section and complete the added fields.

    Hierarchy ID

    Enter the hierarchy ID by which you want to search, or click the link and select a node from the hierarchy tree.

    Include Children

    If you want to include hierarchy children, select this check box. When you select this check box, all child nodes under the selected hierarchy ID are included in the mapper.

    To include additional hierarchy IDs in your query, click Add again and complete the added fields. Repeat this step as often as necessary to specify all the hierarchy nodes for your search.

    To remove a hierarchy ID from the query, click the corresponding Delete button.

    Note:You cannot specify the sort criteria for a standard transaction file.

  9. Click Save.

Standard Transaction File General Information Fields

Field

Description

Name

Enter a unique name for the file.

Hierarchy ID

Select a hierarchy ID to determine who can access the Mapper List screen and view or edit a standard transaction file. PaymentNet users must be assigned the Program Administrator role in order to access the Mapper List screen.

Transaction Types to Include

By default, only transactions are included in a standard transaction file. This is a read-only field.

Mark Transactions as Exported

Select this option if you want the status of the included transactions to be marked as Exported. Transactions with a status of Exported cannot be edited or included in other mapper or standard transaction files. For more information, see Mapper Criteria and Transaction Editing Options.

Compress Output

Select this option to compress the standard transaction output file. By default, all standard transaction files are compressed.

Additional Email Notification

Enter a valid email address to which an email notification will be sent when the file is ready.

Schedule to run automatically?

If you want the file to run on a recurring basis, select this check box and use the Frequency and Day lists to specify the schedule.

Note: Standard transaction files scheduled to run automatically are based on how your organization implemented this option. Standard transaction files are processed to start after 7 p.m. ET or to complete by 8 a.m. ET.

Frequency

Select the frequency with which you want to run the standard transaction file. You can select from these options:

Weekly

If you select this option, then you must indicate the weekday on which you want the file to run. Select a day from the Day list.

Cycle

If you select this option, then you must indicate when you want the file to run during each cycle. Select a cycle from the Cycle list, then select either First day of current period or Last day of current period.

Daily

If you select this option, then you must indicate whether or not you want the file to run on the weekends. Select Every Day or Every Week Day from the Day list.

Monthly

If you select this option, then you must indicate the day of the month on which you want the file to run. Select a numeric value (1-28) from the Day list, or select Last Day of Month.

Automatically mark mapper as successful

If both the Schedule to run automatically and Mark Transactions as Exported check boxes are selected, the Automatically mark mapper as successful check box displays.

Select this check box to mark the status of the file as Successful once it completes. When a standard transaction file is marked as Successful, the included transactions are locked from further editing. As necessary, you can run the file again and include different, unlocked transactions.

Mask sensitive data?

Select this check box to mask the following information in the output file:

  • Account Number (except the last six digits)

  • Central Bill Account Number (except the last six digits)

  • Single-Use Account Number (except the last six digits)

  • Billed To Account Number (except the last six digits)

  • Diversion Account Number (except the last six digits)

  • Employee ID (in its entirety)

  • Merchant Taxpayer ID (except the last four digits)

Note: The options to mask Employee IDs and Merchant Taxpayer IDs must also be enabled at the organization level.