Marketplace Reports

MarketPlace Order LineItem

Table name: marketplace_orderlineitem

For complete documentation, please click here.

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

MarketPlace Order LineItemCharge

Table name: marketplace_orderlineitemcharge

For complete documentation, please click here.

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
purchase_order_id	string	A unique ID associated with the seller's purchase order
customer_order_id	string	The customer order ID
sku	string	A seller-provided Product ID
currency	string	Currency
charge_type	string	The charge type for line items can be one of the following: PRODUCT or SHIPPING
charge_name	string	If chargeType is PRODUCT, chargeName is ItemPrice. If chargeType is PRODUCT and includes a chargeName as SubscriptionDiscount
amount	integer	The details for the amount of the tax charge
tax_name	string	The name associated with the tax.
tax_amount	integer	The details for the amount of the tax charge
seller_id	integer	Seller ID of the seller
line_number	string	Line Number
download_date	timestamp	Download Date

MarketPlace Order LineItemRefundCharge

Table name: marketplace_orderlineitemrefundcharge

For complete documentation, please click here.

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
purchase_order_id	string	A unique ID associated with the seller's purchase order
customer_order_id	string	The customer order ID
line_number	string	Line Number
refund_id	string	Refund ID
refund_reason	string	Reason of refund
charge_type	string	The charge type for line items can be one of the following: PRODUCT or SHIPPING
charge_name	string	If chargeType is PRODUCT, chargeName is ItemPrice. If chargeType is PRODUCT and includes a chargeName as SubscriptionDiscount
charge_amount	integer	The details for the amount of the tax charge
tax_name	string	The name associated with the tax.
tax_amount	integer	The details for the amount of the tax charge
currency	string	Currency
download_date	timestamp	Download Date
seller_id	integer	Unique Seller ID of the Seller

MarketPlace Order LineItemStatus

Table name: marketplace_orderlineitemstatus

For complete documentation, please click here.

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
purchase_order_id	string	A unique ID associated with the seller's purchase order
customer_order_id	string	The customer order ID
line_number	string	Line Number
status	string	Status
statusquantity_amount	integer	The quantity of the unit of measurement for the item.
statusquantity_unit_of_measurement	string	Unit of quantity
cancellation_reason	string	If order is cancelled, cancellationReason will explain the reason
trackinginfo_ship_date_time	timestamp	List of information about the package shipment and tracking updates
trackinginfo_method_code	string	List of information about the package shipment and tracking updates
trackinginfo_tracking_number	string	List of information about the package shipment and tracking updates
trackinginfo_tracking_url	string	List of information about the package shipment and tracking updates
carriername_other_carrier	string	List of information about the package shipment and tracking updates
carriername_carrier	string	List of information about the package shipment and tracking updates
returncenteraddress_name	string	Gives Sellers the ability to specify the RC center address during fulfillment
returncenteraddress_address1	string	Gives Sellers the ability to specify the RC center address during fulfillment
returncenteraddress_address2	string	Gives Sellers the ability to specify the RC center address during fulfillment
returncenteraddress_city	string	Gives Sellers the ability to specify the RC center address during fulfillment
returncenteraddress_state	string	Gives Sellers the ability to specify the RC center address during fulfillment
returncenteraddress_postal_code	string	Gives Sellers the ability to specify the RC center address during fulfillment
returncenteraddress_country	string	Gives Sellers the ability to specify the RC center address during fulfillment
returncenteraddress_day_phone	string	Gives Sellers the ability to specify the RC center address during fulfillment
returncenteraddress_email_id	string	Gives Sellers the ability to specify the RC center address during fulfillment
download_date	timestamp	Download Date
seller_id	integer	Unique Seller ID of the Seller

MarketPlace Order PickupPerson

Table name: marketplace_orderpickupperson

For complete documentation, please click here.

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
purchase_order_id	string	A unique ID associated with the seller's purchase order
customer_order_id	string	The customer order ID
complete_name	string	Details of the pickup person
first_name	string	Details of the pickup person
middle_name	string	Details of the pickup person
last_name	string	Details of the pickup person
general_suffix	string	Details of the pickup person
maturity_suffix	string	Details of the pickup person
title_of_respect	string	Details of the pickup person
empty	string
phone_id	string	Details of the pickup person
phone_area_code	string	Details of the pickup person
phone_extension	string	Details of the pickup person
phone_complete_number	string	Details of the pickup person
phone_type	string	Details of the pickup person
phone_subscriber_number	string	Details of the pickup person
phone_country_code	string	Details of the pickup person
phonevalidity_validation_type	string	Details of the pickup person
phonevalidity_validation_status	string	Details of the pickup person
phonevalidity_validated_date	timestamp	Details of the pickup person
phonevalidity_validated_by	string	Details of the pickup person
download_date	timestamp	Download Date
seller_id	integer	Unique Seller ID of the Seller

MarketPlace Order SubTotal

Table name: marketplace_ordersubtotal

For complete documentation, please click here.

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
purchase_order_id	string	A unique ID associated with the seller's purchase order
customer_order_id	string	The customer order ID
sub_total_type	string	Total type
currency	string	Currency Unit
subtotal_amount	integer	Total Amount
download_date	timestamp	Download Date
seller_id	integer	Unique Seller ID of the Seller