# Marketplace Reports

### Historical Availability

Historical availability of data refers to the pulling in of past data from Walmart Market place in Intentwise Analytics. This refers to your data for the time period before you added a particular account as a data source under My Connections.

| Report Type   | Historical Availability |
| ------------- | ----------------------- |
| Orders report | 180 days                |

## **Data Source**

To enable the Walmart Marketplace Reports, the datasource: W**almart Seller Marketplace/Walmart Vendor Marketplace** has to be enabled on the Intentwise Platform

### MarketPlace Order LineItem

Table name:  marketplace\_orderlineitem

For complete documentation, please click [here](https://developer.walmart.com/global-marketplace/reference/getallorders).

<table><thead><tr><th width="283.9002320185615">Column Name</th><th>DataType</th><th>Description</th></tr></thead><tbody><tr><td>account_id</td><td>Integer</td><td>Intentwise account id</td></tr><tr><td>account_name</td><td>String</td><td>Intentwise account name</td></tr><tr><td>currency_code</td><td>String</td><td>One single currency for billing, budgeting, bid settings &#x26; campaign performance metrics</td></tr><tr><td>country_code</td><td>String</td><td>Countries associated with the account</td></tr><tr><td>purchase_order_id</td><td>String</td><td>A unique ID associated with the seller's purchase order</td></tr><tr><td>customer_order_id</td><td>String</td><td>The customer order ID</td></tr><tr><td>sku</td><td>String</td><td>A seller-provided Product ID</td></tr><tr><td>order_date</td><td>Timestamp</td><td>The date the customer submitted the sales order</td></tr><tr><td>quantity_unit_measurement</td><td>String</td><td>Unit of quantity</td></tr><tr><td>quantity_amount</td><td>Integer</td><td>The quantity of the unit of measurement for the item.</td></tr><tr><td>product_name</td><td>String</td><td>The name of the product associated with the line item.</td></tr><tr><td>line_item_status</td><td>String</td><td>Status of Line Item</td></tr><tr><td>last_status_modified_date</td><td>Timestamp</td><td>Last status modified date</td></tr><tr><td>order_type</td><td>String</td><td>Specifies if the order is a regular order or replacement order.</td></tr><tr><td>customer_email_id</td><td>String</td><td>The email address of the customer for the sales order</td></tr><tr><td>original_customer_order_id</td><td>Integer</td><td>A unique ID associated with the sales order for specified customer</td></tr><tr><td>shipping_phone</td><td>String</td><td>The customer's phone number</td></tr><tr><td>shipping_estimated_delivery_date</td><td>Timestamp</td><td>The estimated time and date for the delivery of the item.</td></tr><tr><td>shipping_estimated_ship_date</td><td>Timestamp</td><td>The estimated time and date when the item will be shipped.</td></tr><tr><td>shipping_method_code</td><td>String</td><td>The shipping method. Can be one of the following: Standard, Express, OneDay, WhiteGlove, Value or Freight</td></tr><tr><td>shipping_postaladdress_name</td><td>String</td><td>Elements of the customer's postal address</td></tr><tr><td>shipping_postaladdress_address1</td><td>String</td><td>Elements of the customer's postal address</td></tr><tr><td>shipping_postaladdress_address2</td><td>String</td><td>Elements of the customer's postal address</td></tr><tr><td>shipping_postaladdress_city</td><td>String</td><td>Elements of the customer's postal address</td></tr><tr><td>shipping_postaladdress_state</td><td>String</td><td>Elements of the customer's postal address</td></tr><tr><td>shipping_postaladdress_postal_code</td><td>String</td><td>Elements of the customer's postal address</td></tr><tr><td>shipping_postaladdress_country</td><td>String</td><td>Elements of the customer's postal address</td></tr><tr><td>shipping_postaladdress_address_type</td><td>String</td><td>Elements of the customer's postal address</td></tr><tr><td>line_number</td><td>String</td><td>The line number associated with the details for each individual item in the purchase order</td></tr><tr><td>fulfillment_option</td><td>String</td><td>Example : S2H, S2S, etc.</td></tr><tr><td>fulfillment_ship_method</td><td>String</td><td>Example : Value, Expedited, Standard, Rush, etc.</td></tr><tr><td>fulfillment_pickup_datetime</td><td>String</td><td>Gives pick up datetime information</td></tr><tr><td>seller_id</td><td>Integer</td><td>Seller ID</td></tr><tr><td>shipnode_type</td><td>String</td><td>Specifies the type of shipNode.</td></tr><tr><td>buyer_id</td><td>String</td><td>Unique ID of the buyer</td></tr><tr><td>mart</td><td>String</td><td></td></tr><tr><td>is_guest</td><td>String</td><td></td></tr><tr><td>payment_types</td><td>String</td><td>Type of Payment</td></tr><tr><td>shipnode_name</td><td>String</td><td>Name of Shipnode</td></tr><tr><td>shipnode_id</td><td>String</td><td>Unique ID of shipnode</td></tr><tr><td>item_condition</td><td>String</td><td>Information about the condition of the product.</td></tr><tr><td>item_image_url</td><td>String</td><td>Web URL for the image of the item.</td></tr><tr><td>item_weight_value</td><td>String</td><td>Weight Value</td></tr><tr><td>item_weight_unit</td><td>String</td><td>Unit Weight</td></tr><tr><td>return_order_id</td><td>String</td><td>Return Order IS</td></tr><tr><td>original_carrier_method</td><td>String</td><td>Carrier Method</td></tr><tr><td>reference_line_id</td><td>String</td><td>Reference Line ID</td></tr><tr><td>serial_numbers</td><td>String</td><td></td></tr><tr><td>intent_to_cancel</td><td>String</td><td></td></tr><tr><td>config_id</td><td>String</td><td>Config ID</td></tr><tr><td>seller_order_id</td><td>String</td><td>A unique ID associated with the sales order for specified Seller</td></tr><tr><td>total_amount</td><td>Integer</td><td>Total Amount</td></tr><tr><td>currency</td><td>String</td><td>Currency</td></tr><tr><td>refund_id</td><td>String</td><td>Refund ID</td></tr><tr><td>refund_comments</td><td>String</td><td>Refund Comments</td></tr><tr><td>fulfillment_store_id</td><td>String</td><td>Fulfillment Store ID</td></tr><tr><td>fulfillment_pickup_by</td><td>String</td><td>Fulfillment Picked by</td></tr><tr><td>fulfillment_shipping_program_type</td><td>String</td><td>Type of Shipping Program</td></tr><tr><td>download_date</td><td>Timestamp</td><td>Download Date</td></tr></tbody></table>

### MarketPlace Order LineItemCharge

Table name:  marketplace\_orderlineitemcharge

For complete documentation, please click [here](https://developer.walmart.com/global-marketplace/reference/getallorders).

<table><thead><tr><th width="231">Column Name</th><th>Data Type</th><th>Description</th></tr></thead><tbody><tr><td>account_id</td><td>integer</td><td>Intentwise account id</td></tr><tr><td>account_name</td><td>string</td><td>Intentwise account name</td></tr><tr><td>currency_code</td><td>string</td><td>One single currency for billing, budgeting, bid settings &#x26; campaign performance metrics</td></tr><tr><td>country_code</td><td>string</td><td>Countries associated with the account</td></tr><tr><td>purchase_order_id</td><td>string</td><td>A unique ID associated with the seller's purchase order</td></tr><tr><td>customer_order_id</td><td>string</td><td>The customer order ID</td></tr><tr><td>sku</td><td>string</td><td>A seller-provided Product ID</td></tr><tr><td>currency</td><td>string</td><td>Currency</td></tr><tr><td>charge_type</td><td>string</td><td>The charge type for line items can be one of the following: PRODUCT or SHIPPING</td></tr><tr><td>charge_name</td><td>string</td><td>If chargeType is PRODUCT, chargeName is ItemPrice. If chargeType is PRODUCT and includes a chargeName as SubscriptionDiscount</td></tr><tr><td>amount</td><td>integer</td><td>The details for the amount of the tax charge</td></tr><tr><td>tax_name</td><td>string</td><td>The name associated with the tax.</td></tr><tr><td>tax_amount</td><td>integer</td><td>The details for the amount of the tax charge</td></tr><tr><td>seller_id</td><td>integer</td><td>Seller ID of the seller</td></tr><tr><td>line_number</td><td>string</td><td>Line Number</td></tr><tr><td>download_date</td><td>timestamp</td><td>Download Date</td></tr></tbody></table>

### MarketPlace Order LineItemRefundCharge

Table name:  marketplace\_orderlineitemrefundcharge

For complete documentation, please click [here](https://developer.walmart.com/global-marketplace/reference/getallorders).

<table><thead><tr><th width="231">Column Name</th><th>Data Type</th><th>Description</th></tr></thead><tbody><tr><td>account_id</td><td>integer</td><td>Intentwise account id</td></tr><tr><td>account_name</td><td>string</td><td>Intentwise account name</td></tr><tr><td>currency_code</td><td>string</td><td>One single currency for billing, budgeting, bid settings &#x26; campaign performance metrics</td></tr><tr><td>country_code</td><td>string</td><td>Countries associated with the account</td></tr><tr><td>purchase_order_id</td><td>string</td><td>A unique ID associated with the seller's purchase order</td></tr><tr><td>customer_order_id</td><td>string</td><td>The customer order ID</td></tr><tr><td>line_number</td><td>string</td><td>Line Number</td></tr><tr><td>refund_id</td><td>string</td><td>Refund ID</td></tr><tr><td>refund_reason</td><td>string</td><td>Reason of refund</td></tr><tr><td>charge_type</td><td>string</td><td>The charge type for line items can be one of the following: PRODUCT or SHIPPING</td></tr><tr><td>charge_name</td><td>string</td><td>If chargeType is PRODUCT, chargeName is ItemPrice. If chargeType is PRODUCT and includes a chargeName as SubscriptionDiscount</td></tr><tr><td>charge_amount</td><td>integer</td><td>The details for the amount of the tax charge</td></tr><tr><td>tax_name</td><td>string</td><td>The name associated with the tax.</td></tr><tr><td>tax_amount</td><td>integer</td><td>The details for the amount of the tax charge</td></tr><tr><td>currency</td><td>string</td><td>Currency</td></tr><tr><td>download_date</td><td>timestamp</td><td>Download Date</td></tr><tr><td>seller_id</td><td>integer</td><td>Unique Seller ID of the Seller</td></tr></tbody></table>

### MarketPlace Order LineItemStatus

Table name:  marketplace\_orderlineitemstatus

For complete documentation, please click [here](https://developer.walmart.com/global-marketplace/reference/getallorders).

<table><thead><tr><th width="245">Column Name</th><th>Data Type</th><th>Description</th></tr></thead><tbody><tr><td>account_id</td><td>integer</td><td>Intentwise account id</td></tr><tr><td>account_name</td><td>string</td><td>Intentwise account name</td></tr><tr><td>currency_code</td><td>string</td><td>One single currency for billing, budgeting, bid settings &#x26; campaign performance metrics</td></tr><tr><td>country_code</td><td>string</td><td>Countries associated with the account</td></tr><tr><td>purchase_order_id</td><td>string</td><td>A unique ID associated with the seller's purchase order</td></tr><tr><td>customer_order_id</td><td>string</td><td>The customer order ID</td></tr><tr><td>line_number</td><td>string</td><td>Line Number</td></tr><tr><td>status</td><td>string</td><td>Status</td></tr><tr><td>statusquantity_amount</td><td>integer</td><td>The quantity of the unit of measurement for the item.</td></tr><tr><td>statusquantity_unit_of_measurement</td><td>string</td><td>Unit of quantity</td></tr><tr><td>cancellation_reason</td><td>string</td><td>If order is cancelled, cancellationReason will explain the reason</td></tr><tr><td>trackinginfo_ship_date_time</td><td>timestamp</td><td>List of information about the package shipment and tracking updates</td></tr><tr><td>trackinginfo_method_code</td><td>string</td><td>List of information about the package shipment and tracking updates</td></tr><tr><td>trackinginfo_tracking_number</td><td>string</td><td>List of information about the package shipment and tracking updates</td></tr><tr><td>trackinginfo_tracking_url</td><td>string</td><td>List of information about the package shipment and tracking updates</td></tr><tr><td>carriername_other_carrier</td><td>string</td><td>List of information about the package shipment and tracking updates</td></tr><tr><td>carriername_carrier</td><td>string</td><td>List of information about the package shipment and tracking updates</td></tr><tr><td>returncenteraddress_name</td><td>string</td><td>Gives Sellers the ability to specify the RC center address during fulfillment</td></tr><tr><td>returncenteraddress_address1</td><td>string</td><td>Gives Sellers the ability to specify the RC center address during fulfillment</td></tr><tr><td>returncenteraddress_address2</td><td>string</td><td>Gives Sellers the ability to specify the RC center address during fulfillment</td></tr><tr><td>returncenteraddress_city</td><td>string</td><td>Gives Sellers the ability to specify the RC center address during fulfillment</td></tr><tr><td>returncenteraddress_state</td><td>string</td><td>Gives Sellers the ability to specify the RC center address during fulfillment</td></tr><tr><td>returncenteraddress_postal_code</td><td>string</td><td>Gives Sellers the ability to specify the RC center address during fulfillment</td></tr><tr><td>returncenteraddress_country</td><td>string</td><td>Gives Sellers the ability to specify the RC center address during fulfillment</td></tr><tr><td>returncenteraddress_day_phone</td><td>string</td><td>Gives Sellers the ability to specify the RC center address during fulfillment</td></tr><tr><td>returncenteraddress_email_id</td><td>string</td><td>Gives Sellers the ability to specify the RC center address during fulfillment</td></tr><tr><td>download_date</td><td>timestamp</td><td>Download Date</td></tr><tr><td>seller_id</td><td>integer</td><td>Unique Seller ID of the Seller</td></tr></tbody></table>

### MarketPlace Order PickupPerson

Table name:  marketplace\_orderpickupperson

For complete documentation, please click [here](https://developer.walmart.com/global-marketplace/reference/getallorders).

<table><thead><tr><th width="284.1240310077519">Column Name</th><th>Data Type</th><th>Description</th></tr></thead><tbody><tr><td>account_id</td><td>integer</td><td>Intentwise account id</td></tr><tr><td>account_name</td><td>string</td><td>Intentwise account name</td></tr><tr><td>currency_code</td><td>string</td><td>One single currency for billing, budgeting, bid settings &#x26; campaign performance metrics</td></tr><tr><td>country_code</td><td>string</td><td>Countries associated with the account</td></tr><tr><td>purchase_order_id</td><td>string</td><td>A unique ID associated with the seller's purchase order</td></tr><tr><td>customer_order_id</td><td>string</td><td>The customer order ID</td></tr><tr><td>complete_name</td><td>string</td><td>Details of the pickup person</td></tr><tr><td>first_name</td><td>string</td><td>Details of the pickup person</td></tr><tr><td>middle_name</td><td>string</td><td>Details of the pickup person</td></tr><tr><td>last_name</td><td>string</td><td>Details of the pickup person</td></tr><tr><td>general_suffix</td><td>string</td><td>Details of the pickup person</td></tr><tr><td>maturity_suffix</td><td>string</td><td>Details of the pickup person</td></tr><tr><td>title_of_respect</td><td>string</td><td>Details of the pickup person</td></tr><tr><td>empty</td><td>string</td><td></td></tr><tr><td>phone_id</td><td>string</td><td>Details of the pickup person</td></tr><tr><td>phone_area_code</td><td>string</td><td>Details of the pickup person</td></tr><tr><td>phone_extension</td><td>string</td><td>Details of the pickup person</td></tr><tr><td>phone_complete_number</td><td>string</td><td>Details of the pickup person</td></tr><tr><td>phone_type</td><td>string</td><td>Details of the pickup person</td></tr><tr><td>phone_subscriber_number</td><td>string</td><td>Details of the pickup person</td></tr><tr><td>phone_country_code</td><td>string</td><td>Details of the pickup person</td></tr><tr><td>phonevalidity_validation_type</td><td>string</td><td>Details of the pickup person</td></tr><tr><td>phonevalidity_validation_status</td><td>string</td><td>Details of the pickup person</td></tr><tr><td>phonevalidity_validated_date</td><td>timestamp</td><td>Details of the pickup person</td></tr><tr><td>phonevalidity_validated_by</td><td>string</td><td>Details of the pickup person</td></tr><tr><td>download_date</td><td>timestamp</td><td>Download Date</td></tr><tr><td>seller_id</td><td>integer</td><td>Unique Seller ID of the Seller</td></tr></tbody></table>

### MarketPlace Order SubTotal

Table name:  marketplace\_ordersubtotal

For complete documentation, please click [here](https://developer.walmart.com/global-marketplace/reference/getallorders).

<table><thead><tr><th width="245">Column Name</th><th>Data Type</th><th>Description</th></tr></thead><tbody><tr><td>account_id</td><td>integer</td><td>Intentwise account id</td></tr><tr><td>account_name</td><td>string</td><td>Intentwise account name</td></tr><tr><td>currency_code</td><td>string</td><td>One single currency for billing, budgeting, bid settings &#x26; campaign performance metrics</td></tr><tr><td>country_code</td><td>string</td><td>Countries associated with the account</td></tr><tr><td>purchase_order_id</td><td>string</td><td>A unique ID associated with the seller's purchase order</td></tr><tr><td>customer_order_id</td><td>string</td><td>The customer order ID</td></tr><tr><td>sub_total_type</td><td>string</td><td>Total type</td></tr><tr><td>currency</td><td>string</td><td>Currency Unit</td></tr><tr><td>subtotal_amount</td><td>integer</td><td>Total Amount</td></tr><tr><td>download_date</td><td>timestamp</td><td>Download Date</td></tr><tr><td>seller_id</td><td>integer</td><td>Unique Seller ID of the Seller</td></tr></tbody></table>

### MarketPlace Item Listing Quality

Table name:  marketplace\_item\_listingquality

For complete documentation, please click [here](https://developer.walmart.com/global-marketplace/reference/getallorders).

| Column Name                                 | Data type | Description                                                                             |
| ------------------------------------------- | --------- | --------------------------------------------------------------------------------------- |
| account\_id                                 | Integer   | Intentwise Account ID                                                                   |
| account\_name                               | String    | Intentwise account name                                                                 |
| currency\_code                              | String    | One single currency for billing, budgeting, bid settings & campaign performance metrics |
| country\_code                               | String    | Countries associated with the account                                                   |
| product\_id                                 | String    | A unique ID associated with the seller's product                                        |
| quality\_score                              | Numeric   |                                                                                         |
| shipping\_speed\_impact                     | String    |                                                                                         |
| shipping\_speed\_score\_value               | Numeric   |                                                                                         |
| content\_and\_discoverability\_impact       | String    |                                                                                         |
| content\_and\_discoverability\_score\_value | Numeric   |                                                                                         |
| rating\_and\_reviews\_impact                | String    |                                                                                         |
| rating\_and\_reviews\_score\_value          | Numeric   |                                                                                         |
| published\_and\_in\_stock\_impact           | String    |                                                                                         |
| published\_and\_in\_stock\_score\_value     | Numeric   |                                                                                         |
| price\_competitiveness\_impact              | String    |                                                                                         |
| price\_competitiveness\_score\_value        | Numeric   |                                                                                         |
| offer\_impact                               | String    |                                                                                         |
| offer\_score\_value                         | Numeric   |                                                                                         |
| score\_details                              | Super     |                                                                                         |
| wfs\_enabled                                | Boolean   |                                                                                         |
| priority                                    | String    |                                                                                         |
| category\_name                              | String    |                                                                                         |
| product\_name                               | String    |                                                                                         |
| item\_id                                    | String    |                                                                                         |
| stats                                       | Super     |                                                                                         |
| post\_purchase\_issues                      | String    |                                                                                         |
| sku                                         | String    | A seller-provided Product ID                                                            |
| condition                                   | String    |                                                                                         |
| product\_type                               | String    |                                                                                         |
| trends                                      | Super     |                                                                                         |
| last\_30\_days\_conversion\_rate            | Numeric   |                                                                                         |
| last\_30\_days\_page\_views                 | Integer   |                                                                                         |
| gmv                                         | Numeric   |                                                                                         |
| is\_customer\_favorites                     | Boolean   |                                                                                         |
| is\_in\_stock                               | Boolean   |                                                                                         |
| is\_fast\_and\_free\_shipping               | Boolean   |                                                                                         |
| updated\_timestamp                          | Date      | Updated Timestamp                                                                       |
| seller\_id                                  | Integer   | Seller ID                                                                               |
| download\_date                              | Date      | Download Date                                                                           |

### MarketPlace Item Listing Quality Score Details

Table name:  marketplace\_item\_listingquality\_scoredetails

For complete documentation, please click [here](https://developer.walmart.com/global-marketplace/reference/getallorders).

| Column Name    | Data type | Description                                                                             |
| -------------- | --------- | --------------------------------------------------------------------------------------- |
| account\_id    | Integer   | Intentwise Account ID                                                                   |
| account\_name  | String    | Intentwise account name                                                                 |
| currency\_code | String    | One single currency for billing, budgeting, bid settings & campaign performance metrics |
| country\_code  | String    | Countries associated with the account                                                   |
| product\_id    | String    | A unique ID associated with the seller's product                                        |
| metric\_name   | String    | Name of the metric                                                                      |
| score\_value   | Numeric   | Value of the score                                                                      |
| seller\_id     | Integer   | Seller ID                                                                               |
| download\_date | Date      | Download Date                                                                           |

### MarketPlace Reconciliation On SKU

Table name:  marketplace\_reconciliation\_on\_sku

For complete documentation, please click [here](https://developer.walmart.com/global-marketplace/reference/getallorders).

<table><thead><tr><th>Column Name</th><th width="239.4000244140625">Data type</th><th>Description</th></tr></thead><tbody><tr><td>account_id</td><td>Integer</td><td>Intentwise Account ID</td></tr><tr><td>account_name</td><td>String</td><td>Account Display Name</td></tr><tr><td>currency_code</td><td>String</td><td>One single currency for billing, budgeting, bid settings &#x26; campaign performance metrics</td></tr><tr><td>country_code</td><td>String</td><td>Countries associated with the account</td></tr><tr><td>seller_id</td><td>Integer</td><td>Selling Partner ID</td></tr><tr><td>recon_date</td><td>Date</td><td>Date on which reconciliation report is available for download.</td></tr><tr><td>transaction_type</td><td>String</td><td>Indicates a debit or a credit Reserve: Funds debited from your account to cover for future refunds Release Reserve: Funds credited against a previous account reserve Sale: Transactions credited to your account for the orders shipped in each payment period Refund: Transactions refunded against a sale order Dispute Settlement: Adjustments credited or debited as part of dispute resolution Adjustment: A miscellaneous credit or debit made by Walmart to your account, including receiving error chargeback, damage in warehouse, lost inventory, and found inventory Service Fee: Debits applied to your account as payment for different Walmart services, including WFS fulfillment fee, storage fee, and more</td></tr><tr><td>transaction_description</td><td>String</td><td>Reason for the debit or credit</td></tr><tr><td>transaction_posted_timestamp</td><td>Date</td><td>Date that the transaction was posted in our payment system</td></tr><tr><td>amount</td><td>Numeric</td><td>Amount that was credited or debited to your account for the transaction</td></tr><tr><td>amount_type</td><td>String</td><td>Reason for the amount transaction, such as product price, product tax, shipping, commission on product, and more</td></tr><tr><td>transaction_key</td><td>String</td><td>Identifier that Walmart uses to internally track the transactions in case a seller contacts our operations team</td></tr><tr><td>transaction_reason_description</td><td>String</td><td>Describes the reason for a refund. This is only available if transaction type is refund.</td></tr><tr><td>partner_item_id</td><td>String</td><td>SKU of the purchased item</td></tr><tr><td>partner_gtin</td><td>String</td><td>GTIN of the purchased item (if applicable)</td></tr><tr><td>partner_item_name</td><td>String</td><td>Name of your item as it appears on Walmart.com</td></tr><tr><td>product_tax_code</td><td>String</td><td>Item's tax code, used to calculate sales tax for the item</td></tr><tr><td>product_type</td><td>String</td><td>Type of item sold</td></tr><tr><td>customer_order</td><td>Integer</td><td>Order number that the Walmart customer gets. One order number can be associated with multiple transactions.</td></tr><tr><td>customer_order_line</td><td>Integer</td><td>Line item within the customer order number that uniquely identifies an order</td></tr><tr><td>purchase_order</td><td>Integer</td><td>Unique number assigned to a specific inbound order</td></tr><tr><td>purchase_order_line</td><td>Integer</td><td>Line item within the PO number of the particular SKU that was ordered</td></tr><tr><td>ship_qty</td><td>String</td><td>Number of items sold or refunded</td></tr><tr><td>ship_to_state</td><td>String</td><td>Customer state where order was shipped</td></tr><tr><td>ship_to_city</td><td>String</td><td>Customer city where order was shipped</td></tr><tr><td>ship_to_zipcode</td><td>Integer</td><td>Customer zip code where order was shipped</td></tr><tr><td>shipping_method</td><td>String</td><td>Shipment speed chosen by the customer</td></tr><tr><td>fulfillment_type</td><td>String</td><td>Whether the item was seller-fulfilled or Walmart-fulfilled (WFS)</td></tr><tr><td>contract_category</td><td>String</td><td>Product category used to determine the commission for the item.</td></tr><tr><td>commission_rate</td><td>Numeric</td><td>Rate applied to your sale order, as determined by the contract category of the item</td></tr><tr><td>commission_rule</td><td>String</td><td>Dynamic commission rule ID (if applicable)</td></tr><tr><td>commission_saving</td><td>String</td><td>Discount on Referral Fee</td></tr><tr><td>commission_incentive_program</td><td>String</td><td>Program under which Discount was applied (Commission Incentive Program (Flash Deals/Custom Deals), Pricing Incentives (Competitive Adjusted Pricing, Reduced Referral Fee (BCAP), Pro Seller etc)</td></tr><tr><td>original_commission</td><td>String</td><td>Base Referral Fee</td></tr><tr><td>total_walmart_funded_savings_program</td><td>String</td><td>Total savings across Programs - WFS, Incentives, WMC etc.</td></tr><tr><td>download_date</td><td>Date</td><td>Download Date</td></tr></tbody></table>

### MarketPlace Reconciliation On Account

Table name:  marketplace\_reconciliation\_on\_account

For complete documentation, please click [here](https://developer.walmart.com/global-marketplace/reference/getallorders).

<table><thead><tr><th>Column Name</th><th width="245">Data type</th><th>Description</th></tr></thead><tbody><tr><td>account_id</td><td>Integer</td><td>Intentwise Account ID</td></tr><tr><td>account_name</td><td>String</td><td>Account Display Name</td></tr><tr><td>currency_code</td><td>String</td><td>One single currency for billing, budgeting, bid settings &#x26; campaign performance metrics</td></tr><tr><td>country_code</td><td>String</td><td>Countries associated with the account</td></tr><tr><td>seller_id</td><td>Integer</td><td>Selling Partner ID</td></tr><tr><td>recon_date</td><td>Date</td><td>Date on which reconciliation report is available for download.</td></tr><tr><td>period_start_date</td><td>Date</td><td>Report Start Date</td></tr><tr><td>period_end_date</td><td>Date</td><td>Report End Date</td></tr><tr><td>total_payable</td><td>Numeric</td><td>The net amount transferred to your payment processor account for this payment cycle. It’s the sum of all transactions reflected in Amount field</td></tr><tr><td>currency</td><td>String</td><td>Currency</td></tr><tr><td>transaction_type</td><td>String</td><td>Indicates a debit or a credit Reserve: Funds debited from your account to cover for future refunds Release Reserve: Funds credited against a previous account reserve Sale: Transactions credited to your account for the orders shipped in each payment period Refund: Transactions refunded against a sale order Dispute Settlement: Adjustments credited or debited as part of dispute resolution Adjustment: A miscellaneous credit or debit made by Walmart to your account, including receiving error chargeback, damage in warehouse, lost inventory, and found inventory Service Fee: Debits applied to your account as payment for different Walmart services, including WFS fulfillment fee, storage fee, and more</td></tr><tr><td>transaction_description</td><td>String</td><td>Reason for the debit or credit</td></tr><tr><td>transaction_posted_timestamp</td><td>Date</td><td>Date that the transaction was posted in our payment system</td></tr><tr><td>amount</td><td>Numeric</td><td>Amount that was credited or debited to your account for the transaction</td></tr><tr><td>amount_type</td><td>String</td><td>Reason for the amount transaction, such as product price, product tax, shipping, commission on product, and more</td></tr><tr><td>campaign_id</td><td>String</td><td>Campaign Name for Walmart Connect sellers</td></tr><tr><td>download_date</td><td>Date</td><td>Download Date</td></tr></tbody></table>