Sell on Amazon Sign in
This article applies to selling in: United Kingdom

Amazon VAT Transactions Report Field Definitions

Field definitions

Here is an example table with a caption:

Download header Description Example
UNIQUE_ACCOUNT_IDENTIFIER A unique alphanumeric identifier for your account. 2BK7LFHYX789F

ACTIVITY_PERIOD (YYYY-MON)

NOTE: This date is based on the ‘TRANSACTION_COMPLETE_DATE’ field.

Year and month where activity is contained within the report. 2015-OCT
SALES_CHANNEL

The channel where the transaction originated.

‘MFN’ – Merchant Fulfilment Network: These are shipments fulfilled directly by the seller for sales placed on Amazon’s websites.

MFN
‘AFN’ – Amazon Fulfilment Network: These are shipments fulfilled by Amazon on the seller’s behalf for sales placed on Amazon’s websites. AFN
MARKETPLACE

Marketplace where the activity originated.

MFN/AFN: ‘Sale’, ‘Refund’, ‘Liquidation_Sale’, ‘Liquidation_Refund’, ‘Donation’ – Amazon.XX: Reflects the Amazon Marketplace on which the transaction occurred.

AFN: ‘Return’, ‘Commingling Buy’ & ‘Commingling Sell’ – Amazon.XX: Reflects the Amazon Marketplace on which the transaction occurred.

Amazon.de
AFN: ‘FC_Transfer’ & ‘Inbound’: There is no marketplace for internal movement and these values will be ‘N/A’. ‘N/A’
PROGRAM_TYPE

This column identifies the programme type pertaining to the transaction. There are business teams within Amazon that launch programmes catering to different use cases for Amazon and the seller. AVTR includes such programmes when the corresponding activities are relevant for the seller’s VAT reporting.

‘LIQUIDATION’: Liquidation sales of excess inventory initiated by a seller. For more details, refer to FBA Liquidations.

‘DONATION’: Donation of excess inventory to a charitable organisation through the Fulfilment by Amazon donations programme. For more details, refer to FBA Donations.

‘COMMINGLING’: Acquisition or disposal of a product from/to another FBA seller (or Amazon Retail), participating in the Commingling Programme. For more details, refer to Commingling FAQs.

‘REGULAR’: Any transaction to which the above programme types do not apply.
LIQUIDATION
TRANSACTION_TYPE

Transaction type associated with the activity.

‘Sale’: Buyer purchases good(s) from a seller.

SALE

‘Return’: Physical return of goods sent back to an Amazon fulfilment centre.

Amazon is not aware of movement details between a buyer and seller when the product is fulfilled by the merchant (MFN) and cannot provide this information.

Returns are represented with no financial information in the report and detail the best information known about the goods’ movements.

RETURN
‘Refund’: A monetary change to a previously completed order. There may not be movement of goods. Address information may be blank for Refunds if the Refund occurred prior to the Return being completed. For example, MFN Refunds will not have a Return associated with them as Amazon is not aware of the movement details between buyer and seller. REFUND
‘FC_Transfer’: Seller’s inventory is transferred between Amazon’s EU cross border Fulfilment Centres. FC_TRANSFER
‘Inbound’: Seller sends inventory to an Amazon Fulfilment Centre. INBOUND
‘Commingling_Sell’: The disposal of a product to another FBA seller (or Amazon Retail), participating in the Commingling Programme. COMMINGLING_SELL
‘Commingling_Buy’: The acquisition of a product from another FBA seller (or Amazon Retail), participating in the Commingling Programme. COMMINGLING_BUY
‘Liquidation_Sale’: Selling excess inventory in bulk at a significant discount. LIQUIDATION_SALE
‘Liquidation_Refund’: A reversal/refund of a liquidation sale transaction. In case of disputes, a partial or full refund will be issued to the liquidator. LIQUIDATION_REFUND
‘Donation’: Giving away excess inventory to a charitable organisation. DONATION
TRANSACTION_EVENT_ID

Transaction Event ID is an ID that relates to the entire transaction.

This ID can be used to search for transaction-level information in Seller Central.

Transaction event IDs can appear more than once if there are sales, refunds, returns and/or multiple items in an order.

MFN: ‘Sale’ & ‘Refund’ – Order ID

AFN: ‘Sale’, & ‘Return’, / ‘Refund’, ‘Commingling_Buy’ & ‘Commingling_Sell’ – Order ID

305-7728503-7061234
AFN: ‘FC_ Transfer’ – Transfer Item ID 183880795620
AFN: ‘Inbound’ – Reference ID 123ABXZE
AFN: ‘Liquidation_Sale’ – SellerRemovalOrderID 200420E0I
AFN: ‘Donation’ – RCA orderID 2705131019
ACTIVITY_TRANSACTION_ID

Activity Transaction ID is an identifier that relates to lower-level activity within a transaction event. For example, multiple shipments or refunds for one order.

This ID cannot be used to search for transaction-level information in Seller Central.

Activity Transaction IDs can appear more than once if there are multiple items relating to the activity level.

AFN: ‘Commingling_Sell’ & ‘Commingling_Buy’ – Shipment ID

MFN/AFN: ‘Sale’ – Shipment ID

15512820259001

AFN: ‘Return’ – Reversal ID corresponding to associated refund. A unique return ID may be present instead

1) If there is no refund associated with movement up to the current reporting month or

2) The associated refund happened three years prior to this return

AFN/MFN: ‘Refund’ – Reversal ID associated with the refund.

amzn1:crow:+h4EhpvFQl2yEVqFpslIM

8230948203985

AFN: ‘FC_Transfer’ – Transfer Item ID ‘183880795620’
AFN: ‘Inbound’ – Inbound Reference ID 123ABXZE
AFN: ‘Liquidation_Sale’ – FCRemoval ShipmentID 210102461552
AFN: ‘Donation’ – FCRemoval ShipmentID 210102461552

TAX_CALCULATION_DATE

(DD-MM-YYYY)

For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions and for sellers who have VAT Calculation Services activated in the previous month 15-10-2015

Blank

The date that is used to determine the VAT details. This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

The date in which VAT has been calculated.

Date on which VAT was calculated.

MFN/AFN: ‘Sale’ ‘Commingling_Sell’ & ‘Commingling_Buy’ – The date on which VAT has been calculated.

AFN: ‘Return’ – The date that is used to determine VAT details.

MFN/AFN: ‘Refund’ – The date on which VAT has been calculated.

AFN: ‘FC_Transfer’ & ‘Inbound’ – This value will be blank.

AFN: ‘Liquidation_Sale’ – The date on which VAT has been calculated.

AFN: ‘Donation’ – This value will be blank.

TRANSACTION_DEPARTURE_DATE (DD-MM-YYYY)

Date associated with the departure (outbound) movement to the final destination. This date may be in a different month to the arrival month. Date used to determine the month in which the activity will be contained in the transaction report is the TRANSACTION_COMPLETE_DATE

MFN/AFN: ‘Sale’ – Shipment Date (seller-to-buyer shipments). This is also the date when the buyer's payment instrument is charged.

AFN: ‘Commingling_Sell’ & ‘Commingling_Buy’ – Shipment Date (seller-to-buyer shipments)

AFN: ‘Liquidation_Sale’ – Shipment date (seller-to-buyer shipments).

AFN: ‘Donation’ – Shipment date (seller-to-buyer shipments).

15-10-2015
AFN: ‘Return’ – Date good(s) sent back. This field will be blank if the data is not provided to Amazon by the buyer or Carrier. Blank
AFN: ‘FC_Transfer’ – Process Date: The date inventory began its movement from a Fulfilment Centre. 15-10-2015
AFN: ‘Inbound’ – The date in which you create shipment in ‘Manage FBA Shipments’ page. Blank

MFN/AFN: ‘Refund’ – Blank. There is a monetary change and the date is reflected in TRANSACTION_COMPLETE_DATE.

NOTE: Product movement will be reflected in the Return section.

Blank
TRANSACTION_ARRIVAL_DATE (DD-MM-YYYY)

Date associated with the final destination (inbound) movement. This date may be in a different month to the arrival month. Date used to determine the month in which the activity will be contained in the transaction report is the TRANSACTION_COMPLETE_DATE_UTC.

MFN/AFN: ‘Sale’ – Delivery date (seller-to-buyer shipments). This field will be blank if the data is not provided to Amazon by the Carrier.

AFN: ‘Commingling_Sell’ & ‘Commingling_Buy’ – Delivery Date (seller-to-buyer shipments).

AFN: ‘Liquidation_Sale’, ‘Liquidation_Refund’, ‘Donation’ – Empty

18-08-2015
AFN: ‘Return’ – Date return arrived at Fulfilment Centre. (buyer-to-seller returns) 18-08-2015
AFN: ‘FC_Transfer’ – Date items arrive at the Fulfilment Centre receiving dock and are pending check-in. 18-08-2015
AFN: ‘Inbounds’ – Date items arrive at the Fulfilment Centre receiving dock and completed check-in. 18-08-2015

MFN/AFN: ‘Refund’ – Blank. There is a monetary change and the date is reflected in TRANSACTION_COMPLETE_DATE

NOTE: Product movement will be reflected in the Return section.

Blank
TRANSACTION_COMPLETE_DATE (DD-MM-YYYY)

Date used to determine the month in which the activity will be contained in the transaction report.

MFN/AFN: ‘Sale’, ‘Liquidation_Sale’, ‘Donation’ – Shipment Date (seller-to-buyer shipments). This is also the date when the buyer's payment instrument is charged.

AFN: ‘Commingling_Sell’ & ‘Commingling_Buy’ – Shipment Date (seller-to-buyer shipments).

20-08-2015 or Blank
AFN: ‘Return’ – Date return arrived at Fulfilment Centre. (buyer-to-seller returns). 20-08-2015 or Blank

MFN/AFN: ‘Refund’, ‘Liquidation_Refund’ – Date the refund of monetary values was completed.

NOTE: Product movement will be reflected in the Return section.

20-08-2015 or Blank
AFN: ‘FC_Transfer’ – Received Date, the date the inventory was checked into the receiving Fulfilment Centre. 20-08-2015 or Blank
AFN: ‘Inbounds’ – Received Date, the date the inventory is checked into the receiving Fulfilment Centre. 20-08-2015 or Blank
SELLER_SKU Stock Keeping Units (SKUs) are unique blocks of letters or numbers that are assigned to Amazon by the seller to make it easier for them to identify their products. Seller SKUs are required when listing an item. If SKU available, populated. If unavailable, populated as 'Not Available'. EL-QBE2-2MBO
ASIN Amazon Standard Identification Numbers (ASINs) are unique blocks of 10 letters or numbers that identify items. ASINs are assigned by Amazon. You can find the ASIN on the product detail pages. Multiple seller SKUs can be assigned to one ASIN. B000WON1Z0
ITEM_ DESCRIPTION

The product description based on the Amazon Marketplace in which the item is transacted.

‘FC_Transfer’ & ‘Inbound’: The product description based on seller’s home market place. This field will be blank if product descriptions are not available in the seller's home market place.

Chaîne de cheville Argent 925/1000 (poinçonnée) – 2 mm Picnic Chaussons 20A0109B black Noir 41 or Blank
ITEM_COUNTRY_OF_MANUFACTURE

Two-character country code where the product was originally made or manufactured; this is not the location where the item is sold.

This will be Blank as it is not collected by Amazon at this time.

Blank
QUANTITY

Units of the ASIN in the activity.

MFN/AFN: ‘Sale’, ‘Liquidation_Sale’, ‘Donation’ – Units sold as a positive value.

AFN: ‘Commingling_Buy’ & ‘Commingling_Sell’ – Units sold as a positive value.

5
AFN: ‘Return’ – Units returned as a positive value. 5
MFN/AFN: ‘Refund’, ‘Liquidation_Refund’ – Units refunded as a positive value. 5
AFN: ‘FC_Transfer’ & ‘Inbound’ – Units received at a Fulfilment Centre as a positive value. 5
ITEM_WEIGHT

The weight of each individual SKU item in kilograms (kg).

All Transactions – Except MFN/AFN ‘Refund’: The unit weight in kilograms (kg).

‘FC_Transfer’ & ‘Inbound’: The weight of each individual SKU item in kilograms (kg) based on seller’s home market place.

This field will be blank if not available in the seller's home market place.

0.01
MFN/AFN: ‘Refund’, ‘Liquidation_Refund’ – Refunds only reflect financial movement, so this value will be 0. Product movement will be reflected in the "Return" section. 0
TOTAL_ACTIVITY_WEIGHT

Total weight of the units moved for this activity line. The unit will be in kilograms (kg).

All Use Cases: ‘QUANTITY’ x ‘ITEM_WEIGHT’

‘FC_Transfer’ & ‘Inbound’: Total weight of the units moved for this activity line in kilograms (kg) based on seller’s home market place.

This field will be blank if not available in the seller's home market place.

0.075 or 0
COST_PRICE_OF_ITEMS For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month 12.00 or 0 or Blank

The cost price of the item (amount paid to acquire the item) as provided by the seller.

This will be blank. The service made available by Amazon does not currently capture this information from sellers.

The cost price is only relevant for cross-border stock transfer in EU.

MFN/AFN:

‘Sale’, ‘Liquidation_Sale’, ‘Donation’ – Cost Price (amount paid to acquire the item) as provided by the seller as a positive value.

AFN: ‘Commingling_Sell’ & ‘Commingling_Buy’ – Blank.

AFN:

‘Return’ – Blank.

MFN/AFN:

‘Refund’, ‘Liquidation_Refund’ – Cost Price (amount paid to acquire the item) as provided by the seller as a positive value.

AFN:

‘FC_Transfer’ & ‘Inbound’ – Cost Price as a positive value

PRICE_OF_ITEMS_AMT_VAT_EXCL For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month 12.00 or 0 or Blank

The total price of items for all units (quantity) in the activity type, excluding VAT, Shipping, Gift Wrap and Promotion amounts. Sales are reflected as positive amounts and returns/refunds are reflected as negative amounts.

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

The total price of items for all units (quantity) in the activity type, excluding VAT, Shipping, Gift Wrap and Promotion amounts.

Sales are reflected as positive amounts and refunds are reflected as negative amounts.

MFN/AFN:

‘Sale’, ‘Liquidation_Sale’ – Sales Price as a positive value.

AFN:

‘Commingling_Buy’ – Transaction price as a positive value.

‘Commingling_Sell’ – Transaction Price as a positive value.

AFN:

‘Return’ – This will be blank

‘Donation’ – This will be blank.

MFN/AFN:

‘Refund’, ‘Liquidation_Refund’ – Sales Price Refunded as a negative value.

AFN:

‘FC_Transfer’ & ‘Inbound’ – This value will be blank, because VCS is not currently performing VAT calculation for these transaction types.

PROMO_PRICE_OF_ITEMS_AMT_VAT_EXCL For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month 12.00 or 0 or Blank

The promotion amount applied to the transaction type for all units (quantity) in the activity type, excluding VAT, shipping, gift wrap and price of item amounts.

Sales are reflected as negative amounts and returns/refunds are reflected as positive amounts.

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

The promotion amount applied to the transaction type for all units (quantity) in the activity type,

Excluding VAT, Shipping, Gift Wrap and Price of Item amounts.

Sales are reflected as negative amounts and returns/refunds are reflected as positive amounts.

MFN/AFN:

‘Sale’ – Promotion amount as a negative value.

‘Refund’ –

Promotion amount refunded as a positive value.

AFN:

‘Commingling_Sell’ & ‘Commingling_Buy’ – This will be blank

AFN:

‘Return’, ‘Donation’, ‘Liquidation_Sale’, ‘Liquidation_Refund’ – This will be blank

AFN:

‘FC_Transfer ’ & ‘Inbound’ –

This value will be 0, because VCS is not currently performing VAT calculation for these transaction types.

TOTAL_PRICE_OF_ITEMS_AMT_VAT_EXCL For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month 12.00 or 0 or Blank

The total value of the item price paid by the buyer, excluding VAT, shipping and gift wrap.

"PRICE_OF_ITEMS_AMT_VAT_EXCL" + "PROMO_PRICE_OF_ITEMS_AMT_VAT_EXCL"

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller-to-buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

The total value of the item price paid by the buyer, excluding VAT, shipping and gift wrap.

"PRICE_OF_ITEMS_AMT_VAT_EXCL" + "PROMO_PRICE_OF_ITEMS_AMT_VAT_EXCL"

MFN/AFN:

‘Sale’, ‘Liquidation_Sale’ – Total Price of Items amount excluding VAT as a positive value.

‘Donation’ – This field will be blank.

AFN:

‘Commingling_Buy’ – Total Price of Items amount excluding VAT as a positive value.

‘Commingling_Sell’ – Total Price of Items amount excluding VAT as a positive value.

AFN:

‘Return’ – This value will be blank

MFN/AFN:

‘Refund’, ‘Liquidation_Refund’ – Total Price of Items amount excluding VAT refunded as a negative value.

AFN:

‘FC_Transfer ’ & ‘Inbound’ –

This value will be 0, because currently VCS is not currently performing VAT calculation for these transaction types.

SHIP_CHARGE_AMT_VAT_EXCL For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month 12.00 or 0 or Blank

The amount of shipping charged/refunded to the buyer for all units (quantity) in the activity type, excluding VAT, Price of Items, Gift Wrap and Promotion amounts.

Sales are reflected as positive amounts and returns/refunds are reflected as negative amounts.

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

The amount of shipping charged/refunded to the buyer for all units (quantity) in the activity type, excluding VAT, Price of Items, Gift Wrap and Promotion amounts.

Sales are reflected as positive amounts and refunds are reflected as negative amounts.

MFN/AFN:

‘Sale’ – Shipping amount excluding VAT as a positive value.

‘Liquidation_Sale’, ‘Liquidation_Refund’, ‘Donation’ – This value will be blank.

AFN:

‘Commingling_Sell’ & ‘Commingling_Buy’ – This will be blank

AFN:

‘Return’ – This will be blank

MFN/AFN:

‘Refund’ – Shipping amount refunded excluding VAT as a negative value.

AFN:

‘FC_Transfer ’ & ‘Inbound’ –

This value will be blank.

PROMO_SHIP_CHARGE_AMT_VAT_EXCL For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month 12.00 or 0 or Blank

The promotion amount applied to shipping charged/refunded to the buyer for all units (quantity) in the activity type, excluding VAT, Price of Items, Shipping Charge and Gift Wrap amounts.

Sales are reflected as negative amounts and returns/refunds are reflected as positive amounts.

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

The promotion amount applied to shipping charged/refunded to the buyer for all units (quantity) in the activity type, excluding VAT, Price of Items, Shipping Charge and Gift Wrap amounts.

Sales are reflected as negative amounts and returns/refunds are reflected as positive amounts.

MFN/AFN:

‘Sale’ – Promotion amount excluding VAT as a negative value

‘Liquidation_Sale’, ‘Liquidation_Refund’, ‘Donation’ – This value will be blank.

AFN:

‘Commingling_Sell’ & ‘Commingling_Buy’ – This will be blank

AFN:

‘Return’ – Promotion amount refunded excluding VAT as a positive value.

MFN/AFN:

‘Refund’ – Promotion amount refunded excluding VAT as a positive value.

AFN:

‘FC_Transfer ’ & ‘Inbound’ –

This value will be blank.

Note: Promotions are not applied to movement between FCs.

TOTAL_SHIP_CHARGE_AMT_VAT_EXCL For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month 12.00 or 0 or Blank

The total value of shipping paid or refunded to the buyer, excluding VAT, price of items and gift wrap,

‘SHIP_CHARGE_AMT_VAT_EXCL’ + ‘PROMO_SHIP_CHG_AMT_VAT_EXCL’

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

The total value of shipping paid or refunded to the buyer, excluding VAT, price of items and gift wrap,

‘SHIP_CHARGE_AMT_VAT_EXCL’ + ‘PROMO_SHIP_CHG_AMT_VAT_EXCL’

MFN/AFN:

‘Sale’ – Total shipping amount excluding VAT as a positive value.

‘Liquidation_Sale’, ‘Liquidation_Refund’, ‘Donation’ – This value will be blank.

AFN:

‘Commingling_Sell’ & ‘Commingling_Buy’ – This will be blank

AFN:

‘Return’ – Total shipping charge amount refunded excluding VAT as a positive value.

MFN/AFN:

‘Refund’ – Total shipping charge amount refunded excluding VAT as a positive value.

AFN:

‘FC_Transfer’ & ‘Inbound’ –

This value will be blank

GIFT_WRAP_AMT_VAT_EXCL For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month 12.00 or 0 or Blank

The amount of gift wrap charged/refunded to the buyer for all units (quantity) in the activity type, excluding VAT, price of items, shipping and promotion amounts.

Sales are reflected as positive amounts and returns/refunds are reflected as negative amounts.

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

The amount of gift wrap charged/refunded to the buyer for all units (quantity) in the activity type, excluding VAT, price of items, shipping and promotion amounts.

Sales are reflected as positive amounts and returns/refunds are reflected as negative amounts.

MFN/AFN:

‘Sale’ – Gift Wrap amount excluding VAT as a positive value.

‘Liquidation_Sale’, ‘Liquidation_Refund’, ‘Donation’ – This value will be blank.

AFN:

‘Commingling_Sell’ & ‘Commingling_Buy’ – This will be blank

AFN:

‘Return’ – Gift Wrap amount refunded excluding VAT as a negative value.

MFN/AFN:

‘Refund’ – Gift Wrap amount refunded excluding VAT as a negative value.

AFN:

‘FC_Transfer’ & ‘Inbound’ –

This value will be blank

Note: There is no gift wrap paid by the buyer in this scenario.

PROMO_GIFT_WRAP_AMT_VAT_EXCL For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month 12.00 or 0 or Blank

The promotion amount applied to gift wrap charged/refunded to the buyer for all units (quantity) in the activity type, excluding VAT, Price of Items and Shipping amounts.

Sales are reflected as negative amounts and returns/refunds are reflected as positive amounts.

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

The promotion amount applied to gift wrap charged/refunded to the buyer for all units (quantity) in the activity type, excluding VAT, Price of Items and Shipping amounts.

Sales are reflected as negative amounts and returns/refunds are reflected as positive amounts.

MFN/AFN:

‘Sale’ – Promotion amount excluding VAT as a negative value.

‘Liquidation_Sale’, ‘Liquidation_Refund’, ‘Donation’ – This value will be blank.

AFN:

‘Commingling_Sell’ & ‘Commingling_Buy’ – This will be blank

AFN:

‘Return’ – This will be blank

MFN/AFN:

‘Refund’ – Promotion amount refunded excluding VAT as a positive value.

AFN:

‘FC_Transfer’ & ‘Inbound’ –

This value will be blank.

Note: There is no gift wrap paid by the buyer in this scenario.

TOTAL_GIFT_WRAP_AMT_VAT_EXCL For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month 12.00 or 0 or Blank

The total value of gift wrap paid or refunded to the buyer, excluding VAT, price of items and shipping.

"GIFT_WRAP_AMT_VAT_EXCL" + "PROMO_GIFT_WRAP_AMT_VAT_EXCL"

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

The total value of gift wrap paid or refunded to the buyer, excluding VAT, price of items and shipping.

"GIFT_WRAP_AMT_VAT_EXCL" + "PROMO_GIFT_WRAP_AMT_VAT_EXCL"

MFN/AFN:

‘Sale’ – Total Gift Wrap amount excluding VAT as a positive value.

‘Liquidation_Sale’, ‘Liquidation_Refund’, ‘Donation’ – This value will be blank.

AFN:

‘Commingling_Sell’ & ‘Commingling_Buy’ – This will be blank

AFN:

‘Return’ – This will be blank

MFN/AFN:

‘Refund’ – Total Gift Wrap amount refunded excluding VAT as a negative value.

AFN:

‘FC_Transfer’ & ‘Inbound’ –

This value will be blank.

TOTAL_ACTIVITY_VALUE_AMT_VAT_EXCL For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month 12.00 or 0 or Blank

The total value of the activity, excluding VAT.

"TOTAL_PRICE_OF_ITEMS_AMT_VAT_EXCL" + "TOTAL_SHIP_CHARGE_AMT_VAT_EXCL" + "TOTAL_GIFT_WRAP_AMT_VAT_EXCL"

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

The total value of the activity, excluding VAT.

"TOTAL_PRICE_OF_ITEMS_AMT_VAT_EXCL" + "TOTAL_SHIP_CHARGE_AMT_VAT_EXCL" + "TOTAL_GIFT_WRAP_AMT_VAT_EXCL"

MFN/AFN:

‘Sale’, ‘Liquidation_Sale’ – Total Activity Value amount excluding VAT as a positive value.

AFN:

‘Commingling_Sell’ & ‘Commingling_Buy’ – Total Activity Value amount excluding VAT as a positive value.

AFN:

‘Return’ – Total Activity Value amount excluding VAT as a positive value.

MFN/AFN:

‘Refund’, ‘Liquidation_Refund’ – Total Activity Value amount excluding VAT as a positive value.

AFN:

‘FC_Transfer’, ‘Inbound’, ‘Donations’ –

This value will be blank.

PRICE_OF_ITEMS_VAT_RATE_PERCENT For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month

0.20

Blank

The VAT rate applied to the activity as a percentage. The rate percentage is provided as a decimal value (e.g. 0.20=20%, 0.02=2%).

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

The VAT rate applied to the activity as a percentage. The rate percentage is provided as decimal value (for example 0.20=20%, 0.02=2%).

MFN/AFN:

‘Sale’, ‘Liquidation_Sale’ – VAT Rate percentage

‘Donation’ – This will be blank

AFN:

‘Commingling_Sell’ and ‘Commingling_Buy’ – VAT Rate percentage

AFN:

‘Return’ – This will be blank

MFN/AFN:

‘Refund’, ‘Liquidation_Refund’ – VAT Rate percentage AFN:

‘FC_Transfer’ & ‘Inbound’ –

This value will be blank

PRICE_OF_ITEMS_VAT_AMT For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month 12.00 or 0 or Blank

The VAT amount charged or refunded to the buyer from the seller on the items in the activity based on the PRICE_OF_ITEMS_VAT_RATE_PERCENT.

This amount excludes shipping, gift wrap, promotions and PRICE_OF_ITEMS_VAT_EXCL.

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

The VAT amount charged or refunded to the buyer from the seller on the items in the activity based on the PRICE_OF_ITEMS_VAT_RATE_PERCENT.

This amount excludes shipping, gift wrap, promotions and PRICE_OF_ITEMS_VAT_EXCL.

MFN/AFN:

‘Sale’, ‘Liquidation_Sale’ – VAT Amount as a positive value.

‘Donation’ – This will be blank

AFN:

‘Commingling_Sell’ & ‘Commingling_Buy’ – VAT Amount as a positive value.

AFN:

‘Return’ – VAT Amount as a positive value.

MFN/AFN:

‘Refund’, ‘Liquidation_Refund’ – VAT Amount as a positive value.

AFN:

‘FC_Transfer’ & ‘Inbound’ –

This value will be blank

PROMO_PRICE_OF_ITEMS_VAT_AMT For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month 12.00 or 0 or Blank

The VAT amount charged or refunded to the buyer from the seller on the promotional amount applied to the items in the activity based on the PRICE_OF_ITEMS_VAT_RATE_PERCENT.

This amount excludes shipping, gift wrap, PRICE_OF_ITEMS_VAT_EXCL and PRICE_OF_ITEMS_VAT_AMT.

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

The VAT amount charged or refunded to the Buyer from the Seller on the promotional amount applied to the items in the activity based on the PRICE_OF_ITEMS_VAT_RATE_PERCENT.

This amount excludes shipping, gift wrap, PRICE_OF_ITEMS_VAT_EXCL and PRICE_OF_ITEMS_VAT_AMT.

Promotion Price of Item VAT amount:

‘PROMO_PRICE_OF_ITEMS_VAT_EXCL’ x ‘PRICE_OF_ITEMS_VAT_RATE_PERCENT’

MFN/AFN:

‘Sale’ – Promotion Price of Item VAT amount as a positive value.

‘Liquidation_Sale’, ‘Liquidation_Refund’, ‘Donation’ – This will be blank

AFN:

‘Commingling_Sell’ & ‘Commingling_Buy’ – This will be blank

AFN:

‘Return’ – This will be blank

MFN/AFN:

‘Refund’, ‘Liquidation_Refund’ – Promotion Price of Item VAT amount refunded as a positive value.

AFN:

‘FC_Transfer’ & ‘Inbound’ –

This value will be blank

TOTAL_PRICE_OF_ITEMS_VAT_AMT For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month 12.00 or 0 or Blank

The total VAT amount charged/refunded to the buyer by the seller on the items in the activity.

"PRICE_OF_ITEMS_VAT_AMT" + "PROMO_PRICE_OF_ITEMS_VAT_AMT"

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

The total VAT amount charged/refunded to the buyer by the seller on the items in the activity.

"PRICE_OF_ITEMS_VAT_AMT" + "PROMO_PRICE_OF_ITEMS_VAT_AMT"

MFN/AFN:

‘Sale’, ‘Liquidation_Sale’ – Total Price of Item VAT amount as a positive value.

‘Donation’ – This will be blank

AFN:

‘Commingling_Buy’ & ‘Commingling_Sell’ – Total Price of Item VAT amount as a positive value.

AFN:

‘Return’ – This will be blank

MFN/AFN:

‘Refund’, ‘Liquidation_Refund’ – Total Price of Item VAT amount as a positive value.

AFN:

‘FC_Transfer’ & ‘Inbound’ –

This value will be blank

SHIP_CHARGE_VAT_RATE_PERCENT For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month 0.20 or Blank

The VAT rate percentage applied to the shipping charged/refunded to the buyer for the activity.

The rate percentage is provided as a decimal value (e.g. 0.20=20%, 0.02=2%).

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

The VAT rate percentage applied to the shipping charged/refunded to the buyer for the activity.

The rate percentage is provided as decimal value (for example 0.20=20%, 0.02=2%).

MFN/AFN:

‘Sale’ – Shipping VAT Rate %

‘Liquidation_Sale’, ‘Liquidation_Refund’, ‘Donation’ – This will be blank

AFN:

‘Commingling_Buy’ & ‘Commingling_Sell’ – This will be blank

AFN:

‘Return’ – This will be blank

MFN/AFN:

‘Refund’ – Shipping VAT Rate %

AFN:

‘FC_Transfer’ & ‘Inbound’ –

This value will be blank

SHIP_CHARGE_VAT_AMT For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month 12.00 or 0 or Blank

The VAT amount charged or refunded to the buyer by the seller on the shipping amount based on the SHIP_CHARGE_VAT_RATE_PERCENT.

This amount excludes price of items, gift wrap, promotions and SHIP_CHARGE_AMT_VAT_EXCL

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

The VAT amount charged or refunded to the buyer by the seller on the shipping amount based on the SHIP_CHARGE_VAT_RATE_PERCENT.

MFN/AFN:

‘Sale’ – Shipping charge VAT amount as a positive value.

‘Liquidation_Sale’, ‘Liquidation_Refund’, ‘Donation’ – This will be blank

AFN:

‘Commingling_Buy’ & ‘Commingling_Sell’ – This will be blank

AFN:

‘Return’ – This will be blank

MFN/AFN:

‘Refund’ – Shipping charge VAT amount as a positive value.

AFN:

‘FC_Transfer’ & ‘Inbound’ –

This value will be blank

PROMO_SHIP_CHARGE_VAT_AMT For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month 12.00 or 0 or Blank

The VAT amount charged or refunded to the buyer by the seller on the promotional amount applied to the shipping amount, based on the SHIP_CHARGE_VAT_RATE_PERCENT.

This amount excludes price of items, gift wrap and SHIP_CHARGE_AMT_VAT_EXCL.

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

The VAT amount charged or refunded to the buyer by the seller on the promotional amount applied to the shipping amount, based on the SHIP_CHARGE_VAT_RATE_PERCENT.

MFN/AFN:

‘Sale’ – Promotion shipping charge VAT amount as a positive value.

‘Liquidation_Sale’, ‘Liquidation_Refund’, ‘Donation’ – This will be blank

AFN:

‘Commingling_Buy’ & ‘Commingling_Sell’ – This will be blank

AFN:

‘Return’ – This will be blank

MFN/AFN:

‘Refund’ – Promotion shipping charge VAT amount refunded as a positive value.

AFN:

‘FC_Transfer’ & ‘Inbound’ –

This value will be blank

TOTAL_SHIP_CHARGE_VAT_AMT For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month 12.00 or 0 or Blank

The total VAT amount charged/refunded to the buyer by the seller on the shipping amount for the activity.

"SHIP_CHARGE_VAT_AMT" + "PROMO_SHIP_CHARGE_VAT_AMT"

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

The total VAT amount charged/refunded to the buyer by the seller on the shipping amount for the activity.

"SHIP_CHARGE_VAT_AMT" + "PROMO_SHIP_CHARGE_VAT_AMT"

MFN/AFN:

‘Sale’ – Total Shipping charge VAT amount as a positive value.

‘Liquidation_Sale’, ‘Liquidation_Refund’, ‘Donation’ – This will be blank

AFN:

‘Commingling_Buy’ & ‘Commingling_Sell’ – This will be blank

AFN:

‘Return’ – This will be blank

MFN/AFN:

‘Refund’ – Total Shipping charge VAT amount refunded as a positive value.

AFN:

‘FC_Transfer’ & ‘Inbound’ –

This value will be blank

GIFT_WRAP_VAT_RATE_PERCENT For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month 0.20 or Blank

The VAT rate percentage applied to the gift wrap charged/refunded to the buyer for the activity.

The rate percentage is provided as a decimal value (e.g. 0.20=20%, 0.02=2%).

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

MFN/AFN:

‘Sale’ – Gift Wrap VAT Rate %

‘Liquidation_Sale’, ‘Liquidation_Refund’, ‘Donation’ – This will be blank

AFN:

‘Commingling_Buy’ & ‘Commingling_Sell’ – This will be blank

AFN:

‘Return’ – This will be blank

MFN/AFN:

‘Refund’ – Gift Wrap VAT Rate %

AFN:

‘FC_Transfer’ & ‘Inbound’ –

This value will be blank

GIFT_WRAP_VAT_AMT For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month 12.00 or 0 or Blank

The VAT rate percentage applied to the gift wrap charged/refunded to the buyer for the activity.

The rate percentage is provided as a decimal value (e.g. 0.20=20%, 0.02=2%).

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

MFN/AFN:

‘Sale’ – Gift Wrap VAT Rate %

‘Liquidation_Sale’, ‘Liquidation_Refund’, ‘Donation’ – This will be blank

AFN:

‘Commingling_Buy’ & ‘Commingling_Sell’ – This will be blank

AFN:

‘Return’ – This will be blank

MFN/AFN:

‘Refund’ – Gift Wrap VAT Rate %

AFN:

‘FC_Transfer’ & ‘Inbound’ –

This value will be blank

PROMO_GIFT_WRAP_VAT_AMT For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month 12.00 or 0 or Blank

The VAT amount charged or refunded to the buyer by the seller on the promotional amount applied to gift wrap, based on the GIFT_WRAP_VAT_RATE_PERCENT.

This amount excludes price of items, shipping and GIFT_WRAP_AMT_VAT_EXCL.

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

The VAT amount charged or refunded to the buyer by the seller on the promotional amount applied to gift wrap, based on the GIFT_WRAP_VAT_RATE_PERCENT.

This amount excludes price of items, shipping and GIFT_WRAP_AMT_VAT_EXCL.

MFN/AFN:

‘Sale’ – Promotion Gift Wrap VAT amount as a positive value.

AFN:

‘Commingling_Buy’ & ‘Commingling_Sell’ – This will be blank

AFN:

‘Return’ – This will be blank

MFN/AFN:

‘Refund’ – Promotion Gift Wrap VAT amount refunded as a positive value.

AFN:

‘FC_Transfer’ & ‘Inbound’ –

This value will be blank

TOTAL_GIFT_WRAP_VAT_AMT For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month 12.00 or 0 or Blank

The total VAT amount charged/refunded to the buyer by the seller on the gift wrap for the activity.

"GIFT_WRAP_VAT_AMT" + "PROMO_GIFT_WRAP_VAT_AMT"

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

The total VAT amount charged/refunded to the buyer by the seller on the gift wrap for the activity.

"GIFT_WRAP_VAT_AMT" + "PROMO_GIFT_WRAP_VAT_AMT"

MFN/AFN:

‘Sale’ – Total Gift Wrap VAT amount as a positive value.

‘Liquidation_Sale’, ‘Liquidation_Refund’, ‘Donation’ – This will be blank

AFN:

‘Commingling_Buy’ & ‘Commingling_Sell’ – This will be blank

AFN:

‘Return’ – This will be blank

MFN/AFN:

‘Refund’ – Total Gift Wrap VAT amount as a positive value.

AFN:

‘FC_Transfer’ & ‘Inbound’ –

This value will be blank

TOTAL_ACTIVITY_VALUE_VAT_AMT For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month 12.00 or 0 or Blank

The total VAT for the activity.

"TOTAL_PRICE_OF_ITEMS_VAT_AMT" + "TOTAL_SHIP_CHARGE_VAT_AMT" + "TOTAL_GIFT_WRAP_VAT_AMT"

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

The total VAT for the activity.

"TOTAL_PRICE_OF_ITEMS_VAT_AMT" + "TOTAL_SHIP_CHARGE_VAT_AMT" + "TOTAL_GIFT_WRAP_VAT_AMT"

MFN/AFN:

‘Sale’ – Total Activity Value VAT amount as a positive value.

‘Liquidation_Sale’, ‘Liquidation_Refund’, ‘Donation’ – This will be blank

AFN:

‘Commingling_Buy’ & ‘Commingling_Sell’ – Total Activity Value VAT amount as a positive value.

AFN:

‘Return’ – This will be blank

MFN/AFN:

‘Refund’ – Total Activity Value VAT amount as a positive value.

AFN:

‘FC_Transfer’ & ‘Inbound’ –

This value will be blank

PRICE_OF_ITEMS_AMT_VAT_INCL

The total price of items for all units (quantity) in the activity type, including VAT and excluding shipping, gift wrap and promotion amounts.

Sales are reflected as positive amounts and returns/refunds are reflected as negative amounts.

MFN/AFN ‘Sale’, ‘Liquidation_Sale’: The total VAT inclusive amount of the items in the activity.

‘Donation’ – This will be blank

AFN ‘Commingling_Buy’ & ‘Commingling_Sell’: The total VAT – inclusive amount of the items in the activity.

MFN/AFN ‘Refund’, ‘Liquidation_Refund’: The total VAT inclusive amount of the items in the activity.

NOTE: Product movement will be reflected in the Return section.

AFN ‘FC_Transfer’ & ‘Inbounds’

This will be blank. The service made available by Amazon does not currently capture this information from sellers.

AFN ‘Return’: This will be blank. The service made available by Amazon does not currently capture this information from sellers.

Note: The service made available by Amazon does not currently calculate VAT details on seller to buyer orders, for non VAT Calculation Service enrolled sellers.
12.00 or 0 or Blank
PROMO_PRICE_OF_ITEMS_AMT_VAT_INCL

The total promotion price of items for all units (quantity) in the activity type, including VAT and excluding price of items, shipping and gift wrap.

Sales are reflected as positive amounts and returns/refunds are reflected as negative amounts.

MFN/AFN ‘Sale’: The total VAT inclusive promotional amount of the items in the activity

‘Liquidation_Sale’, ‘Liquidation_Refund’, ‘Donation’ – This will be blank

AFN: ‘Commingling_Buy’ & ‘Commingling_Sell’: This will be blank. There are no promotional amounts applied to Commingling transactions.

MFN/AFN ‘Refund’: The total VAT inclusive promotional amount of the items in the activity.

NOTE: Product movement will be reflected in the Return section.

AFN ‘FC_Transfer’ & ‘Inbounds’: There are no promotional amounts applied to Inbound and Transfer activity. There are no financial movements between the seller and Amazon.

AFN ‘Return’: This will be blank. The service made available by Amazon does not currently capture this information from sellers.

Note: The service made available by Amazon does not currently calculate VAT details on seller-to-buyer orders for non VAT Calculation Service enrolled sellers.

12.00 or 0 or Blank
TOTAL_PRICE_OF_ITEMS_AMT_VAT_INCL

The total price of items for all units (quantity) in the activity type, including VAT and excluding shipping and gift wrap charges.

Sales are reflected as positive amounts and returns/refunds are reflected as negative amounts.

MFN/AFN ‘Sale’, ‘Liquidation_Sale’: PRICE_OF_ITEMS_AMT_VAT_INCL + PROMO_PRICE_OF_ITEMS_AMT_VAT_INCL

AFN ‘Commingling_Buy’ & ‘Commingling_Sell’: PRICE_OF_ITEMS_AMT_VAT_INCL

MFN/AFN ‘Refund’, ‘Liquidation_Refund’: PRICE_OF_ITEMS_AMT_VAT_INCL + PROMO_PRICE_OF_ITEMS_AMT_VAT_INCL

NOTE: Product movement will be reflected in the Return section.

AFN ‘FC_Transfer’ & ‘Inbounds’ & ‘Return’ & ‘Return’ & ‘Donation’: This will be blank. The service made available by Amazon does not currently capture this information from sellers.

Note: The service made available by Amazon does not currently calculate VAT details on seller-to-buyer orders for non VAT Calculation Service enrolled sellers.

12.00 or 0 or Blank
SHIP_CHARGE_AMT_VAT_INCL

The amount of shipping charged/refunded to the buyer for all units (quantity) in the activity type, including VAT, but excluding the price of items, gift wrap and promotion amounts.

Sales are reflected as positive amounts and returns/refunds are reflected as negative amounts.

MFN/AFN ‘Sale’: The total VAT inclusive amount of the shipping in the activity.

‘Liquidation_Sale’, ‘Liquidation_Refund’, ‘Donation’ – This will be blank.

MFN/AFN ‘Refund’: The total VAT inclusive amount of the shipping in the activity.

AFN ‘Commingling_Buy’ & ‘Commingling_Sell’: This will be blank. There are no shipping charges for Commingling transactions.

NOTE: Product movement will be reflected in the Return section.

AFN ‘FC_Transfer’ & ‘Inbounds’: This value will be 0. The buyer is not charged for movement between Fulfilment Centres.

AFN ‘Return’: This will be blank. The service made available by Amazon does not currently capture this information from sellers.

Note: The service made available by Amazon does not currently calculate VAT details on seller to buyer orders, for non VAT Calculation Service enrolled sellers.
12.00 or 0 or Blank
PROMO_SHIP_CHARGE_AMT_VAT_INCL

The promotion amount for shipping charges for all units (quantity) in the activity type, including VAT and excluding the price of items and gift wrap.

Sales are reflected as positive amounts and returns/refunds are reflected as negative amounts.

MFN/AFN ‘Sale’: The total VAT inclusive amount of the promotion amount on shipping charges in the activity.

‘Liquidation_Sale’, ‘Liquidation_Refund’, ‘Donation’ – This will be blank

MFN/AFN ‘Refund’: The total VAT inclusive amount of the promotion amount on shipping charges in the activity.

AFN ‘Commingling_Buy’ & ‘Commingling_Sell’: This will be blank. There are no shipping charges for Commingling transactions.

NOTE: Product movement will be reflected in the Return section.

AFN ‘Return’: This will be blank. The service made available by Amazon does not currently capture this information from sellers.

AFN ‘FC_Transfer’ & ‘Inbounds’: There are no promotional amounts applied to Inbound and Transfer activity. There are no financial movements between the seller and Amazon.

Note: The service made available by Amazon does not currently calculate VAT details on seller-to-buyer orders for non VAT Calculation Service enrolled sellers.

12.00 or 0 or Blank
TOTAL_SHIP_CHARGE_AMT_VAT_INCL

The total shipping charges for all units (quantity) in the activity type, including VAT and excluding price of items, gift wrap and promotion amounts.

Sales are reflected as positive amounts and returns/refunds are reflected as negative amounts.

MFN/AFN ‘Sale’: ‘SHIP_CHG_VAT_INCL’ + ‘PROMO_SHIP_CHG_VAT_INCL’

‘Liquidation_Sale’, ‘Liquidation_Refund’, ‘Donation’ – This will be blank.

MFN/AFN ‘Refund’: ‘SHIP_CHG_VAT_INCL’ + ‘PROMO_SHIP_CHG_VAT_INCL’

AFN ‘Commingling_Buy’ & ‘Commingling_Sell’: This will be blank. There are no shipping charges for Commingling transactions.

NOTE: Product movement will be reflected in the Return section.

AFN ‘FC_Transfer’ & ‘Inbounds’: This value will be 0. The buyer is not charged for movement between Fulfilment Centres.

AFN ‘Return’: This will be blank. The service made available by Amazon does not currently capture this information from sellers.

Note: The service made available by Amazon does not currently calculate VAT details on seller-to-buyer orders for non VAT Calculation Service enrolled sellers.

12.00 or 0 or Blank
GIFT_WRAP_AMT_VAT_INCL

The amount of gift wrap charged/refunded to the buyer for all units (quantity) in the activity type, including VAT, but excluding the price of items, shipping and promotion amounts.

Sales are reflected as positive amounts and returns/refunds are reflected as negative amounts.

MFN/AFN ‘Sale’: The total VAT inclusive amount of the gift wrap charges in the activity.

‘Liquidation_Sale’, ‘Liquidation_Refund’, ‘Donation’ – This will be blank.

MFN/AFN ‘Refund’: The total VAT inclusive amount of the gift wrap charges in the activity.

AFN ‘Commingling_Buy’ & ‘Commingling_Sell’: This will be blank. There are no gift wrapping charges for Commingling transactions.

NOTE: Product movement will be reflected in the Return section.

AFN ‘FC_Transfer’ & ‘Inbounds’: This value will be 0. The buyer is not charged for movement between Fulfilment Centres.

AFN ‘Return’: This will be blank. The service made available by Amazon does not currently capture this information from sellers.

Note: The service made available by Amazon does not currently calculate VAT details on seller-to-buyer orders for non VAT Calculation Service enrolled sellers.

12.00 or 0 or Blank
PROMO_GIFT_WRAP_AMT_VAT_INCL

The promotion amount for gift wrap charges for all units (quantity) in the activity type, including VAT and excluding the price of items, shipping and gift wrap.

Sales are reflected as positive amounts and returns/refunds are reflected as negative amounts.

MFN/AFN ‘Sale’: The total VAT inclusive amount of the promotion amount on shipping charges in the activity.

‘Liquidation_Sale’, ‘Liquidation_Refund’, ‘Donation’ – This will be blank.

MFN/AFN ‘Refund’: The total VAT inclusive amount of the promotion amount on shipping charges in the activity.

AFN ‘Commingling_Buy’ & ‘Commingling_Sell’: This will be blank. There are no gift wrapping charges for Commingling transactions.

NOTE: Product movement will be reflected in the Return section.

AFN ‘Return’: This will be blank. The service made available by Amazon does not currently capture this information from sellers.

AFN ‘FC_Transfer’ & ‘Inbounds’: There are no promotional amounts applied to Inbound and Transfer activity. There are no financial movements between the seller and Amazon.

Note: The service made available by Amazon does not currently calculate VAT details on seller-to-buyer orders for non VAT Calculation Service enrolled sellers.

12.00 or 0 or Blank
TOTAL_GIFT_WRAP_AMT_VAT_INCL

The total gift wrap charges for all units (quantity) in the activity type, including VAT and excluding the price of items, shipping and promotion amounts.

Sales are reflected as positive amounts and returns/refunds are reflected as negative amounts.

MFN/AFN ‘Sale’: ‘GIFT_WRAP_CHG_VAT_INCL’ + ‘PROMO_GIFT_WRAP_VAT_INCL’

‘Liquidation_Sale’, ‘Liquidation_Refund’, ‘Donation’ – This will be blank.

MFN/AFN ‘Refund’: ‘GIFT_WRAP_CHG_VAT_INCL’ + ‘PROMO_GIFT_WRAP_VAT_INCL’

AFN ‘Commingling_Buy’ & ‘Commingling_Sell’: This will be blank. There are no gift wrapping charges for Commingling transactions.

NOTE: Product movement will be reflected in the Return section.

AFN ‘FC_Transfer’ & ‘Inbounds’: This value will be 0. The buyer is not charged for movement between Fulfilment Centres.

AFN ‘Return’: This will be blank. The service made available by Amazon does not currently capture this information from sellers.

Note: The service made available by Amazon does not currently calculate VAT details on seller-to-buyer orders for non VAT Calculation Service enrolled sellers.

12.00 or 0 or Blank
TOTAL_ACTIVITY_VALUE_AMT_VAT_INCL

The total VAT-inclusive amount for the activity inclusive of price of items, gift wrap, shipping and promotion amounts.

"TOTAL_PRICE_OF_ITEMS_AMT_VAT_INCL" + "TOTAL_SHIP_CHARGE_AMT_VAT_INCL" + "TOTAL_GIFT_WRAP_AMT_VAT_INCL"

MFN/AFN ‘Sale’, ‘Liquidation_Sale’: The amount charged or refunded to the buyer for this activity.

MFN/AFN ‘Refund’, ‘Liquidation_Refund’: The amount charged or refunded to the buyer for this activity.

AFN ‘Commingling_Buy’ & ‘Commingling_Sell’: The amount charged to the buyer for this activity.

NOTE: Product movement will be reflected in the Return section.

AFN ‘FC_Transfer’ & ‘Inbounds’ & ‘Return’ & ‘Donation’: This will be blank. The service made available by Amazon does not currently capture this information from sellers.

Note: The service made available by Amazon does not currently calculate VAT details on seller-to-buyer orders for non VAT Calculation Service enrolled sellers.

12.00 or 0 or Blank
TRANSACTION_CURRENCY_CODE

Currency code that relates to the activity.

MFN/AFN: ‘Sale’, ‘Liquidation_Sale’, ‘Refund’, ‘Liquidation_Refund’, & ‘Donation’ – The currency of the marketplace in which the item was sold.

AFN: ‘Commingling_Buy’ & ‘Commingling_Sell’ – The currency of the marketplace in which the item was sold.

EUR

AFN: ‘FC_Transfer’ & ‘Inbounds’ & ‘Return’ – These will be blank. The service made available by Amazon does not currently capture this information from sellers.

Blank
COMMODITY_CODE

An eight-digit numeric code provided by the European Government that identifies a group of goods.

This will be blank. The service made available by Amazon does not currently capture this information from sellers.

71131100 or Blank
STATISTICAL_CODE_DEPART

Additional national statistic code required for certain products departing from specific countries.

For example, in CZ, additional statistical codes relate to fuel-related commodities and in FR, additional statistical codes relate to meats, wines and aircraft-related commodities.

This will be blank. The service made available by Amazon does not currently capture this information from sellers.

22071000 or Blank
STATISTICAL_CODE_ARRIVAL

Additional national statistic code required for certain products delivered to specific countries.

For example, in CZ, additional statistical codes relate to fuel-related commodities and in FR, additional statistical codes relate to meats, wines and aircraft-related commodities.

This will be blank. The service made available by Amazon does not currently capture this information from sellers.

22071000 or Blank
COMMODITY_CODE_SUPPLEMENTARY_UNIT

Supplementary unit for certain Commodity Codes.

For example, carats for diamonds.

This will be blank. The service made available by Amazon does not currently capture this information from sellers.

Carats

Blank

ITEM_QTY_SUPPLEMENTARY_UNIT

COMMODITY_CODE_SUPPLEMENTARY_UNIT quantity in the transaction.

For example, 10 if it is a 10-carat diamond.

This will be blank. The service made available by Amazon does not currently capture this information from sellers.

10 or Blank
TOTAL_ACTIVITY_SUPPLEMENTARY_UNIT

Total supplementary weight of the transaction.

For example, if there are 3 diamonds in this order and each diamond weighs 10 carats, this will be 30.

"ITEM_QTY_SUPPLEMENTARY_UNIT" x "QTY"

This will be blank. The service made available by Amazon does not currently capture this information from sellers.

30 or Blank
PRODUCT_TAX_CODE For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month A_GEN_STANDARD or Blank

This is the Product Tax Code (PTC) assigned by the seller for this product.

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

This is the Product Tax Code (PTC) assigned by the seller for this product.

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller-to-buyer orders, and this must be filled in by the seller if applicable.

MFN/AFN:

‘Sale’, ‘Liquidation_Sale’ – The PTC assigned by the seller.

AFN:

‘Commingling_Sell’ – The PTC assigned by the Seller. If you participate in the Commingling programme but have not activated VAT Calculation Service, the PTC will be assigned by Amazon.

‘Commingling_Buy’ – The PTC assigned by Amazon.

AFN:

‘Return’ – The PTC assigned by the seller.

MFN/AFN:

‘Refund’ – The PTC assigned by the seller.

AFN:

‘FC_Transfer’ & ‘Inbound’ – This field will be blank

‘Donation’ – This field will be blank

DEPARTURE_CITY

City associated with the departure location for the transaction.

AFN: ‘Sale’, ‘Liquidation_Sale’, ‘Donation’ – Amazon Fulfilment Centre region where the items departed from.

AFN: ‘Commingling_Buy’ & ‘Commingling_Sell’ – Amazon Fulfilment Centre region where the transfer took place.

AFN: ‘FC_Transfer’ – Amazon Fulfilment Centre region where the items departed from.

Leipzig

MFN: ‘Sale’ – This information is not currently captured by Amazon and will be blank.

AFN: ‘Inbound’ – This information is not currently captured by Amazon and will be blank.

AFN: ‘Return’ – this value will be blank. Amazon does not know the true ship-from location due to seller ability to send returns from any location. SALE_ARRIVAL_COUNTRY is the last-known location where the item in this transaction was delivered. The return may come from this country, but Amazon cannot confirm that information.

Blank

MFN/AFN: ‘Refund’, ‘Liquidation_Refund’ – There is no product movement related to a Refund and these values will be blank.

SALE_ARRIVAL_COUNTRY is the last-known location where the item in this transaction was delivered.

Blank
DEPARTURE_COUNTRY

Two-character country code associated with the departure location for the transaction.

AFN: ‘Sale’, ‘Liquidation_Sale’, ‘Donation’ – Amazon Fulfilment Centre country where the items departed from.

AFN: ‘Commingling_Buy’ & ‘Commingling_Sell’ – Amazon Fulfilment Centre country where the transfer took place.

AFN: ‘FC_Transfer’ – Amazon Fulfilment Centre country where the items departed from.

DE

MFN: ‘Sale’ – This information is not currently captured by Amazon and will be blank.

AFN: ‘Inbound’ – This information is not currently captured by Amazon and will be blank.

AFN: ‘Return’ – Departure country of the return shipment. If not available, SALE_ARRIVAL_COUNTRY for the corresponding sale is populated.

Blank

MFN/AFN: ‘Refund’, ‘Liquidation_Refund’ – There is no product movement related to a Refund and these values will be blank.

SALE_ARRIVAL_COUNTRY is the last-known location where the item in this transaction was delivered.

Blank
DEPARTURE_POST_CODE

Postcode associated with the departure location for the transaction.

AFN: ‘Sale’, ‘Liquidation_Sale’, ‘Donation’ – Amazon Fulfilment Centre postcode where the items departed from.

AFN: ‘Commingling_Buy’ & ‘Commingling_Sell’ – Amazon Fulfilment Centre postcode where the transfer took place.

AFN: ‘FC_Transfer’ – Amazon Fulfilment Centre postcode where the items departed from.

70806

MFN: ‘Sale’ – This information is not currently captured by Amazon and will be blank.

AFN: ‘Inbound’ – Postcode in the ‘ship from’ address provided in ‘Manage FBA Shipments’ page for the shipment.

AFN: ‘Return’ – Postcode where the item was delivered in corresponding ‘sale’.

LE11 1JP

MFN: ‘Refund’ – Postcode where the item departed from in corresponding ‘sale’.

AFN: ‘Refund’, ‘Liquidation_Refund’ – There is no product movement in AFN refund and this value will be blank.

Blank
ARRIVAL_CITY

City associated with the arrival location for the transaction.

MFN/AFN: ‘Sale’, ‘Liquidation_Sale’, ‘Donation’ – Region where the shipment was delivered.

AFN: ‘Commingling_Buy’ & ‘Commingling_Sell’ – Amazon Fulfilment Centre region where the transfer took place.

AFN: ‘Return’: Amazon Fulfilment Centre region where the return items arrived.

AFN: ‘FC_Transfer’ & Inbound – Amazon Fulfilment Centre region where the inbound items arrived.

Leipzig

MFN/AFN: ‘Refund’, ‘Liquidation_Refund’ – There is no product movement related to a Refund and these values will be blank.

Blank
ARRIVAL_COUNTRY

Two-character country code associated with the arrival location for the transaction.

MFN/AFN: ‘Sale’, ‘Liquidation_Sale’, ‘Donation’ – Country where the shipment was delivered.

AFN: ‘Commingling_Buy’ & ‘Commingling_Sell’ – Amazon Fulfilment Centre country where the transfer took place.

AFN: ‘Return’: Amazon Fulfilment Centre country where the return items arrived.

AFN: ‘FC_Transfer’ & Inbound – Amazon Fulfilment Centre country where the inbound items arrived.

DE
MFN/AFN: ‘Refund’, ‘Liquidation_Refund’ – There is no product movement related to a Refund and these values will be blank. Blank
ARRIVAL_POST_CODE

Postcode associated with the arrival location for the transaction.

MFN/AFN: ‘Sale’, ‘Liquidation_Sale’, ‘Donation’ – Postcode where the shipment was delivered.

AFN: ‘Commingling_Buy’ & ‘Commingling_Sell’ – Amazon Fulfilment Centre postcode where the transfer took place.

AFN: ‘Return’: Amazon Fulfilment Centre postcode where the return items arrived.

AFN: ‘FC_Transfer’ & Inbound – Amazon Fulfilment Centre postcode where the inbound items arrived.

70806

MFN: ‘Refund’, ‘Liquidation_Refund’ – Postcode where the item arrived at in corresponding ‘sale’

AFN: There is no product movement in AFN refund and this value will be blank.

Blank
SALE_DEPART_COUNTRY

Two-character departure country code associated with the original sale.

AFN: ‘Sale’, ‘Return’, ‘Refund’, ‘Liquidation_Sale’, ‘Liquidation_Refund’ – Amazon Fulfilment Centre country where the items departed from.

AFN: ‘Commingling_Buy’ & ‘Commingling_Sell’ – Amazon Fulfilment Centre country where the transfer took place.

DE

MFN: ‘Sale’ ‘Refund’ – Departure country of the shipment for the original sale.

Blank
AFN: ‘FC_Transfer’, ‘Inbound’ & ‘Donation’ – There is no sale on Amazon for these transaction types and this value will be blank. Blank
SALE_ARRIVAL_COUNTRY

Two-character arrival country code associated with the original sale.

AFN/MFN: ‘Sale’, ‘Return’, ‘Refund’, ‘Liquidation_Sale’, ‘Liquidation_Refund’ – Buyer’s delivery country associated with the original sale.

AFN: ‘Commingling_Buy’ & ‘Commingling_Sell’ – Amazon Fulfilment Centre country where the transfer took place.

DE

AFN: ‘FC_Transfer’, ‘Inbound’, & ‘Donation’ – There is no sale on Amazon for these transaction types and this value will be blank.

Blank
TRANSPORTATION_MODE

The way goods are moved between destinations.

AFN: ‘FC_Transfer’, ‘Donation’ – Transport by Road

Transport by road

AFN: ‘Sale’, ‘Liquidation_Sale’ – Consignment by post – package is transferred to an outside carrier for delivery.

AFN: ‘Return’ – Consignment by post – package is transferred to an outside carrier for delivery

AFN: ‘Commingling_Buy’ & ‘Commingling_Sell’ – Consignment by post – package is transferred to an outside carrier for delivery

Consignment by post

AFN: ‘Inbound’ – Amazon does not have the information as the transaction originated from the seller and these values will be blank.

MFN: ‘Sale’ – Amazon does not have the information as the transaction originated from the seller and these values will be blank.

MFN/AFN: ‘Refund’, ‘Liquidation_Refund’ – There is no product movement related to a Refund and these values will be blank.

Blank
DELIVERY_CONDITIONS

The delivery conditions (Incoterms) used to communicate the condition in which the product was delivered.

Incoterms are a series of pre-defined commercial terms published by the International Chamber of Commerce (ICC). The Incoterms are intended to clearly communicate the tasks, costs and risks associated with the transportation and delivery of goods.

MFN: ‘Sale’ – Amazon does not have the information as the transaction originated from the seller and these values will be blank.

MFN/AFN: ‘Refund’, ‘Liquidation_Refund’ – There is no product movement related to a Refund and these values will be blank.

Blank

AFN: ‘Return’ – XXX

AFN: ‘FC_Transfer’ – XXX

XXX
AFN: ‘Inbound’ – DDP DDP
AFN: ‘Sale’, ‘Liquidation_Sale’, ‘Donation’ – DAP DAP
AFN: ‘Commingling_Buy’ & ‘Commingling_Sell’ – DAP

SELLER_DEPART_VAT_NUMBER_COUNTRY For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month DE or Blank

The country associated with the seller’s VAT number in relation to the departure country. This is represented as a two-character country code.

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

The country associated with the seller’s VAT number in relation to the departure country. This is represented as a two-character country code.

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller-to-buyer orders, and this must be filled in by the seller if applicable.

MFN/AFN:

‘Sale’, ‘Liquidation_Sale’ – Country of seller’s departure location.

‘Donation’ – This will be blank.

AFN:

‘Commingling_Buy’ & ‘Commingling_Sell’ – Country of seller’s departure location.

AFN:

‘Return’ – Country of seller’s departure location.

MFN/AFN:

‘Refund’, ‘Liquidation_Refund’ – Original ship from country.

NOTE: There is no product movement related to a Refund.

AFN:

‘FC_Transfer’ & ‘Inbound’ – Country of seller’s departure location.

SELLER_DEPART_COUNTRY_VAT_NUMBER For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month DE123456789 or Blank

The seller’s VAT number in relation to the departure country.

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

The seller’s VAT number in relation to the departure country.

This will be blank.

MFN/AFN:

‘Sale’, ‘Liquidation_Sale’ – Seller’s VAT number of the departure location.

‘Donation’ – This will be blank.

AFN:

‘Commingling_Buy’ & ‘Commingling_Sell’ – Seller’s VAT number of the departure location.

AFN:

‘Return’ – Seller’s VAT number of the departure location.

MFN/AFN:

‘Refund’, ‘Liquidation_Refund’ – Original ship from country VAT.

NOTE: There is no product movement related to a Refund.

AFN:

‘FC_Transfer’ & ‘Inbound’ – Seller’s VAT number of the departure location.

SELLER_ARRIVAL_VAT_NUMBER_COUNTRY For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month DE or Blank

The country associated with the seller’s VAT number in relation to the arrival country. This is represented as a two-character country code.

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

The country associated with the seller’s VAT number in relation to the arrival country. This is represented as a two-character country code.

MFN/AFN:

‘Sale’, ‘Liquidation_Sale’ – Seller’s arrival location.

‘Donation’ – This will be blank.

AFN:

‘Commingling_Buy’ & ‘Commingling_Sell’ – Seller’s arrival location.

AFN:

‘Return’ – Seller’s arrival location.

MFN/AFN:

‘Refund’, ‘Liquidation_Refund’ – Original ship to country VAT.

AFN:

‘FC_Transfer’ & ‘Inbound’ – Seller’s arrival location.

SELLER_ARRIVAL_COUNTRY_VAT_NUMBER For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month DE123456789 or Blank

The seller's VAT number in relation to the arrival country.

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

The seller’s VAT number, in relation to the arrival country.

This will be blank.

MFN/AFN:

‘Sale’, ‘Liquidation_Sale’ – Seller’s VAT number of the arrival location.

‘Donation’ – This will be blank.

AFN:

‘Commingling_Buy’ & ‘Commingling_Sell’ – Seller’s VAT number of the arrival location.

AFN:

‘Return’ – Seller’s VAT number of the arrival location.

MFN/AFN:

‘Refund’, ‘Liquidation_Refund’ – Original ship to country VAT.

AFN:

‘FC_Transfer’ & ‘Inbound’ – Seller’s VAT number of the arrival location.

TRANSACTION_SELLER_VAT_NUMBER_COUNTRY For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month DE or Blank

The country associated with the seller’s VAT number used for this transaction. This is represented as a two-character country code.

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

The country associated with the seller’s VAT number used for this transaction.

MFN/AFN:

‘Sale’, ‘Liquidation_Sale’ – Seller’s VAT number country.

‘Donation’ – This will be blank.

AFN:

‘Commingling_Buy’ & ‘Commingling_Sell’ – Seller’s VAT number country.

AFN:

‘Return’ – Seller’s VAT number country.

MFN/AFN:

‘Refund’, ‘Liquidation_Refund’ – Seller’s VAT number country.

AFN:

‘FC_Transfer’ & ‘Inbound’ – This value will be ‘N/A’.

NOTE: There in no VAT on internal movement.

TRANSACTION_SELLER_VAT_NUMBER For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month DE123456789 or Blank

Seller’s VAT number provided for this transaction and is also reflected on the VAT Invoice.

The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

Seller’s VAT number provided for this transaction, and is also reflected on the VAT Invoice.

MFN/AFN:

‘Sale’, ‘Liquidation_Sale’ – Seller’s VAT number.

‘Donation’ – This will be blank.

AFN:

‘Commingling_Buy’ & ‘Commingling_Sell’ – Seller’s VAT number.

AFN:

‘Return’ – Seller’s VAT number.

MFN/AFN:

‘Refund’, ‘Liquidation_Refund’ – Seller’s VAT number.

AFN:

‘FC_Transfer’ & ‘Inbound’ – This value will be Blank.

BUYER_VAT_NUMBER_COUNTRY For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month DE or Blank

The country associated with the buyer’s VAT number provided for this transaction. This is represented as a two-character country code.

This will be blank. The service made available by Amazon does not currently capture buyer VAT details on seller-to-buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if they have captured it outside Amazon Seller Central.

The country associated with the buyer’s VAT number provided for this transaction.

MFN/AFN:

‘Sale’ – Buyer’s VAT number country.

‘Liquidation_Sale’, ‘Liquidation_Refund’, ‘Donation’ – This will be blank.

AFN:

‘Return’ – Buyer’s VAT number country.

‘Commingling_Sell’ – Buyer’s VAT number country.

MFN/AFN:

‘Refund’ – Buyer’s VAT number country.

AFN:

‘FC_Transfer’ & ‘Inbound’ – This value will be ‘N/A’.

‘Commingling_Buy’ – This value will be blank

BUYER_VAT_NUMBER For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month DE123456789 or Blank

Buyer’s VAT number provided for this transaction.

This will be blank. The service made available by Amazon does not currently capture buyer VAT details on seller-to-buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if they have captured it outside Amazon Seller Central.

Buyer’s VAT number provided for this transaction.

MFN/AFN:

‘Sale’ – Buyer’s VAT number.

‘Liquidation_Sale’, ‘Liquidation_Refund’, ‘Donation’ – This will be blank.

AFN:

‘Return’ – Buyer’s VAT number.

‘Commingling_Sell’ – Buyer’s VAT number.

MFN/AFN:

‘Refund’ – Buyer’s VAT number.

AFN:

‘FC_Transfer’ & ‘Inbound’ – This value will be ‘N/A’.

‘Commingling_Buy’ – This value will be blank

VAT_CALCULATION_IMPUTATION_COUNTRY For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month DE

The country which was used to back VAT out of the VAT-inclusive price. This is represented as a two-character country code.

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

The country which was used to back VAT out of the VAT-inclusive price. This is represented as a two-character country code.

‘Sale’ – Seller’s VAT Imputation Country.

‘Liquidation_Sale’, ‘Liquidation_Refund’, ‘Donation’ – This will be blank.

AFN:

‘Return’ – Seller’s VAT Imputation Country.

‘Commingling_Buy’ & ‘Commingling_Sell’ – Seller’s VAT Imputation Country.

MFN/AFN:

‘Refund’ – Seller’s VAT Imputation Country.

AFN:

‘FC_Transfer’ & ‘Inbound’ – This value will be ‘N/A’.

TAXABLE_JURISDICTION For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month France or United Kingdom

Indicates the jurisdictional value where a tax calculation was performed. For example, Country, Territory, etc.

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

Indicates the jurisdictional value where a tax calculation was performed. For example, Country, Territory, etc.

MFN/AFN: ‘Sale’, ‘Liquidation_Sale’ – Taxable Jurisdiction country name.

‘Donation’ – This will be blank.

AFN: ‘Return’ – Taxable Jurisdiction country name.

‘Commingling_Buy’ & ‘Commingling_Sell’ – Taxable Jurisdiction country name.

MFN/AFN: ‘Refund’, ‘Liquidation_Refund’ – Taxable Jurisdiction country name.

AFN: ‘FC_Transfer’ & ‘Inbound’ – This value will be blank or ‘N/A’.

TAXABLE_JURISDICTION_LEVEL For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month Country or Territory or Blank

Indicates at which jurisdictional level a tax calculation was performed. For example, Country, Territory, etc.

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

Indicates at which jurisdictional level a tax calculation was performed. For example, Country, Territory, etc.

VAT_INV_NUMBER For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month 1125150-0189150-00005 or Blank

Indicates the sequential number assigned to the tax document, if applicable. E.g. the sequential VAT invoice number or credit note number.

This will be blank. Amazon does not currently calculate VAT details on seller to buyer orders as seller has not activated VAT Calculation Services and this must be filled in by the seller if applicable.

Indicates the sequential number assigned to the tax document, if applicable. E.g. the sequential VAT invoice number or credit note number.

MFN/AFN:

‘Sale’, ‘Liquidation_Sale’ – VAT Invoice number.

‘Donation’ – This will be blank.

AFN:

‘Return’ – VAT Invoice number.

‘Commingling_Buy’ & ‘Commingling_Sell’ – VAT Invoice number.

MFN/AFN:

‘Refund’, ‘Liquidation_Refund’ – VAT Invoice number.

AFN:

‘FC_Transfer’ & ‘Inbound’ – This value will be Blank.

VAT_INV_CONVERTED_AMT For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month 29.99 or Blank

Indicates the total invoice-level VAT amount converted into the local taxed jurisdiction’s currency, where that currency differs to that of the marketplace.

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

MFN/AFN:

‘Sale’ – Converted VAT amount.

‘Liquidation_Sale’, ‘Liquidation_Refund’, ‘Donation’ – This will be blank.

AFN:

‘Commingling_Buy’ & ‘Commingling_Sell’ – Converted VAT amount.

AFN:

‘Return’ – This will be blank.

MFN/AFN:

‘Refund’ – Converted VAT amount as a negative value.

AFN:

‘FC_Transfer’ & ‘Inbound’ – This value will be Blank.

VAT_INV_CURRENCY_CODE For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month GBP or Blank

Indicates the currency code of the local taxed jurisdiction’s currency, where that currency differs to that of the marketplace.

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

Indicates the currency code of the local taxed jurisdiction’s currency, where that currency differs to that of the marketplace.

MFN/AFN:

‘Sale’ – Converted VAT Currency Code.

‘Liquidation_Sale’, ‘Liquidation_Refund’, ‘Donation’ – This will be blank.

AFN:

‘Commingling_Buy’ & ‘Commingling_Sell’ – Converted VAT Currency Code.

AFN:

‘Return’ – This will be blank.

MFN/AFN:

‘Refund’ – Converted VAT Currency Code.

AFN:

‘FC_Transfer’ & ‘Inbound’ – This value will be Blank.

VAT_INV_EXCHANGE_RATE For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month 1.6 or Blank

Indicates the exchange rate used to convert the total VAT amount in the marketplace currency to that of the local taxed jurisdiction’s currency. The exchange rates are provided by the European Central Bank

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

MFN/AFN:

‘Sale’ – VAT Exchange Rate.

AFN:

‘Commingling_Buy’ & ‘Commingling_Sell’ – VAT Exchange Rate.

‘Liquidation_Sale’, ‘Liquidation_Refund’, ‘Donation’ – This will be blank.

AFN:

‘Return’ – VAT Exchange Rate. This will be blank

MFN/AFN:

‘Refund’ – VAT Exchange Rate.

AFN:

‘FC_Transfer’ & ‘Inbound’ – This value will be Blank.

VAT_INV_EXCHANGE_RATE_DATE

DD-MM-YYYY

For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month 15-10-2016 or Blank

Indicates the date of the exchange rate used to convert the total VAT amount in the marketplace currency to that of the local tax jurisdiction's currency.

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller-to-buyer orders and this must be filled in by the seller if applicable.

MFN/AFN:

‘Sale’ – Date of Exchange Rate conversion.

‘Liquidation_Sale’, ‘Liquidation_Refund’, ‘Donation’ – This will be blank.

AFN:

‘Commingling_Buy’ & ‘Commingling_Sell’ – Date of Exchange Rate conversion.

AFN:

‘Return’ – Date of Exchange Rate conversion. This will be blank

MFN/AFN:

‘Refund’ – Date of Exchange Rate conversion.

AFN:

‘FC_Transfer’ & ‘Inbound’ – This value will be Blank.

EXPORT_OUTSIDE_EU For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month Y or N or Blank

Indicates whether or not an item was shipped from a EU28 member country to a country outside the EU28 member countries.

This will be blank. The service made available by Amazon does not currently calculate VAT details on seller to buyer orders as the seller has not activated VAT Calculation Services, and this must be filled in by the seller if applicable.

MFN/AFN:

‘Sale’, ‘Liquidation_Sale’ – This field will contain a Yes/No value, depending if an item was shipped from a EU28 member country to a non-EU28 member country.

‘Donation’ – This will be blank.

AFN:

‘Return’ – This field will contain a Yes/No value, depending on whether an item was shipped from a EU28 member country to a non-EU28 member country.

‘Commingling_Buy’ & ‘Commingling_Sell’ – This field will always be filled with a ‘No’ value, since Commingling transactions take place inside the EU.

MFN/AFN:

‘Refund’, ‘Liquidation_Refund’ – This field will contain a Yes/No value, depending if an item was shipped from a EU28 member country to a non-EU28 member country.

AFN:

‘FC_Transfer’ & ‘Inbound’ – This value will be Blank.

INVOICE_URL For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month Blank
This field will be blank. The service made available by Amazon does not currently capture this as seller has not activated VAT Calculation Services. URL link for the seller to download or view the invoice/credit note document.

buyer name

For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month.

This field will be blank. The service made available by Amazon does not currently capture this as seller has not activated VAT Calculation Services

.

Name of the VAT registered customer, as stated on the invoice.

John Smith
ARRIVAL_ADDRESS For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month.

This field will be blank. The service made available by Amazon does not currently capture this as seller has not activated VAT Calculation Services.

Address associated with the arrival location for the transaction.

MFN/AFN Sale – Shipment address as stated on the invoice.

AFN/MFN Refund – Shipment address of the original sale, as stated on the original invoice.

11 Main St, Apt 12, c/o John Smith

SUPPLIER_NAME For sellers who do not have VAT Calculation Services activated in the previous month. For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month. DE123456789
This field will be blank. The service made available by Amazon does not currently capture this as seller has not activated VAT Calculation Services.

Supplier’s VAT Number provided for this transaction.

AFN:

‘Commingling_Buy’ – Supplier’s VAT number.

This field will be blank for all other transactions.

TAX_REPORTING_SCHEME For sellers who do not have VAT Calculation Services activated in the previous month.

This column identifies the tax legislation pertaining to the transaction.

Sale, Refund:


  1. UK_VOEC-DOMESTIC: This stands for transactions having UK as the origin as well as destination country, that fall under the UK VAT On eCommerce legislation. It is relevant for transactions where Amazon collected and remitted tax to the authorities on behalf of any non-UK Selling Partner. For more details, refer to UK VAT on eCommerce Legislation.
  2. UK_VOEC-IMPORT: This stands for transactions having a country other than UK as the origin country, and UK as the destination country, that fall under the UK VAT On eCommerce legislation. It is relevant for transactions where Amazon collected and remitted tax to the authorities on behalf of any Selling Partner for whom goods from outside UK were sold to a UK private individual. For more details, refer to UK VAT on eCommerce Legislation.
  3. NO_VOEC: This stands for Norway VAT On eCommerce legislation. It is relevant for transactions where Amazon collected and remitted tax to the authorities on behalf of a non-Norway based seller, selling goods from outside Norway, to a Norway-based private individual.
  4. REGULAR: Any transaction to which the above legislations/rules do not apply.

    Non-Sale/Non-Refund transactions: This field will be blank

UK_VOEC-DOMESTIC
This field will be blank. The service made available by Amazon does not currently capture this as seller has not activated VAT Calculation Services.
TAX_COLLECTION_RESPONSIBILITY For sellers who do not have VAT Calculation Services activated in the previous month.

This field will be blank. The service made available by Amazon does not currently capture this as seller has not activated VAT Calculation Services.

For Commingling and AGL transactions, and for sellers who have VAT Calculation Services activated in the previous month.

This column identifies the party responsible for collection and remittance of tax (VAT) to the authorities.

SELLER
Note: Information on this page does not constitute tax, legal or other professional advice and must not be used as such. Consult your tax advisor to help you understand your VAT obligations in Europe. You are responsible for the accuracy of your data used for any reporting or tax purposes.
Sign in to use the tool and get personalised help (desktop browser required). Sign in


Reach Hundreds of Millions of Customers

Start Selling on Amazon


© 1999-2021, Amazon.com, Inc. or its affiliates