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 |