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