Paid Invoices

Table name Vendor: payments_invoices

This report contains paid invoices the brand has sent to Amazon. In theory, the invoices and payments should line up at some point, although there is a lag between them for obvious reasons. Invoices will always come before payments.

Invoices may differ from payments. This is because Amazon may deduct things before they pay, such as promotions, chargebacks, and co-op agreements. As a result, an invoice for $1,000 may only result in a payment of $500 once everything is deducted.

Like Payments, this report is primarily useful to accounting teams. Note that payments_invoices contains details for both successful and failed payments found in the payments_payments table. In most use cases, limit queries of payments_invoices with a join to payments_payments on payment_id, and filter on payment_status = ‘Successful’.

select sum(pi.amount_paid)
from payments_invoices pi
join payments_payments pp
  on pi._partneruuid = pp._partneruuid
 and pi.payment_number = pp.payment_number
 and pp.payment_status = 'Successful'

Statistics

Updated: Daily

Backfill: 1 year

Data Dictionary