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 off of 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 Fulfillment Network: These are shipments fulfilled directly by the seller for sales placed on Amazon’s websites.

MFN
"AFN" - Amazon Fulfillment Network: These are shipments fulfilled by Amazon on the seller’s behalf for sales placed on Amazon’s websites. AFN
"MCF" - Multi-Channel Fulfillment: These are shipments fulfilled by Amazon on the seller’s behalf for sales not placed on any of Amazon’s websites. MCF
MARKETPLACE

Marketplace where the activity originated.

MFN/AFN: “Sale” & “Refund” – 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
MCF: “Sale” & Return” – Off-Amazon: Reflects that the transaction was generated from a website other than Amazon. Off-Amazon
AFN: “FC_Transfer” & “Inbound”: There is no marketplace for internal movement and these values will be “N/A”. “N/A”
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 fulfillment center.

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 since 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 Fulfillment Centers. FC_TRANSFER
“Inbound”: Seller sends inventory to an Amazon Fulfillment Center. 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
TRANSACTION_EVENT_ID

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

This ID can be used to search for transactional 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

MCF: “Sale”& “Return”- Order ID

305-7728503-7061234
AFN: “FC_ Transfer”- Transfer Item ID 183880795620
AFN: “Inbound”- Reference ID 123ABXZE
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 transactional level information in Seller Central.

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

AFN : “Commingling_Sell” & “Commingling_Buy” - Shipment ID

MFN/AFN/MCF: “Sale” – Shipment ID

15512820259001

AFN/MCF: “Return” – Reversal ID corresponding to associated refund. A unique return ID may be present instead

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

2) Associated refund happened 3 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

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 seller has not activated VAT Calculation Service, 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.

MCF: “Sale” & “Return”- 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 from the arrival month. Date used to determine the month in which the activity will be contained in the transaction report TRANSACTION_COMPLETE_DATE

MFN/AFN/MCF: “Sale”- Shipment Date (seller to buyer shipments). This is also the date the buyer's payment instrument is charged.

AFN: “Commingling_Sell” & “Commingling_Buy” – Shipment Date (seller-to-buyer shipments)

15-10-2015
AFN/MCF: “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 Fulfillment Center. 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 from 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/MCF: “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).

18-08-2015
AFN/MCF: “Return”- Date return arrived at Fulfillment Center. (buyer to seller returns) 18-08-2015
AFN: “FC_Transfer”- Date items arrive at the Fulfillment Center receiving dock and are pending check-in. 18-08-2015
AFN: “Inbounds”- Date items arrive at the Fulfillment Center 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/MCF: “Sale”- Shipment Date (seller to Buyer shipments). This is also the date the buyer's payment instrument is charged.

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

20-08-2015 or Blank
AFN/MCF: “Return”- Date return arrived at Fulfillment Center. (Buyer to seller returns) 20-08-2015 or Blank

MFN/AFN: “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 Fulfillment Center. 20-08-2015 or Blank
AFN: “Inbounds”- Received Date, the date the inventory is checked into the receiving Fulfillment Center. 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 product detail pages. Multiple seller SKUs can be assigned per one ASIN. B000WON1Z0
ITEM_ DESCRIPTION

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

“FC_Transfer” & “Inbound”: The product description based on seller’s home market place. This field will be blank if product description not available in seller’s home market place.

NOTE: This field might be blank if activity is MCF as Amazon may not be provided a description when the item is not sold on Amazon.

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/MCF: “Sale”- Units sold as a positive value.

AFN: “Commingling_Buy” & “Commingling_Sell” – Units sold as a positive value.

5
AFN/MCF: “Return”- Units returned as a positive value. 5
MFN/AFN: “Refund”- Units refunded as a positive value. 5
AFN: “FC_Transfer” & “Inbound” - Units received at a Fulfillment Center 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 seller’s home market place.

0.01
MFN/AFN: “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 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 stock cross border stock transfer in EU.

MFN/AFN/MCF:

“Sale”- Cost Price (amount paid to acquire the item) as provided by the seller as a positive value.

AFN: “Commingling_Sell” & “Commingling_Buy” – Blank.

AFN/MCF:

“Return”- Blank.

MFN/AFN:

“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 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/MCF:

“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/MCF:

“Return”- Sales Price Refunded as a negative value.This will be blank

MFN/AFN:

“Refund’- Sales Price Refunded as a negative value.

AFN:

“FC_Transfer” & “Inbound”- This value will be Blank, because currently VCS is currently not 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 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/MCF:

“Return”- This will be blank

AFN:

“FC_Transfer ” & “Inbound”-

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

MCF:

“Sale” &“Return”- This field will be blank.

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 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/MCF:

“Sale”- Total Price of Items amount excluding VAT as a positive value.

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/MCF:

“Return”- This value will be blank

MFN/AFN:

“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 currently not 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 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/MCF:

“Sale”- Shipping amount excluding VAT as a positive value.

AFN:

“Commingling_Sell” & “Commingling_Buy” – This will be blank

AFN/MCF:

“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 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/MCF:

“Sale”- Promotion amount excluding VAT as a negative value

AFN:

“Commingling_Sell” & “Commingling_Buy” – This will be blank

AFN/MCF:

“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 FC’s.

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 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/MCF:

“Sale”- Total shipping amount excluding VAT as a positive value.

AFN:

“Commingling_Sell” & “Commingling_Buy” – This will be blank

AFN/MCF:

“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 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/MCF:

“Sale”- Gift Wrap amount excluding VAT as a positive value.

AFN:

“Commingling_Sell” & “Commingling_Buy” – This will be blank

AFN/MCF:

“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 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/MCF:

“Sale”- Promotion amount excluding VAT as a negative value.

AFN:

“Commingling_Sell” & “Commingling_Buy” – This will be blank

AFN/MCF:

“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 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/MCF:

“Sale”- Total Gift Wrap amount excluding VAT as a positive value.

AFN:

“Commingling_Sell” & “Commingling_Buy” – This will be blank

AFN/MCF:

“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 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/MCF:

“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/MCF:

“Return”- Total Activity Value amount excluding VAT as a positive value.

MFN/AFN:

“Refund”- Total Activity Value amount excluding VAT as a positive value.

AFN:

“FC_Transfer” & “Inbound”-

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 percentage applied to the activity. The rate percentage is provided as 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 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 activity. The rate percentage is provided as decimal value (for example, 0.20=20%, 0.02=2%).

MFN/AFN/MCF:

“Sale”- VAT Rate percentage

AFN:

“Commingling_Sell” and “Commingling_Buy” – VAT Rate percentage

AFN/MCF:

“Return”- This will be blank

MFN/AFN:

“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 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/MCF:

“Sale”- VAT Amount as a positive value.

AFN:

“Commingling_Sell” & “Commingling_Buy” – VAT Amount as a positive value.

AFN/MCF:

“Return”- VAT Amount as a positive value.

MFN/AFN:

“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 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/MCF:

“Sale”- Promotion Price of Item VAT amount as a positive value.

AFN:

“Commingling_Sell” & “Commingling_Buy” – This will be blank

AFN/MCF:

“Return”- This will be blank

MFN/AFN:

“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 from 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 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 from the seller on the items in the activity.

"PRICE_OF_ITEMS_VAT_AMT" + "PROMO_PRICE_OF_ITEMS_VAT_AMT"

MFN/AFN/MCF:

“Sale”- Total Price of Item VAT amount as a positive value.

AFN:

“Commingling_Buy” & “Commingling_Sell” – Total Price of Item VAT amount as a positive value.

AFN/MCF:

“Return”- This will be blank

MFN/AFN:

“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 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 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/MCF:

“Sale”- Shipping VAT Rate %

AFN:

“Commingling_Buy” & “Commingling_Sell” – This will be blank

AFN/MCF:

“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 from 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 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 shipping amount based on the SHIP_CHARGE_VAT_RATE_PERCENT.

MFN/AFN/MCF:

“Sale”- Shipping charge VAT amount as a positive value.

AFN:

“Commingling_Buy” & “Commingling_Sell” – This will be blank

AFN/MCF:

“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 from 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 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 shipping amount, based on the SHIP_CHARGE_VAT_RATE_PERCENT.

MFN/AFN/MCF:

“Sale”- Promotion shipping charge VAT amount as a positive value.

AFN:

“Commingling_Buy” & “Commingling_Sell” – This will be blank

AFN/MCF:

“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 from 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 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 from the seller on the shipping amount for the activity.

"SHIP_CHARGE_VAT_AMT" + "PROMO_SHIP_CHARGE_VAT_AMT"

MFN/AFN/MCF:

“Sale”- Total Shipping charge VAT amount as a positive value.

AFN:

“Commingling_Buy” & “Commingling_Sell” – This will be blank

AFN/MCF:

“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 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 seller has not activated VAT Calculation Services and this must be filled in by the seller if applicable.

MFN/AFN/MCF:

“Sale”- Gift Wrap VAT Rate %

AFN:

“Commingling_Buy” & “Commingling_Sell” – This will be blank

AFN/MCF:

“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 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 seller has not activated VAT Calculation Services and this must be filled in by the seller if applicable.

MFN/AFN/MCF:

“Sale”- Gift Wrap VAT Rate %

AFN:

“Commingling_Buy” & “Commingling_Sell” – This will be blank

AFN/MCF:

“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 from 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 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 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/MCF:

“Sale”- Promotion Gift Wrap VAT amount as a positive value.

AFN:

“Commingling_Buy” & “Commingling_Sell” – This will be blank

AFN/MCF:

“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 from 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 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 from the seller on the gift wrap for the activity.

"GIFT_WRAP_VAT_AMT" + "PROMO_GIFT_WRAP_VAT_AMT"

MFN/AFN/MCF:

“Sale”- Total Gift Wrap VAT amount as a positive value.

AFN:

“Commingling_Buy” & “Commingling_Sell” – This will be blank

AFN/MCF:

“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 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/MCF:

“Sale”- Total Activity Value VAT amount as a positive value.

AFN:

“Commingling_Buy” & “Commingling_Sell” – Total Activity Value VAT amount as a positive value.

AFN/MCF:

“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”: The total VAT inclusive amount of the items in the activity.

AFN “Commingling_Buy” & “Commingling_Sell”: The total VAT-inclusive amount of the items in the activity.

MFN/AFN “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”, MCF “Sale”

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

AFN/MCF "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

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.

MCF “Sale”: 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.

AFN/MCF "Return", MCF "Sale": 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”: 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”: 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", MCF “Sale” & “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
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 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.

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 on movement between Fulfillment Centers.

AFN "Return", MCF “Sale” & “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 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.

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", MCF “Sale” & “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"

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 on movement between Fulfillment Centers.

AFN "Return", MCF “Sale” & “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 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.

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 on movement between Fulfillment Centers.

AFN "Return", MCF “Sale” & “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 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.

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", MCF “Sale” & “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 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"

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 on movement between Fulfillment Centers.

AFN "Return", MCF “Sale” & “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”: The amount charged or refunded to the buyer for this activity.

MFN/AFN “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", MCF “Sale” & “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
TRANSACTION_CURRENCY_CODE

Currency code that relates to the activity.

MFN/AFN: “Sale” & “Refund” - 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.

MCF: “Sale” & “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 fuels related commodities and in FR, additional statistical codes relate to meats, wines, and aircrafts 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 fuels related commodities and in FR, additional statistical codes relate to meats, wines, and aircrafts 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 is 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 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/MCF:

“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/MCF:

"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

DEPARTURE_CITY

City associated with the departure location for the transaction.

AFN/MCF: “Sale” - Amazon Fulfillment Center region where the items departed from.

AFN: “Commingling_Buy” & “Commingling_Sell” - Amazon Fulfilment Centre region where the transfer took place.

AFN: “FC_Transfer” - Amazon Fulfillment Center 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/MCF: “Return” - this value will be blank. Amazon does not know the true ship from location due to seller ability to send return 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” - 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/MCF: “Sale” - Amazon Fulfillment Center country where the items departed from.

AFN: “Commingling_Buy” & “Commingling_Sell” - Amazon Fulfilment Centre country where the transfer took place.

AFN: “FC_Transfer” - Amazon Fulfillment Center 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/MCF: “Return” - Departure country of the return shipment. If not available, SALE_ARRIVAL_COUNTRY for the corresponding sale is populated.

Blank

MFN/AFN: “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

Post Code associated with the departure location for the transaction.

AFN/MCF: “Sale” - Amazon Fulfillment Center post code where the items departed from.

AFN: “Commingling_Buy” & “Commingling_Sell” - Amazon Fulfilment Centre postcode where the transfer took place.

AFN: “FC_Transfer” - Amazon Fulfillment Center post code where the items departed from.

70806

MFN: “Sale” - This information is not currently captured by Amazon and will be blank.

AFN: “Inbound” - Postal code in the "ship from" address provided in "Manage FBA Shipments" page for the shipment.

MCF: “Return” - These values will be blank. Amazon does not know the true ship from location due to seller ability to send return from any location. SALE_ARRIVAL_COUNTRY is the last known location where the item in this transaction was delivered.

AFN: "Return" - Post code where the item was delivered in corresponding "sale".

LE11 1JP

MFN: “Refund” - Post code where the item departed from in corresponding "sale".

AFN: “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/MCF: “Sale” – Region where the shipment was delivered.

AFN: “Commingling_Buy” & “Commingling_Sell” - Amazon Fulfilment Centre region where the transfer took place.

AFN/MCF: "Return": Amazon Fulfillment Center region where the return items arrived.

AFN: “FC_Transfer” & Inbound – Amazon Fulfillment Center region where the inbound items arrived.

Leipzig

MFN/AFN: “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/MCF: “Sale” – Country where the shipment was delivered.

AFN: “Commingling_Buy” & “Commingling_Sell” - Amazon Fulfilment Centre country where the transfer took place.

AFN/MCF: "Return": Amazon Fulfillment Center country where the return items arrived.

AFN: “FC_Transfer” & Inbound – Amazon Fulfillment Center country where the inbound items arrived.

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

Post Code associated with the arrival location for the transaction.

MFN/AFN/MCF: “Sale” – Post code where the shipment was delivered.

AFN: “Commingling_Buy” & “Commingling_Sell” - Amazon Fulfilment Centre postcode where the transfer took place.

AFN/MCF: "Return": Amazon Fulfillment Center post code where the return items arrived.

AFN: “FC_Transfer” & Inbound – Amazon Fulfillment Center post code where the inbound items arrived.

70806

MFN: “Refund” – Post code 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/MCF: “Sale” & “Return” & “Refund” – Amazon Fulfillment Center 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” – 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/MCF/MFN: “Sale” & “Return” & “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/MCF: “FC_Transfer” & “Inbound” - 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” - Transport by Road

Transport by Road

AFN/MCF: “Sale” - Consignment by post - package is transferred to an outside carrier for delivery.

AFN/MCF: “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" - 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" - There is no product movement related to a Refund and these values will be blank.

Blank

AFN/MCF: “Return” - XXX

AFN: “FC_Transfer” - XXX

XXX
AFN: “Inbound” - DDP DDP
AFN/MCF: “Sale” - 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 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/MCF:

“Sale”- Country of seller’s departure location.

AFN:

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

AFN/MCF:

"Return”- Country of seller’s departure location.

MFN/AFN:

“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 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/MCF:

“Sale”- Seller’s VAT number of the departure location.

AFN:

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

AFN/MCF:

"Return”- Seller’s VAT number of the departure location.

MFN/AFN:

“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 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/MCF:

“Sale”- Seller’s arrival location.

AFN:

“Commingling_Buy” & “Commingling_Sell” – Seller’s arrival location.

AFN/MCF:

"Return”- Seller’s arrival location.

MFN/AFN:

“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 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/MCF:

“Sale”- Seller’s VAT number of the arrival location.

AFN:

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

AFN/MCF:

"Return”- Seller’s VAT number of the arrival location.

MFN/AFN:

“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 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/MCF:

“Sale”- Seller’s VAT number country.

AFN:

“Commingling_Buy” & “Commingling_Sell” – Seller’s VAT number country.

AFN/MCF:

"Return”- Seller’s VAT number country.

MFN/AFN:

“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 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/MCF:

“Sale”- Seller’s VAT number.

AFN:

“Commingling_Buy” & “Commingling_Sell” – Seller’s VAT number.

AFN/MCF:

"Return”- Seller’s VAT number.

MFN/AFN:

“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 seller has not activated VAT Calculation Services and this must be filled in by the seller if they have captured it outside of Amazon Seller Central.

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

MFN/AFN:

“Sale”- Buyer’s VAT number country.

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

MCF:

“Sale” & “Return”- Buyer’s VAT number country.

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 seller has not activated VAT Calculation Services and this must be filled in by the seller if they have captured it outside of Amazon Seller Central.

Buyer's VAT number, provided for this transaction.

MFN/AFN:

“Sale”- Buyer’s VAT number country.

AFN:

"Return”- Buyer’s VAT number country.

“Commingling_Sell” – Buyer’s VAT number.

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

MCF:

“Sale” & “Return”- Buyer’s VAT number country.

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 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.

AFN:

"Return”- This will be blankSeller’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.”

MCF:

“Sale” & “Return”- This field will be Blank.

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 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.
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 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.

MFN/AFN:

“Sale”- Taxable Jurisdiction country name.

AFN:

"Return”- This will be blankTaxable Jurisdiction country name.

“Commingling_Buy” & “Commingling_Sell” – Taxable Jurisdiction country name.

MFN/AFN:

“Refund”- Taxable Jurisdiction country name.

AFN:

“FC_Transfer” & “Inbound”- This value will be blank“N/A.”

MCF:

"Sale" & "Return"- This field will be Blank.

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.For example, the sequential VAT invoice number or credit note number.

MFN/AFN:

“Sale”- VAT Invoice number.

AFN:

"Return”- This will be blankVAT Invoice number.

“Commingling_Buy” & “Commingling_Sell” – VAT Invoice number.

MFN/AFN:

“Refund”- VAT Invoice number.

AFN:

“FC_Transfer” & “Inbound”- This value will be Blank.

MCF:

“Sale” & “Return”- VAT Invoice number or 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 seller has not activated VAT Calculation Services and this must be filled in by the seller if applicable.

MFN/AFN:

“Sale”- Converted VAT amount.

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.

MCF:

“Sale” & “Return”- Converted VAT amount or 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 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.

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.

MCF:

“Sale” & “Return”- Converted VAT Currency Code or 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 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.

AFN:

"Return”- VAT Exchange Rate.This will be blank

MFN/AFN:

“Refund”- VAT Exchange Rate.

AFN:

“FC_Transfer” & “Inbound”- This value will be Blank.

MCF:

“Sale” & “Return”- VAT Exchange Rate or 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 taxed 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.

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.

MCF:

“Sale” & “Return”- Date of Exchange Rate conversion or 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 seller has not activated VAT Calculation Services and this must be filled in by the seller if applicable.

MFN/AFN:

“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.

AFN:

"Return”- 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.

“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”- 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.

MCF:

“Sale” & “Return”- 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/MCF 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.

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. Amazon Services Europe Sarl
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.

AFN:

“Commingling_Buy” – Supplier’s name as stated on the invoice.

This field will be blank for all other transactions.

Note: Information on this page does not constitute tax, legal, or other professional advice and must not be used as such. Consult your tax agent 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


Was this article helpful?
Thank you for your feedback
How can we improve this help page? Note: This form doesn’t create a support case. Please specify what you think is wrong with the content itself.
1000
What was helpful?
1000
Thank you again for your help!
Thank you for your feedback. If you have more questions, please Contact Us.

Reach Hundreds of Millions of Customers

Start Selling on Amazon


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