MasterCard per Location Fee Report

The MasterCard per Location Fee report is a PayFac report containing the details of location fees assessed by Legal Entity and Sub-merchant. Worldpay produces the report on the 15th of each month. Each report contains data for the prior month. For example, a report produced on August 15th would contain data for July 1st through July 31st.

Filename Syntax

The syntax of the report filename is:

PayFacMasterCardLocationReport_${organizationId}_${monthYear}

where

organizationId is the Worldpay assigned identifier of the Payment Facilitator
MonthYear is the month and year to which the data applies

Report Structure

The table below provides information about the fields included in the report. The report fields are in the order presented in the table.

A data type of Signed Decimal (17,2) with a Max Size of 21 is defined as:
17 digits + decimal point + 2 digits + sign.

Field Name	Data Type	Max Size	Description
ORGANIZATION_ID	Numeric (with preceding apostrophe)	19	The Organization ID in the Worldpay eComm system.
ORGANIZATION_NAME	Alphanumeric	50	The Payment Facilitator/Organization name in the Worldpay eComm system.
LEGAL_ENTITY_ID	Numeric (with preceding apostrophe)	19	The Legal Identity identifier assigned by Worldpay.
LEGAL_ENTITY_NAME	Alphanumeric	60	The Legal Entity name in the Worldpay eComm system.
MERCHANT_ID	Numeric (with preceding apostrophe)	19	The sub-merchant identifier assigned by Worldpay.
MERCHANT_NAME	Alphanumeric	50	The name of the sub-merchant in the Worldpay eComm system.
NORMALIZED_ADDRESS	Alphanumeric	200	The address of the sub-merchant with differences such as street/St. normalized to a common designations. This acts to reduce the count of locations due to meaningless differences.
URL	Alphanumeric	120	The URL of the merchant.
MERCHANT_CATEGORY_CODE	Alphanumeric	4	Specifies the MCC of the sub-merchant.
TRAN_COUNT	Numeric	19	The count of settlement transactions for the sub-merchant location over the designated month.
SALES_VOLUME	Decimal (16,2)	19	The dollar amount of the MasterCard settled transactions.
LOCATION	Numeric	1	One of the following values: 1 - location counted for fees 0 - location not counted for fees
EXCLUSION NOTE	Alphanumeric	200	Provides an explanation for the exclusion of the location. Example - Merchant location's URL is already accounted for billing.