New Payment & Invoice Detail tables
This week we updated our Vendor Central invoice payment table schema to simplify invoice management and reconciliation. Our Vendor Central customers could access the payments_coop table containing a summary of invoices, fees paid, and the associated agreements. This let you aggregate fees and invoices by time period, as an input to Net PPM (pure product margin). However, the summaries did not break down fee calculations or billing, making it difficult to deep dive charges by agreement type.
We launched six new detail tables to help:
Table | Contents | Period |
---|---|---|
payments_cost_variance_distributor_details | ASIN level details regarding specific CoOP deductions for accrual based agreements. (Not all invoices have details so invoice IDs will not 1:1 match with payments_coop) | Weekly |
payments_distributor_returns_details | ASIN level details regarding specific CoOP adjustments for returned inventory for accrual based agreements. (Not all invoices have details so invoice IDs will not 1:1 match with payments_coop) | Weekly |
payments_distributor_shipment_details | ASIN level details regarding specific CooP deductions for accrual based agreements. | Weekly |
payments_customer_shipment_details | ASIN level details regarding specific CoOP based on customer purchases like VPCs.. (Not all invoices have details so invoice IDs will not 1:1 match with payments_coop) | Weekly |
ASIN level details regarding specific CoOP based on customer purchases like VPCs.. (Not all invoices have details so invoice IDs will not 1:1 match with payments_coop) | Specific for CoOP deductions for VPCs, this table shows the number of clipped coupons and clipped fees for any given invoice_id, invoice_date, and agreement_id | Weekly |
payments_invoice_vir | Additional detail for VPCs including coupon_face_value and redemption_fees | Weekly |
How should I use this data?
When a vendor owes Amazon money, Amazon usually takes it as a deduction from invoice payments to the vendor. The most common of these are CoOp deductions, which are taken for agreements such as:
Standard Accrual - Sometimes called the Base Accrual, this is a flat percentage of COGS paid to Amazon for baseline marketing on the website.
Damage Allowance - Compensation for products damaged en route to Amazon, returned by customers, or otherwise rendered unsellable. Amazon prefers to handle disposal of these products instead of shipping them back to the vendor, and receives a % of COGS in return.
Freight Allowance - If Amazon pays for shipping into their fulfillment centers (We-Pay), they charge vendors a flat % of COGS as compensation.
Subscribe and Save - When vendors enroll products in Subscribe & Save, Amazon charges the vendor a fee for every subscription to fund promotional discounts.
Vendor Powered Coupons (VPCs) - When vendors create VPCs, Amazon charges the vendor a fee for every coupon clip and redemption.
The new granularity gives you the ability to deep dive invoices and fees by type. We recommend starting with the payments_coop table and joining invoice_id to the detail tables you need.