Destinations
Data sources
AI insights
About us
Careers
Security
Customer reviews
Contact us
Affiliate program
Solution partners
Template gallery
Looker Studio templates
Power BI templates
Excel templates
Google Sheets templates
Tableau templates
Facebook Ads templates
Google Ads templates
Data fields & Metrics
AI prompt library & Guides
Product documentation
API documentation
Case studies
Blog
Data models
Windsor vs Supermetrics
Windsor vs Funnel.io
Windsor vs Fivetran
Windsor vs Rivery
Windsor vs Portermetrics
Windsor vs Coupler.io
+
Stream marketing data from Amazon MWS to Snowflake
About Amazon MWS
About SnowFlake
Connect Amazon Seller Central to Snowflake
It is very simple to connect Amazon Seller Central (MWS) to Snowflake, it can be done in a fast and easy manner with Windsor.ai.
First Step
Follow the Tutorial Below:
- Add all the columns that are returned by your connector’s URL.
- Create the WINDSOR_UPLOAD role (name has no importance)
- Create a user and add the previously created role to that user
- Grant rights to the DATABASE to the created user
- Grand the rights to the destination table
- Get the required fields from Snowflake to use the Snowflake destination in Onboard Form
- Get the username
- Get the password
- Get the account
- Get the warehouse
- Get the database
- Get the schema
- Get the table name
Second step
1.You need to select Amazon Seller Central (MWS) as a Data Source and Grant Access to Windsor.ai.
2. In Select Destination select Snowflake as destination
3. Enter all the credentials required and click Save
4.Your data will now be streamed to Snowflake. In case there is an error you will be notified.
Amazon Seller Central (MWS) metrics and dimensions available for streaming into Snowflake
| name | type | description |
|---|---|---|
| Account ID | TEXT | The account ID |
| Account Name | TEXT | The account name |
| amazon-order-id (get_amazon_fulfilled_shipments_data_general) | TEXT | amazon-order-id (get_amazon_fulfilled_shipments_data_general) Amazon'sunique, displayable identifier for an order. |
| amazon-order-item-id (get_amazon_fulfilled_shipments_data_general) | TEXT | amazon-order-item-id (get_amazon_fulfilled_shipments_data_general)Amazon's unique, displayable identifier for an item within the order. |
| bill-address-1 (get_amazon_fulfilled_shipments_data_general) | TEXT | bill-address-1 (get_amazon_fulfilled_shipments_data_general) The firstline of a standard address. |
| bill-address-2 (get_amazon_fulfilled_shipments_data_general) | TEXT | bill-address-2 (get_amazon_fulfilled_shipments_data_general) Thesecond line of a standard address. |
| bill-address-3 (get_amazon_fulfilled_shipments_data_general) | TEXT | bill-address-3 (get_amazon_fulfilled_shipments_data_general) The thirdline of a standard address. |
| bill-city (get_amazon_fulfilled_shipments_data_general) | CITY | bill-city (get_amazon_fulfilled_shipments_data_general) The city of astandard address. |
| bill-country (get_amazon_fulfilled_shipments_data_general) | COUNTRY | bill-country (get_amazon_fulfilled_shipments_data_general) ISO 3166standard two-letter country code. |
| bill-postal-code (get_amazon_fulfilled_shipments_data_general) | TEXT | bill-postal-code (get_amazon_fulfilled_shipments_data_general) Thepostal (zip) code of a standard address. |
| bill-state (get_amazon_fulfilled_shipments_data_general) | TEXT | bill-state (get_amazon_fulfilled_shipments_data_general) The state orregion of a standard address. |
| buyer-email (get_amazon_fulfilled_shipments_data_general) | TEXT | buyer-email (get_amazon_fulfilled_shipments_data_general) Theencrypted email address of the buyer. |
| buyer-name (get_amazon_fulfilled_shipments_data_general) | TEXT | buyer-name (get_amazon_fulfilled_shipments_data_general) The full nameof the buyer. |
| buyer-phone-number (get_amazon_fulfilled_shipments_data_general) | TEXT | buyer-phone-number (get_amazon_fulfilled_shipments_data_general) Thephone number of the buyer. |
| carrier (get_amazon_fulfilled_shipments_data_general) | TEXT | carrier (get_amazon_fulfilled_shipments_data_general) The name of thecarrier the package was shipped with. |
| currency (get_amazon_fulfilled_shipments_data_general) | TEXT | currency (get_amazon_fulfilled_shipments_data_general) The currencyused for the purchase. Supported currencies include USD, CAD, GBP,EUR, and JPY. |
| estimated-arrival-date (get_amazon_fulfilled_shipments_data_general) | DATE | estimated-arrival-date (get_amazon_fulfilled_shipments_data_general)The estimated date of delivery to the customer. |
| fulfillment-center-id (get_amazon_fulfilled_shipments_data_general) | TEXT | fulfillment-center-id (get_amazon_fulfilled_shipments_data_general)The unique identifier from which fulfillment center the order wasshipped. |
| fulfillment-channel (get_amazon_fulfilled_shipments_data_general) | TEXT | fulfillment-channel (get_amazon_fulfilled_shipments_data_general)Indicates how the order was fulfilled, via Amazon (AFN) or Merchant(MFN) |
| gift-wrap-price (get_amazon_fulfilled_shipments_data_general) | NUMERIC | gift-wrap-price (get_amazon_fulfilled_shipments_data_general) Theamount that the buyer paid for gift wrap. Amount is aggregate of thequantity, not unit price. |
| gift-wrap-tax (get_amazon_fulfilled_shipments_data_general) | NUMERIC | gift-wrap-tax (get_amazon_fulfilled_shipments_data_general) The amountthat the buyer paid for gift wrap tax. Amount is aggregate of thequantity, not unit price. |
| item-price (get_amazon_fulfilled_shipments_data_general) | NUMERIC | item-price (get_amazon_fulfilled_shipments_data_general) The amountthat the buyer paid for the item. Amount is aggregate of the quantity,not unit price. |
| item-promotion-discount (get_amazon_fulfilled_shipments_data_general) | NUMERIC | item-promotion-discount (get_amazon_fulfilled_shipments_data_general)Promotion discount applied to the order item. |
| item-tax (get_amazon_fulfilled_shipments_data_general) | NUMERIC | item-tax (get_amazon_fulfilled_shipments_data_general) The amount thatthe buyer paid for item tax. Amount is aggregate of the quantity, notunit price. |
| merchant-order-id (get_amazon_fulfilled_shipments_data_general) | TEXT | merchant-order-id (get_amazon_fulfilled_shipments_data_general) Aunique identifier optionally supplied for the order by the Merchant. |
| merchant-order-item-id (get_amazon_fulfilled_shipments_data_general) | TEXT | merchant-order-item-id (get_amazon_fulfilled_shipments_data_general) Aunique identifier for an item within the order. |
| payments-date (get_amazon_fulfilled_shipments_data_general) | DATE | payments-date (get_amazon_fulfilled_shipments_data_general) The datethe buyer's credit card was charged and order processing wascompleted. |
| product-name (get_amazon_fulfilled_shipments_data_general) | TEXT | product-name (get_amazon_fulfilled_shipments_data_general) The shorttitle for the product, displayed in bold on the detail web page and inthe title bar of the browser window. |
| purchase-date (get_amazon_fulfilled_shipments_data_general) | DATE | purchase-date (get_amazon_fulfilled_shipments_data_general) The datethe order was placed. |
| quantity-shipped (get_amazon_fulfilled_shipments_data_general) | NUMERIC | quantity-shipped (get_amazon_fulfilled_shipments_data_general) Thenumber of this item that were shipped. |
| recipient-name (get_amazon_fulfilled_shipments_data_general) | TEXT | recipient-name (get_amazon_fulfilled_shipments_data_general) Namefield of a standard address. |
| reporting-date (get_amazon_fulfilled_shipments_data_general) | DATE | reporting-date (get_amazon_fulfilled_shipments_data_general) The datethe data for this report became available in the FBA data store. |
| sales-channel (get_amazon_fulfilled_shipments_data_general) | TEXT | sales-channel (get_amazon_fulfilled_shipments_data_general) The sourceof the order. |
| ship-address-1 (get_amazon_fulfilled_shipments_data_general) | TEXT | ship-address-1 (get_amazon_fulfilled_shipments_data_general) The firstline of a standard address. |
| ship-address-2 (get_amazon_fulfilled_shipments_data_general) | TEXT | ship-address-2 (get_amazon_fulfilled_shipments_data_general) Thesecond line of a standard address. |
| ship-address-3 (get_amazon_fulfilled_shipments_data_general) | TEXT | ship-address-3 (get_amazon_fulfilled_shipments_data_general) The thirdline of a standard address. |
| ship-city (get_amazon_fulfilled_shipments_data_general) | CITY | ship-city (get_amazon_fulfilled_shipments_data_general) The city of astandard address. |
| ship-country (get_amazon_fulfilled_shipments_data_general) | COUNTRY | ship-country (get_amazon_fulfilled_shipments_data_general) ISO 3166standard two-letter country code. |
| ship-phone-number (get_amazon_fulfilled_shipments_data_general) | TEXT | ship-phone-number (get_amazon_fulfilled_shipments_data_general) Thephone number associated with the ship-to address. |
| ship-postal-code (get_amazon_fulfilled_shipments_data_general) | TEXT | ship-postal-code (get_amazon_fulfilled_shipments_data_general) Thepostal (ZIP) code of a standard address. |
| ship-promotion-discount (get_amazon_fulfilled_shipments_data_general) | NUMERIC | ship-promotion-discount (get_amazon_fulfilled_shipments_data_general)Promotion discount applied to shipping. |
| ship-service-level (get_amazon_fulfilled_shipments_data_general) | TEXT | ship-service-level (get_amazon_fulfilled_shipments_data_general) Anenumerated value that determines the type of fulfillment service thatthe buyer expects the merchant to use (e.g., Standard v. Expedited) |
| ship-state (get_amazon_fulfilled_shipments_data_general) | TEXT | ship-state (get_amazon_fulfilled_shipments_data_general) The state orregion of a standard address. |
| shipment-date (get_amazon_fulfilled_shipments_data_general) | DATE | shipment-date (get_amazon_fulfilled_shipments_data_general) The datethe shipment was completed (shipped) by the fulfillment center |
| shipment-id (get_amazon_fulfilled_shipments_data_general) | TEXT | shipment-id (get_amazon_fulfilled_shipments_data_general) EncryptedAmazon shipment id |
| shipment-item-id (get_amazon_fulfilled_shipments_data_general) | TEXT | shipment-item-id (get_amazon_fulfilled_shipments_data_general)Encrypted Amazon shipment item id |
| shipping-price (get_amazon_fulfilled_shipments_data_general) | NUMERIC | shipping-price (get_amazon_fulfilled_shipments_data_general) Theamount that the buyer paid for shipping. Amount is aggregate of thequantity, not unit price. |
| shipping-tax (get_amazon_fulfilled_shipments_data_general) | NUMERIC | shipping-tax (get_amazon_fulfilled_shipments_data_general) The amountthat the buyer paid for shipping tax. Amount is aggregate of thequantity, not unit price. |
| sku (get_amazon_fulfilled_shipments_data_general) | TEXT | sku (get_amazon_fulfilled_shipments_data_general) A merchant-definedunique identifier for a product. |
| tracking-number (get_amazon_fulfilled_shipments_data_general) | TEXT | tracking-number (get_amazon_fulfilled_shipments_data_general) Thecarrier's tracking number for the package. |
| Data Source | TEXT | The name of the Windsor connector returning the row |
| Date | DATE | Date to which metrics apply |
| Day of month | TEXT | Day of the month |
| asin (get_fba_estimated_fba_fees_txt_data) | TEXT | asin (get_fba_estimated_fba_fees_txt_data) Amazon StandardIdentification Numbers (ASINs) are unique blocks of 10 letters ornumbers that identify products. ASINs are assigned by Amazon. You canfind the ASIN on the product detail page. |
| brand (get_fba_estimated_fba_fees_txt_data) | TEXT | brand (get_fba_estimated_fba_fees_txt_data) The brand of your product |
| currency (get_fba_estimated_fba_fees_txt_data) | TEXT | currency (get_fba_estimated_fba_fees_txt_data) The currency in whichthe fee is calculated |
| estimated-fee-total (get_fba_estimated_fba_fees_txt_data) | NUMERIC | estimated-fee-total (get_fba_estimated_fba_fees_txt_data) Theestimated fulfillment and selling on Amazon fee |
| estimated-order-handling-fee-per-order (get_fba_estimated_fba_fees_txt_data) | NUMERIC | estimated-order-handling-fee-per-order(get_fba_estimated_fba_fees_txt_data) The estimated order handling feeper order |
| estimated-pick-pack-fee-per-unit (get_fba_estimated_fba_fees_txt_data) | TEXT | estimated-pick-pack-fee-per-unit (get_fba_estimated_fba_fees_txt_data) |
| estimated-referral-fee-per-unit (get_fba_estimated_fba_fees_txt_data) | NUMERIC | estimated-referral-fee-per-unit (get_fba_estimated_fba_fees_txt_data)The estimated selling on Amazon referral fee |
| estimated-variable-closing-fee (get_fba_estimated_fba_fees_txt_data) | NUMERIC | estimated-variable-closing-fee (get_fba_estimated_fba_fees_txt_data)The estimated variable closing fee for your product |
| estimated-weight-handling-fee-per-unit (get_fba_estimated_fba_fees_txt_data) | NUMERIC | estimated-weight-handling-fee-per-unit(get_fba_estimated_fba_fees_txt_data) The estimated weight handlingfee for your product based on the outbound shipping weight |
| expected-fulfillment-fee-per-unit (get_fba_estimated_fba_fees_txt_data) | NUMERIC | expected-fulfillment-fee-per-unit(get_fba_estimated_fba_fees_txt_data) |
| fnsku (get_fba_estimated_fba_fees_txt_data) | TEXT | fnsku (get_fba_estimated_fba_fees_txt_data) Unique identifier assignedby Amazon to products stored in and fulfilled from an Amazonfulfillment center |
| fulfilled-by (get_fba_estimated_fba_fees_txt_data) | TEXT | fulfilled-by (get_fba_estimated_fba_fees_txt_data) The entity thatfulfilled the item |
| item-package-weight (get_fba_estimated_fba_fees_txt_data) | NUMERIC | item-package-weight (get_fba_estimated_fba_fees_txt_data) |
| length-and-girth (get_fba_estimated_fba_fees_txt_data) | NUMERIC | length-and-girth (get_fba_estimated_fba_fees_txt_data) The longestside of your product, including its packaging, plus the girth, a unitmeasure, equivalent to 2 x (median side + shortest side) |
| longest-side (get_fba_estimated_fba_fees_txt_data) | NUMERIC | longest-side (get_fba_estimated_fba_fees_txt_data) Measurement of thelongest side of your product including its packaging |
| median-side (get_fba_estimated_fba_fees_txt_data) | NUMERIC | median-side (get_fba_estimated_fba_fees_txt_data) Measurement of theside that is neither the longest nor the shortest side of your productincluding its packaging |
| product-group (get_fba_estimated_fba_fees_txt_data) | TEXT | product-group (get_fba_estimated_fba_fees_txt_data) The Amazondepartment or category |
| product-name (get_fba_estimated_fba_fees_txt_data) | TEXT | product-name (get_fba_estimated_fba_fees_txt_data) The title of yourproduct |
| product-size-tier (get_fba_estimated_fba_fees_txt_data) | TEXT | product-size-tier (get_fba_estimated_fba_fees_txt_data) The size tierassigned to your product by FBA based on its dimensions and weight |
| sales-price (get_fba_estimated_fba_fees_txt_data) | NUMERIC | sales-price (get_fba_estimated_fba_fees_txt_data) Your currentpromotional price |
| shortest-side (get_fba_estimated_fba_fees_txt_data) | NUMERIC | shortest-side (get_fba_estimated_fba_fees_txt_data) Measurement of theshortest side of your product including its packaging |
| sku (get_fba_estimated_fba_fees_txt_data) | TEXT | sku (get_fba_estimated_fba_fees_txt_data) Stock Keeping Units (SKUs)are unique blocks of letters or numbers that identify your products.SKUs are assigned by you as the seller. |
| unit-of-dimension (get_fba_estimated_fba_fees_txt_data) | TEXT | unit-of-dimension (get_fba_estimated_fba_fees_txt_data) |
| unit-of-weight (get_fba_estimated_fba_fees_txt_data) | TEXT | unit-of-weight (get_fba_estimated_fba_fees_txt_data) The unit ofweight used in weight measurement |
| your-price (get_fba_estimated_fba_fees_txt_data) | NUMERIC | your-price (get_fba_estimated_fba_fees_txt_data) Your current sellingprice |
| asin (get_fba_fulfillment_customer_returns_data) | TEXT | asin (get_fba_fulfillment_customer_returns_data) Amazon standard itemnumber |
| customer-comments (get_fba_fulfillment_customer_returns_data) | TEXT | customer-comments (get_fba_fulfillment_customer_returns_data) Whenavailable, comments submitted by customers regarding the reason forthe return are provided. |
| detailed-disposition (get_fba_fulfillment_customer_returns_data) | TEXT | detailed-disposition (get_fba_fulfillment_customer_returns_data)Condition of the returned item: see Condition Codes below forexplanation |
| fnsku (get_fba_fulfillment_customer_returns_data) | TEXT | fnsku (get_fba_fulfillment_customer_returns_data) Fulfillment networkSKU |
| fulfillment-center-id (get_fba_fulfillment_customer_returns_data) | TEXT | fulfillment-center-id (get_fba_fulfillment_customer_returns_data)Fulfillment center where the returned merchandise was processed |
| license-plate-number (get_fba_fulfillment_customer_returns_data) | TEXT | license-plate-number (get_fba_fulfillment_customer_returns_data) |
| order-id (get_fba_fulfillment_customer_returns_data) | TEXT | order-id (get_fba_fulfillment_customer_returns_data) |
| product-name (get_fba_fulfillment_customer_returns_data) | TEXT | product-name (get_fba_fulfillment_customer_returns_data) The name ofthe product as it appears on Amazon |
| quantity (get_fba_fulfillment_customer_returns_data) | NUMERIC | quantity (get_fba_fulfillment_customer_returns_data) Number of unitsof this item returned |
| reason (get_fba_fulfillment_customer_returns_data) | TEXT | reason (get_fba_fulfillment_customer_returns_data) A short descriptionof reason for return as indicated by the customer.See Customer Reason below for explanation |
| return-date (get_fba_fulfillment_customer_returns_data) | DATE | return-date (get_fba_fulfillment_customer_returns_data) Date returnedmerchandise was processed at the fulfillment center.DD-MM-YYYY. |
| sku (get_fba_fulfillment_customer_returns_data) | TEXT | sku (get_fba_fulfillment_customer_returns_data) Seller's itemidentifier |
| status (get_fba_fulfillment_customer_returns_data) | TEXT | status (get_fba_fulfillment_customer_returns_data) A short descriptionof the status of the customer return. Please seeReturn Status below for explanation. |
| asin (get_fba_inventory_planning_data) | TEXT | asin (get_fba_inventory_planning_data) Unique blocks of 10 letters ornumbers that Amazon assigns to the products that are sold throughAmazon |
| asin-limit (get_fba_inventory_planning_data) | NUMERIC | asin-limit (get_fba_inventory_planning_data) |
| condition (get_fba_inventory_planning_data) | TEXT | condition (get_fba_inventory_planning_data) The condition of the unit(for example, new or used) |
| currency (get_fba_inventory_planning_data) | TEXT | currency (get_fba_inventory_planning_data) The currency for theestimated long-term storage fee charge |
| fnsku (get_fba_inventory_planning_data) | TEXT | fnsku (get_fba_inventory_planning_data) Unique blocks of letters andnumbers that Amazon assigns to products that are stored in andfulfilled from an Amazon fulfillment center |
| in-bound-quantity (get_fba_inventory_planning_data) | NUMERIC | in-bound-quantity (get_fba_inventory_planning_data) |
| inbound-recommend-quantity (get_fba_inventory_planning_data) | NUMERIC | inbound-recommend-quantity (get_fba_inventory_planning_data) |
| inv-age-0-to-90-days (get_fba_inventory_planning_data) | NUMERIC | inv-age-0-to-90-days (get_fba_inventory_planning_data) |
| inv-age-181-to-270-days (get_fba_inventory_planning_data) | NUMERIC | inv-age-181-to-270-days (get_fba_inventory_planning_data) |
| inv-age-271-to-365-days (get_fba_inventory_planning_data) | NUMERIC | inv-age-271-to-365-days (get_fba_inventory_planning_data) |
| inv-age-365-plus-days (get_fba_inventory_planning_data) | NUMERIC | inv-age-365-plus-days (get_fba_inventory_planning_data) |
| inv-age-91-to-180-days (get_fba_inventory_planning_data) | NUMERIC | inv-age-91-to-180-days (get_fba_inventory_planning_data) |
| is-hazmat (get_fba_inventory_planning_data) | TEXT | is-hazmat (get_fba_inventory_planning_data) |
| lowest-afn-new-price (get_fba_inventory_planning_data) | NUMERIC | lowest-afn-new-price (get_fba_inventory_planning_data) |
| lowest-afn-used-price (get_fba_inventory_planning_data) | NUMERIC | lowest-afn-used-price (get_fba_inventory_planning_data) |
| lowest-mfn-new-price (get_fba_inventory_planning_data) | NUMERIC | lowest-mfn-new-price (get_fba_inventory_planning_data) |
| lowest-mfn-used-price (get_fba_inventory_planning_data) | NUMERIC | lowest-mfn-used-price (get_fba_inventory_planning_data) |
| num-afn-new-sellers (get_fba_inventory_planning_data) | NUMERIC | num-afn-new-sellers (get_fba_inventory_planning_data) |
| num-afn-used-sellers (get_fba_inventory_planning_data) | NUMERIC | num-afn-used-sellers (get_fba_inventory_planning_data) |
| per-unit-volume (get_fba_inventory_planning_data) | NUMERIC | per-unit-volume (get_fba_inventory_planning_data) |
| product-group (get_fba_inventory_planning_data) | TEXT | product-group (get_fba_inventory_planning_data) Distinct productgrouping distinguishing products like books, from watches or videogames |
| product-name (get_fba_inventory_planning_data) | TEXT | product-name (get_fba_inventory_planning_data) The name of yourproduct |
| projected-ltsf-12-mo (get_fba_inventory_planning_data) | NUMERIC | projected-ltsf-12-mo (get_fba_inventory_planning_data) |
| projected-ltsf-6-mo (get_fba_inventory_planning_data) | NUMERIC | projected-ltsf-6-mo (get_fba_inventory_planning_data) |
| qty-in-long-term-storage-program (get_fba_inventory_planning_data) | NUMERIC | qty-in-long-term-storage-program (get_fba_inventory_planning_data) |
| qty-to-be-charged-ltsf-12-mo (get_fba_inventory_planning_data) | NUMERIC | qty-to-be-charged-ltsf-12-mo (get_fba_inventory_planning_data) |
| qty-to-be-charged-ltsf-6-mo (get_fba_inventory_planning_data) | NUMERIC | qty-to-be-charged-ltsf-6-mo (get_fba_inventory_planning_data) |
| qty-with-removals-in-progress (get_fba_inventory_planning_data) | TEXT | qty-with-removals-in-progress (get_fba_inventory_planning_data) |
| sales-price (get_fba_inventory_planning_data) | NUMERIC | sales-price (get_fba_inventory_planning_data) |
| sales-rank (get_fba_inventory_planning_data) | NUMERIC | sales-rank (get_fba_inventory_planning_data) The current rank for yourproduct. The change in sales rank value is the plus or minus change inthe past 7 days. |
| sellable-quantity (get_fba_inventory_planning_data) | NUMERIC | sellable-quantity (get_fba_inventory_planning_data) |
| sku (get_fba_inventory_planning_data) | TEXT | sku (get_fba_inventory_planning_data) Unique blocks of letters andnumbers that you assign to the products that you are selling |
| snapshot-date (get_fba_inventory_planning_data) | DATE | snapshot-date (get_fba_inventory_planning_data) The date the reportwas generated |
| total-quantity (get_fba_inventory_planning_data) | NUMERIC | total-quantity (get_fba_inventory_planning_data) |
| units-shipped-last-180-days (get_fba_inventory_planning_data) | NUMERIC | units-shipped-last-180-days (get_fba_inventory_planning_data) |
| units-shipped-last-24-hrs (get_fba_inventory_planning_data) | NUMERIC | units-shipped-last-24-hrs (get_fba_inventory_planning_data) |
| units-shipped-last-30-days (get_fba_inventory_planning_data) | NUMERIC | units-shipped-last-30-days (get_fba_inventory_planning_data) |
| units-shipped-last-365-days (get_fba_inventory_planning_data) | NUMERIC | units-shipped-last-365-days (get_fba_inventory_planning_data) |
| units-shipped-last-7-days (get_fba_inventory_planning_data) | NUMERIC | units-shipped-last-7-days (get_fba_inventory_planning_data) |
| units-shipped-last-90-days (get_fba_inventory_planning_data) | NUMERIC | units-shipped-last-90-days (get_fba_inventory_planning_data) |
| unsellable-quantity (get_fba_inventory_planning_data) | NUMERIC | unsellable-quantity (get_fba_inventory_planning_data) |
| weeks-of-cover-t180 (get_fba_inventory_planning_data) | TEXT | weeks-of-cover-t180 (get_fba_inventory_planning_data) |
| weeks-of-cover-t30 (get_fba_inventory_planning_data) | TEXT | weeks-of-cover-t30 (get_fba_inventory_planning_data) Your historicaltrailing 30-day on-hand inventory average divided by your units soldover the same time period divided by 4 weeks. If you sold 400 units ofa given item in the last 30 days (4 weeks) and had 100 sellable unitsin fulfillment centers, your weeks of cover last 30 days would be 1. |
| weeks-of-cover-t365 (get_fba_inventory_planning_data) | TEXT | weeks-of-cover-t365 (get_fba_inventory_planning_data) |
| weeks-of-cover-t7 (get_fba_inventory_planning_data) | TEXT | weeks-of-cover-t7 (get_fba_inventory_planning_data) |
| weeks-of-cover-t90 (get_fba_inventory_planning_data) | TEXT | weeks-of-cover-t90 (get_fba_inventory_planning_data) Your historicaltrailing 90-day on-hand inventory average divided by your units soldover the same time period divided by 12 weeks. If you sold 400 unitsof a given item in the last 90 days (12 weeks) and had an average of10 sellable units in fulfillment centers, your weeks of cover last 90days would be 3.33. |
| your-price (get_fba_inventory_planning_data) | NUMERIC | your-price (get_fba_inventory_planning_data) Your listed price |
| alert (get_fba_inventory_planning_data) | TEXT | alert (get_fba_inventory_planning_data) This is displayed when an itemhas a low-traffic or low-conversion alert. Low traffic indicatesthat a low number of potential buyers have seen the listing. Lowconversion indicates that potential buyers are viewing the listing butaren’t following through to buy the product. |
| available (get_fba_inventory_planning_data) | NUMERIC | available (get_fba_inventory_planning_data) Available (sellableinventory) quantity |
| days-of-supply (get_fba_inventory_planning_data) | NUMERIC | days-of-supply (get_fba_inventory_planning_data) The estimated numberof days that your current inventory supply will last based on theprojected demand for your product |
| estimated-cost-savings-of-recommended-actions (get_fba_inventory_planning_data) | NUMERIC | estimated-cost-savings-of-recommended-actions(get_fba_inventory_planning_data) Estimated cost savings betweentaking the recommended action versus the storage fees you would incuron that inventory by taking no action |
| estimated-excess-quantity (get_fba_inventory_planning_data) | NUMERIC | estimated-excess-quantity (get_fba_inventory_planning_data) Estimatedexcess units are overstocked units based on your current salesvelocity and customer demand forecast. It’s costing you more to keepthese units on hand and pay storage fees than to reduce the number ofunits through a price reduction or removal. |
| estimated-ltsf-next-charge (get_fba_inventory_planning_data) | TEXT | estimated-ltsf-next-charge (get_fba_inventory_planning_data) |
| estimated-storage-cost-next-month (get_fba_inventory_planning_data) | NUMERIC | estimated-storage-cost-next-month (get_fba_inventory_planning_data)Estimated storage fees (monthly storage + long-term storage) that youwould incur 30 days from today, based on your current sales rate.Note: Inventory costs are based on quantities in the latest dailysnapshot and may differ from your actual inventory quantities. |
| featuredoffer-price (get_fba_inventory_planning_data) | NUMERIC | featuredoffer-price (get_fba_inventory_planning_data) Offer displayedon a product detail page with an Add to Cart button |
| healthy-inventory-level (get_fba_inventory_planning_data) | NUMERIC | healthy-inventory-level (get_fba_inventory_planning_data) Quantity ofinventory that is not considered excess based on product demand andyour costs. Our recommendations are based on helping you reach thislevel of inventory. |
| inbound-quantity (get_fba_inventory_planning_data) | NUMERIC | inbound-quantity (get_fba_inventory_planning_data) Inbound quantity =inbound-working + inbound-shipped + inbound receiving |
| inbound-received (get_fba_inventory_planning_data) | NUMERIC | inbound-received (get_fba_inventory_planning_data) Shipments inreceiving status |
| inbound-shipped (get_fba_inventory_planning_data) | NUMERIC | inbound-shipped (get_fba_inventory_planning_data) Shipments in shippedstatus |
| inbound-working (get_fba_inventory_planning_data) | NUMERIC | inbound-working (get_fba_inventory_planning_data) Shipments in workingstatus |
| inv-age-0-to-30-days (get_fba_inventory_planning_data) | TEXT | inv-age-0-to-30-days (get_fba_inventory_planning_data) |
| inv-age-181-to-330-days (get_fba_inventory_planning_data) | TEXT | inv-age-181-to-330-days (get_fba_inventory_planning_data) |
| inv-age-31-to-60-days (get_fba_inventory_planning_data) | TEXT | inv-age-31-to-60-days (get_fba_inventory_planning_data) |
| inv-age-331-to-365-days (get_fba_inventory_planning_data) | TEXT | inv-age-331-to-365-days (get_fba_inventory_planning_data) |
| inv-age-61-to-90-days (get_fba_inventory_planning_data) | TEXT | inv-age-61-to-90-days (get_fba_inventory_planning_data) |
| item-volume (get_fba_inventory_planning_data) | NUMERIC | item-volume (get_fba_inventory_planning_data) The volume of the item,which is calculated by multiplying the longest side, median side, andshortest side together. These measurements generally correspond to thelength, width, and height of the item. |
| lowest-price-new-plus-shipping (get_fba_inventory_planning_data) | TEXT | lowest-price-new-plus-shipping (get_fba_inventory_planning_data) |
| lowest-price-used (get_fba_inventory_planning_data) | TEXT | lowest-price-used (get_fba_inventory_planning_data) |
| marketplace (get_fba_inventory_planning_data) | TEXT | marketplace (get_fba_inventory_planning_data) The Amazon store wherethe product is located |
| no-sale-last-6-months (get_fba_inventory_planning_data) | NUMERIC | no-sale-last-6-months (get_fba_inventory_planning_data) Inventory thathas not sold in six or more consecutive months and that have been infulfillment centers for more than 180 days. These units will beautomatically removed during the next removal cycle if you are optedin to automated fulfillable inventory removals. |
| pending-removal-quantity (get_fba_inventory_planning_data) | NUMERIC | pending-removal-quantity (get_fba_inventory_planning_data) The numberof units that you have asked to be returned to you or disposed of |
| projected-ltsf-9-mo (get_fba_inventory_planning_data) | TEXT | projected-ltsf-9-mo (get_fba_inventory_planning_data) |
| qty-to-be-charged-ltsf-9-mo (get_fba_inventory_planning_data) | TEXT | qty-to-be-charged-ltsf-9-mo (get_fba_inventory_planning_data) |
| recommended-action (get_fba_inventory_planning_data) | TEXT | recommended-action (get_fba_inventory_planning_data) The actionrecommended for your inventory. Recommendations are based on yourcurrent customer demand and on whether it would cost you less to takean action than to do nothing. |
| recommended-removal-quantity (get_fba_inventory_planning_data) | NUMERIC | recommended-removal-quantity (get_fba_inventory_planning_data)Estimated number of units that would likely benefit from removalinstead of being charged storage fees |
| recommended-sale-duration-days (get_fba_inventory_planning_data) | NUMERIC | recommended-sale-duration-days (get_fba_inventory_planning_data) If asale is recommended, this is the estimated sale duration in days thatwould likely help you sell through your excess inventory. |
| recommended-sales-price (get_fba_inventory_planning_data) | NUMERIC | recommended-sales-price (get_fba_inventory_planning_data) Sales pricerecommended to help you sell through your inventory based on yourcurrent inventory settings. This value may be different from thelowest price or Featured Offer price. We recommend that you keep yourproduct at this price until you have sold through your excessinventory. |
| sales-shipped-last-30-days (get_fba_inventory_planning_data) | NUMERIC | sales-shipped-last-30-days (get_fba_inventory_planning_data) Shipped-unit sales in the last 30 days |
| sales-shipped-last-60-days (get_fba_inventory_planning_data) | NUMERIC | sales-shipped-last-60-days (get_fba_inventory_planning_data) Shipped-unit sales in the last 60 days |
| sales-shipped-last-7-days (get_fba_inventory_planning_data) | NUMERIC | sales-shipped-last-7-days (get_fba_inventory_planning_data) Shipped-unit sales in the last 7 days |
| sales-shipped-last-90-days (get_fba_inventory_planning_data) | NUMERIC | sales-shipped-last-90-days (get_fba_inventory_planning_data) Shipped-unit sales in the last 90 days |
| sell-through (get_fba_inventory_planning_data) | NUMERIC | sell-through (get_fba_inventory_planning_data) The rate at which yourunits sold and shipped over the past 90 days divided by the averageinventory available at fulfillment centers during that time. Trackingyour sell-through rate can help you determine whether you need to takeaction to improve traffic or conversion for your products. |
| storage-type (get_fba_inventory_planning_data) | TEXT | storage-type (get_fba_inventory_planning_data) Storage-type categoryof the product for which storage limits are set. Note: Standard sizeincludes small and standard types. |
| storage-volume (get_fba_inventory_planning_data) | NUMERIC | storage-volume (get_fba_inventory_planning_data) Storage volume is thetotal usage for this product in our fulfillment centers minusinventory that is pending removal |
| units-shipped-t30 (get_fba_inventory_planning_data) | NUMERIC | units-shipped-t30 (get_fba_inventory_planning_data) Units shipped inthe last 30 days |
| units-shipped-t60 (get_fba_inventory_planning_data) | NUMERIC | units-shipped-t60 (get_fba_inventory_planning_data) Units shipped inthe last 60 days |
| units-shipped-t7 (get_fba_inventory_planning_data) | NUMERIC | units-shipped-t7 (get_fba_inventory_planning_data) Units shipped inthe last 7 days |
| units-shipped-t90 (get_fba_inventory_planning_data) | NUMERIC | units-shipped-t90 (get_fba_inventory_planning_data) Units shipped inthe last 90 days |
| volume-unit-measurement (get_fba_inventory_planning_data) | TEXT | volume-unit-measurement (get_fba_inventory_planning_data) Unit ofmeasurement for the volume of the item |
| afn-fulfillable-quantity (get_fba_myi_unsuppressed_inventory_data) | NUMERIC | afn-fulfillable-quantity (get_fba_myi_unsuppressed_inventory_data) Thenumber of units you have for a SKU in Amazon fulfillment centersthat can be picked, packed, and shipped. |
| afn-future-supply-buyable (get_fba_myi_unsuppressed_inventory_data) | NUMERIC | afn-future-supply-buyable (get_fba_myi_unsuppressed_inventory_data)The number of units available for customers to find and buy whileinventory is on its way to an Amazon fulfillment center through In-Stock Head Start. |
| afn-inbound-receiving-quantity (get_fba_myi_unsuppressed_inventory_data) | NUMERIC | afn-inbound-receiving-quantity(get_fba_myi_unsuppressed_inventory_data) The number of units you havefor a SKU that have not yet been received atan Amazon fulfillment center for processing, but are part of aninbound shipment with some units that havealready been received and processed. |
| afn-inbound-shipped-quantity (get_fba_myi_unsuppressed_inventory_data) | NUMERIC | afn-inbound-shipped-quantity (get_fba_myi_unsuppressed_inventory_data)The number of units you have for a SKU in an inbound shipment that youhave notified Amazon about and provided a tracking number. |
| afn-inbound-working-quantity (get_fba_myi_unsuppressed_inventory_data) | NUMERIC | afn-inbound-working-quantity (get_fba_myi_unsuppressed_inventory_data)The number of units you have for a SKU in an inbound shipment that youhave notified Amazon about. |
| afn-listing-exists (get_fba_myi_unsuppressed_inventory_data) | TEXT | afn-listing-exists (get_fba_myi_unsuppressed_inventory_data) "Yes"indicates that the item is listed for Fulfillment byAmazon. |
| afn-researching-quantity (get_fba_myi_unsuppressed_inventory_data) | NUMERIC | afn-researching-quantity (get_fba_myi_unsuppressed_inventory_data) |
| afn-reserved-future-supply (get_fba_myi_unsuppressed_inventory_data) | NUMERIC | afn-reserved-future-supply (get_fba_myi_unsuppressed_inventory_data)The number of units that customers have purchased while inventory ison its way to an Amazon fulfillment centerthrough In-Stock Head Start. |
| afn-reserved-quantity (get_fba_myi_unsuppressed_inventory_data) | NUMERIC | afn-reserved-quantity (get_fba_myi_unsuppressed_inventory_data) Thenumber of units you have for a SKU in Amazon fulfillment centersthat are currently being picked, packed, and shipped or are sidelinedfor measurement, sampling, or other internalprocesses. |
| afn-total-quantity (get_fba_myi_unsuppressed_inventory_data) | NUMERIC | afn-total-quantity (get_fba_myi_unsuppressed_inventory_data) The totalnumber of units you have for a SKU in an inbound shipment orin Amazon fulfillment centers: (afn-total-quantity) =(afn-warehouse-quantity) + (afn-inbound-working-quantity) +(afn-inbound-shipped-quantity) + (afn-inbound-receiving-quantity) |
| afn-unsellable-quantity (get_fba_myi_unsuppressed_inventory_data) | NUMERIC | afn-unsellable-quantity (get_fba_myi_unsuppressed_inventory_data) Thenumber of units you have for a SKU in Amazon fulfillment centers inunsellable condition. |
| afn-warehouse-quantity (get_fba_myi_unsuppressed_inventory_data) | NUMERIC | afn-warehouse-quantity (get_fba_myi_unsuppressed_inventory_data) Thenumber of units you have for an SKU in Amazon fulfillment centersthat have been processed: (afn-warehouse-quantity) =(afn-fulfillable-quantity) + (afn-unsellable-quantity) +(afn-reserved-quantity). |
| asin (get_fba_myi_unsuppressed_inventory_data) | TEXT | asin (get_fba_myi_unsuppressed_inventory_data) Amazon StandardIdentification Numbers (ASINs) are unique blocks of 10letters or numbers that identify items. ASINs are assigned by Amazon.You can find the ASIN on the product detailpage. |
| condition (get_fba_myi_unsuppressed_inventory_data) | TEXT | condition (get_fba_myi_unsuppressed_inventory_data) The condition ofyour product. |
| fnsku (get_fba_myi_unsuppressed_inventory_data) | TEXT | fnsku (get_fba_myi_unsuppressed_inventory_data) Fulfillment NetworkStock Keeping Units (FNSKUs) are unique identifiersassigned by Amazon to products stored in and fulfilled from Amazonfulfillment centers. |
| mfn-fulfillable-quantity (get_fba_myi_unsuppressed_inventory_data) | TEXT | mfn-fulfillable-quantity (get_fba_myi_unsuppressed_inventory_data) Thequantity in your fulfillment network that can be picked, packed, andshipped. |
| mfn-listing-exists (get_fba_myi_unsuppressed_inventory_data) | TEXT | mfn-listing-exists (get_fba_myi_unsuppressed_inventory_data) "Yes"indicates that the product is listed for fulfillment by you as theseller. |
| per-unit-volume (get_fba_myi_unsuppressed_inventory_data) | NUMERIC | per-unit-volume (get_fba_myi_unsuppressed_inventory_data) The volumein cubic feet of one unit (to the nearest1/100 of an inch). |
| product-name (get_fba_myi_unsuppressed_inventory_data) | TEXT | product-name (get_fba_myi_unsuppressed_inventory_data) The title ofyour product. |
| sku (get_fba_myi_unsuppressed_inventory_data) | TEXT | sku (get_fba_myi_unsuppressed_inventory_data) Stock Keeping Units(SKUs) are unique blocks of letters or numbers thatidentify your products. |
| your-price (get_fba_myi_unsuppressed_inventory_data) | NUMERIC | your-price (get_fba_myi_unsuppressed_inventory_data) Your currentselling price. |
| amazon-order-id (get_fba_reimbursements_data) | TEXT | amazon-order-id (get_fba_reimbursements_data) The unique identifierassigned to the customer order. This field isempty if the reimbursement is not associated with an order. |
| amount-per-unit (get_fba_reimbursements_data) | NUMERIC | amount-per-unit (get_fba_reimbursements_data) The per-unitreimbursement amount for this line item. |
| amount-total (get_fba_reimbursements_data) | NUMERIC | amount-total (get_fba_reimbursements_data) The total amount of thecash reimbursement for this line item. |
| approval-date (get_fba_reimbursements_data) | DATE | approval-date (get_fba_reimbursements_data) The date the reimbursementwas approved. |
| asin (get_fba_reimbursements_data) | TEXT | asin (get_fba_reimbursements_data) An ASIN (Amazon StandardIdentification Numbers) is a unique identifierassigned by Amazon to products in the Amazon product catalog. The ASINcan be found on the product detail page. |
| case-id (get_fba_reimbursements_data) | TEXT | case-id (get_fba_reimbursements_data) The unique identifier assignedto the case when you request a reimbursement. |
| condition (get_fba_reimbursements_data) | TEXT | condition (get_fba_reimbursements_data) The condition of your item(for example, New). |
| currency-unit (get_fba_reimbursements_data) | TEXT | currency-unit (get_fba_reimbursements_data) The currency for theapplicable marketplace. |
| fnsku (get_fba_reimbursements_data) | TEXT | fnsku (get_fba_reimbursements_data) The fulfillment network SKU (stockkeeping unit) is the unique identifierFulfillment by Amazon assigned to your product. |
| original-reimbursement-id (get_fba_reimbursements_data) | TEXT | original-reimbursement-id (get_fba_reimbursements_data) |
| original-reimbursement-type (get_fba_reimbursements_data) | TEXT | original-reimbursement-type (get_fba_reimbursements_data) |
| product-name (get_fba_reimbursements_data) | TEXT | product-name (get_fba_reimbursements_data) The name of your product. |
| quantity-reimbursed-cash (get_fba_reimbursements_data) | NUMERIC | quantity-reimbursed-cash (get_fba_reimbursements_data) The totalnumber of units reimbursed with cash. |
| quantity-reimbursed-inventory (get_fba_reimbursements_data) | NUMERIC | quantity-reimbursed-inventory (get_fba_reimbursements_data) The numberof units reimbursed with inventory. |
| quantity-reimbursed-total (get_fba_reimbursements_data) | NUMERIC | quantity-reimbursed-total (get_fba_reimbursements_data) The totalnumber of units reimbursed with either cash or inventory(Quantity Reimbursed [Cash] + Quantity Reimbursed [Inventory]). |
| reason (get_fba_reimbursements_data) | TEXT | reason (get_fba_reimbursements_data) The reason for the reimbursement(for example, Damaged: Warehouse). |
| reimbursement-id (get_fba_reimbursements_data) | TEXT | reimbursement-id (get_fba_reimbursements_data) The unique identifierfor this reimbursement. Each reimbursement mayinclude multiple line items. |
| sku (get_fba_reimbursements_data) | TEXT | sku (get_fba_reimbursements_data) |
| (Deprecated) asin (get_fba_uno_inventory_data) | TEXT | asin (get_fba_uno_inventory_data) |
| (Deprecated) price (get_fba_uno_inventory_data) | NUMERIC | price (get_fba_uno_inventory_data) |
| (Deprecated) quantity (get_fba_uno_inventory_data) | NUMERIC | quantity (get_fba_uno_inventory_data) |
| (Deprecated) sku (get_fba_uno_inventory_data) | TEXT | sku (get_fba_uno_inventory_data) |
| amazon-order-id (get_flat_file_all_orders_data_by_last_update_general) | TEXT | amazon-order-id (get_flat_file_all_orders_data_by_last_update_general) |
| asin (get_flat_file_all_orders_data_by_last_update_general) | TEXT | asin (get_flat_file_all_orders_data_by_last_update_general) |
| currency (get_flat_file_all_orders_data_by_last_update_general) | TEXT | currency (get_flat_file_all_orders_data_by_last_update_general)Currency type Example: USD |
| fulfillment-channel (get_flat_file_all_orders_data_by_last_update_general) | TEXT | fulfillment-channel(get_flat_file_all_orders_data_by_last_update_general) |
| gift-wrap-price (get_flat_file_all_orders_data_by_last_update_general) | NUMERIC | gift-wrap-price (get_flat_file_all_orders_data_by_last_update_general)The price of the gift wrap selected by the buyer. |
| gift-wrap-tax (get_flat_file_all_orders_data_by_last_update_general) | NUMERIC | gift-wrap-tax (get_flat_file_all_orders_data_by_last_update_general)The amount of tax paid on the gift wrap. |
| is-business-order (get_flat_file_all_orders_data_by_last_update_general) | TEXT | is-business-order(get_flat_file_all_orders_data_by_last_update_general) Indicates ifthe order is from an Amazon Business customer.Example: true, false |
| item-price (get_flat_file_all_orders_data_by_last_update_general) | NUMERIC | item-price (get_flat_file_all_orders_data_by_last_update_general)Price a buyer paid for the item(s). All amounts are aggregates of thequantity, not unit prices.Example: Item Price = $10 Quantity = 2 Itemprice displayed = $20 |
| item-promotion-discount (get_flat_file_all_orders_data_by_last_update_general) | TEXT | item-promotion-discount(get_flat_file_all_orders_data_by_last_update_general) Amountdiscounted from orders that qualify for either a money-off or apercent-off promotion. |
| item-status (get_flat_file_all_orders_data_by_last_update_general) | TEXT | item-status (get_flat_file_all_orders_data_by_last_update_general) |
| item-tax (get_flat_file_all_orders_data_by_last_update_general) | NUMERIC | item-tax (get_flat_file_all_orders_data_by_last_update_general) |
| last-updated-date (get_flat_file_all_orders_data_by_last_update_general) | DATE | last-updated-date(get_flat_file_all_orders_data_by_last_update_general) |
| merchant-order-id (get_flat_file_all_orders_data_by_last_update_general) | TEXT | merchant-order-id(get_flat_file_all_orders_data_by_last_update_general) |
| order-channel (get_flat_file_all_orders_data_by_last_update_general) | TEXT | order-channel (get_flat_file_all_orders_data_by_last_update_general)Information about how an order was placed. |
| order-status (get_flat_file_all_orders_data_by_last_update_general) | TEXT | order-status (get_flat_file_all_orders_data_by_last_update_general) |
| price-designation (get_flat_file_all_orders_data_by_last_update_general) | TEXT | price-designation(get_flat_file_all_orders_data_by_last_update_general) Indicates thetype of business price that the buyer used. Learn more about businessprices. (Amazon Business Seller Program only.) |
| product-name (get_flat_file_all_orders_data_by_last_update_general) | TEXT | product-name (get_flat_file_all_orders_data_by_last_update_general)Short title for the product, displayed on the product detail page andin the browser title bar.Example: Snowboard |
| promotion-ids (get_flat_file_all_orders_data_by_last_update_general) | TEXT | promotion-ids (get_flat_file_all_orders_data_by_last_update_general) |
| purchase-date (get_flat_file_all_orders_data_by_last_update_general) | DATE | purchase-date (get_flat_file_all_orders_data_by_last_update_general)Date the order was placed, in yyyy-mm-dd format. Note: Unless youspecify a different shipping lead time, you have agreed to ship theorder within two business days of this date. |
| purchase-order-number (get_flat_file_all_orders_data_by_last_update_general) | TEXT | purchase-order-number(get_flat_file_all_orders_data_by_last_update_general) The buyer'spurchase order number (for orders from Amazon Business customers).This must be included on the customer package packing slip or on thepackage shipping label. For more information on packing slips andpurchase order numbers, click here. |
| quantity (get_flat_file_all_orders_data_by_last_update_general) | TEXT | quantity (get_flat_file_all_orders_data_by_last_update_general) |
| sales-channel (get_flat_file_all_orders_data_by_last_update_general) | TEXT | sales-channel (get_flat_file_all_orders_data_by_last_update_general) |
| ship-city (get_flat_file_all_orders_data_by_last_update_general) | CITY | ship-city (get_flat_file_all_orders_data_by_last_update_general) Cityof "Ship To" address. |
| ship-country (get_flat_file_all_orders_data_by_last_update_general) | COUNTRY | ship-country (get_flat_file_all_orders_data_by_last_update_general)International Standards Organization two-letter country code (ISO3166-2 compliant).Example: US |
| ship-postal-code (get_flat_file_all_orders_data_by_last_update_general) | TEXT | ship-postal-code(get_flat_file_all_orders_data_by_last_update_general) ZIP code orpostal code of "Ship To" address. Value format depends on destinationcountry. |
| ship-promotion-discount (get_flat_file_all_orders_data_by_last_update_general) | TEXT | ship-promotion-discount(get_flat_file_all_orders_data_by_last_update_general) |
| ship-service-level (get_flat_file_all_orders_data_by_last_update_general) | TEXT | ship-service-level(get_flat_file_all_orders_data_by_last_update_general) Type ofshipping selected by the buyer when ordering the item; for example,standard, expedited. |
| ship-state (get_flat_file_all_orders_data_by_last_update_general) | TEXT | ship-state (get_flat_file_all_orders_data_by_last_update_general)State, province, or region of "Ship To" address. Varies with countryof origin. Note: Abbreviations can vary depending on how it wasentered by the buyer. |
| shipping-price (get_flat_file_all_orders_data_by_last_update_general) | NUMERIC | shipping-price (get_flat_file_all_orders_data_by_last_update_general)Price a buyer paid for shipping. All amounts are aggregates of thequantity, not unit prices. |
| shipping-tax (get_flat_file_all_orders_data_by_last_update_general) | TEXT | shipping-tax (get_flat_file_all_orders_data_by_last_update_general) |
| sku (get_flat_file_all_orders_data_by_last_update_general) | TEXT | sku (get_flat_file_all_orders_data_by_last_update_general) StockKeeping Unit. The seller-defined unique identifier for a product.Example: AA786936215595 |
| amazon-order-id (get_flat_file_all_orders_data_by_order_date_general) | TEXT | amazon-order-id (get_flat_file_all_orders_data_by_order_date_general) |
| asin (get_flat_file_all_orders_data_by_order_date_general) | TEXT | asin (get_flat_file_all_orders_data_by_order_date_general) |
| currency (get_flat_file_all_orders_data_by_order_date_general) | TEXT | currency (get_flat_file_all_orders_data_by_order_date_general)Currency type Example: USD |
| fulfillment-channel (get_flat_file_all_orders_data_by_order_date_general) | TEXT | fulfillment-channel(get_flat_file_all_orders_data_by_order_date_general) |
| gift-wrap-price (get_flat_file_all_orders_data_by_order_date_general) | NUMERIC | gift-wrap-price (get_flat_file_all_orders_data_by_order_date_general)The price of the gift wrap selected by the buyer. |
| gift-wrap-tax (get_flat_file_all_orders_data_by_order_date_general) | NUMERIC | gift-wrap-tax (get_flat_file_all_orders_data_by_order_date_general)The amount of tax paid on the gift wrap. |
| is-business-order (get_flat_file_all_orders_data_by_order_date_general) | TEXT | is-business-order(get_flat_file_all_orders_data_by_order_date_general) Indicates if theorder is from an Amazon Business customer.Example: true, false |
| item-price (get_flat_file_all_orders_data_by_order_date_general) | NUMERIC | item-price (get_flat_file_all_orders_data_by_order_date_general) Pricea buyer paid for the item(s). All amounts are aggregates of thequantity, not unit prices.Example: Item Price = $10 Quantity = 2 Itemprice displayed = $20 |
| item-promotion-discount (get_flat_file_all_orders_data_by_order_date_general) | TEXT | item-promotion-discount(get_flat_file_all_orders_data_by_order_date_general) Amountdiscounted from orders that qualify for either a money-off or apercent-off promotion. |
| item-status (get_flat_file_all_orders_data_by_order_date_general) | TEXT | item-status (get_flat_file_all_orders_data_by_order_date_general) |
| item-tax (get_flat_file_all_orders_data_by_order_date_general) | NUMERIC | item-tax (get_flat_file_all_orders_data_by_order_date_general) |
| last-updated-date (get_flat_file_all_orders_data_by_order_date_general) | DATE | last-updated-date(get_flat_file_all_orders_data_by_order_date_general) |
| merchant-order-id (get_flat_file_all_orders_data_by_order_date_general) | TEXT | merchant-order-id(get_flat_file_all_orders_data_by_order_date_general) |
| order-channel (get_flat_file_all_orders_data_by_order_date_general) | TEXT | order-channel (get_flat_file_all_orders_data_by_order_date_general)Information about how an order was placed. |
| order-status (get_flat_file_all_orders_data_by_order_date_general) | TEXT | order-status (get_flat_file_all_orders_data_by_order_date_general) |
| price-designation (get_flat_file_all_orders_data_by_order_date_general) | TEXT | price-designation(get_flat_file_all_orders_data_by_order_date_general) Indicates thetype of business price that the buyer used. Learn more about businessprices. (Amazon Business Seller Program only.) |
| product-name (get_flat_file_all_orders_data_by_order_date_general) | TEXT | product-name (get_flat_file_all_orders_data_by_order_date_general)Short title for the product, displayed on the product detail page andin the browser title bar.Example: Snowboard |
| promotion-ids (get_flat_file_all_orders_data_by_order_date_general) | TEXT | promotion-ids (get_flat_file_all_orders_data_by_order_date_general) |
| purchase-date (get_flat_file_all_orders_data_by_order_date_general) | TIMESTAMP | purchase-date (get_flat_file_all_orders_data_by_order_date_general)Date the order was placed, in yyyy-mm-dd format. Note: Unless youspecify a different shipping lead time, you have agreed to ship theorder within two business days of this date. |
| purchase-order-number (get_flat_file_all_orders_data_by_order_date_general) | TEXT | purchase-order-number(get_flat_file_all_orders_data_by_order_date_general) The buyer'spurchase order number (for orders from Amazon Business customers).This must be included on the customer package packing slip or on thepackage shipping label. For more information on packing slips andpurchase order numbers, click here. |
| quantity (get_flat_file_all_orders_data_by_order_date_general) | TEXT | quantity (get_flat_file_all_orders_data_by_order_date_general) |
| sales-channel (get_flat_file_all_orders_data_by_order_date_general) | TEXT | sales-channel (get_flat_file_all_orders_data_by_order_date_general) |
| ship-city (get_flat_file_all_orders_data_by_order_date_general) | CITY | ship-city (get_flat_file_all_orders_data_by_order_date_general) Cityof "Ship To" address. |
| ship-country (get_flat_file_all_orders_data_by_order_date_general) | COUNTRY | ship-country (get_flat_file_all_orders_data_by_order_date_general)International Standards Organization two-letter country code (ISO3166-2 compliant).Example: US |
| ship-postal-code (get_flat_file_all_orders_data_by_order_date_general) | TEXT | ship-postal-code (get_flat_file_all_orders_data_by_order_date_general)ZIP code or postal code of "Ship To" address. Value format depends ondestination country. |
| ship-promotion-discount (get_flat_file_all_orders_data_by_order_date_general) | TEXT | ship-promotion-discount(get_flat_file_all_orders_data_by_order_date_general) |
| ship-service-level (get_flat_file_all_orders_data_by_order_date_general) | TEXT | ship-service-level(get_flat_file_all_orders_data_by_order_date_general) Type of shippingselected by the buyer when ordering the item; for example, standard,expedited. |
| ship-state (get_flat_file_all_orders_data_by_order_date_general) | TEXT | ship-state (get_flat_file_all_orders_data_by_order_date_general)State, province, or region of "Ship To" address. Varies with countryof origin. Note: Abbreviations can vary depending on how it wasentered by the buyer. |
| shipping-price (get_flat_file_all_orders_data_by_order_date_general) | NUMERIC | shipping-price (get_flat_file_all_orders_data_by_order_date_general)Price a buyer paid for shipping. All amounts are aggregates of thequantity, not unit prices. |
| shipping-tax (get_flat_file_all_orders_data_by_order_date_general) | TEXT | shipping-tax (get_flat_file_all_orders_data_by_order_date_general) |
| sku (get_flat_file_all_orders_data_by_order_date_general) | TEXT | sku (get_flat_file_all_orders_data_by_order_date_general) StockKeeping Unit. The seller-defined unique identifier for a product.Example: AA786936215595 |
| asin (get_flat_file_open_listings_data) | TEXT | asin (get_flat_file_open_listings_data) |
| Business Price (get_flat_file_open_listings_data) | TEXT | Business Price (get_flat_file_open_listings_data) |
| price (get_flat_file_open_listings_data) | NUMERIC | price (get_flat_file_open_listings_data) |
| Progressive Lower Bound 1 (get_flat_file_open_listings_data) | TEXT | Progressive Lower Bound 1 (get_flat_file_open_listings_data) |
| Progressive Lower Bound 2 (get_flat_file_open_listings_data) | TEXT | Progressive Lower Bound 2 (get_flat_file_open_listings_data) |
| Progressive Lower Bound 3 (get_flat_file_open_listings_data) | TEXT | Progressive Lower Bound 3 (get_flat_file_open_listings_data) |
| Progressive Price 1 (get_flat_file_open_listings_data) | TEXT | Progressive Price 1 (get_flat_file_open_listings_data) |
| Progressive Price 2 (get_flat_file_open_listings_data) | TEXT | Progressive Price 2 (get_flat_file_open_listings_data) |
| Progressive Price 3 (get_flat_file_open_listings_data) | TEXT | Progressive Price 3 (get_flat_file_open_listings_data) |
| Progressive Price Type (get_flat_file_open_listings_data) | TEXT | Progressive Price Type (get_flat_file_open_listings_data) |
| quantity (get_flat_file_open_listings_data) | NUMERIC | quantity (get_flat_file_open_listings_data) |
| Quantity Lower Bound 1 (get_flat_file_open_listings_data) | TEXT | Quantity Lower Bound 1 (get_flat_file_open_listings_data) |
| Quantity Lower Bound 2 (get_flat_file_open_listings_data) | TEXT | Quantity Lower Bound 2 (get_flat_file_open_listings_data) |
| Quantity Lower Bound 3 (get_flat_file_open_listings_data) | TEXT | Quantity Lower Bound 3 (get_flat_file_open_listings_data) |
| Quantity Lower Bound 4 (get_flat_file_open_listings_data) | TEXT | Quantity Lower Bound 4 (get_flat_file_open_listings_data) |
| Quantity Lower Bound 5 (get_flat_file_open_listings_data) | TEXT | Quantity Lower Bound 5 (get_flat_file_open_listings_data) |
| Quantity Price 1 (get_flat_file_open_listings_data) | TEXT | Quantity Price 1 (get_flat_file_open_listings_data) |
| Quantity Price 2 (get_flat_file_open_listings_data) | TEXT | Quantity Price 2 (get_flat_file_open_listings_data) |
| Quantity Price 3 (get_flat_file_open_listings_data) | TEXT | Quantity Price 3 (get_flat_file_open_listings_data) |
| Quantity Price 4 (get_flat_file_open_listings_data) | TEXT | Quantity Price 4 (get_flat_file_open_listings_data) |
| Quantity Price 5 (get_flat_file_open_listings_data) | TEXT | Quantity Price 5 (get_flat_file_open_listings_data) |
| Quantity Price Type (get_flat_file_open_listings_data) | TEXT | Quantity Price Type (get_flat_file_open_listings_data) |
| sku (get_flat_file_open_listings_data) | TEXT | sku (get_flat_file_open_listings_data) |
| Marketplace Country | COUNTRY | The Marketplace Country |
| add-delete (get_merchant_listings_all_data) | TEXT | add-delete (get_merchant_listings_all_data) This field will be emptyin the report; it enables you to use an open listings report to updateonline inventory. |
| asin1 (get_merchant_listings_all_data) | TEXT | asin1 (get_merchant_listings_all_data) This is not used. The field ispopulated with the product-id. |
| asin2 (get_merchant_listings_all_data) | TEXT | asin2 (get_merchant_listings_all_data) This is used for backwardscompatibility only. |
| asin3 (get_merchant_listings_all_data) | TEXT | asin3 (get_merchant_listings_all_data) This is used for backwardscompatibility only. |
| bid-for-featured-placement (get_merchant_listings_all_data) | TEXT | bid-for-featured-placement (get_merchant_listings_all_data) This isused for backwards compatibility only. |
| expedited-shipping (get_merchant_listings_all_data) | TEXT | expedited-shipping (get_merchant_listings_all_data) Second = listingsthat are available for second day shipping to U.S. domestic addressesNext = listings that are available for next day shipping to U.S.domestic addresses Same = listings that are available for same dayshipping to U.S. domestic addresses n = not offered |
| fulfillment-channel (get_merchant_listings_all_data) | TEXT | fulfillment-channel (get_merchant_listings_all_data) This willindicate for FBA sellers if the listing is set for seller fulfilmentor fulfilment by Amazon. |
| image-url (get_merchant_listings_all_data) | IMAGE_URL | image-url (get_merchant_listings_all_data) |
| item-condition (get_merchant_listings_all_data) | NUMERIC | item-condition (get_merchant_listings_all_data) This is your conditioncode for the listing.1 = Used; Like New 2 = Used; Very Good 3 = Used;Good 4 = Used; Acceptable 5 = Collectible; Like New 6 = Collectible;Very Good 7 = Collectible; Good 8 = Collectible; Acceptable 10 =Refurbished 11 = New |
| item-description (get_merchant_listings_all_data) | TEXT | item-description (get_merchant_listings_all_data) This is used forbackwards compatibility only. |
| item-is-marketplace (get_merchant_listings_all_data) | TEXT | item-is-marketplace (get_merchant_listings_all_data) This will alwaysbe y. |
| item-name (get_merchant_listings_all_data) | TEXT | item-name (get_merchant_listings_all_data) The title of the itemlisted. This will be populated with Amazon catalog data. |
| item-note (get_merchant_listings_all_data) | TEXT | item-note (get_merchant_listings_all_data) Your description of thelisting. |
| listing-id (get_merchant_listings_all_data) | TEXT | listing-id (get_merchant_listings_all_data) An identifier created byAmazon when you create a listing. Consists of 4 digits, a capitalletter, and 6 more digits. |
| merchant-shipping-group (get_merchant_listings_all_data) | TEXT | merchant-shipping-group (get_merchant_listings_all_data) |
| open-date (get_merchant_listings_all_data) | DATE | open-date (get_merchant_listings_all_data) The date the listing wascreated. |
| pending-quantity (get_merchant_listings_all_data) | TEXT | pending-quantity (get_merchant_listings_all_data) This is the quantityof the item that is pending purchase at the time of the report. |
| price (get_merchant_listings_all_data) | NUMERIC | price (get_merchant_listings_all_data) The price you are asking forthe product. |
| product-id (get_merchant_listings_all_data) | TEXT | product-id (get_merchant_listings_all_data) ASIN, ISBN, UPC, or EANfor the item |
| product-id-type (get_merchant_listings_all_data) | NUMERIC | product-id-type (get_merchant_listings_all_data) A numeric entry thatindicates if the product-id is an ASIN, ISBN, UPC, or EAN code/number.When uploading files in Standard Book format, this field value willdefault to 2 (ISBN) unless otherwise specified.1 = ASIN 2 = ISBN 3 =UPC 4 = EAN |
| quantity (get_merchant_listings_all_data) | TEXT | quantity (get_merchant_listings_all_data) The quantity of the productavailable for purchase. |
| seller-sku (get_merchant_listings_all_data) | TEXT | seller-sku (get_merchant_listings_all_data) Stock Keeping Units (SKUs)are unique blocks of letters and/or numbers that identify yourproducts. SKUs are assigned by you as the seller. |
| status (get_merchant_listings_all_data) | TEXT | status (get_merchant_listings_all_data) |
| will-ship-internationally (get_merchant_listings_all_data) | TEXT | will-ship-internationally (get_merchant_listings_all_data) 2 =listings that are available to customers outside the U.S.1 = listingsthat are available only to customers in the U.S. |
| zshop-boldface (get_merchant_listings_all_data) | TEXT | zshop-boldface (get_merchant_listings_all_data) This is used forbackwards compatibility only. |
| zshop-browse-path (get_merchant_listings_all_data) | TEXT | zshop-browse-path (get_merchant_listings_all_data) This is used forbackwards compatibility only. |
| zshop-category1 (get_merchant_listings_all_data) | TEXT | zshop-category1 (get_merchant_listings_all_data) This is used forbackwards compatibility only. |
| zshop-shipping-fee (get_merchant_listings_all_data) | TEXT | zshop-shipping-fee (get_merchant_listings_all_data) This is used forbackwards compatibility only. |
| zshop-storefront-feature (get_merchant_listings_all_data) | TEXT | zshop-storefront-feature (get_merchant_listings_all_data) This is usedfor backwards compatibility only. |
| Month | TEXT | Number of the month |
| Now | TIMESTAMP | Current timestamp |
| Alert (get_restock_inventory_recommendations_report) | TEXT | Alert (get_restock_inventory_recommendations_report) |
| ASIN (get_restock_inventory_recommendations_report) | TEXT | ASIN (get_restock_inventory_recommendations_report) |
| Available (get_restock_inventory_recommendations_report) | NUMERIC | Available (get_restock_inventory_recommendations_report) |
| Condition (get_restock_inventory_recommendations_report) | TEXT | Condition (get_restock_inventory_recommendations_report) |
| Country (get_restock_inventory_recommendations_report) | COUNTRY | Country (get_restock_inventory_recommendations_report) |
| Currency code (get_restock_inventory_recommendations_report) | TEXT | Currency code (get_restock_inventory_recommendations_report) |
| Customer Order (get_restock_inventory_recommendations_report) | NUMERIC | Customer Order (get_restock_inventory_recommendations_report) |
| Days of Supply at Amazon Fulfillment Network (get_restock_inventory_recommendations_report) | TEXT | Days of Supply at Amazon Fulfillment Network(get_restock_inventory_recommendations_report) |
| FC Processing (get_restock_inventory_recommendations_report) | NUMERIC | FC Processing (get_restock_inventory_recommendations_report) |
| FC transfer (get_restock_inventory_recommendations_report) | NUMERIC | FC transfer (get_restock_inventory_recommendations_report) |
| FNSKU (get_restock_inventory_recommendations_report) | TEXT | FNSKU (get_restock_inventory_recommendations_report) |
| Fulfilled by (get_restock_inventory_recommendations_report) | TEXT | Fulfilled by (get_restock_inventory_recommendations_report) |
| Inbound (get_restock_inventory_recommendations_report) | NUMERIC | Inbound (get_restock_inventory_recommendations_report) |
| Merchant SKU (get_restock_inventory_recommendations_report) | TEXT | Merchant SKU (get_restock_inventory_recommendations_report) |
| Price (get_restock_inventory_recommendations_report) | NUMERIC | Price (get_restock_inventory_recommendations_report) |
| Product Name (get_restock_inventory_recommendations_report) | TEXT | Product Name (get_restock_inventory_recommendations_report) |
| Receiving (get_restock_inventory_recommendations_report) | NUMERIC | Receiving (get_restock_inventory_recommendations_report) |
| Recommended action (get_restock_inventory_recommendations_report) | TEXT | Recommended action (get_restock_inventory_recommendations_report) |
| Recommended replenishment qty (get_restock_inventory_recommendations_report) | NUMERIC | Recommended replenishment qty(get_restock_inventory_recommendations_report) |
| Recommended ship date (get_restock_inventory_recommendations_report) | DATE | Recommended ship date (get_restock_inventory_recommendations_report) |
| Sales last 30 days (get_restock_inventory_recommendations_report) | NUMERIC | Sales last 30 days (get_restock_inventory_recommendations_report) |
| Shipped (get_restock_inventory_recommendations_report) | NUMERIC | Shipped (get_restock_inventory_recommendations_report) |
| Supplier (get_restock_inventory_recommendations_report) | TEXT | Supplier (get_restock_inventory_recommendations_report) |
| Supplier part no. (get_restock_inventory_recommendations_report) | TEXT | Supplier part no. (get_restock_inventory_recommendations_report) |
| Total Days of Supply (including units from open shipments) (get_restock_inventory_recommendations_report) | TEXT | Total Days of Supply (including units from open shipments)(get_restock_inventory_recommendations_report) |
| Total Units (get_restock_inventory_recommendations_report) | NUMERIC | Total Units (get_restock_inventory_recommendations_report) |
| Unfulfillable (get_restock_inventory_recommendations_report) | NUMERIC | Unfulfillable (get_restock_inventory_recommendations_report) |
| Units Sold Last 30 Days (get_restock_inventory_recommendations_report) | NUMERIC | Units Sold Last 30 Days (get_restock_inventory_recommendations_report) |
| Working (get_restock_inventory_recommendations_report) | NUMERIC | Working (get_restock_inventory_recommendations_report) |
| childAsin (get_sales_and_traffic_report) | TEXT | childAsin (get_sales_and_traffic_report) |
| date (get_sales_and_traffic_report) | DATE | date (get_sales_and_traffic_report) |
| parentAsin (get_sales_and_traffic_report) | TEXT | parentAsin (get_sales_and_traffic_report) |
| salesByAsin-averageSalesPerOrderItem-amount (get_sales_and_traffic_report) | NUMERIC | salesByAsin-averageSalesPerOrderItem-amount (get_sales_and_traffic_report) |
| (Deprecated) salesByAsin-averageSalesPerOrderItem-currencyCode (get_sales_and_traffic_report) | TEXT | salesByAsin-averageSalesPerOrderItem-currencyCode (get_sales_and_traffic_report) |
| (Deprecated) salesByAsin-averageSalesPerOrderItemB2B-amount (get_sales_and_traffic_report) | NUMERIC | salesByAsin-averageSalesPerOrderItemB2B-amount (get_sales_and_traffic_report) |
| (Deprecated) salesByAsin-averageSalesPerOrderItemB2B-currencyCode (get_sales_and_traffic_report) | TEXT | salesByAsin-averageSalesPerOrderItemB2B-currencyCode (get_sales_and_traffic_report) |
| salesByAsin-averageSellingPrice-amount (get_sales_and_traffic_report) | NUMERIC | salesByAsin-averageSellingPrice-amount (get_sales_and_traffic_report) |
| (Deprecated) salesByAsin-averageSellingPrice-currencyCode (get_sales_and_traffic_report) | TEXT | salesByAsin-averageSellingPrice-currencyCode (get_sales_and_traffic_report) |
| (Deprecated) salesByAsin-averageSellingPriceB2B-amount (get_sales_and_traffic_report) | NUMERIC | salesByAsin-averageSellingPriceB2B-amount (get_sales_and_traffic_report) |
| (Deprecated) salesByAsin-averageSellingPriceB2B-currencyCode (get_sales_and_traffic_report) | TEXT | salesByAsin-averageSellingPriceB2B-currencyCode (get_sales_and_traffic_report) |
| (Deprecated) salesByAsin-averageUnitsPerOrderItem (get_sales_and_traffic_report) | NUMERIC | salesByAsin-averageUnitsPerOrderItem (get_sales_and_traffic_report) |
| (Deprecated) salesByAsin-averageUnitsPerOrderItemB2B (get_sales_and_traffic_report) | NUMERIC | salesByAsin-averageUnitsPerOrderItemB2B (get_sales_and_traffic_report) |
| (Deprecated) salesByAsin-claimsAmount-amount (get_sales_and_traffic_report) | TEXT | salesByAsin-claimsAmount-amount (get_sales_and_traffic_report) |
| (Deprecated) salesByAsin-claimsAmount-currencyCode (get_sales_and_traffic_report) | TEXT | salesByAsin-claimsAmount-currencyCode (get_sales_and_traffic_report) |
| (Deprecated) salesByAsin-claimsGranted (get_sales_and_traffic_report) | TEXT | salesByAsin-claimsGranted (get_sales_and_traffic_report) |
| salesByAsin-orderedProductSales-amount (get_sales_and_traffic_report) | NUMERIC | salesByAsin-orderedProductSales-amount (get_sales_and_traffic_report) |
| salesByAsin-orderedProductSales-currencyCode (get_sales_and_traffic_report) | TEXT | salesByAsin-orderedProductSales-currencyCode (get_sales_and_traffic_report) |
| salesByAsin-orderedProductSalesB2B-amount (get_sales_and_traffic_report) | NUMERIC | salesByAsin-orderedProductSalesB2B-amount (get_sales_and_traffic_report) |
| salesByAsin-orderedProductSalesB2B-currencyCode (get_sales_and_traffic_report) | TEXT | salesByAsin-orderedProductSalesB2B-currencyCode (get_sales_and_traffic_report) |
| (Deprecated) salesByAsin-ordersShipped (get_sales_and_traffic_report) | NUMERIC | salesByAsin-ordersShipped (get_sales_and_traffic_report) |
| salesByAsin-refundRate (get_sales_and_traffic_report) | NUMERIC | salesByAsin-refundRate (get_sales_and_traffic_report) |
| salesByAsin-shippedProductSales-amount (get_sales_and_traffic_report) | NUMERIC | salesByAsin-shippedProductSales-amount (get_sales_and_traffic_report) |
| (Deprecated) salesByAsin-shippedProductSales-currencyCode (get_sales_and_traffic_report) | TEXT | salesByAsin-shippedProductSales-currencyCode (get_sales_and_traffic_report) |
| salesByAsin-totalOrderItems (get_sales_and_traffic_report) | NUMERIC | salesByAsin-totalOrderItems (get_sales_and_traffic_report) |
| salesByAsin-totalOrderItemsB2B (get_sales_and_traffic_report) | NUMERIC | salesByAsin-totalOrderItemsB2B (get_sales_and_traffic_report) |
| salesByAsin-unitsOrdered (get_sales_and_traffic_report) | NUMERIC | salesByAsin-unitsOrdered (get_sales_and_traffic_report) |
| salesByAsin-unitsOrderedB2B (get_sales_and_traffic_report) | NUMERIC | salesByAsin-unitsOrderedB2B (get_sales_and_traffic_report) |
| (Deprecated) salesByAsin-unitsRefunded (get_sales_and_traffic_report) | NUMERIC | salesByAsin-unitsRefunded (get_sales_and_traffic_report) |
| salesByAsin-unitsShipped (get_sales_and_traffic_report) | NUMERIC | salesByAsin-unitsShipped (get_sales_and_traffic_report) |
| salesByDate-averageSalesPerOrderItem-amount (get_sales_and_traffic_report) | NUMERIC | salesByDate-averageSalesPerOrderItem-amount (get_sales_and_traffic_report) |
| salesByDate-averageSalesPerOrderItem-currencyCode (get_sales_and_traffic_report) | TEXT | salesByDate-averageSalesPerOrderItem-currencyCode (get_sales_and_traffic_report) |
| salesByDate-averageSalesPerOrderItemB2B-amount (get_sales_and_traffic_report) | NUMERIC | salesByDate-averageSalesPerOrderItemB2B-amount (get_sales_and_traffic_report) |
| salesByDate-averageSalesPerOrderItemB2B-currencyCode (get_sales_and_traffic_report) | TEXT | salesByDate-averageSalesPerOrderItemB2B-currencyCode (get_sales_and_traffic_report) |
| salesByDate-averageSellingPrice-amount (get_sales_and_traffic_report) | NUMERIC | salesByDate-averageSellingPrice-amount (get_sales_and_traffic_report) |
| salesByDate-averageSellingPrice-currencyCode (get_sales_and_traffic_report) | TEXT | salesByDate-averageSellingPrice-currencyCode (get_sales_and_traffic_report) |
| salesByDate-averageSellingPriceB2B-amount (get_sales_and_traffic_report) | NUMERIC | salesByDate-averageSellingPriceB2B-amount (get_sales_and_traffic_report) |
| salesByDate-averageSellingPriceB2B-currencyCode (get_sales_and_traffic_report) | TEXT | salesByDate-averageSellingPriceB2B-currencyCode (get_sales_and_traffic_report) |
| salesByDate-averageUnitsPerOrderItem (get_sales_and_traffic_report) | NUMERIC | salesByDate-averageUnitsPerOrderItem (get_sales_and_traffic_report) |
| salesByDate-averageUnitsPerOrderItemB2B (get_sales_and_traffic_report) | NUMERIC | salesByDate-averageUnitsPerOrderItemB2B (get_sales_and_traffic_report) |
| salesByDate-claimsAmount-amount (get_sales_and_traffic_report) | TEXT | salesByDate-claimsAmount-amount (get_sales_and_traffic_report) |
| salesByDate-claimsAmount-currencyCode (get_sales_and_traffic_report) | TEXT | salesByDate-claimsAmount-currencyCode (get_sales_and_traffic_report) |
| salesByDate-claimsGranted (get_sales_and_traffic_report) | TEXT | salesByDate-claimsGranted (get_sales_and_traffic_report) |
| salesByDate-orderedProductSales-amount (get_sales_and_traffic_report) | NUMERIC | salesByDate-orderedProductSales-amount (get_sales_and_traffic_report) |
| salesByDate-orderedProductSales-currencyCode (get_sales_and_traffic_report) | TEXT | salesByDate-orderedProductSales-currencyCode (get_sales_and_traffic_report) |
| salesByDate-orderedProductSalesB2B-amount (get_sales_and_traffic_report) | NUMERIC | salesByDate-orderedProductSalesB2B-amount (get_sales_and_traffic_report) |
| salesByDate-orderedProductSalesB2B-currencyCode (get_sales_and_traffic_report) | TEXT | salesByDate-orderedProductSalesB2B-currencyCode (get_sales_and_traffic_report) |
| salesByDate-ordersShipped (get_sales_and_traffic_report) | NUMERIC | salesByDate-ordersShipped (get_sales_and_traffic_report) |
| salesByDate-refundRate (get_sales_and_traffic_report) | NUMERIC | salesByDate-refundRate (get_sales_and_traffic_report) |
| salesByDate-shippedProductSales-amount (get_sales_and_traffic_report) | NUMERIC | salesByDate-shippedProductSales-amount (get_sales_and_traffic_report) |
| salesByDate-shippedProductSales-currencyCode (get_sales_and_traffic_report) | TEXT | salesByDate-shippedProductSales-currencyCode (get_sales_and_traffic_report) |
| salesByDate-totalOrderItems (get_sales_and_traffic_report) | NUMERIC | salesByDate-totalOrderItems (get_sales_and_traffic_report) |
| salesByDate-totalOrderItemsB2B (get_sales_and_traffic_report) | NUMERIC | salesByDate-totalOrderItemsB2B (get_sales_and_traffic_report) |
| salesByDate-unitsOrdered (get_sales_and_traffic_report) | NUMERIC | salesByDate-unitsOrdered (get_sales_and_traffic_report) |
| salesByDate-unitsOrderedB2B (get_sales_and_traffic_report) | NUMERIC | salesByDate-unitsOrderedB2B (get_sales_and_traffic_report) |
| salesByDate-unitsRefunded (get_sales_and_traffic_report) | NUMERIC | salesByDate-unitsRefunded (get_sales_and_traffic_report) |
| salesByDate-unitsShipped (get_sales_and_traffic_report) | NUMERIC | salesByDate-unitsShipped (get_sales_and_traffic_report) |
| (Deprecated) trafficByAsin-averageOfferCount (get_sales_and_traffic_report) | NUMERIC | trafficByAsin-averageOfferCount (get_sales_and_traffic_report) |
| trafficByAsin-averageParentItems (get_sales_and_traffic_report) | NUMERIC | trafficByAsin-averageParentItems (get_sales_and_traffic_report) |
| trafficByAsin-browserPageViews (get_sales_and_traffic_report) | NUMERIC | trafficByAsin-browserPageViews (get_sales_and_traffic_report) |
| trafficByAsin-browserPageViewsB2B (get_sales_and_traffic_report) | NUMERIC | trafficByAsin-browserPageViewsB2B (get_sales_and_traffic_report) |
| trafficByAsin-browserSessions (get_sales_and_traffic_report) | NUMERIC | trafficByAsin-browserSessions (get_sales_and_traffic_report) |
| trafficByAsin-browserSessionsB2B (get_sales_and_traffic_report) | NUMERIC | trafficByAsin-browserSessionsB2B (get_sales_and_traffic_report) |
| trafficByAsin-buyBoxPercentage (get_sales_and_traffic_report) | NUMERIC | trafficByAsin-buyBoxPercentage (get_sales_and_traffic_report) |
| trafficByAsin-buyBoxPercentageB2B (get_sales_and_traffic_report) | NUMERIC | trafficByAsin-buyBoxPercentageB2B (get_sales_and_traffic_report) |
| (Deprecated) trafficByAsin-feedbackReceived (get_sales_and_traffic_report) | TEXT | trafficByAsin-feedbackReceived (get_sales_and_traffic_report) |
| trafficByAsin-mobileAppPageViews (get_sales_and_traffic_report) | NUMERIC | trafficByAsin-mobileAppPageViews (get_sales_and_traffic_report) |
| trafficByAsin-mobileAppPageViewsB2B (get_sales_and_traffic_report) | NUMERIC | trafficByAsin-mobileAppPageViewsB2B (get_sales_and_traffic_report) |
| trafficByAsin-mobileAppSessions (get_sales_and_traffic_report) | NUMERIC | trafficByAsin-mobileAppSessions (get_sales_and_traffic_report) |
| trafficByAsin-mobileAppSessionsB2B (get_sales_and_traffic_report) | NUMERIC | trafficByAsin-mobileAppSessionsB2B (get_sales_and_traffic_report) |
| (Deprecated) trafficByAsin-negativeFeedbackReceived (get_sales_and_traffic_report) | TEXT | trafficByAsin-negativeFeedbackReceived (get_sales_and_traffic_report) |
| trafficByAsin-orderItemSessionPercentage (get_sales_and_traffic_report) | NUMERIC | trafficByAsin-orderItemSessionPercentage (get_sales_and_traffic_report) |
| (Deprecated) trafficByAsin-orderItemSessionPercentageB2B (get_sales_and_traffic_report) | NUMERIC | trafficByAsin-orderItemSessionPercentageB2B (get_sales_and_traffic_report) |
| trafficByAsin-pageViews (get_sales_and_traffic_report) | NUMERIC | trafficByAsin-pageViews (get_sales_and_traffic_report) |
| trafficByAsin-pageViewsB2B (get_sales_and_traffic_report) | NUMERIC | trafficByAsin-pageViewsB2B (get_sales_and_traffic_report) |
| trafficByAsin-receivedNegativeFeedbackRate (get_sales_and_traffic_report) | TEXT | trafficByAsin-receivedNegativeFeedbackRate (get_sales_and_traffic_report) |
| trafficByAsin-sessions (get_sales_and_traffic_report) | NUMERIC | trafficByAsin-sessions (get_sales_and_traffic_report) |
| trafficByAsin-sessionsB2B (get_sales_and_traffic_report) | NUMERIC | trafficByAsin-sessionsB2B (get_sales_and_traffic_report) |
| trafficByAsin-unitSessionPercentage (get_sales_and_traffic_report) | NUMERIC | trafficByAsin-unitSessionPercentage (get_sales_and_traffic_report) |
| trafficByAsin-unitSessionPercentageB2B (get_sales_and_traffic_report) | NUMERIC | trafficByAsin-unitSessionPercentageB2B (get_sales_and_traffic_report) |
| trafficByDate-averageOfferCount (get_sales_and_traffic_report) | NUMERIC | trafficByDate-averageOfferCount (get_sales_and_traffic_report) |
| trafficByDate-averageParentItems (get_sales_and_traffic_report) | NUMERIC | trafficByDate-averageParentItems (get_sales_and_traffic_report) |
| trafficByDate-browserPageViews (get_sales_and_traffic_report) | NUMERIC | trafficByDate-browserPageViews (get_sales_and_traffic_report) |
| trafficByDate-browserPageViewsB2B (get_sales_and_traffic_report) | NUMERIC | trafficByDate-browserPageViewsB2B (get_sales_and_traffic_report) |
| trafficByDate-browserSessions (get_sales_and_traffic_report) | NUMERIC | trafficByDate-browserSessions (get_sales_and_traffic_report) |
| trafficByDate-browserSessionsB2B (get_sales_and_traffic_report) | NUMERIC | trafficByDate-browserSessionsB2B (get_sales_and_traffic_report) |
| trafficByDate-buyBoxPercentage (get_sales_and_traffic_report) | NUMERIC | trafficByDate-buyBoxPercentage (get_sales_and_traffic_report) |
| trafficByDate-buyBoxPercentageB2B (get_sales_and_traffic_report) | NUMERIC | trafficByDate-buyBoxPercentageB2B (get_sales_and_traffic_report) |
| trafficByDate-feedbackReceived (get_sales_and_traffic_report) | TEXT | trafficByDate-feedbackReceived (get_sales_and_traffic_report) |
| trafficByDate-mobileAppPageViews (get_sales_and_traffic_report) | NUMERIC | trafficByDate-mobileAppPageViews (get_sales_and_traffic_report) |
| trafficByDate-mobileAppPageViewsB2B (get_sales_and_traffic_report) | NUMERIC | trafficByDate-mobileAppPageViewsB2B (get_sales_and_traffic_report) |
| trafficByDate-mobileAppSessions (get_sales_and_traffic_report) | NUMERIC | trafficByDate-mobileAppSessions (get_sales_and_traffic_report) |
| trafficByDate-mobileAppSessionsB2B (get_sales_and_traffic_report) | NUMERIC | trafficByDate-mobileAppSessionsB2B (get_sales_and_traffic_report) |
| trafficByDate-negativeFeedbackReceived (get_sales_and_traffic_report) | TEXT | trafficByDate-negativeFeedbackReceived (get_sales_and_traffic_report) |
| trafficByDate-orderItemSessionPercentage (get_sales_and_traffic_report) | NUMERIC | trafficByDate-orderItemSessionPercentage (get_sales_and_traffic_report) |
| trafficByDate-orderItemSessionPercentageB2B (get_sales_and_traffic_report) | NUMERIC | trafficByDate-orderItemSessionPercentageB2B (get_sales_and_traffic_report) |
| trafficByDate-pageViews (get_sales_and_traffic_report) | NUMERIC | trafficByDate-pageViews (get_sales_and_traffic_report) |
| trafficByDate-pageViewsB2B (get_sales_and_traffic_report) | NUMERIC | trafficByDate-pageViewsB2B (get_sales_and_traffic_report) |
| trafficByDate-receivedNegativeFeedbackRate (get_sales_and_traffic_report) | TEXT | trafficByDate-receivedNegativeFeedbackRate (get_sales_and_traffic_report) |
| trafficByDate-sessions (get_sales_and_traffic_report) | NUMERIC | trafficByDate-sessions (get_sales_and_traffic_report) |
| trafficByDate-sessionsB2B (get_sales_and_traffic_report) | NUMERIC | trafficByDate-sessionsB2B (get_sales_and_traffic_report) |
| trafficByDate-unitSessionPercentage (get_sales_and_traffic_report) | NUMERIC | trafficByDate-unitSessionPercentage (get_sales_and_traffic_report) |
| trafficByDate-unitSessionPercentageB2B (get_sales_and_traffic_report) | NUMERIC | trafficByDate-unitSessionPercentageB2B (get_sales_and_traffic_report) |
| Source | TEXT | The name of the Windsor connector returning the row |
| Today | DATE | Today's date |
| adjustment-id (get_v2_settlement_report_data_flat_file_v2) | TEXT | adjustment-id (get_v2_settlement_report_data_flat_file_v2) |
| amount (get_v2_settlement_report_data_flat_file_v2) | NUMERIC | amount (get_v2_settlement_report_data_flat_file_v2) |
| amount-description (get_v2_settlement_report_data_flat_file_v2) | TEXT | amount-description (get_v2_settlement_report_data_flat_file_v2) |
| amount-type (get_v2_settlement_report_data_flat_file_v2) | TEXT | amount-type (get_v2_settlement_report_data_flat_file_v2) |
| currency (get_v2_settlement_report_data_flat_file_v2) | TEXT | currency (get_v2_settlement_report_data_flat_file_v2) |
| deposit-date (get_v2_settlement_report_data_flat_file_v2) | DATE | deposit-date (get_v2_settlement_report_data_flat_file_v2) |
| fulfillment-id (get_v2_settlement_report_data_flat_file_v2) | TEXT | fulfillment-id (get_v2_settlement_report_data_flat_file_v2) |
| marketplace-name (get_v2_settlement_report_data_flat_file_v2) | TEXT | marketplace-name (get_v2_settlement_report_data_flat_file_v2) |
| merchant-adjustment-item-id (get_v2_settlement_report_data_flat_file_v2) | TEXT | merchant-adjustment-item-id(get_v2_settlement_report_data_flat_file_v2) |
| merchant-order-id (get_v2_settlement_report_data_flat_file_v2) | TEXT | merchant-order-id (get_v2_settlement_report_data_flat_file_v2) |
| merchant-order-item-id (get_v2_settlement_report_data_flat_file_v2) | TEXT | merchant-order-item-id (get_v2_settlement_report_data_flat_file_v2) |
| order-id (get_v2_settlement_report_data_flat_file_v2) | TEXT | order-id (get_v2_settlement_report_data_flat_file_v2) |
| order-item-code (get_v2_settlement_report_data_flat_file_v2) | TEXT | order-item-code (get_v2_settlement_report_data_flat_file_v2) |
| posted-date (get_v2_settlement_report_data_flat_file_v2) | DATE | posted-date (get_v2_settlement_report_data_flat_file_v2) |
| posted-date-time (get_v2_settlement_report_data_flat_file_v2) | TEXT | posted-date-time (get_v2_settlement_report_data_flat_file_v2) |
| promotion-id (get_v2_settlement_report_data_flat_file_v2) | TEXT | promotion-id (get_v2_settlement_report_data_flat_file_v2) |
| quantity-purchased (get_v2_settlement_report_data_flat_file_v2) | NUMERIC | quantity-purchased (get_v2_settlement_report_data_flat_file_v2) |
| settlement-end-date (get_v2_settlement_report_data_flat_file_v2) | DATE | settlement-end-date (get_v2_settlement_report_data_flat_file_v2) |
| settlement-id (get_v2_settlement_report_data_flat_file_v2) | TEXT | settlement-id (get_v2_settlement_report_data_flat_file_v2) |
| settlement-start-date (get_v2_settlement_report_data_flat_file_v2) | DATE | settlement-start-date (get_v2_settlement_report_data_flat_file_v2) |
| shipment-id (get_v2_settlement_report_data_flat_file_v2) | TEXT | shipment-id (get_v2_settlement_report_data_flat_file_v2) |
| sku (get_v2_settlement_report_data_flat_file_v2) | TEXT | sku (get_v2_settlement_report_data_flat_file_v2) |
| total-amount (get_v2_settlement_report_data_flat_file_v2) | NUMERIC | total-amount (get_v2_settlement_report_data_flat_file_v2) |
| transaction-type (get_v2_settlement_report_data_flat_file_v2) | TEXT | transaction-type (get_v2_settlement_report_data_flat_file_v2) |
| ACTIVITY_PERIOD (get_vat_transaction_data) | DATE | ACTIVITY_PERIOD (get_vat_transaction_data) |
| ACTIVITY_TRANSACTION_ID (get_vat_transaction_data) | TEXT | ACTIVITY_TRANSACTION_ID (get_vat_transaction_data) |
| ARRIVAL_ADDRESS (get_vat_transaction_data) | TEXT | ARRIVAL_ADDRESS (get_vat_transaction_data) |
| ARRIVAL_CITY (get_vat_transaction_data) | CITY | ARRIVAL_CITY (get_vat_transaction_data) |
| ARRIVAL_COUNTRY (get_vat_transaction_data) | COUNTRY | ARRIVAL_COUNTRY (get_vat_transaction_data) |
| ARRIVAL_POST_CODE (get_vat_transaction_data) | TEXT | ARRIVAL_POST_CODE (get_vat_transaction_data) |
| ASIN (get_vat_transaction_data) | TEXT | ASIN (get_vat_transaction_data) |
| BUYER_NAME (get_vat_transaction_data) | TEXT | BUYER_NAME (get_vat_transaction_data) |
| BUYER_VAT_NUMBER (get_vat_transaction_data) | TEXT | BUYER_VAT_NUMBER (get_vat_transaction_data) |
| BUYER_VAT_NUMBER_COUNTRY (get_vat_transaction_data) | COUNTRY | BUYER_VAT_NUMBER_COUNTRY (get_vat_transaction_data) |
| COMMODITY_CODE (get_vat_transaction_data) | TEXT | COMMODITY_CODE (get_vat_transaction_data) |
| COMMODITY_CODE_SUPPLEMENTARY_UNIT (get_vat_transaction_data) | TEXT | COMMODITY_CODE_SUPPLEMENTARY_UNIT (get_vat_transaction_data) |
| COST_PRICE_OF_ITEMS (get_vat_transaction_data) | NUMERIC | COST_PRICE_OF_ITEMS (get_vat_transaction_data) |
| DELIVERY_CONDITIONS (get_vat_transaction_data) | TEXT | DELIVERY_CONDITIONS (get_vat_transaction_data) |
| DEPARTURE_COUNTRY (get_vat_transaction_data) | COUNTRY | DEPARTURE_COUNTRY (get_vat_transaction_data) |
| DEPARTURE_POST_CODE (get_vat_transaction_data) | TEXT | DEPARTURE_POST_CODE (get_vat_transaction_data) |
| DEPATURE_CITY (get_vat_transaction_data) | CITY | DEPATURE_CITY (get_vat_transaction_data) |
| EXPORT_OUTSIDE_EU (get_vat_transaction_data) | TEXT | EXPORT_OUTSIDE_EU (get_vat_transaction_data) |
| GIFT_WRAP_AMT_VAT_EXCL (get_vat_transaction_data) | NUMERIC | GIFT_WRAP_AMT_VAT_EXCL (get_vat_transaction_data) |
| GIFT_WRAP_AMT_VAT_INCL (get_vat_transaction_data) | NUMERIC | GIFT_WRAP_AMT_VAT_INCL (get_vat_transaction_data) |
| GIFT_WRAP_VAT_AMT (get_vat_transaction_data) | NUMERIC | GIFT_WRAP_VAT_AMT (get_vat_transaction_data) |
| GIFT_WRAP_VAT_RATE_PERCENT (get_vat_transaction_data) | NUMERIC | GIFT_WRAP_VAT_RATE_PERCENT (get_vat_transaction_data) |
| INVOICE_URL (get_vat_transaction_data) | TEXT | INVOICE_URL (get_vat_transaction_data) |
| ITEM_DESCRIPTION (get_vat_transaction_data) | TEXT | ITEM_DESCRIPTION (get_vat_transaction_data) |
| ITEM_MANUFACTURE_COUNTRY (get_vat_transaction_data) | COUNTRY | ITEM_MANUFACTURE_COUNTRY (get_vat_transaction_data) |
| ITEM_QTY_SUPPLEMENTARY_UNIT (get_vat_transaction_data) | NUMERIC | ITEM_QTY_SUPPLEMENTARY_UNIT (get_vat_transaction_data) |
| ITEM_WEIGHT (get_vat_transaction_data) | NUMERIC | ITEM_WEIGHT (get_vat_transaction_data) |
| MARKETPLACE (get_vat_transaction_data) | TEXT | MARKETPLACE (get_vat_transaction_data) |
| PRICE_OF_ITEMS_AMT_VAT_EXCL (get_vat_transaction_data) | NUMERIC | PRICE_OF_ITEMS_AMT_VAT_EXCL (get_vat_transaction_data) |
| PRICE_OF_ITEMS_AMT_VAT_INCL (get_vat_transaction_data) | NUMERIC | PRICE_OF_ITEMS_AMT_VAT_INCL (get_vat_transaction_data) |
| PRICE_OF_ITEMS_VAT_AMT (get_vat_transaction_data) | NUMERIC | PRICE_OF_ITEMS_VAT_AMT (get_vat_transaction_data) |
| PRICE_OF_ITEMS_VAT_RATE_PERCENT (get_vat_transaction_data) | NUMERIC | PRICE_OF_ITEMS_VAT_RATE_PERCENT (get_vat_transaction_data) |
| PRODUCT_TAX_CODE (get_vat_transaction_data) | TEXT | PRODUCT_TAX_CODE (get_vat_transaction_data) |
| PROGRAM_TYPE (get_vat_transaction_data) | TEXT | PROGRAM_TYPE (get_vat_transaction_data) |
| PROMO_GIFT_WRAP_AMT_VAT_EXCL (get_vat_transaction_data) | NUMERIC | PROMO_GIFT_WRAP_AMT_VAT_EXCL (get_vat_transaction_data) |
| PROMO_GIFT_WRAP_AMT_VAT_INCL (get_vat_transaction_data) | NUMERIC | PROMO_GIFT_WRAP_AMT_VAT_INCL (get_vat_transaction_data) |
| PROMO_GIFT_WRAP_VAT_AMT (get_vat_transaction_data) | NUMERIC | PROMO_GIFT_WRAP_VAT_AMT (get_vat_transaction_data) |
| PROMO_PRICE_OF_ITEMS_AMT_VAT_EXCL (get_vat_transaction_data) | NUMERIC | PROMO_PRICE_OF_ITEMS_AMT_VAT_EXCL (get_vat_transaction_data) |
| PROMO_PRICE_OF_ITEMS_AMT_VAT_INCL (get_vat_transaction_data) | NUMERIC | PROMO_PRICE_OF_ITEMS_AMT_VAT_INCL (get_vat_transaction_data) |
| PROMO_PRICE_OF_ITEMS_VAT_AMT (get_vat_transaction_data) | NUMERIC | PROMO_PRICE_OF_ITEMS_VAT_AMT (get_vat_transaction_data) |
| PROMO_SHIP_CHARGE_AMT_VAT_EXCL (get_vat_transaction_data) | NUMERIC | PROMO_SHIP_CHARGE_AMT_VAT_EXCL (get_vat_transaction_data) |
| PROMO_SHIP_CHARGE_AMT_VAT_INCL (get_vat_transaction_data) | NUMERIC | PROMO_SHIP_CHARGE_AMT_VAT_INCL (get_vat_transaction_data) |
| PROMO_SHIP_CHARGE_VAT_AMT (get_vat_transaction_data) | NUMERIC | PROMO_SHIP_CHARGE_VAT_AMT (get_vat_transaction_data) |
| QTY (get_vat_transaction_data) | NUMERIC | QTY (get_vat_transaction_data) |
| SALE_ARRIVAL_COUNTRY (get_vat_transaction_data) | COUNTRY | SALE_ARRIVAL_COUNTRY (get_vat_transaction_data) |
| SALE_DEPART_COUNTRY (get_vat_transaction_data) | COUNTRY | SALE_DEPART_COUNTRY (get_vat_transaction_data) |
| SALES_CHANNEL (get_vat_transaction_data) | TEXT | SALES_CHANNEL (get_vat_transaction_data) |
| SELLER_ARRIVAL_COUNTRY_VAT_NUMBER (get_vat_transaction_data) | TEXT | SELLER_ARRIVAL_COUNTRY_VAT_NUMBER (get_vat_transaction_data) |
| SELLER_ARRIVAL_VAT_NUMBER_COUNTRY (get_vat_transaction_data) | COUNTRY | SELLER_ARRIVAL_VAT_NUMBER_COUNTRY (get_vat_transaction_data) |
| SELLER_DEPART_COUNTRY_VAT_NUMBER (get_vat_transaction_data) | TEXT | SELLER_DEPART_COUNTRY_VAT_NUMBER (get_vat_transaction_data) |
| SELLER_DEPART_VAT_NUMBER_COUNTRY (get_vat_transaction_data) | COUNTRY | SELLER_DEPART_VAT_NUMBER_COUNTRY (get_vat_transaction_data) |
| SELLER_SKU (get_vat_transaction_data) | TEXT | SELLER_SKU (get_vat_transaction_data) |
| SHIP_CHARGE_AMT_VAT_EXCL (get_vat_transaction_data) | NUMERIC | SHIP_CHARGE_AMT_VAT_EXCL (get_vat_transaction_data) |
| SHIP_CHARGE_AMT_VAT_INCL (get_vat_transaction_data) | NUMERIC | SHIP_CHARGE_AMT_VAT_INCL (get_vat_transaction_data) |
| SHIP_CHARGE_VAT_AMT (get_vat_transaction_data) | NUMERIC | SHIP_CHARGE_VAT_AMT (get_vat_transaction_data) |
| SHIP_CHARGE_VAT_RATE_PERCENT (get_vat_transaction_data) | NUMERIC | SHIP_CHARGE_VAT_RATE_PERCENT (get_vat_transaction_data) |
| STATISTICAL_CODE_ARRIVAL (get_vat_transaction_data) | TEXT | STATISTICAL_CODE_ARRIVAL (get_vat_transaction_data) |
| STATISTICAL_CODE_DEPART (get_vat_transaction_data) | TEXT | STATISTICAL_CODE_DEPART (get_vat_transaction_data) |
| SUPPLIER_NAME (get_vat_transaction_data) | TEXT | SUPPLIER_NAME (get_vat_transaction_data) |
| SUPPLIER_VAT_NUMBER (get_vat_transaction_data) | TEXT | SUPPLIER_VAT_NUMBER (get_vat_transaction_data) |
| TAX_CALCULATION_DATE (get_vat_transaction_data) | DATE | TAX_CALCULATION_DATE (get_vat_transaction_data) |
| TAX_COLLECTION_RESPONSIBILITY (get_vat_transaction_data) | TEXT | TAX_COLLECTION_RESPONSIBILITY (get_vat_transaction_data) |
| TAX_REPORTING_SCHEME (get_vat_transaction_data) | TEXT | TAX_REPORTING_SCHEME (get_vat_transaction_data) |
| TAXABLE_JURISDICTION (get_vat_transaction_data) | TEXT | TAXABLE_JURISDICTION (get_vat_transaction_data) |
| TAXABLE_JURISDICTION_LEVEL (get_vat_transaction_data) | TEXT | TAXABLE_JURISDICTION_LEVEL (get_vat_transaction_data) |
| TOTAL_ACTIVITY_SUPPLEMENTARY_UNIT (get_vat_transaction_data) | NUMERIC | TOTAL_ACTIVITY_SUPPLEMENTARY_UNIT (get_vat_transaction_data) |
| TOTAL_ACTIVITY_VALUE_AMT_VAT_EXCL (get_vat_transaction_data) | NUMERIC | TOTAL_ACTIVITY_VALUE_AMT_VAT_EXCL (get_vat_transaction_data) |
| TOTAL_ACTIVITY_VALUE_AMT_VAT_INCL (get_vat_transaction_data) | NUMERIC | TOTAL_ACTIVITY_VALUE_AMT_VAT_INCL (get_vat_transaction_data) |
| TOTAL_ACTIVITY_VALUE_VAT_AMT (get_vat_transaction_data) | NUMERIC | TOTAL_ACTIVITY_VALUE_VAT_AMT (get_vat_transaction_data) |
| TOTAL_ACTIVITY_WEIGHT (get_vat_transaction_data) | NUMERIC | TOTAL_ACTIVITY_WEIGHT (get_vat_transaction_data) |
| TOTAL_GIFT_WRAP_AMT_VAT_EXCL (get_vat_transaction_data) | NUMERIC | TOTAL_GIFT_WRAP_AMT_VAT_EXCL (get_vat_transaction_data) |
| TOTAL_GIFT_WRAP_AMT_VAT_INCL (get_vat_transaction_data) | NUMERIC | TOTAL_GIFT_WRAP_AMT_VAT_INCL (get_vat_transaction_data) |
| TOTAL_GIFT_WRAP_VAT_AMT (get_vat_transaction_data) | NUMERIC | TOTAL_GIFT_WRAP_VAT_AMT (get_vat_transaction_data) |
| TOTAL_PRICE_OF_ITEMS_AMT_VAT_EXCL (get_vat_transaction_data) | NUMERIC | TOTAL_PRICE_OF_ITEMS_AMT_VAT_EXCL (get_vat_transaction_data) |
| TOTAL_PRICE_OF_ITEMS_AMT_VAT_INCL (get_vat_transaction_data) | NUMERIC | TOTAL_PRICE_OF_ITEMS_AMT_VAT_INCL (get_vat_transaction_data) |
| TOTAL_PRICE_OF_ITEMS_VAT_AMT (get_vat_transaction_data) | NUMERIC | TOTAL_PRICE_OF_ITEMS_VAT_AMT (get_vat_transaction_data) |
| TOTAL_SHIP_CHARGE_AMT_VAT_EXCL (get_vat_transaction_data) | NUMERIC | TOTAL_SHIP_CHARGE_AMT_VAT_EXCL (get_vat_transaction_data) |
| TOTAL_SHIP_CHARGE_AMT_VAT_INCL (get_vat_transaction_data) | NUMERIC | TOTAL_SHIP_CHARGE_AMT_VAT_INCL (get_vat_transaction_data) |
| TOTAL_SHIP_CHARGE_VAT_AMT (get_vat_transaction_data) | NUMERIC | TOTAL_SHIP_CHARGE_VAT_AMT (get_vat_transaction_data) |
| TRANSACTION_ARRIVAL_DATE (get_vat_transaction_data) | DATE | TRANSACTION_ARRIVAL_DATE (get_vat_transaction_data) |
| TRANSACTION_COMPLETE_DATE (get_vat_transaction_data) | DATE | TRANSACTION_COMPLETE_DATE (get_vat_transaction_data) |
| TRANSACTION_CURRENCY_CODE (get_vat_transaction_data) | TEXT | TRANSACTION_CURRENCY_CODE (get_vat_transaction_data) |
| TRANSACTION_DEPART_DATE (get_vat_transaction_data) | DATE | TRANSACTION_DEPART_DATE (get_vat_transaction_data) |
| TRANSACTION_EVENT_ID (get_vat_transaction_data) | TEXT | TRANSACTION_EVENT_ID (get_vat_transaction_data) |
| TRANSACTION_SELLER_VAT_NUMBER (get_vat_transaction_data) | TEXT | TRANSACTION_SELLER_VAT_NUMBER (get_vat_transaction_data) |
| TRANSACTION_SELLER_VAT_NUMBER_COUNTRY (get_vat_transaction_data) | COUNTRY | TRANSACTION_SELLER_VAT_NUMBER_COUNTRY (get_vat_transaction_data) |
| TRANSACTION_TYPE (get_vat_transaction_data) | TEXT | TRANSACTION_TYPE (get_vat_transaction_data) |
| TRANSPORTATION_MODE (get_vat_transaction_data) | TEXT | TRANSPORTATION_MODE (get_vat_transaction_data) |
| UNIQUE_ACCOUNT_IDENTIFIER (get_vat_transaction_data) | TEXT | UNIQUE_ACCOUNT_IDENTIFIER (get_vat_transaction_data) |
| VAT_CALCULATION_IMPUTATION_COUNTRY (get_vat_transaction_data) | COUNTRY | VAT_CALCULATION_IMPUTATION_COUNTRY (get_vat_transaction_data) |
| VAT_INV_CONVERTED_AMT (get_vat_transaction_data) | NUMERIC | VAT_INV_CONVERTED_AMT (get_vat_transaction_data) |
| VAT_INV_CURRENCY_CODE (get_vat_transaction_data) | TEXT | VAT_INV_CURRENCY_CODE (get_vat_transaction_data) |
| VAT_INV_EXCHANGE_RATE (get_vat_transaction_data) | NUMERIC | VAT_INV_EXCHANGE_RATE (get_vat_transaction_data) |
| VAT_INV_EXCHANGE_RATE_DATE (get_vat_transaction_data) | DATE | VAT_INV_EXCHANGE_RATE_DATE (get_vat_transaction_data) |
| VAT_INV_NUMBER (get_vat_transaction_data) | TEXT | VAT_INV_NUMBER (get_vat_transaction_data) |
| Week | TEXT | Week (Sun-Sat). |
| Day of week and day number | TEXT | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. |
| Day of week and day number, ISO | TEXT | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 |
| Week ISO | TEXT | Week, ISO format (Mon-Sun). |
| Year | TEXT | Year |
| Yearmonth | TEXT | Year and month, e.g. 2024|3 |
| Year of week | TEXT | The year that contains first day of the week (Sun-Sat). |
| Year of week, ISO | TEXT | The year that contains first day of the ISO week (Mon-Sun). |
| Year week | TEXT | Year and week for US weeks (Sun-Sat), e.g. 2024|15 |
| Year week ISO | TEXT | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |
Easily connect Amazon Seller Central (MWS) to Snowflake
See the value and return on every marketing touchpoint
Providing 70+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.
Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.