Reporting Filter Parameters

Reporting filter parameters

Filter Parameter	Description
ADDR_ADDRESS	Filter by customer billing street address.
ADDR_ZIP	Filter by customer billing postal or zip code.
APPROVED	Set to 1 to explicitly include approved orders.
AUTH_AMT	Filter by a specific authorization amount.
BATCH_ID	Filter by a specific gateway settlement batch number.
CLIENT_ID_CHILD	Filter results for a specific child client under a master account.
CUST_EMAIL	Filter by the customer's email address.
CUST_NAME	Filter by the customer's full name.
DECLINED	Set to 1 to include declined transactions in the results.
DESCRIPTOR	Filter by the transaction descriptor sent to the bank.
FROM_TIMESTAMP	The start date for the report range (YYYY-MM-DD).
IP	Filter by the customer's originating IP address.
MBSHP_ID	Filter by a specific Membership or Subscription ID.
MERCH_ACCT_ID	Filter results for a specific Merchant Account ID (MID).
OMNI	A universal search key. Matches against any ID field (Transaction, Order, Customer, etc.) or email addresses. Supports partial matches on non-numeric strings.
ORDER_ID	Filter by the Gateway Purchase Order ID (PO_ID).
PENDING	Set to 1 to include orders currently in a pending state (common for ACH and eCheck).
PMT_BIN	Filter by the first 6 digits of the payment card number.
PMT_ID	Filter by the unique internal Payment ID or Token.
PMT_LAST4	Filter by the last four digits of the card or account number.
PMT_NUMB	Filter by the full credit card number.
SITE_ID	Filter results for a specific Website ID.
TO_TIMESTAMP	The end date for the report range (YYYY-MM-DD).
TRANS_ID	Filter by the unique Gateway Transaction ID.
USERNAME	Filter by the customer's website access or subscription username.