Walmart Marketplace

Explore the interactive ERD

Table & Field Reference

product_identifier

Column	Type	Keys
`product_id`	Unknown	PK
`feed_id`	Unknown	PKFK
`feed_item_detail_index`	Unknown	PKFK
`product_id_type`	Unknown

feed_item_detail

Column	Type	Keys
`index`	Unknown	PK
`feed_id`	Unknown	PKFK
`ingestion_status`	Unknown
`itemid`	Unknown
`mart_id`	Unknown
`sku`	Unknown
`wpid`	Unknown

feed_item_status

Column	Type	Keys
`feed_id`	Unknown	PKFK
`additional_attribute`	Unknown
`feed_status`	Unknown
`feed_submission_date`	Unknown
`ingestion_error`	Unknown
`items_failed`	Unknown
`items_processing`	Unknown
`items_received`	Unknown
`items_succeeded`	Unknown
`submitted_by`	Unknown

inbound_shipment_item

Column	Type	Keys
`shipment_id`	Unknown	PKFK
`sku`	Unknown	PKFK
`damaged_qty`	Unknown
`expected_delivery_date`	Unknown
`fill_rate`	Unknown
`gtin`	Unknown
`inbound_order_id`	Unknown
`inner_pack_quantity`	Unknown
`item_desc`	Unknown
`item_quantity`	Unknown
`received_qty`	Unknown
`updated_expected_delivery_date`	Unknown
`vendor_pack_quantity`	Unknown

wfs_inventory_log

Column	Type	Keys
`id`	Unknown	PK
`gtin`	Unknown	PKFK
`changed_unit`	Unknown
`fc_name`	Unknown
`shipment_id`	Unknown
`transaction_location`	Unknown
`transaction_reason_code`	Unknown
`transaction_reason_desc`	Unknown
`transaction_time`	Unknown
`transaction_type`	Unknown

wfs_inventory_log_payload

Column	Type	Keys
`gtin`	Unknown	PKFK
`product_name`	Unknown
`vendor_sku`	Unknown

distributor_supported_service

Column	Type	Keys
`distributor_supported_service`	Unknown	PK
`ship_node`	Unknown	PKFK

two_day_shipping_detail

Column	Type	Keys
`index`	Unknown	PK
`fulfillment_center_ship_node`	Unknown	PKFK
`carrier_method_name`	Unknown
`carrier_method_type`	Unknown

calendar_day_configuration

Column	Type	Keys
`index`	Unknown	PK
`ship_node`	Unknown	PKFK
`additional_days_off`	Unknown
`carrier_weekend_calendar_saturday_working_day`	Unknown
`carrier_weekend_calendar_sunday_working_day`	Unknown
`standard_processing_schedule_friday_cut_off_time`	Unknown
`standard_processing_schedule_friday_is_working_day`	Unknown
`standard_processing_schedule_monday_cut_off_time`	Unknown
`standard_processing_schedule_monday_is_working_day`	Unknown
`standard_processing_schedule_saturday_cut_off_time`	Unknown
`standard_processing_schedule_saturday_is_working_day`	Unknown
`standard_processing_schedule_sunday_cut_off_time`	Unknown
`standard_processing_schedule_sunday_is_working_day`	Unknown
`standard_processing_schedule_thursday_cut_off_time`	Unknown
`standard_processing_schedule_thursday_is_working_day`	Unknown
`standard_processing_schedule_tuesday_cut_off_time`	Unknown
`standard_processing_schedule_tuesday_is_working_day`	Unknown
`standard_processing_schedule_wednesday_cut_off_time`	Unknown
`standard_processing_schedule_wednesday_is_working_day`	Unknown

fulfillment_center

Column	Type	Keys
`ship_node`	Unknown	PK
`custom_node_id`	Unknown
`node_type`	Unknown
`postal_address_address_line_1`	Unknown
`postal_address_city`	Unknown
`postal_address_country`	Unknown
`postal_address_postal_code`	Unknown
`postal_address_state`	Unknown
`ship_node_name`	Unknown
`status`	Unknown
`time_zone`	Unknown

fulfillment_order_line_quantity_info

Column	Type	Keys
`index`	Unknown	PK
`fulfillment_order_line_index`	Unknown	PKFK
`seller_order_id`	Unknown	PKFK
`status`	Unknown
`status_description`	Unknown
`status_measurement_value`	Unknown
`status_unit_of_measure`	Unknown

fulfillment_order_line

Column	Type	Keys
`index`	Unknown	PK
`seller_order_id`	Unknown	PKFK
`address_type`	Unknown
`addressline_one`	Unknown
`addressline_two`	Unknown
`city`	Unknown
`complete_name`	Unknown
`country_code`	Unknown
`first_name`	Unknown
`fulfillment_type`	Unknown
`last_modified`	Unknown
`last_name`	Unknown
`order_product_name`	Unknown
`ordered_quantity_measure_unit`	Unknown
`ordered_quantity_measurement_value`	Unknown
`postal_code`	Unknown
`shipping_method`	Unknown
`shipping_tier`	Unknown
`state_or_province_code`	Unknown
`state_or_province_name`	Unknown

fulfillment_order_shipment_line

Column	Type	Keys
`index`	Unknown	PK
`seller_order_id`	Unknown	PKFK
`shipment_no`	Unknown	PKFK
`fulfiller_line_id`	Unknown
`measurement_value`	Unknown
`shipment_line_no`	Unknown
`unit_of_measure`	Unknown

fulfillment_order_shipment_date

Column	Type	Keys
`index`	Unknown	PK
`seller_order_id`	Unknown	PKFK
`shipment_no`	Unknown	PKFK
`actual_date`	Unknown
`datetype_id`	Unknown
`expected_date`	Unknown

fulfillment_order_shipment

Column	Type	Keys
`shipment_no`	Unknown	PK
`seller_order_id`	Unknown	PKFK
`actual_shipment_date`	Unknown
`carrier_description`	Unknown
`carrier_service_code`	Unknown
`external_tracking_url`	Unknown
`last_modified`	Unknown
`package_asn`	Unknown
`package_id`	Unknown
`purchase_order_id`	Unknown
`scac`	Unknown
`status`	Unknown
`status_description`	Unknown
`tracking_no`	Unknown

fulfillment_order_status

Column	Type	Keys
`seller_order_id`	Unknown	PK
`buyer_first_name`	Unknown
`buyer_last_name`	Unknown
`order_channel_id`	Unknown
`order_date`	Unknown
`order_type`	Unknown
`status`	Unknown

unpublished_item

Column	Type	Keys
`_fivetran_id`	String	PK
`gtin`	Unknown	FK
`sku`	Unknown	FK
`brand`	Unknown
`conversion_rate`	Unknown
`customer_rating`	Unknown
`gmv_amount`	Unknown
`gmv_amount_currency`	Unknown
`item_id`	Unknown
`lifecycle_status`	Unknown
`market_price_amount`	Unknown
`market_price_currency`	Unknown
`market_trending`	Unknown
`offer_end_date`	Unknown
`offer_start_date`	Unknown
`page_view`	Unknown
`price_amount`	Unknown
`price_currency`	Unknown
`product_name`	Unknown
`product_type`	Unknown
`publish_status`	Unknown
`unpublish_reason`	Unknown
`unpublished_date`	Unknown

order_line_status

Column	Type	Keys
`index`	Unknown	PK
`order_line_index`	Unknown	PKFK
`purchase_order_id`	Unknown	PKFK
`cancellation_reason`	Unknown
`return_center_address`	Unknown
`return_center_address_address_1`	Unknown
`return_center_address_address_2`	Unknown
`return_center_address_city`	Unknown
`return_center_address_country`	Unknown
`return_center_address_email_id`	Unknown
`return_center_address_name`	Unknown
`return_center_address_postal_code`	Unknown
`return_center_address_state`	Unknown
`status`	Unknown
`status_quantity_amount`	Unknown
`status_quantity_unit_of_measurement`	Unknown
`sub_seller_id`	Unknown
`tracking_info_carrier_name`	Unknown
`tracking_info_method_code`	Unknown
`tracking_info_ship_date_time`	Unknown
`tracking_info_tracking_number`	Unknown
`tracking_info_tracking_url`	Unknown

orders

Column	Type	Keys
`purchase_order_id`	Unknown	PK
`buyer_id`	Unknown
`customer_email_id`	Unknown
`customer_order_id`	Unknown
`is_guest`	Unknown
`mart`	Unknown
`order_date`	Unknown
`order_type`	Unknown
`original_customer_order_id`	Unknown
`payment_type`	Unknown
`ship_node_id`	Unknown
`ship_node_name`	Unknown
`ship_node_type`	Unknown
`shipnode_type`	Unknown
`shipping_info_estimated_delivery_date`	Unknown
`shipping_info_estimated_ship_date`	Unknown
`shipping_info_method_code`	Unknown
`shipping_info_phone`	Unknown
`shipping_info_postal_address_address_1`	Unknown
`shipping_info_postal_address_address_2`	Unknown
`shipping_info_postal_address_address_type`	Unknown
`shipping_info_postal_address_city`	Unknown
`shipping_info_postal_address_country`	Unknown
`shipping_info_postal_address_name`	Unknown
`shipping_info_postal_address_postal_code`	Unknown
`shipping_info_postal_address_state`	Unknown

order_line

Column	Type	Keys
`index`	Unknown	PK
`purchase_order_id`	Unknown	PKFK
`item_sku`	Unknown	FK
`return_order_id`	Unknown	FK
`config_id`	Unknown
`fulfillment_fulfillment_option`	Unknown
`fulfillment_pickup_by`	Unknown
`fulfillment_pickup_date_time`	Unknown
`fulfillment_ship_method`	Unknown
`fulfillment_shipping_programtype`	Unknown
`fulfillment_store_id`	Unknown
`intent_to_cancel`	Unknown
`item_condition`	Unknown
`item_image_url`	Unknown
`item_product_name`	Unknown
`item_weight_unit`	Unknown
`item_weight_value`	Unknown
`line_number`	Unknown
`orderlinequantity_amount`	Unknown
`orderlinequantity_unitof_measurement`	Unknown
`reference_line_id`	Unknown
`refund_comment`	Unknown
`refund_id`	Unknown
`seller_order_id`	Unknown
`serial_number`	Unknown
`status_date`	Unknown

order_pickup_person

Column	Type	Keys
`index`	Unknown	PK
`purchase_order_id`	Unknown	PKFK
`name_complete_name`	Unknown
`name_empty`	Unknown
`name_first_name`	Unknown
`name_general_suffix`	Unknown
`name_last_name`	Unknown
`name_maturity_suffix`	Unknown
`name_middle_name`	Unknown
`name_title_of_respect`	Unknown
`phone_area_code`	Unknown
`phone_complete_number`	Unknown
`phone_country_code`	Unknown
`phone_extension`	Unknown
`phone_id`	Unknown
`phone_subscriber_number`	Unknown
`phone_type`	Unknown
`phone_validity_validated_by`	Unknown
`phone_validity_validated_date`	Unknown
`phone_validity_validation_status`	Unknown
`phone_validity_validation_type`	Unknown

order_line_refund_charge

Column	Type	Keys
`index`	Unknown	PK
`order_line_index`	Unknown	PKFK
`purchase_order_id`	Unknown	PKFK
`charge_amount`	Unknown
`charge_amount_currency`	Unknown
`charge_name`	Unknown
`charge_type`	Unknown
`refund_reason`	Unknown
`tax_amount`	Unknown
`tax_name`	Unknown
`taxamount_currency`	Unknown

order_line_charge

Column	Type	Keys
`index`	Unknown	PK
`order_line_index`	Unknown	PKFK
`purchase_order_id`	Unknown	PKFK
`charge_amount`	Unknown
`charge_amount_currency`	Unknown
`charge_name`	Unknown
`charge_type`	Unknown
`tax_amount`	Unknown
`tax_name`	Unknown
`taxamount_currency`	Unknown

label_detail_box_item

Column	Type	Keys
`sku`	Unknown	PK
`purchase_order_id`	Unknown	PKFK
`line_number`	Unknown
`quantity`	Unknown

label_detail_add_on

Column	Type	Keys
`index`	Unknown	PK
`purchase_order_id`	Unknown	PKFK
`charge_amount`	Unknown
`charge_currency`	Unknown
`declared_amount`	Unknown
`declared_currency`	Unknown
`name`	Unknown
`ref_link`	Unknown
`status`	Unknown

label_detail_by_purchase_order

Column	Type	Keys
`purchase_order_id`	Unknown	PKFK
`carrier_full_name`	Unknown
`carrier_name`	Unknown
`carrier_service_type`	Unknown
`tracking_no`	Unknown
`tracking_url`	Unknown

item_unpublished_reason

Column	Type	Keys
`index`	Unknown	PK
`sku`	Unknown	PKFK
`unpublished_reason`	Unknown

item_additional_attribute_value

Column	Type	Keys
`index`	Unknown	PK
`item_additional_attribute_index`	Unknown	PKFK
`sku`	Unknown	PKFK
`groups`	Unknown
`is_variant`	Unknown
`rank`	Unknown
`source`	Unknown
`value`	Unknown

item_additional_attribute

Column	Type	Keys
`index`	Unknown	PK
`sku`	Unknown	PKFK
`is_variant`	Unknown
`name`	Unknown
`type`	Unknown
`variant_resource_type`	Unknown

item

Column	Type	Keys
`sku`	Unknown	PK
`condition`	Unknown
`gtin`	Unknown
`lifecycle_status`	Unknown
`mart`	Unknown
`price_amount`	Unknown
`price_currency`	Unknown
`product_name`	Unknown
`product_type`	Unknown
`published_status`	Unknown
`shelf`	Unknown
`upc`	Unknown
`variant_group_id`	Unknown
`variant_group_info_grouping_attributes_name`	Unknown
`variant_group_info_grouping_attributes_value`	Unknown
`variant_group_info_is_primary`	Unknown
`variant_group_info_primary`	Unknown
`wpid`	Unknown

shipment_package

Column	Type	Keys
`index`	Unknown	PK
`carrier_rate_quote_quote_id`	Unknown	PKFK
`assessorial_charge`	Unknown
`billing_weight`	Unknown
`height`	Unknown
`label_information_ep_tracker_id`	Unknown
`label_information_label_data`	Unknown
`label_information_label_format`	Unknown
`label_information_master`	Unknown
`label_information_master_tracking_code`	Unknown
`label_information_package_asn`	Unknown
`label_information_reference_tracking_code`	Unknown
`label_information_shipment_id`	Unknown
`label_information_tracking_code`	Unknown
`length`	Unknown
`length_uom`	Unknown
`net_charge`	Unknown
`no_of_package`	Unknown
`nominal_charge`	Unknown
`package_sequence_number`	Unknown
`package_type`	Unknown
`service_charge`	Unknown
`stackable`	Unknown
`weight`	Unknown
`weight_uom`	Unknown
`width`	Unknown

carrier_rate_quote

Column	Type	Keys
`quote_id`	Unknown	PK
`shipment_id`	Unknown	FK
`carrier_id`	Unknown
`carrier_name`	Unknown
`destination_location_address_address_line_1`	Unknown
`destination_location_address_address_line_2`	Unknown
`destination_location_address_city`	Unknown
`destination_location_address_country_code`	Unknown
`destination_location_address_phone`	Unknown
`destination_location_address_postal_code`	Unknown
`destination_location_address_state_code`	Unknown
`destination_location_location_id`	Unknown
`destination_location_location_name`	Unknown
`origin_location_address_address_line_1`	Unknown
`origin_location_address_address_line_2`	Unknown
`origin_location_address_city`	Unknown
`origin_location_address_country_code`	Unknown
`origin_location_address_phone`	Unknown
`origin_location_address_postal_code`	Unknown
`origin_location_address_state_code`	Unknown
`origin_location_location_id`	Unknown
`origin_location_location_name`	Unknown
`quote_creation_date`	Unknown
`rate_quote_assessorial_charge`	Unknown
`rate_quote_currency`	Unknown
`rate_quote_declared_value`	Unknown
`rate_quote_discount_charge`	Unknown
`rate_quote_effective_date`	Unknown
`rate_quote_equipment_type_code`	Unknown
`rate_quote_estimated_delivery_date_time`	Unknown
`rate_quote_expiry_date`	Unknown
`rate_quote_freight_charge`	Unknown
`rate_quote_freight_ready_date`	Unknown
`rate_quote_fuel_charge`	Unknown
`rate_quote_minimum_charge`	Unknown
`rate_quote_mixed_sku`	Unknown
`rate_quote_mode`	Unknown
`rate_quote_net_charge`	Unknown
`rate_quote_nominal_charge`	Unknown
`rate_quote_number_of_pallet`	Unknown
`rate_quote_seller_freight_classcode`	Unknown
`rate_quote_service_charge`	Unknown
`rate_quote_service_code`	Unknown
`rate_quote_single_sku`	Unknown
`rate_quote_status`	Unknown
`rate_quote_sur_charge_type`	Unknown
`rate_quote_sur_charge_value`	Unknown
`rate_quote_total_billing_weight`	Unknown
`rate_quote_total_volume`	Unknown
`rate_quote_total_weight`	Unknown
`rate_quote_transit_day`	Unknown
`return_location_address_address_line_1`	Unknown
`return_location_address_address_line_2`	Unknown
`return_location_address_city`	Unknown
`return_location_address_country_code`	Unknown
`return_location_address_phone`	Unknown
`return_location_address_postal_code`	Unknown
`return_location_address_state_code`	Unknown
`return_location_location_name`	Unknown

shipping_configuration_category

Column	Type	Keys
`index`	Unknown	PK
`shipping_configuration_fivetran_id`	Unknown	PKFK
`shipping_detail_index`	Unknown	PKFK
`fulfillment_lag_time`	Unknown
`name`	Unknown

shipping_configuration_detail

Column	Type	Keys
`index`	Unknown	PK
`shipping_configuration_fivetran_id`	Unknown	PKFK
`configuration_name`	Unknown

shipping_configuration

Column	Type	Keys
`_fivetran_id`	String	PK
`partner_id`	Unknown	FK
`business_reg_number`	Unknown
`country_of_incorporation`	Unknown
`partner_display_name`	Unknown
`partner_name`	Unknown
`partner_store_id`	Unknown

lag_time

Column	Type	Keys
`_fivetran_id`	String	PK
`sku`	Unknown	FK
`fulfillment_lag_time`	Unknown

simulation_result

Column	Type	Keys
`_fivetran_id`	String	PK
`rule_id`	Unknown	FK
`rule_status`	Unknown
`simulation_count`	Unknown

inbound_shipment_error

Column	Type	Keys
`index`	Unknown	PK
`inbound_order_id`	Unknown	PKFK
`category`	Unknown
`code`	Unknown
`description`	Unknown
`field`	Unknown
`info`	Unknown
`severity`	Unknown

add_on_service

Column	Type	Keys
`index`	Unknown	PK
`inbound_order_id`	Unknown	PKFK
`product_id`	Unknown	PKFK
`add_on_service`	Unknown

dimension

Column	Type	Keys
`dimension`	Unknown	PK
`inbound_order_id`	Unknown	PKFK

inbound_shipment_order_item

Column	Type	Keys
`product_id`	Unknown	PK
`inbound_order_id`	Unknown	PKFK
`expected_delivery_date`	Unknown
`inner_pack_quantity`	Unknown
`item_desc`	Unknown
`item_nbr`	Unknown
`item_quantity`	Unknown
`non_sort_item`	Unknown
`product_type`	Unknown
`ship_node`	Unknown
`sku`	Unknown
`vendor_pack_quantity`	Unknown

inbound_shipment_error_payload

Column	Type	Keys
`inbound_order_id`	Unknown	PKFK
`created_date`	Unknown
`return_address_address_line_1`	Unknown
`return_address_address_line_2`	Unknown
`return_address_city`	Unknown
`return_address_country_code`	Unknown
`return_address_postal_code`	Unknown
`return_address_state_code`	Unknown

quality_issue_product_type

Column	Type	Keys
`index`	Unknown	PK
`category`	Unknown	PKFK
`offer_count`	Unknown
`product_type_name`	Unknown

item_count_listing_quality_issue

Column	Type	Keys
`category`	Unknown	PK
`name`	Unknown
`offer_count`	Unknown

third_party_fulfillment_provider

Column	Type	Keys
`ship_node`	Unknown	PKFK
`ship_node_name`	Unknown

price_incentive

Column	Type	Keys
`incentive_status`	Unknown	PK
`sku_id`	Unknown	PKFK
`base_referral_fee`	Unknown
`current_price`	Unknown
`enrollment_date`	Unknown
`enrollment_type`	Unknown
`expiration_date`	Unknown
`incentive_id`	Unknown
`incentive_type`	Unknown
`inventory_count`	Unknown
`item_id`	Unknown
`offer_id`	Unknown
`product_image_url`	Unknown
`product_name`	Unknown
`product_url`	Unknown
`reduced_referral_fee`	Unknown
`shipping_price`	Unknown
`start_date`	Unknown
`target_price`	Unknown

coverage_area

Column	Type	Keys
`coverage_area`	Unknown	PK
`ship_node`	Unknown	PKFK

fulfillment_center_coverage

Column	Type	Keys
`ship_node`	Unknown	PKFK
`shipnode_name`	Unknown

top_trending_item

Column	Type	Keys
`item_id`	Unknown	PK
`taxanomy_department_department_id`	Unknown	FK
`brand`	Unknown
`category_name`	Unknown
`department_name`	Unknown
`exists_for_seller`	Unknown
`is_two_day_eligible`	Unknown
`isbn`	Unknown
`issn`	Unknown
`product_name`	Unknown
`rank`	Unknown
`sub_category_name`	Unknown
`super_department_name`	Unknown
`total_offer`	Unknown

return_line

Column	Type	Keys
`index`	Unknown	PK
`customer_order_id`	Unknown	PKFK
`return_id`	Unknown	PKFK
`return_line_group_index`	Unknown	PKFK
`return_order_line_number`	Unknown

return_line_group_carrier_info_list

Column	Type	Keys
`carrier_id`	Unknown	PK
`customer_order_id`	Unknown	PKFK
`return_id`	Unknown	PKFK
`return_line_group_index`	Unknown	PKFK
`return_line_label_index`	Unknown	PKFK
`carrier_name`	Unknown
`service_type`	Unknown
`tracking_no`	Unknown

return_line_label

Column	Type	Keys
`index`	Unknown	PK
`customer_order_id`	Unknown	PKFK
`return_id`	Unknown	PKFK
`return_line_group_index`	Unknown	PKFK
`label_image_url`	Unknown

return_line_group

Column	Type	Keys
`index`	Unknown	PK
`customer_order_id`	Unknown	PKFK
`return_id`	Unknown	PKFK
`group_no`	Unknown
`return_expected_flag`	Unknown

return_order_line_charge_tax

Column	Type	Keys
`index`	Unknown	PK
`return_id`	Unknown	PKFK
`return_order_line_charge_index`	Unknown	PKFK
`return_order_line_index`	Unknown	PKFK
`excess_tax_currency_amount`	Unknown
`excess_tax_currency_unit`	Unknown
`tax_name`	Unknown
`tax_per_unit_currency_amount`	Unknown
`tax_per_unit_currency_unit`	Unknown

return_order_line_charge_reference

Column	Type	Keys
`index`	Unknown	PK
`return_id`	Unknown	PKFK
`return_order_line_charge_index`	Unknown	PKFK
`return_order_line_index`	Unknown	PKFK
`name`	Unknown
`value`	Unknown

return_order_line_charge

Column	Type	Keys
`index`	Unknown	PK
`return_id`	Unknown	PKFK
`return_order_line_index`	Unknown	PKFK
`charge_category`	Unknown
`charge_name`	Unknown
`chargeperunit_currency_amount`	Unknown
`chargeperunit_currency_unit`	Unknown
`excess_charge_currency_amount`	Unknown
`excess_charge_currency_unit`	Unknown
`is_billable`	Unknown
`is_discount`	Unknown

return_order_line_charge_total

Column	Type	Keys
`index`	Unknown	PK
`return_id`	Unknown	PKFK
`return_order_line_index`	Unknown	PKFK
`currency_amount`	Unknown
`currency_unit`	Unknown
`name`	Unknown

return_order_line_refund_channel

Column	Type	Keys
`index`	Unknown	PK
`return_id`	Unknown	PKFK
`return_order_line_index`	Unknown	PKFK
`quantity_measurement_value`	Unknown
`refund_channel_name`	Unknown

return_order_line_tracking_reference

Column	Type	Keys
`index`	Unknown	PK
`return_id`	Unknown	PKFK
`return_order_line_index`	Unknown	PKFK
`return_order_line_tracking_detail_index`	Unknown	PKFK
`name`	Unknown
`value`	Unknown

return_order_line_tracking_detail

Column	Type	Keys
`index`	Unknown	PK
`return_id`	Unknown	PKFK
`return_order_line_index`	Unknown	PKFK
`event_description`	Unknown
`event_tag`	Unknown
`event_time`	Unknown
`sequence_no`	Unknown

return_order_line_current_tracking_status

Column	Type	Keys
`index`	Unknown	PK
`return_id`	Unknown	PKFK
`return_order_line_index`	Unknown	PKFK
`current_refund_status`	Unknown
`quantity_measurement_value`	Unknown
`quantity_unit_of_measure`	Unknown
`status`	Unknown
`status_time`	Unknown

return_order_line

Column	Type	Keys
`index`	Unknown	PK
`return_id`	Unknown	PKFK
`purchase_order_id`	Unknown	FK
`seller_order_id`	Unknown	FK
`cancellable_qty`	Unknown
`current_delivery_status`	Unknown
`current_refund_status`	Unknown
`exception_item_type`	Unknown
`is_fast_replacement`	Unknown
`is_keep_it`	Unknown
`is_return_for_exception`	Unknown
`item_condition`	Unknown
`item_product_name`	Unknown
`item_sku`	Unknown
`item_weight_measurement_value`	Unknown
`item_weight_unit_of_measure`	Unknown
`last_item`	Unknown
`purchase_order_line_number`	Unknown
`quantity_measurement_value`	Unknown
`quantity_unit_of_measure`	Unknown
`recharge_reason`	Unknown
`rechargeable_qty`	Unknown
`refund_channel`	Unknown
`refunded_qty`	Unknown
`return_cancellation_reason`	Unknown
`return_expected_flag`	Unknown
`return_order_line_number`	Unknown
`return_reason`	Unknown
`sales_order_line_number`	Unknown
`status`	Unknown
`status_time`	Unknown
`unit_price_currency_amount`	Unknown
`unit_price_currency_unit`	Unknown

return

Column	Type	Keys
`id`	Unknown	PK
`customer_order_id`	Unknown	PKFK
`customer_email_id`	Unknown
`customer_first_name`	Unknown
`customer_last_name`	Unknown
`refund_mode`	Unknown
`replacement_customer_order_id`	Unknown
`return_by_date`	Unknown
`return_order_date`	Unknown
`returnchannel_name`	Unknown
`total_refund_currency_amount`	Unknown
`total_refund_currency_unit`	Unknown

item_taxonomy_subcategory

Column	Type	Keys
`sub_category_id`	Unknown	PK
`item_taxonomy_category_id`	Unknown	PKFK
`sub_category_name`	Unknown

item_taxonomy

Column	Type	Keys
`category_id`	Unknown	PK
`category_name`	Unknown

partner_throttle_configuration

Column	Type	Keys
`index`	Unknown	PK
`partner_id`	Unknown	PKFK
`filesize_unitofmeasurement`	Unknown
`filesize_value`	Unknown
`rate_count`	Unknown
`replenish_timewindow_unitofmeasurement`	Unknown
`replenish_timewindow_value`	Unknown
`type`	Unknown

partner_configuration_value

Column	Type	Keys
`index`	Unknown	PK
`partner_id`	Unknown	PKFK
`feed_type`	Unknown

partner_configuration

Column	Type	Keys
`index`	Unknown	PK
`partner_id`	Unknown	PKFK
`configuration_name`	Unknown
`configuration_status`	Unknown

partner_configuration_detail

Column	Type	Keys
`partner_id`	Unknown	PK
`business_regnumber`	Unknown
`country_of_incorporation`	Unknown
`partner_display_name`	Unknown
`partner_name`	Unknown
`partner_store_id`	Unknown

shipment_tracking_no

Column	Type	Keys
`tracking_no`	Unknown	PK
`shipment_id`	Unknown	PKFK

shipment

Column	Type	Keys
`id`	Unknown	PK
`carrier_name`	Unknown
`created_date`	Unknown
`expected_delivery_date`	Unknown
`inbound_order_id`	Unknown
`received_unit`	Unknown
`return_address_address_line_1`	Unknown
`return_address_address_line_2`	Unknown
`return_address_city`	Unknown
`return_address_country_code`	Unknown
`return_address_postal_code`	Unknown
`return_address_state_code`	Unknown
`ship_to_address_address_line_1`	Unknown
`ship_to_address_city`	Unknown
`ship_to_address_country_code`	Unknown
`ship_to_address_fc_name`	Unknown
`ship_to_address_postal_code`	Unknown
`ship_to_address_state_code`	Unknown
`shipment_unit`	Unknown
`status`	Unknown
`updated_expected_delivery_date`	Unknown

rule_exception

Column	Type	Keys
`sku_id`	Unknown	PK

rule_area_state

Column	Type	Keys
`index`	Unknown	PK
`region_code`	Unknown	PKFK
`state_subregion_code`	Unknown
`state_subregion_name`	Unknown

rule_area

Column	Type	Keys
`region_code`	Unknown	PK
`region_name`	Unknown

taxanomy_department_category

Column	Type	Keys
`category_id`	Unknown	PK
`taxanomy_dept_id`	Unknown	PKFK
`category_name`	Unknown

taxanomy_department_payload

Column	Type	Keys
`department_id`	Unknown	PKFK
`department_name`	Unknown

performance_report

Column	Type	Keys
`partner_id`	Unknown	PKFK
`payload_14_day_cancellation_customer_fault`	Unknown
`payload_14_day_cancellation_seller_fault`	Unknown
`payload_14_day_otd`	Unknown
`payload_14_day_ots`	Unknown
`payload_14_day_refund_rate_customer_fault`	Unknown
`payload_14_day_refund_rate_seller_fault`	Unknown
`payload_14_day_vtr`	Unknown
`payload_30_day_cancellation_customer_fault`	Unknown
`payload_30_day_cancellation_seller_fault`	Unknown
`payload_30_day_otd`	Unknown
`payload_30_day_ots`	Unknown
`payload_30_day_refund_rate_customer_fault`	Unknown
`payload_30_day_refund_rate_seller_fault`	Unknown
`payload_30_day_vtr`	Unknown
`payload_60_day_cancellation_customer_fault`	Unknown
`payload_60_day_cancellation_seller_fault`	Unknown
`payload_60_day_otd`	Unknown
`payload_60_day_ots`	Unknown
`payload_60_day_refund_rate_customer_fault`	Unknown
`payload_60_day_refund_rate_seller_fault`	Unknown
`payload_60_day_vtr`	Unknown
`payload_7_day_cancellation_customer_fault`	Unknown
`payload_7_day_cancellation_seller_fault`	Unknown
`payload_7_day_otd`	Unknown
`payload_7_day_ots`	Unknown
`payload_7_day_refund_rate_customer_fault`	Unknown
`payload_7_day_refund_rate_seller_fault`	Unknown
`payload_7_day_vtr`	Unknown
`payload_90_day_cancellation_customer_fault`	Unknown
`payload_90_day_cancellation_seller_fault`	Unknown
`payload_90_day_otd`	Unknown
`payload_90_day_ots`	Unknown
`payload_90_day_refund_rate_customer_fault`	Unknown
`payload_90_day_refund_rate_seller_fault`	Unknown
`payload_90_day_vtr`	Unknown
`status`	Unknown

repricer_strategy

Column	Type	Keys
`index`	Unknown	PK
`collection_id`	Unknown	PKFK
`adjustment_type`	Unknown
`adjustment_value`	Unknown
`strategy_type`	Unknown

repricer_strategy_collection

Column	Type	Keys
`id`	Unknown	PK
`assigned_count`	Unknown
`enable_repricer_for_promotion`	Unknown
`enabled`	Unknown
`repricer_strategy`	Unknown

rule_condition

Column	Type	Keys
`index`	Unknown	PK
`rule_id`	Unknown	PKFK
`name`	Unknown
`operator`	Unknown
`value`	Unknown

rule_action_sub_region

Column	Type	Keys
`index`	Unknown	PK
`rule_action_index`	Unknown	PKFK
`sub_region_code`	Unknown	FK

rule_action

Column	Type	Keys
`index`	Unknown	PK
`rule_id`	Unknown	PKFK
`region_code`	Unknown	FK

rule

Column	Type	Keys
`id`	Unknown	PK
`description`	Unknown
`name`	Unknown
`priority`	Unknown
`rule_status`	Unknown
`sku_processing_status`	Unknown

inventory_node

Column	Type	Keys
`ship_node`	Unknown	PK
`inventory_sku`	Unknown	PKFK
`avail_tosell_quantity_amount`	Unknown
`avail_tosell_quantity_unit`	Unknown
`input_quantity_amount`	Unknown
`input_quantity_unit`	Unknown
`reserved_quantity_amount`	Unknown
`reserved_quantity_unit`	Unknown

inventory

Column	Type	Keys
`sku`	Unknown	PKFK

shipping_method_state_sub_region

Column	Type	Keys
`index`	Unknown	PK
`shipping_template_id`	Unknown	PKFK
`state_sub_region_index`	Unknown	PKFK
`state_subregion_code`	Unknown
`state_subregion_name`	Unknown

shipping_method_sub_region_state

Column	Type	Keys
`index`	Unknown	PK
`shipping_template_id`	Unknown	PKFK
`sub_region_index`	Unknown	PKFK
`state_code`	Unknown
`state_name`	Unknown

shipping_method_sub_region

Column	Type	Keys
`index`	Unknown	PK
`shipping_method_region_index`	Unknown	PKFK
`shipping_template_id`	Unknown	PKFK
`sub_region_code`	Unknown
`sub_region_name`	Unknown

shipping_method_region

Column	Type	Keys
`index`	Unknown	PK
`shiiping_configuration_index`	Unknown	PKFK
`shipping_template_id`	Unknown	PKFK
`region_code`	Unknown
`region_name`	Unknown

shipping_method_address_type

Column	Type	Keys
`address_type`	Unknown	PK
`shipping_configuration_index`	Unknown	PKFK
`template_id`	Unknown	PKFK

shipping_method_tiered_shipping_charge

Column	Type	Keys
`index`	Unknown	PK
`shipping_configuration_index`	Unknown	PKFK
`template_id`	Unknown	PKFK
`maximum_limit`	Unknown
`minimum_limit`	Unknown
`shipcharge_amount`	Unknown
`shipcharge_currency`	Unknown

shipping_method_configuration

Column	Type	Keys
`index`	Unknown	PK
`shipping_method_index`	Unknown	PKFK
`template_id`	Unknown	PKFK
`address_type`	Unknown
`per_shipping_charge_charge_per_item_amount`	Unknown
`per_shipping_charge_charge_per_item_currency`	Unknown
`per_shipping_charge_charge_per_weight_ammount`	Unknown
`per_shipping_charge_charge_per_weight_currency`	Unknown
`per_shipping_charge_shipping_and_handling_amount`	Unknown
`per_shipping_charge_shipping_and_handling_currency`	Unknown
`per_shipping_charge_unit_of_measure`	Unknown
`transit_time`	Unknown

shipping_method

Column	Type	Keys
`index`	Unknown	PK
`template_id`	Unknown	PKFK
`ship_method`	Unknown
`status`	Unknown

shipping_template

Column	Type	Keys
`id`	Unknown	PK
`created_by`	Unknown
`created_date`	Unknown
`modified_by`	Unknown
`modified_date`	Unknown
`name`	Unknown
`rate_model_type`	Unknown
`status`	Unknown
`type`	Unknown

seller_listing_quality_score

Column	Type	Keys
`_fivetran_id`	String	PK
`listing_quality`	Unknown
`overall_quality`	Unknown
`post_purchase_qualitydefect_ratio`	Unknown
`post_purchase_qualityitem_defect_count`	Unknown
`score_content_score`	Unknown
`score_offer_score`	Unknown
`score_rating_review_score`	Unknown

recon_report

Column	Type	Keys
`_fivetran_id`	String	PK
`available_report_date`	Unknown	FK
`amount`	Unknown
`amount_type`	Unknown
`commission_rule`	Unknown
`contract_category`	Unknown
`currency`	Unknown
`customer_order_line_no`	Unknown
`customer_order_no`	Unknown
`fulfillment_detail`	Unknown
`fulfillment_type`	Unknown
`partner_gtin`	Unknown
`partner_item_id`	Unknown
`partner_item_name`	Unknown
`period_end_date`	Unknown
`period_start_date`	Unknown
`product_tax_code`	Unknown
`product_type`	Unknown
`purchase_order_line_no`	Unknown
`purchase_order_no`	Unknown
`ship_quantity`	Unknown
`ship_to_city`	Unknown
`ship_to_state`	Unknown
`ship_to_zipcode`	Unknown
`shipping_method`	Unknown
`total_payable`	Unknown
`transaction_description`	Unknown
`transaction_key`	Unknown
`transaction_posted_timestamp`	Unknown
`transaction_type`	Unknown

payment_statement_report

Column	Type	Keys
`partner_id`	Unknown	PKFK
`error`	Unknown
`payload_closing_balance`	Unknown
`payload_hold_amount`	Unknown
`payload_hold_dates`	Unknown
`payload_last_updated_date`	Unknown
`payload_net_payable`	Unknown
`payload_opening_balance`	Unknown
`payload_order_activity`	Unknown
`payload_other_activities`	Unknown
`payload_outstanding_mca_balance`	Unknown
`payload_paid_to_you`	Unknown
`payload_partner_transaction_netpayable`	Unknown
`payload_partner_transaction_review`	Unknown
`payload_payment_processor`	Unknown
`payload_refund_commission_savings`	Unknown
`payload_refund_net_comm`	Unknown
`payload_refund_net_payable`	Unknown
`payload_refund_net_tax_collected`	Unknown
`payload_refund_net_tax_withheld`	Unknown
`payload_refund_pricing_adjustment`	Unknown
`payload_refund_product_price`	Unknown
`payload_refund_product_tax_collected`	Unknown
`payload_refund_product_tax_withheld`	Unknown
`payload_refund_shipping`	Unknown
`payload_refund_shipping_tax_collected`	Unknown
`payload_refund_shipping_tax_withheld`	Unknown
`payload_refund_total_base_commission`	Unknown
`payload_refund_total_sf_amt`	Unknown
`payload_reserve`	Unknown
`payload_reserve_to_date`	Unknown
`payload_return_ship_service_charge`	Unknown
`payload_sale_aggregate_commission_savings`	Unknown
`payload_sale_aggregate_net_comm`	Unknown
`payload_sale_aggregate_net_payable`	Unknown
`payload_sale_aggregate_net_tax_collected`	Unknown
`payload_sale_aggregate_net_tax_withheld`	Unknown
`payload_sale_aggregate_netfee_collected`	Unknown
`payload_sale_aggregate_pricing_adjustment`	Unknown
`payload_sale_aggregate_product_price`	Unknown
`payload_sale_aggregate_product_tax_collected`	Unknown
`payload_sale_aggregate_product_tax_withheld`	Unknown
`payload_sale_aggregate_shipping`	Unknown
`payload_sale_aggregate_shipping_tax_collected`	Unknown
`payload_sale_aggregate_shipping_tax_withheld`	Unknown
`payload_sale_aggregate_total_base_commission`	Unknown
`payload_sale_aggregate_total_s_f_amt`	Unknown
`payload_scheduled_settlement_date`	Unknown
`payload_seller_payment_status`	Unknown
`payload_seller_status`	Unknown
`payload_seller_store_front_url`	Unknown
`payload_settle_cycle`	Unknown
`payload_tenure`	Unknown
`payload_walmart_fulfillment_services`	Unknown
`payload_wfs_fullfillment_fee`	Unknown
`payload_wfs_inventory_removalfee`	Unknown
`payload_wfs_net_payable`	Unknown
`payload_wfs_return_shipping_fee`	Unknown
`payload_wfs_storagefee`	Unknown
`status`	Unknown
`status_code`	Unknown

available_report_date

Column	Type	Keys
`available_report_date`	Unknown	PK

carrier_method

Column	Type	Keys
`id`	Unknown	PK
`display_description`	Unknown
`method_name`	Unknown
`method_type`	Unknown

taxanomy_department

Column	Type	Keys
`department_id`	Unknown	PK
`taxanomy_super_dept_id`	Unknown	PKFK
`department_name`	Unknown

taxanomy_super_department

Column	Type	Keys
`super_department_id`	Unknown	PK
`super_department`	Unknown

feed_status

Column	Type	Keys
`feed_id`	Unknown	PK
`partner_id`	Unknown	FK
`batch_id`	Unknown
`channel_type`	Unknown
`feed_date`	Unknown
`feed_source`	Unknown
`feed_status`	Unknown
`feed_type`	Unknown
`file_name`	Unknown
`item_data_error_count`	Unknown
`item_system_error_count`	Unknown
`item_timeout_error_count`	Unknown
`items_failed`	Unknown
`items_processing`	Unknown
`items_received`	Unknown
`items_succeeded`	Unknown
`modified_dtm`	Unknown
`org_id`	Unknown

promotional_pricing

Column	Type	Keys
`index`	Unknown	PK
`sku`	Unknown	PKFK
`comparison_price_max_unit_value_amount`	Unknown
`comparison_price_max_unit_value_currency`	Unknown
`comparison_price_max_unit_value_value`	Unknown
`comparison_price_max_value_amount`	Unknown
`comparison_price_max_value_currency`	Unknown
`comparison_price_max_value_value`	Unknown
`comparison_price_min_unit_value_amount`	Unknown
`comparison_price_min_unit_value_currency`	Unknown
`comparison_price_min_unit_value_value`	Unknown
`comparison_price_min_value_amount`	Unknown
`comparison_price_min_value_currency`	Unknown
`comparison_price_min_value_value`	Unknown
`comparison_price_per_unit_value_amount`	Unknown
`comparison_price_per_unit_value_currency`	Unknown
`comparison_price_per_unit_value_value`	Unknown
`comparison_price_type`	Unknown
`comparison_price_uom_type`	Unknown
`comparison_price_value_amount`	Unknown
`comparison_price_value_currency`	Unknown
`current_price_max_unit_value_amount`	Unknown
`current_price_max_unit_value_currency`	Unknown
`current_price_max_unit_value_value`	Unknown
`current_price_max_value_amount`	Unknown
`current_price_max_value_currency`	Unknown
`current_price_max_value_value`	Unknown
`current_price_min_unit_value_amount`	Unknown
`current_price_min_unit_value_currency`	Unknown
`current_price_min_unit_value_value`	Unknown
`current_price_min_value_amount`	Unknown
`current_price_min_value_currency`	Unknown
`current_price_min_value_value`	Unknown
`current_price_per_unit_value_amount`	Unknown
`current_price_per_unit_value_currency`	Unknown
`current_price_per_unit_value_value`	Unknown
`current_price_type`	Unknown
`current_price_uom_type`	Unknown
`current_price_value_amount`	Unknown
`current_price_value_currency`	Unknown
`effective_date`	Unknown
`expiration_date`	Unknown
`pickup_discount_is_pickup_discount_eligible`	Unknown
`pickup_discount_pickup_discount_amount`	Unknown
`pickup_discount_pickup_discount_currency`	Unknown
`pickup_discount_pickup_discount_value`	Unknown
`pid`	Unknown
`price_display_codes_hide_price_for_soi`	Unknown
`price_display_codes_is_clearance`	Unknown
`price_display_codes_is_eligible_for_associate_discount`	Unknown
`price_display_codes_is_reduced_price`	Unknown
`price_display_codes_is_rollback`	Unknown
`price_display_codes_is_strikethrough`	Unknown
`price_display_codes_submap_type`	Unknown
`process_mode`	Unknown
`promo_id`	Unknown
`savings_amount`	Unknown
`savings_percent`	Unknown

promotional_price_additional_attribute

Column	Type	Keys
`index`	Unknown	PK
`sku`	Unknown	PKFK
`name`	Unknown
`value`	Unknown

promotional_price

Column	Type	Keys
`sku`	Unknown	PKFK
`item_id`	Unknown
`max_sales_retail_price_amount`	Unknown
`max_sales_retail_price_currency`	Unknown
`max_sales_retail_price_value`	Unknown
`min_advt_price`	Unknown
`min_advt_price_amount`	Unknown
`min_advt_price_currency`	Unknown
`min_advt_price_value`	Unknown
`offer_id`	Unknown
`pricing_list_replace_all`	Unknown
`product_type`	Unknown
`rebate_end_date`	Unknown
`rebate_info_url`	Unknown
`rebate_rebate_amount`	Unknown
`rebate_rebate_currency`	Unknown
`rebate_rebate_type`	Unknown
`rebate_rebate_value`	Unknown
`rebate_start_date`	Unknown
`wpid`	Unknown