Fields in the Payments Data Set

Important: You must enable the Payments additional data set to generate this report type.

This report provides detailed information about all payment and refund transactions with the associated information of customer accounts, payment methods, and transactions.

Field Description

The table below describes fields available in this report data set.

Field Group	Field Name	Field Type	Description	Example
Payment details	CUSTOMER_PAYMENT_DOCUMENT_NUMBER	character varying (20)	The number of a payment document.	0000001
	CUSTOMER_PAYMENT_DOCUMENT_DATE	integer	A document creation date and time.	1567112400
	CUSTOMER_PAYMENT_DOCUMENT_TYPE	text	The type of a document: Payment, Check, Void and so on.	Payment
	CUSTOMER_PAYMENT_STATUS	text	The current status of a document: Hold, Open, Closed and so on.	Closed
	CUSTOMER_PAYMENT_TOTAL	numeric (20,8)	A payment total amount.	5.48
	CUSTOMER_PAYMENT_CURRENCY_ID	character (3)	A currency code.	USD
	CUSTOMER_PAYMENT_REFERENCE_NUMBER	character varying (80)	The reference number of the last online transaction performed to process an online payment.	2084580
	CUSTOMER_PAYMENT_DESCRIPTION	character varying (4096)	A payment description.	Payment for Order SO000001.
	CUSTOMER_PAYMENT_CREATION_TIME	integer	The date and time when the payment was created.	1567172083
	CUSTOMER_PAYMENT_PROCESSING_STATUS	text	The processing status of a payment: New, Canceled, Refunded, Void, and so on.	Money Captured
	CUSTOMER_PAYMENT_AUTH_CODE	character varying (80)	The authentication code of the respective transaction for this payment.
	CUSTOMER_PAYMENT_CREATED_BY	integer	A user ID (-1 means the system).	1000014
	INVOICES	JSON	A list of invoice numbers per payment document.	["000010","000011"]
	INVOICES_WITH_APPLIED_AMOUNT	JSON	A list of invoice numbers with total applied amount per payment document.	[["720000350","15.50"],["720000394","4.50"]]
Payment method information	CUSTOMER_PAYMENT_METHOD_ID	integer	The ID of a payment method: credit card, cash, check, and so on.	3
	CUSTOMER_PAYMENT_METHOD_PAY_SYSTEM	character varying (60)	The type of a payment system: redirect, token, and so on.	Redirect
	CUSTOMER_PAYMENT_METHOD_CREATION_DATE	integer	The date of the creation of a payment method in the system.	1567171331
	CUSTOMER_PAYMENT_METHOD_IS_RATIFIED	integer	The ratification status of a payment method.	0
	CUSTOMER_PAYMENT_METHOD_RATIFIED_DATE	integer	The date of a payment method ratification.
	CUSTOMER_PAYMENT_METHOD_EMAIL	character varying (100)	Billing information for credit cards.
	CUSTOMER_PAYMENT_METHOD_ADDRESS1	character varying (80)
	CUSTOMER_PAYMENT_METHOD_ADDRESS2	character varying (80)
	CUSTOMER_PAYMENT_METHOD_CITY	character varying (40)
	CUSTOMER_PAYMENT_METHOD_STATE	character varying (80)
	CUSTOMER_PAYMENT_METHOD_ZIP	character varying (10)
	CUSTOMER_PAYMENT_METHOD_COUNTRYID	character varying (2)
E-Transactions	CUSTOMER_ETRAN_DATE	integer	The date and time when an e-transaction was created.
	CUSTOMER_ETRAN_TYPE	text	The type of an e-transaction: Redirect, Sell, and so on.	Sell
	CUSTOMER_ETRAN_RESULT	text	The result of an e-transaction: In Process, Ok, Error, and so on.	Ok
	CUSTOMER_ETRAN_TRANSACTIONNUMBER	character varying (80)	An e-transaction reference number.	1569808826
	CUSTOMER_ETRAN_COMMENT	character varying (1024)	A comment for a transaction from a payment gateway.	Success.
Customer account data	CUSTOMER_ACCOUNT_ID	integer	The ID of a customer account or a subreseller account acting as a buyer.	1000022
	CUSTOMER_ACCOUNT_BSS_APS_ID	character varying (38)	The APS ID of a related bssAccountInfo APS resource (BSS attributes of an account on the APS bus).	e4dc3a22-b099-4a2f-a284-04f43b2b28bc
	CUSTOMER_NAME	character varying (80)	A customer's Company Name for Business accounts, or First Name, Middle Name, and Last Name for Personal accounts.	John Smith
	CUSTOMER_ACCOUNT_CURRENCY	character varying (5)	The currency of a customer account in which all monetary values are denominated.	USD
	CUSTOMER_ACCOUNT_STATEMENT_DAY	integer	The statement day of a customer account. Used as a date of consolidated invoicing and billing orders alignment, if configured.	30
	CUSTOMER_BILLING_CONTACT_NAME	text	The contact information of a customer.
	CUSTOMER_BILLING_CONTACT_EMAIL	character varying (100)
	CUSTOMER_BILLING_CONTACT_PHONE	text
	CUSTOMER_BILLING_CONTACT_FAX	text
	CUSTOMER_ADMIN_CONTACT_NAME	text
	CUSTOMER_ADMIN_CONTACT_EMAIL	character varying (100)
	CUSTOMER_ADMIN_CONTACT_PHONE	text
	CUSTOMER_ADMIN_CONTACT_FAX	text
	CUSTOMER_TECH_CONTACT_NAME	text
	CUSTOMER_TECH_CONTACT_EMAIL	character varying (100)
	CUSTOMER_TECH_CONTACT_PHONE	text
	CUSTOMER_TECH_CONTACT_FAX	text
	CUSTOMER_PERS_CONTACT_EMAIL	character varying (100)
	CUSTOMER_PERS_CONTACT_PHONE	text