Order Payment View

The Order Payment view provides dimensions and measures related to payment attempts made in connection to orders. Each record represents a payment attempt.

The measures calculated by this view are:

Name Measure Type Description
Average Amount Collected Average The average amount collected for all order payments.
Average Amount Due Average The average of amount requested minus the total amount collected.
Average Amount Requested Average The average amount requested for all order payments.
Average Order Value Average The total order total divided by the valid order count.
Order Payment Count Count The count of all order payments.
Total Amount Collected Sum Sum of amount collected for all order payments.
Total Amount Due Sum The total amount requested minus the total amount collected.
Total Amount Requested Sum Sum of amount requested for all order payments.

The dimensions included in this view are:

Name Data Type Description
Amount Collected Number The total monetary amount collected in this payment transaction for the order.
Amount Credited Number The total amount credited for this payment.
Amount Requested Number The total amount originally requested for this payment.
Billing Address 1 String Physical or mailing address line one.
Billing Address 2 String Physical or mailing address line two.
Billing Address 3 String Physical or mailing address line three.
Billing Address 4 String Physical or mailing address line four.
Billing Address City String City provided in the billing address for the order.
Billing Address Country Code String Country code provided in the billing address for the order.
Billing Address Postal Code String Postal or zip code provided in the billing address for the order.
Billing Address State/Province String State or province provided in the billing address for the order.
Billing Address Type String Whether the address is commercial or residential.
Billing Contact Email String The email address for the customer contact.
Billing Contact First Name String First name provided in the billing contact for the order.
Billing Contact Last Name String Last name provided in the billing contact for the order.
External Transaction ID String Identifier for the payment transaction from an external system.
Is Paid Yes/No Value is yes if the payment status is Paid or Collected; no otherwise.
Is Same Billing Shipping Address Yes/No If true, the system overrides the customer's billing address information with the supplied fulfillment information.
Order ID String Internal unique identifier of the order with which the order payment is associated.
Order Number String Storefront identifier of the order.
Order Payment Created Date Datetime The timestamp of the date and time the order payment was created.
Order Payment ID String Internal unique identifier of the order payment.
Order Payment Status String The payment status on the associated order. Possible values include Credited, Errored, Paid, Pending, Unpaid, or Voided.
Order Payment Updated Date Datetime The timestamp of the date and time the order payment was most recently updated.
Order Payments Age Tier Number Returns a 30-, 60-, or 90-day tier for each order payment based on its created date.
Order Status String The current status of the order. Possible values include Abandoned, Accepted, Cancelled, Completed, Errored, Pending, PendingReview, Processing, or Validated.
Payment Card Type String The type of credit card.
Payment Status String The current status of the payment. Possible values include Authorized, Collected, Credited, Declined, New, Paid, PaymentRequested, Pending, Unpaid, or Voided.
Payment Term Code String Unique identifier that corresponds to the payment term description for a purchase order used as payment for the order.
Payment Term Description String The payment term for a purchase order (e.g., net 30) used as payment.
Payment Type String The type of payment, such as credit card, check, or PayPal Express.
Payment Workflow String The source of data for this payment.
Purchase Order Number String The storefront identifier of the purchase order used as payment.
Reporting Currency Code String The currency in which monetary amounts are shown in reports.
Site ID Number Unique identifier for the site. This ID is used at all levels of a store and catalog to associate objects to a site.
Site Name String The human readable name for the site associated with the Site ID.
Transactional Currency Code String The currency in which the original transaction was denominated.