# Walmart Marketplace schema ERD

Table and field reference for the Fivetran Walmart Marketplace connector.

## Table & Field Reference

### product_identifier

| Column | Type | Keys |
| --- | --- | --- |
| product_id | Unknown | PK |
| feed_id | Unknown | PK, FK |
| feed_item_detail_index | Unknown | PK, FK |
| product_id_type | Unknown |  |

### feed_item_detail

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| feed_id | Unknown | PK, FK |
| ingestion_status | Unknown |  |
| itemid | Unknown |  |
| mart_id | Unknown |  |
| sku | Unknown |  |
| wpid | Unknown |  |

### feed_item_status

| Column | Type | Keys |
| --- | --- | --- |
| feed_id | Unknown | PK, FK |
| 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 | PK, FK |
| sku | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| product_name | Unknown |  |
| vendor_sku | Unknown |  |

### distributor_supported_service

| Column | Type | Keys |
| --- | --- | --- |
| distributor_supported_service | Unknown | PK |
| ship_node | Unknown | PK, FK |

### two_day_shipping_detail

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| fulfillment_center_ship_node | Unknown | PK, FK |
| carrier_method_name | Unknown |  |
| carrier_method_type | Unknown |  |

### calendar_day_configuration

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| ship_node | Unknown | PK, FK |
| 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 | PK, FK |
| seller_order_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| shipment_no | Unknown | PK, FK |
| 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 | PK, FK |
| shipment_no | Unknown | PK, FK |
| actual_date | Unknown |  |
| datetype_id | Unknown |  |
| expected_date | Unknown |  |

### fulfillment_order_shipment

| Column | Type | Keys |
| --- | --- | --- |
| shipment_no | Unknown | PK |
| seller_order_id | Unknown | PK, FK |
| 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 | PK, FK |
| purchase_order_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| purchase_order_id | Unknown | PK, FK |
| 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 | PK, FK |
| purchase_order_id | Unknown | PK, FK |
| 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 | PK, FK |
| line_number | Unknown |  |
| quantity | Unknown |  |

### label_detail_add_on

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| purchase_order_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| unpublished_reason | Unknown |  |

### item_additional_attribute_value

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| item_additional_attribute_index | Unknown | PK, FK |
| sku | Unknown | PK, FK |
| groups | Unknown |  |
| is_variant | Unknown |  |
| rank | Unknown |  |
| source | Unknown |  |
| value | Unknown |  |

### item_additional_attribute

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| sku | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| shipping_detail_index | Unknown | PK, FK |
| fulfillment_lag_time | Unknown |  |
| name | Unknown |  |

### shipping_configuration_detail

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| shipping_configuration_fivetran_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| product_id | Unknown | PK, FK |
| add_on_service | Unknown |  |

### dimension

| Column | Type | Keys |
| --- | --- | --- |
| dimension | Unknown | PK |
| inbound_order_id | Unknown | PK, FK |

### inbound_shipment_order_item

| Column | Type | Keys |
| --- | --- | --- |
| product_id | Unknown | PK |
| inbound_order_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| ship_node_name | Unknown |  |

### price_incentive

| Column | Type | Keys |
| --- | --- | --- |
| incentive_status | Unknown | PK |
| sku_id | Unknown | PK, FK |
| 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 | PK, FK |

### fulfillment_center_coverage

| Column | Type | Keys |
| --- | --- | --- |
| ship_node | Unknown | PK, FK |
| 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 | PK, FK |
| return_id | Unknown | PK, FK |
| return_line_group_index | Unknown | PK, FK |
| return_order_line_number | Unknown |  |

### return_line_group_carrier_info_list

| Column | Type | Keys |
| --- | --- | --- |
| carrier_id | Unknown | PK |
| customer_order_id | Unknown | PK, FK |
| return_id | Unknown | PK, FK |
| return_line_group_index | Unknown | PK, FK |
| return_line_label_index | Unknown | PK, FK |
| carrier_name | Unknown |  |
| service_type | Unknown |  |
| tracking_no | Unknown |  |

### return_line_label

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| customer_order_id | Unknown | PK, FK |
| return_id | Unknown | PK, FK |
| return_line_group_index | Unknown | PK, FK |
| label_image_url | Unknown |  |

### return_line_group

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| customer_order_id | Unknown | PK, FK |
| return_id | Unknown | PK, FK |
| group_no | Unknown |  |
| return_expected_flag | Unknown |  |

### return_order_line_charge_tax

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| return_id | Unknown | PK, FK |
| return_order_line_charge_index | Unknown | PK, FK |
| return_order_line_index | Unknown | PK, FK |
| 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 | PK, FK |
| return_order_line_charge_index | Unknown | PK, FK |
| return_order_line_index | Unknown | PK, FK |
| name | Unknown |  |
| value | Unknown |  |

### return_order_line_charge

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| return_id | Unknown | PK, FK |
| return_order_line_index | Unknown | PK, FK |
| 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 | PK, FK |
| return_order_line_index | Unknown | PK, FK |
| currency_amount | Unknown |  |
| currency_unit | Unknown |  |
| name | Unknown |  |

### return_order_line_refund_channel

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| return_id | Unknown | PK, FK |
| return_order_line_index | Unknown | PK, FK |
| quantity_measurement_value | Unknown |  |
| refund_channel_name | Unknown |  |

### return_order_line_tracking_reference

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| return_id | Unknown | PK, FK |
| return_order_line_index | Unknown | PK, FK |
| return_order_line_tracking_detail_index | Unknown | PK, FK |
| name | Unknown |  |
| value | Unknown |  |

### return_order_line_tracking_detail

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| return_id | Unknown | PK, FK |
| return_order_line_index | Unknown | PK, FK |
| 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 | PK, FK |
| return_order_line_index | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| feed_type | Unknown |  |

### partner_configuration

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| partner_id | Unknown | PK, FK |
| 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 | PK, FK |

### 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 | PK, FK |
| 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 | PK, FK |
| category_name | Unknown |  |

### taxanomy_department_payload

| Column | Type | Keys |
| --- | --- | --- |
| department_id | Unknown | PK, FK |
| department_name | Unknown |  |

### performance_report

| Column | Type | Keys |
| --- | --- | --- |
| partner_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| name | Unknown |  |
| operator | Unknown |  |
| value | Unknown |  |

### rule_action_sub_region

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| rule_action_index | Unknown | PK, FK |
| sub_region_code | Unknown | FK |

### rule_action

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| rule_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |

### shipping_method_state_sub_region

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| shipping_template_id | Unknown | PK, FK |
| state_sub_region_index | Unknown | PK, FK |
| state_subregion_code | Unknown |  |
| state_subregion_name | Unknown |  |

### shipping_method_sub_region_state

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| shipping_template_id | Unknown | PK, FK |
| sub_region_index | Unknown | PK, FK |
| state_code | Unknown |  |
| state_name | Unknown |  |

### shipping_method_sub_region

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| shipping_method_region_index | Unknown | PK, FK |
| shipping_template_id | Unknown | PK, FK |
| sub_region_code | Unknown |  |
| sub_region_name | Unknown |  |

### shipping_method_region

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| shiiping_configuration_index | Unknown | PK, FK |
| shipping_template_id | Unknown | PK, FK |
| region_code | Unknown |  |
| region_name | Unknown |  |

### shipping_method_address_type

| Column | Type | Keys |
| --- | --- | --- |
| address_type | Unknown | PK |
| shipping_configuration_index | Unknown | PK, FK |
| template_id | Unknown | PK, FK |

### shipping_method_tiered_shipping_charge

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| shipping_configuration_index | Unknown | PK, FK |
| template_id | Unknown | PK, FK |
| 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 | PK, FK |
| template_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| name | Unknown |  |
| value | Unknown |  |

### promotional_price

| Column | Type | Keys |
| --- | --- | --- |
| sku | Unknown | PK, FK |
| 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 |  |

## Relationships

- product_identifier(feed_id) → feed_item_detail(feed_id)
- product_identifier(feed_item_detail_index) → feed_item_detail(index)
- feed_item_detail(feed_id) → feed_item_status(feed_id)
- feed_item_status(feed_id) → feed_status(feed_id)
- inbound_shipment_item(sku) → item(sku)
- inbound_shipment_item(shipment_id) → shipment(id)
- wfs_inventory_log(gtin) → wfs_inventory_log_payload(gtin)
- wfs_inventory_log_payload(gtin) → item(gtin)
- distributor_supported_service(ship_node) → fulfillment_center(ship_node)
- two_day_shipping_detail(fulfillment_center_ship_node) → fulfillment_center(ship_node)
- calendar_day_configuration(ship_node) → fulfillment_center(ship_node)
- fulfillment_order_line_quantity_info(seller_order_id) → fulfillment_order_line(seller_order_id)
- fulfillment_order_line_quantity_info(fulfillment_order_line_index) → fulfillment_order_line(index)
- fulfillment_order_line(seller_order_id) → fulfillment_order_status(seller_order_id)
- fulfillment_order_shipment_line(seller_order_id) → fulfillment_order_shipment(seller_order_id)
- fulfillment_order_shipment_line(shipment_no) → fulfillment_order_shipment(shipment_no)
- fulfillment_order_shipment_date(seller_order_id) → fulfillment_order_shipment(seller_order_id)
- fulfillment_order_shipment_date(shipment_no) → fulfillment_order_shipment(shipment_no)
- fulfillment_order_shipment(seller_order_id) → fulfillment_order_status(seller_order_id)
- unpublished_item(sku) → item(sku)
- unpublished_item(gtin) → item(gtin)
- order_line_status(purchase_order_id) → order_line(purchase_order_id)
- order_line_status(order_line_index) → order_line(index)
- order_line(item_sku) → item(sku)
- order_line(purchase_order_id) → orders(purchase_order_id)
- order_line(return_order_id) → return(id)
- order_pickup_person(purchase_order_id) → orders(purchase_order_id)
- order_line_refund_charge(purchase_order_id) → order_line(purchase_order_id)
- order_line_refund_charge(order_line_index) → order_line(index)
- order_line_charge(purchase_order_id) → order_line(purchase_order_id)
- order_line_charge(order_line_index) → order_line(index)
- label_detail_box_item(purchase_order_id) → label_detail_by_purchase_order(purchase_order_id)
- label_detail_add_on(purchase_order_id) → label_detail_by_purchase_order(purchase_order_id)
- label_detail_by_purchase_order(purchase_order_id) → orders(purchase_order_id)
- item_unpublished_reason(sku) → item(sku)
- item_additional_attribute_value(sku) → item_additional_attribute(sku)
- item_additional_attribute_value(item_additional_attribute_index) → item_additional_attribute(index)
- item_additional_attribute(sku) → item(sku)
- shipment_package(carrier_rate_quote_quote_id) → carrier_rate_quote(quote_id)
- carrier_rate_quote(shipment_id) → shipment(id)
- shipping_configuration_category(shipping_configuration_fivetran_id) → shipping_configuration_detail(shipping_configuration_fivetran_id)
- shipping_configuration_category(shipping_detail_index) → shipping_configuration_detail(index)
- shipping_configuration_detail(shipping_configuration_fivetran_id) → shipping_configuration(_fivetran_id)
- shipping_configuration(partner_id) → partner_configuration_detail(partner_id)
- lag_time(sku) → item(sku)
- simulation_result(rule_id) → rule(id)
- inbound_shipment_error(inbound_order_id) → inbound_shipment_error_payload(inbound_order_id)
- add_on_service(product_id) → inbound_shipment_order_item(product_id)
- add_on_service(inbound_order_id) → inbound_shipment_order_item(inbound_order_id)
- dimension(inbound_order_id) → inbound_shipment_order_item(inbound_order_id)
- inbound_shipment_order_item(inbound_order_id) → inbound_shipment_error_payload(inbound_order_id)
- inbound_shipment_error_payload(inbound_order_id) → inbound_shipment_item(inbound_order_id)
- quality_issue_product_type(category) → item_count_listing_quality_issue(category)
- third_party_fulfillment_provider(ship_node) → fulfillment_center(ship_node)
- price_incentive(sku_id) → item(sku)
- coverage_area(ship_node) → fulfillment_center_coverage(ship_node)
- fulfillment_center_coverage(ship_node) → fulfillment_center(ship_node)
- top_trending_item(taxanomy_department_department_id) → taxanomy_department(department_id)
- return_line(return_line_group_index) → return_line_group(index)
- return_line(return_id) → return_line_group(return_id)
- return_line(customer_order_id) → return_line_group(customer_order_id)
- return_line_group_carrier_info_list(return_line_label_index) → return_line_label(index)
- return_line_group_carrier_info_list(return_line_group_index) → return_line_label(return_line_group_index)
- return_line_group_carrier_info_list(return_id) → return_line_label(return_id)
- return_line_group_carrier_info_list(customer_order_id) → return_line_label(customer_order_id)
- return_line_label(return_line_group_index) → return_line_group(index)
- return_line_label(return_id) → return_line_group(return_id)
- return_line_label(customer_order_id) → return_line_group(customer_order_id)
- return_line_group(return_id) → return(id)
- return_line_group(customer_order_id) → return(customer_order_id)
- return_order_line_charge_tax(return_order_line_charge_index) → return_order_line_charge(index)
- return_order_line_charge_tax(return_order_line_index) → return_order_line_charge(return_order_line_index)
- return_order_line_charge_tax(return_id) → return_order_line_charge(return_id)
- return_order_line_charge_reference(return_order_line_charge_index) → return_order_line_charge(index)
- return_order_line_charge_reference(return_order_line_index) → return_order_line_charge(return_order_line_index)
- return_order_line_charge_reference(return_id) → return_order_line_charge(return_id)
- return_order_line_charge(return_id) → return_order_line(return_id)
- return_order_line_charge(return_order_line_index) → return_order_line(index)
- return_order_line_charge_total(return_id) → return_order_line(return_id)
- return_order_line_charge_total(return_order_line_index) → return_order_line(index)
- return_order_line_refund_channel(return_id) → return_order_line(return_id)
- return_order_line_refund_channel(return_order_line_index) → return_order_line(index)
- return_order_line_tracking_reference(return_id) → return_order_line_tracking_detail(return_id)
- return_order_line_tracking_reference(return_order_line_index) → return_order_line_tracking_detail(return_order_line_index)
- return_order_line_tracking_reference(return_order_line_tracking_detail_index) → return_order_line_tracking_detail(index)
- return_order_line_tracking_detail(return_id) → return_order_line(return_id)
- return_order_line_tracking_detail(return_order_line_index) → return_order_line(index)
- return_order_line_current_tracking_status(return_id) → return_order_line(return_id)
- return_order_line_current_tracking_status(return_order_line_index) → return_order_line(index)
- return_order_line(seller_order_id) → order_line(seller_order_id)
- return_order_line(purchase_order_id) → orders(purchase_order_id)
- return_order_line(return_id) → return(id)
- return(customer_order_id) → orders(customer_order_id)
- item_taxonomy_subcategory(item_taxonomy_category_id) → item_taxonomy(category_id)
- partner_throttle_configuration(partner_id) → partner_configuration_value(partner_id)
- partner_configuration_value(partner_id) → partner_configuration(partner_id)
- partner_configuration(partner_id) → partner_configuration_detail(partner_id)
- shipment_tracking_no(shipment_id) → shipment(id)
- rule_area_state(region_code) → rule_area(region_code)
- taxanomy_department_category(taxanomy_dept_id) → taxanomy_department_payload(department_id)
- taxanomy_department_payload(department_id) → taxanomy_department(department_id)
- performance_report(partner_id) → partner_configuration_detail(partner_id)
- repricer_strategy(collection_id) → repricer_strategy_collection(id)
- rule_condition(rule_id) → rule(id)
- rule_action_sub_region(sub_region_code) → rule_area_state(state_subregion_code)
- rule_action_sub_region(rule_action_index) → rule_action(index)
- rule_action(region_code) → rule_area(region_code)
- rule_action(rule_id) → rule(id)
- inventory_node(inventory_sku) → inventory(sku)
- inventory(sku) → item(sku)
- shipping_method_state_sub_region(shipping_template_id) → shipping_method_sub_region_state(shipping_template_id)
- shipping_method_state_sub_region(state_sub_region_index) → shipping_method_sub_region_state(index)
- shipping_method_sub_region_state(shipping_template_id) → shipping_method_sub_region(shipping_template_id)
- shipping_method_sub_region_state(sub_region_index) → shipping_method_sub_region(index)
- shipping_method_sub_region(shipping_template_id) → shipping_method_region(shipping_template_id)
- shipping_method_sub_region(shipping_method_region_index) → shipping_method_region(index)
- shipping_method_region(shipping_template_id) → shipping_method_configuration(template_id)
- shipping_method_region(shiiping_configuration_index) → shipping_method_configuration(index)
- shipping_method_address_type(shipping_configuration_index) → shipping_method_configuration(index)
- shipping_method_address_type(template_id) → shipping_method_configuration(template_id)
- shipping_method_tiered_shipping_charge(template_id) → shipping_method_configuration(template_id)
- shipping_method_tiered_shipping_charge(shipping_configuration_index) → shipping_method_configuration(index)
- shipping_method_configuration(template_id) → shipping_method(template_id)
- shipping_method_configuration(shipping_method_index) → shipping_method(index)
- shipping_method(template_id) → shipping_template(id)
- recon_report(available_report_date) → available_report_date(available_report_date)
- payment_statement_report(partner_id) → partner_configuration_detail(partner_id)
- taxanomy_department(taxanomy_super_dept_id) → taxanomy_super_department(super_department_id)
- feed_status(partner_id) → partner_configuration_detail(partner_id)
- promotional_pricing(sku) → promotional_price(sku)
- promotional_price_additional_attribute(sku) → promotional_price(sku)
- promotional_price(sku) → item(sku)