Fields in the Payments Data Set

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

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

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"]
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