parcelLab
Explore the interactive ERD
Table & Field Reference
returns_configuration_courier_service_level
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
returns_configuration_courier_mapping_index | Unknown | PKFK |
returns_configuration_id | Unknown | PKFK |
key | Unknown | |
name | Unknown | |
type | Unknown | |
updated_at | Unknown |
returns_configuration_courier_mapping
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
returns_configuration_id | Unknown | PKFK |
courier_api_account | Unknown | |
courier_api_courier_code | Unknown | |
courier_api_has_oauth_credential | Unknown | |
courier_api_identifier | Unknown | |
courier_api_name | Unknown | |
courier_api_service_config | Unknown | |
courier_api_service_name | Unknown | |
filter | Json |
returns_configuration_returnable_period
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
returns_configuration_id | Unknown | PKFK |
description | Unknown | |
filter | Json | |
grace_period | Unknown | |
grace_period_shipping_date | Unknown | |
is_warranty_period | Unknown | |
trial_period | Unknown |
returns_configuration
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
account | Unknown | FK |
client | Unknown | |
code | Unknown | |
returns_order_api | Unknown | |
returns_rules | Unknown |
document_template
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
account | Unknown | FK |
client_key | Unknown | |
content | Unknown | |
identifier | Unknown | |
key | Unknown |
survey_theme
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
background_image | Unknown | |
background_image_attachment | Unknown | |
background_image_fit | Unknown | |
background_opacity | Unknown | |
color_palette | Unknown | |
css_variables | Json | |
header_view | Unknown | |
is_panelless | Unknown | |
theme_name | Unknown |
order_info_tracking_checkpoint
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
order_info_tracking_number | Unknown | PKFK |
order_number | Unknown | PKFK |
courier | Unknown | |
delivery_extra_info | Unknown | |
delivery_location_type | Unknown | |
estimated_delivery_date_end_date | Unknown | |
estimated_delivery_date_end_time | Unknown | |
estimated_delivery_date_start_date | Unknown | |
estimated_delivery_date_start_time | Unknown | |
event_timestamp | Unknown | |
exception_type | Unknown | |
is_hidden | Unknown | |
location | Unknown | |
next_action | Unknown | |
status_code | Unknown | |
status_details | Unknown | |
status_text | Unknown | |
step | Unknown |
order_info_tracking_opening_hours
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
order_info_tracking_number | Unknown | PKFK |
order_number | Unknown | PKFK |
close | Unknown | |
day | Unknown | |
is_open | Unknown |
order_info_tracking_article
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
order_info_tracking_number | Unknown | PKFK |
order_number | Unknown | PKFK |
additional_attributes | Json | |
amount_invoiced | Unknown | |
article_brand | Unknown | |
article_category | Unknown | |
article_image_url | Unknown | |
article_name | Unknown | |
article_store_url | Unknown | |
barcode | Unknown | |
color | Unknown | |
harmonized_system_code | Unknown | |
height | Unknown | |
is_bulky | Unknown | |
length | Unknown | |
length_unit | Unknown | |
line_item_id | Unknown | |
order_item_id | Unknown | |
origin_country_iso_3 | Unknown | |
product_id | Unknown | |
quantity | Unknown | |
size | Unknown | |
sku | Unknown | |
tags | Json | |
tax_amount | Unknown | |
unit_price | Unknown | |
unit_price_original | Unknown | |
variant_id | Unknown | |
version | Unknown | |
weight | Unknown | |
weight_unit | Unknown | |
width | Unknown |
order_info_tracking
| Column | Type | Keys |
|---|---|---|
order_number | Unknown | PKFK |
tracking_number | Unknown | PKFK |
action_box_address | Unknown | |
action_box_label | Unknown | |
action_box_label_caption | Unknown | |
action_box_label_communication | Unknown | |
action_box_raw_earliest_date | Unknown | |
action_box_raw_earliest_time | Unknown | |
action_box_raw_has_time | Unknown | |
action_box_raw_latest_date | Unknown | |
action_box_raw_latest_time | Unknown | |
action_box_type | Unknown | |
additional_attributes | Json | |
courier_info_courier | Unknown | |
courier_info_courier_name | Unknown | |
courier_info_courier_reroute_url | Unknown | |
courier_info_courier_tracking_url | Unknown | |
courier_info_last_mile_courier | Unknown | |
courier_info_last_mile_courier_name | Unknown | |
delivery_location | Unknown | |
is_delayed | Unknown | |
is_exception | Unknown | |
last_delivery_delivery_extra_info | Unknown | |
last_delivery_event_timestamp | Unknown | |
last_delivery_exception_type | Unknown | |
last_delivery_icon_hint | Unknown | |
last_delivery_lifecycle_status | Unknown | |
last_delivery_next_action | Unknown | |
last_delivery_status_code | Unknown | |
last_delivery_status_details | Unknown | |
last_delivery_status_text | Unknown | |
last_delivery_step | Unknown | |
reporting_contacted_with_message | Json | |
reporting_contacted_with_messages | Json | |
reporting_courier_dropoff_date | Unknown | |
reporting_delivery_date | Unknown | |
reporting_exception_message | Json | |
reporting_exception_messages | Json | |
reporting_has_failed_attempt | Unknown | |
reporting_in_transit_date | Unknown | |
reporting_is_customer_promise_exceeded | Unknown | |
reporting_is_delayed | Unknown | |
reporting_is_delayed_dispatch | Unknown | |
reporting_is_forgotten | Unknown | |
reporting_is_returned | Unknown | |
reporting_pickup_date | Unknown | |
reporting_returned_date | Unknown | |
reporting_trending_late_probability | Unknown | |
reporting_trending_late_status | Unknown | |
supports_live_refresh | Unknown |
prediction
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
courier | Unknown | |
courier_alias | Json | |
courier_name | Unknown | |
courier_service_level | Json | |
prediction_cutoff | Unknown | |
prediction_cutoff_locale | Unknown | |
prediction_earliest_date | Unknown | |
prediction_earliest_locale | Unknown | |
prediction_latest_date | Unknown | |
prediction_latest_locale | Unknown | |
prediction_likely | Unknown | |
prediction_max | Unknown | |
prediction_min | Unknown | |
prediction_most_likely_date | Unknown | |
prediction_most_likely_locale | Unknown | |
prediction_send_date | Unknown | |
warehouse | Unknown |
orders_article
| Column | Type | Keys |
|---|---|---|
line_item_id | Unknown | PK |
orders_external_id | Unknown | PKFK |
additional_attributes | Json | |
amount_invoiced | Unknown | |
article_brand | Unknown | |
article_category | Unknown | |
article_image_url | Unknown | |
article_name | Unknown | |
article_store_url | Unknown | |
barcode | Unknown | |
color | Unknown | |
harmonized_system_code | Unknown | |
height | Unknown | |
is_bulky | Unknown | |
length | Unknown | |
length_unit | Unknown | |
order_item_id | Unknown | |
origin_country_iso_3 | Unknown | |
other_property | Unknown | |
product_id | Unknown | |
quantity | Unknown | |
size | Unknown | |
sku | Unknown | |
tags | Json | |
tax_amount | Unknown | |
unit_price | Unknown | |
unit_price_original | Unknown | |
variant_id | Unknown | |
version | Unknown | |
weight | Unknown | |
weight_unit | Unknown | |
width | Unknown |
orders_additional_attribute
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
orders_external_id | Unknown | PKFK |
key | Unknown | |
value | Unknown |
orders_mutation
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
orders_external_id | Unknown | PKFK |
tracking_number | Unknown | FK |
cancelled_date | Unknown | |
cancelled_reason | Unknown | |
current_quantity | Unknown | |
line_item | Json | |
line_item_id | Unknown | |
new_line_item | Json | |
old_line_item_id | Unknown | |
operation_id | Unknown | |
quantity | Unknown | |
reason | Unknown | |
result | Unknown | |
result_errors | Json | |
result_message | Unknown | |
result_success | Unknown | |
result_warning | Json | |
tracking_courier | Unknown | |
type | Unknown |
orders_tracking_article
| Column | Type | Keys |
|---|---|---|
line_item_id | Unknown | PK |
orders_external_id | Unknown | PKFK |
orders_tracking_index | Unknown | PKFK |
amount_invoiced | Unknown | |
article_brand | Unknown | |
article_category | Unknown | |
article_image_url | Unknown | |
article_name | Unknown | |
article_store_url | Unknown | |
barcode | Unknown | |
color | Unknown | |
harmonized_system_code | Unknown | |
height | Unknown | |
is_bulky | Unknown | |
length | Unknown | |
length_unit | Unknown | |
order_item_id | Unknown | |
origin_country_iso_3 | Unknown | |
product_id | Unknown | |
quantity | Unknown | |
size | Unknown | |
sku | Unknown | |
tags | Json | |
tax_amount | Unknown | |
unit_price | Unknown | |
unit_price_original | Unknown | |
variant_id | Unknown | |
version | Unknown | |
weight | Unknown | |
weight_unit | Unknown | |
width | Unknown |
orders_tracking_checkpoint
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
orders_external_id | Unknown | PKFK |
orders_tracking_index | Unknown | PKFK |
courier | Unknown | |
courier_status | Unknown | |
delivery_location | Unknown | |
event_timestamp | Unknown | |
exception | Json | |
message | Unknown | |
status_code | Unknown |
orders_tracking
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
orders_external_id | Unknown | PKFK |
additional_fields | Unknown | |
additional_recipients | Json | |
announced_delivery_date | Unknown | |
announced_delivery_date_max | Unknown | |
announced_delivery_date_min | Unknown | |
announced_send_date | Unknown | |
cancelled_date | Unknown | |
cash_on_delivery_amount | Unknown | |
client_key | Unknown | |
collection_code_carrier | Unknown | |
collection_code_retailer | Unknown | |
courier | Unknown | |
courier_change_url | Unknown | |
courier_contact_email | Unknown | |
courier_contact_name | Unknown | |
courier_contact_phone | Unknown | |
courier_service_level | Unknown | |
delivery_method | Unknown | |
delivery_number | Unknown | |
destination_country_iso_3 | Unknown | |
external_reference | Unknown | |
flags | Json | |
identifiers_consignment | Unknown | |
invoice_number | Unknown | |
is_dropshipment | Unknown | |
is_return | Unknown | |
is_returns_portal | Unknown | |
language_iso_2 | Unknown | |
notifications_inactive | Unknown | |
number_of_parcels | Unknown | |
origin_country_iso_3 | Unknown | |
origin_postal_code | Unknown | |
origin_region | Unknown | |
pod_date | Unknown | |
pod_identifier | Unknown | |
pod_signature | Unknown | |
recipient_email | Unknown | |
recipient_name | Unknown | |
recipient_phone | Unknown | |
recipient_postal_code | Unknown | |
reporting_courier_dropoff_date | Unknown | |
reporting_delivery_date | Unknown | |
reporting_in_transit_date | Unknown | |
reporting_pickup_date | Unknown | |
requires_signature | Unknown | |
review_link | Unknown | |
security_hash | Unknown | |
shipping_address_address_line | Unknown | |
shipping_address_address_line_extra | Unknown | |
shipping_address_city | Unknown | |
shipping_address_company_name | Unknown | |
shipping_address_country_iso_3 | Unknown | |
shipping_address_first_name | Unknown | |
shipping_address_last_name | Unknown | |
shipping_address_phone | Unknown | |
shipping_address_postal_code | Unknown | |
shipping_address_region_code | Unknown | |
shipping_cost_discount | Unknown | |
shipping_cost_net | Unknown | |
shipping_cost_total | Unknown | |
shipping_dimensions_unit | Unknown | |
shipping_height | Unknown | |
shipping_length | Unknown | |
shipping_volume_total | Unknown | |
shipping_volume_unit | Unknown | |
shipping_weight_total | Unknown | |
shipping_weight_unit | Unknown | |
shipping_width | Unknown | |
status_link | Unknown | |
support_phone | Unknown | |
tags | Json | |
timezone | Unknown | |
tracking_number | Unknown | |
transport_number | Unknown | |
warehouse | Unknown |
orders
| Column | Type | Keys |
|---|---|---|
account | Unknown | PK |
external_id | Unknown | PK |
additional_recipients | Json | |
announced_delivery_date | Unknown | |
announced_delivery_date_max | Unknown | |
announced_delivery_date_min | Unknown | |
billing_address_city | Unknown | |
billing_address_company_name | Unknown | |
billing_address_country_iso_3 | Unknown | |
billing_address_first_name | Unknown | |
billing_address_last_name | Unknown | |
billing_address_line | Unknown | |
billing_address_line_extra | Unknown | |
billing_address_phone | Unknown | |
billing_address_postal_code | Unknown | |
billing_address_region_code | Unknown | |
cancelled_date | Unknown | |
cancelled_reason | Unknown | |
channel | Unknown | |
client_key | Unknown | |
customer_number | Unknown | |
delivery_method | Unknown | |
destination_country_iso_3 | Unknown | |
external_reference | Unknown | |
has_multiple_shipments | Unknown | |
invoice_number | Unknown | |
language_iso_2 | Unknown | |
order_currency | Unknown | |
order_date | Unknown | |
order_discount_amount | Unknown | |
order_net_amount | Unknown | |
order_number | Unknown | |
order_status | Unknown | |
order_tax_amount | Unknown | |
order_total_amount | Unknown | |
payment_method | Unknown | |
payments | Json | |
recipient_email | Unknown | |
recipient_name | Unknown | |
shipping_address_city | Unknown | |
shipping_address_company_name | Unknown | |
shipping_address_country_iso_3 | Unknown | |
shipping_address_first_name | Unknown | |
shipping_address_last_name | Unknown | |
shipping_address_line | Unknown | |
shipping_address_line_extra | Unknown | |
shipping_address_phone | Unknown | |
shipping_address_postal_code | Unknown | |
shipping_address_region_code | Unknown | |
tags | Json | |
timezone | Unknown |
return_registration_article_order
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
return_registration_external_id | Unknown | PKFK |
additional_attribute | Json | |
amount_invoiced | Unknown | |
article_brand | Unknown | |
article_category | Unknown | |
article_currency | Unknown | |
article_image_url | Unknown | |
article_name | Unknown | |
article_store_url | Unknown | |
barcode | Unknown | |
color | Unknown | |
delivery_no | Unknown | |
discount_allocation | Json | |
fulfillment_origin_location_id | Unknown | |
harmonized_system_code | Unknown | |
height | Unknown | |
hide_label | Unknown | |
is_bulky | Unknown | |
is_free_gift_auto_selected | Unknown | |
is_non_returnable | Unknown | |
length | Unknown | |
length_unit | Unknown | |
line_item_id | Unknown | |
msrp | Unknown | |
msrp_delta | Unknown | |
non_returnable_final_sale | Unknown | |
option_values | Json | |
order_item_id | Unknown | |
origin_country_iso_3 | Unknown | |
original_compensation_method | Unknown | |
pretty_condition | Unknown | |
pretty_product_id | Unknown | |
product_id | Unknown | |
properties | Json | |
quantity | Unknown | |
requires_extra_material | Unknown | |
return_reason_path | Unknown | |
returned_to_retailer | Unknown | |
shopify_fulfillment_line_item_id | Unknown | |
shopify_fulfillment_line_items | Json | |
shopify_line_item_id | Unknown | |
size | Unknown | |
size_check | Unknown | |
sku | Unknown | |
tags | Json | |
tax_amount | Unknown | |
unit_price | Unknown | |
unit_price_original | Unknown | |
variant_id | Unknown | |
variant_id_shopify | Unknown | |
vendor | Unknown | |
version | Unknown | |
warranty | Unknown | |
weight | Unknown | |
weight_unit | Unknown | |
width | Unknown |
return_registration_article_return
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
return_registration_external_id | Unknown | PKFK |
accepted_quantity | Unknown | |
additional_attribute | Json | |
amount_invoiced | Unknown | |
article_brand | Unknown | |
article_category | Unknown | |
article_image | Json | |
article_image_url | Unknown | |
article_name | Unknown | |
article_store_url | Unknown | |
barcode | Unknown | |
color | Unknown | |
compensation_method | Unknown | |
condition | Unknown | |
delivered_date | Unknown | |
fulfillment | Unknown | |
harmonized_system_code | Unknown | |
height | Unknown | |
hide_label | Unknown | |
is_bulky | Unknown | |
length | Unknown | |
length_unit | Unknown | |
line_item_id | Unknown | |
order_item_id | Unknown | |
origin_country_iso_3 | Unknown | |
problem_description | Unknown | |
product_id | Unknown | |
quantity | Unknown | |
quantity_returned | Unknown | |
reference_date_for_return | Unknown | |
reference_date_type | Unknown | |
rejected_quantity | Unknown | |
return_quantity | Unknown | |
return_reason | Unknown | |
return_reason_code | Unknown | |
return_reason_pretty | Unknown | |
shopify_return_reason | Unknown | |
size | Unknown | |
size_check | Unknown | |
sku | Unknown | |
status_reason | Unknown | |
status_reason_code | Unknown | |
tags | Json | |
tax_amount | Unknown | |
unit_price | Unknown | |
unit_price_msrp_current | Unknown | |
unit_price_original | Unknown | |
variant_id | Unknown | |
version | Unknown | |
weight | Unknown | |
weight_unit | Unknown | |
width | Unknown |
return_registration_label
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
return_registration_external_id | Unknown | PKFK |
tracking_number | Unknown | FK |
configuration_id | Unknown | |
courier | Unknown | |
delivery_status | Unknown | |
destination_id | Unknown | |
documents | Json | |
earliest_pickup_time | Unknown | |
external_reference | Unknown | |
flags | Json | |
is_free_label | Unknown | |
is_pickup | Unknown | |
label_cost_amount | Unknown | |
latest_pickup_time | Unknown | |
line_item_ids | Json | |
locations_url | Unknown | |
pickup_confirmation_code | Unknown | |
pickup_date | Unknown | |
pickup_time | Unknown | |
service_level | Unknown | |
tracking_id | Unknown | |
type | Unknown |
return_registration_mutation
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
return_registration_external_id | Unknown | PKFK |
destination_address_address_line | Unknown | |
destination_address_address_line_extra | Unknown | |
destination_address_city | Unknown | |
destination_address_company_name | Unknown | |
destination_address_country_iso_3 | Unknown | |
destination_address_first_name | Unknown | |
destination_address_last_name | Unknown | |
destination_address_phone | Unknown | |
destination_address_postal_code | Unknown | |
destination_address_region_code | Unknown | |
operation_id | Unknown | |
request_additional_fields | Json | |
request_courier | Unknown | |
request_destination_id | Unknown | |
request_flags | Json | |
request_label_types | Json | |
request_line_item_ids | Json | |
request_service_level | Unknown | |
request_template_id | Unknown | |
request_tracking_number | Unknown | |
request_type | Unknown | |
result_errors | Json | |
result_warning | Json | |
success | Unknown | |
type | Unknown |
return_registration
| Column | Type | Keys |
|---|---|---|
external_id | Unknown | PK |
account | Unknown | |
additional_fields | Json | |
client_key | Unknown | |
code | Unknown | |
created_at | Unknown | |
customer_address_city | Unknown | |
customer_address_company_name | Unknown | |
customer_address_country_iso_3 | Unknown | |
customer_address_first_name | Unknown | |
customer_address_last_name | Unknown | |
customer_address_line | Unknown | |
customer_address_line_extra | Unknown | |
customer_address_phone | Unknown | |
customer_address_postal_code | Unknown | |
customer_address_region_code | Unknown | |
customer_country_iso_3 | Unknown | |
customer_email | Unknown | |
customer_first_name | Unknown | |
customer_last_name | Unknown | |
customer_phone | Unknown | |
customer_salutation | Unknown | |
external_reference | Unknown | |
is_gift_returns_portal | Unknown | |
language_iso_2 | Unknown | |
order_currency | Unknown | |
order_date | Unknown | |
order_delivery_date | Unknown | |
order_payment_method | Json | |
order_shipping_amount | Unknown | |
order_shipping_date | Unknown | |
order_tax_amount | Unknown | |
order_total_amount | Unknown | |
original_courier | Unknown | |
original_order_id | Unknown | |
reference | Unknown | |
refund_method | Unknown | |
sequence_number | Unknown | |
status | Unknown | |
status_reason | Unknown | |
tags | Json | |
updated_at | Unknown | |
verification_code_used | Unknown | |
version | Unknown |
return_registration_article_returnability_reason
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
return_registration_article_returnability_index | Unknown | PKFK |
return_registration_external_id | Unknown | PKFK |
code | Unknown | |
id | Unknown | |
image_upload | Unknown | |
name | Unknown | |
name_localized | Unknown | |
note | Unknown | |
note_localized | Unknown | |
path | Unknown | |
path_segments | Json | |
problem_description | Unknown | |
problem_description_min_length | Unknown | |
shopify_return_reason | Unknown | |
tags | Json | |
type | Unknown |
return_registration_article_returnability_compensation_method
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
return_registration_article_returnability_index | Unknown | PKFK |
return_registration_external_id | Unknown | PKFK |
category | Unknown | |
description | Unknown | |
description_localized | Unknown | |
external_code | Unknown | |
tags | Json |
return_registration_article_returnability
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
return_registration_external_id | Unknown | PKFK |
article_additional_attribute | Json | |
article_amount_invoiced | Unknown | |
article_article_currency | Unknown | |
article_barcode | Unknown | |
article_brand | Unknown | |
article_category | Unknown | |
article_color | Unknown | |
article_delivered_date | Unknown | |
article_delivery_no | Unknown | |
article_discount_allocation | Json | |
article_filters | Json | |
article_fulfillment | Unknown | |
article_fulfillment_origin_location_id | Unknown | |
article_harmonized_system_code | Unknown | |
article_height | Unknown | |
article_hide_label | Unknown | |
article_image_url | Unknown | |
article_is_bulky | Unknown | |
article_is_free_gift_auto_selected | Unknown | |
article_is_non_returnable | Unknown | |
article_length | Unknown | |
article_length_unit | Unknown | |
article_line_item_id | Unknown | |
article_msrp | Unknown | |
article_msrp_delta | Unknown | |
article_name | Unknown | |
article_option_values | Json | |
article_order_item_id | Unknown | |
article_origin_country_iso_3 | Unknown | |
article_pretty_condition | Unknown | |
article_pretty_product_id | Unknown | |
article_price | Unknown | |
article_price_paid_no_tax | Unknown | |
article_price_paid_shop_currency | Unknown | |
article_price_paid_shop_currency_no_tax | Unknown | |
article_price_shop_currency | Unknown | |
article_product_id | Unknown | |
article_properties | Json | |
article_quantity | Unknown | |
article_quantity_returned | Unknown | |
article_reference_date_for_return | Unknown | |
article_reference_date_type | Unknown | |
article_requires_extra_material | Unknown | |
article_return_reason_path | Unknown | |
article_returned_to_retailer | Unknown | |
article_shopify_fulfillment_line_item | Json | |
article_shopify_fulfillment_line_item_id | Unknown | |
article_shopify_line_item_id | Unknown | |
article_size | Unknown | |
article_size_check | Unknown | |
article_sku | Unknown | |
article_store_url | Unknown | |
article_tags | Json | |
article_tax_amount | Unknown | |
article_tracking_number | Json | |
article_unit_price | Unknown | |
article_unit_price_msrp_current | Unknown | |
article_unit_price_original | Unknown | |
article_variant_id | Unknown | |
article_vendor | Unknown | |
article_version | Unknown | |
article_warranty | Unknown | |
article_weight | Unknown | |
article_weight_unit | Unknown | |
article_width | Unknown | |
grace_period_day | Unknown | |
has_compensation | Unknown | |
is_in_trial_period | Unknown | |
is_in_warranty_period | Unknown | |
trial_period_day | Unknown | |
warranty_period_day | Unknown |
return_registration_article_selection
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
return_registration_external_id | Unknown | PKFK |
article_images | Json | |
compensation_method | Unknown | |
exchange_product_options | Json | |
line_item_id | Unknown | |
problem_description | Unknown | |
return_quantity | Unknown | |
return_reason | Unknown | |
selected | Unknown |
return_registration_refund_method
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
return_registration_external_id | Unknown | PKFK |
code | Unknown | |
code_localized | Unknown | |
hint_localized | Unknown | |
type | Unknown |
return_registration_line_items_by_flag_article
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
return_registration_external_id | Unknown | PKFK |
return_registration_line_items_by_flag_index | Unknown | PKFK |
article_name | Unknown | |
line_item_id | Unknown | |
product_id | Unknown | |
quantity | Unknown | |
sku | Unknown |
return_registration_line_items_by_flag
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
return_registration_external_id | Unknown | PKFK |
description_localized | Unknown | |
flag | Unknown | |
title_localized | Unknown |
return_registration_split_group_article
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
return_registration_external_id | Unknown | PKFK |
return_registration_split_group_index | Unknown | PKFK |
article_name | Unknown | |
line_item_id | Unknown | |
product_id | Unknown | |
quantity | Unknown | |
sku | Unknown |
return_registration_split_group
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
return_registration_external_id | Unknown | PKFK |
display_name | Unknown | |
key | Unknown |