SkuVault
Explore the interactive ERD
Table & Field Reference
sale_merchant_item_by_date
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
product_sku | Unknown | PKFK |
sale_by_date_id | Unknown | PKFK |
part_number | Unknown | |
quantity | Unknown | |
unit_price_a | Unknown | |
unit_price_s | Unknown |
sale_merchant_kit_item_by_date
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
sale_by_date_id | Unknown | PKFK |
sale_merchant_kit_by_date_index | Unknown | PKFK |
part_number | Unknown | |
product_sku | Unknown | |
quantity | Unknown | |
unit_price_a | Unknown | |
unit_price_s | Unknown |
sale_merchant_kit_by_date
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
sale_by_date_id | Unknown | PKFK |
product_sku | Unknown | FK |
quantity | Unknown | |
unit_price_a | Unknown | |
unit_price_s | Unknown |
sale_processed_item_by_date
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
sale_by_date_id | Unknown | PKFK |
product_sku | Unknown | FK |
failed_quantity | Unknown | |
passed_quantity | Unknown | |
picked_quantity | Unknown |
sale_by_date
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
channel | Unknown | |
channel_id | Unknown | |
client | Unknown | |
contact_info_company | Unknown | |
contact_info_email | Unknown | |
contact_info_firstname | Unknown | |
contact_info_lastname | Unknown | |
contact_info_phone | Unknown | |
fulfilled_items | Json | |
last_printed_date | Unknown | |
market_place | Unknown | |
market_place_id | Unknown | |
notes | Unknown | |
printed_status | Unknown | |
sale_date | Unknown | |
seller_sale_id | Unknown | |
shipping_carrier | Unknown | |
shipping_charge_a | Unknown | |
shipping_charge_s | Unknown | |
shipping_class | Unknown | |
shipping_cost_a | Unknown | |
shipping_cost_s | Unknown | |
shipping_info_address_1 | Unknown | |
shipping_info_address_2 | Unknown | |
shipping_info_city | Unknown | |
shipping_info_country | Unknown | |
shipping_info_postal_code | Unknown | |
shipping_info_region | Unknown | |
status | Unknown |
product_supplier_info
| Column | Type | Keys |
|---|---|---|
product_sku | Unknown | PKFK |
supplier_name | Unknown | PKFK |
cost | Unknown | |
is_active | Unknown | |
is_primary | Unknown | |
lead_time | Unknown | |
supplier_part_number | Unknown |
product_picture
| Column | Type | Keys |
|---|---|---|
picture | Unknown | PK |
product_sku | Unknown | PKFK |
product_attribute
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
product_sku | Unknown | FK |
name | Unknown | |
value | Unknown |
product_status
| Column | Type | Keys |
|---|---|---|
status | Unknown | PK |
product_sku | Unknown | PKFK |
product
| Column | Type | Keys |
|---|---|---|
sku | Unknown | PK |
brand | Unknown | FK |
classification | Unknown | FK |
primary_sku | Unknown | FK |
supplier | Unknown | FK |
client | Unknown | |
code | Unknown | |
cost | Unknown | |
created_date_utc | Instant | |
description | Unknown | |
disable_quantity_sync | Unknown | |
id | Unknown | |
incremental_quantity | Unknown | |
is_alternate_code | Unknown | |
is_alternate_sku | Unknown | |
is_serialized | Unknown | |
long_description | Unknown | |
minimum_order_quantity | Unknown | |
minimum_order_quantity_information | Unknown | |
modified_date_utc | Instant | |
part_number | Unknown | |
quantity_available | Unknown | |
quantity_in_stock | Unknown | |
quantity_inbound | Unknown | |
quantity_incoming | Unknown | |
quantity_on_hand | Unknown | |
quantity_on_hold | Unknown | |
quantity_pending | Unknown | |
quantity_picked | Unknown | |
quantity_total_fba | Unknown | |
quantity_transfer | Unknown | |
reorder_point | Unknown | |
retail_price | Unknown | |
sale_price | Unknown | |
short_description | Unknown | |
variation_parent_sku | Unknown | |
weight_unit | Unknown | |
weight_value | Unknown |
token
| Column | Type | Keys |
|---|---|---|
tenant_token | Unknown | PK |
user_token | Unknown | PK |
available_alternate_sku
| Column | Type | Keys |
|---|---|---|
alternate_sku | Unknown | PK |
product_sku | Unknown | PKFK |
available_quantity
| Column | Type | Keys |
|---|---|---|
product_sku | Unknown | PKFK |
last_modified_date_time_utc | Instant |
warehouse
| Column | Type | Keys |
|---|---|---|
code | Unknown | PK |
id | Unknown |
classification_attribute
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
classification_name | Unknown | PKFK |
is_enabled | Unknown | |
is_required | Unknown | |
values | Json |
classification
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
is_enabled | Unknown |
brand
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
is_enabled | Unknown |
external_warehouse_quantitiy
| Column | Type | Keys |
|---|---|---|
product_sku | Unknown | PKFK |
in_stock_quantity | Unknown | |
inbound_quantity | Unknown | |
reserve_quantity | Unknown | |
total_quantity | Unknown | |
transfer_quantity | Unknown |
purchase_order_line_item
| Column | Type | Keys |
|---|---|---|
product_sku | Unknown | PKFK |
purchase_order_id | Unknown | PKFK |
cost | Unknown | |
identifier | Unknown | |
private_notes | Unknown | |
public_notes | Unknown | |
quantity | Unknown | |
quantity_to_3_pl | Unknown | |
received_quantity | Unknown | |
received_quantity_to_3_pl | Unknown | |
retail_cost | Unknown | |
variant | Unknown |
purchase_order
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
supplier_name | Unknown | FK |
actual_shipped_date | Instant | |
arrival_due_date | Instant | |
carrier_name | Unknown | |
class_name | Unknown | |
costs | Json | |
created_date | Instant | |
order_cancel_date | Instant | |
order_date | Instant | |
payment_status | Unknown | |
po_number | Unknown | |
private_notes | Unknown | |
public_notes | Unknown | |
requested_ship_date | Instant | |
sent_status | Unknown | |
ship_to_address | Unknown | |
ship_to_warehouse | Unknown | |
status | Unknown | |
terms_name | Unknown | |
tracking_info | Unknown |
kit_line_item
| Column | Type | Keys |
|---|---|---|
kit_line_index | Unknown | PKFK |
kit_sku | Unknown | PKFK |
product_sku | Unknown | PKFK |
code | Unknown | |
description | Unknown |
kit_line
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
kit_sku | Unknown | PKFK |
combine | Unknown | |
line_name | Unknown | |
quantity | Unknown |
kit_status
| Column | Type | Keys |
|---|---|---|
status | Unknown | PK |
kit_sku | Unknown | PKFK |
kit
| Column | Type | Keys |
|---|---|---|
sku | Unknown | PK |
available_quantity | Unknown | |
available_quantity_last_modified_date_time_utc | Unknown | |
code | Unknown | |
cost | Unknown | |
description | Unknown | |
last_modified_date_time_utc | Unknown |
location
| Column | Type | Keys |
|---|---|---|
location_code | Unknown | PK |
warehouse_code | Unknown | PKFK |
container_code | Unknown | |
parent_location | Unknown | |
total_quantity | Unknown | |
warehouse_name | Unknown |
shipment_cost
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
shipment_sale_id | Unknown | FK |
shipment_tracking_number | Unknown | FK |
cost_a | Unknown | |
cost_s | Unknown | |
cost_type | Unknown |
shipment_parcel_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
shipment_parcel_number | Unknown | PKFK |
shipment_sale_id | Unknown | PKFK |
shipment_tracking_number | Unknown | PKFK |
product_sku | Unknown | FK |
quantity | Unknown |
shipment_parcel_kit
| Column | Type | Keys |
|---|---|---|
kit_sku | Unknown | PKFK |
shipment_parcel_number | Unknown | PKFK |
shipment_sale_id | Unknown | PKFK |
shipment_tracking_number | Unknown | PKFK |
shipment_parcel
| Column | Type | Keys |
|---|---|---|
number | Unknown | PK |
shipment_sale_id | Unknown | PKFK |
shipment_tracking_number | Unknown | PKFK |
dimensionsheight | Unknown | |
dimensionslength | Unknown | |
dimensionsunit | Unknown | |
dimensionswidth | Unknown | |
note | Unknown | |
weight | Unknown | |
weight_unit | Unknown |
shipment_landed_cost
| Column | Type | Keys |
|---|---|---|
product_sku | Unknown | PKFK |
shipment_sale_id | Unknown | PKFK |
shipment_tracking_number | Unknown | PKFK |
cost_a | Unknown | |
cost_s | Unknown |
shipment
| Column | Type | Keys |
|---|---|---|
tracking_number | Unknown | PK |
sale_id | Unknown | PKFK |
shipped_from_warehouse_code | Unknown | FK |
alternate_id | Unknown | |
carrier | Unknown | |
class | Unknown | |
created_date | Unknown | |
estimated_delivery_date | Unknown | |
estimated_ship_date | Unknown | |
file_id | Json | |
manifest_id | Unknown | |
note | Unknown | |
shipped_from_address_1 | Unknown | |
shipped_from_address_2 | Unknown | |
shipped_from_city | Unknown | |
shipped_from_company | Unknown | |
shipped_from_country | Unknown | |
shipped_from_email | Unknown | |
shipped_from_first_name | Unknown | |
shipped_from_last_name | Unknown | |
shipped_from_middle_name | Unknown | |
shipped_from_postal_code | Unknown | |
shipped_from_region | Unknown | |
shipped_from_three_pl | Unknown | |
source | Unknown | |
status | Unknown | |
total_weight | Unknown | |
tracking_url | Unknown | |
type | Unknown | |
weight_unit | Unknown |
transaction
| Column | Type | Keys |
|---|---|---|
transaction_date | Instant | PK |
product_sku | Unknown | PKFK |
context_id | Unknown | |
context_type | Unknown | |
location | Unknown | |
lot_number | Unknown | |
quantity | Unknown | |
quantity_after | Unknown | |
quantity_before | Unknown | |
scanned_code | Unknown | |
title | Unknown | |
transaction_note | Unknown | |
transaction_reason | Unknown | |
transaction_type | Unknown | |
username | Unknown |
supplier
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
is_enabled | Unknown |
serial_number
| Column | Type | Keys |
|---|---|---|
serial_number | Unknown | PK |
location_code | Unknown | FK |
warehouse_code | Unknown | FK |
container_code | Unknown |
receive_history
| Column | Type | Keys |
|---|---|---|
product_sku | Unknown | PKFK |
location | Unknown | FK |
warehouse | Unknown | FK |
part_number | Unknown | |
quantity | Unknown | |
quantity_3_pl | Unknown | |
quantity_to_location | Unknown | |
receipt_date | Instant | |
received_date | Instant | |
username | Unknown |
receive_correction_quantity_receipt_date
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
product_sku | Unknown | FK |
new_quantity | Unknown | |
old_quantity | Unknown | |
receipt_date | Instant |
receive_correction
| Column | Type | Keys |
|---|---|---|
product_sku | Unknown | PKFK |
warehouse | Unknown | FK |
corrected_date | Instant | |
new_quantity | Unknown | |
new_quantity_3_pl | Unknown | |
old_quantity | Unknown | |
old_quantity_3_pl | Unknown | |
part_number | Unknown | |
ponumber | Unknown | |
received_date | Instant | |
username | Unknown |
external_warehouse
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
code | Unknown | |
name | Unknown |
handling_time_kit
| Column | Type | Keys |
|---|---|---|
account_id | Unknown | PK |
product_sku | Unknown | PKFK |
quantity | Unknown |
handling_time_product
| Column | Type | Keys |
|---|---|---|
account_id | Unknown | PK |
kit_sku | Unknown | PKFK |
quantity | Unknown |
inventory_location
| Column | Type | Keys |
|---|---|---|
location_code | Unknown | PK |
sku | Unknown | PK |
warehouse_code | Unknown | PKFK |
quantity | Unknown | |
reserve | Unknown |
sale_item_promotion
| Column | Type | Keys |
|---|---|---|
code | Unknown | PK |
product_sku | Unknown | PKFK |
item_discount_a | Unknown | |
item_discount_s | Unknown | |
shipping_discount_a | Unknown | |
shipping_discount_s | Unknown |
sale_item
| Column | Type | Keys |
|---|---|---|
product_sku | Unknown | PKFK |
sale_id | Unknown | FK |
quantity | Unknown | |
taxes | Unknown | |
unit_price_a | Unknown | |
unit_price_s | Unknown |
sale_kit
| Column | Type | Keys |
|---|---|---|
kit_sku | Unknown | PKFK |
sale_id | Unknown | PKFK |
kit_items | Json | |
quantity | Unknown | |
unit_price_a | Unknown | |
unit_price_s | Unknown |
sale_charge
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
sale_id | Unknown | FK |
amount_a | Unknown | |
amount_s | Unknown | |
type | Unknown |
sale_promotion
| Column | Type | Keys |
|---|---|---|
code | Unknown | PK |
sale_id | Unknown | PKFK |
order_discount_a | Unknown | |
order_discount_s | Unknown | |
shipping_discount_a | Unknown | |
shipping_discount_s | Unknown | |
type | Unknown |
sale
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
channel_id | Unknown | |
contact_infocompany | Unknown | |
contact_infoemail | Unknown | |
contact_infofirst_name | Unknown | |
contact_infolast_name | Unknown | |
contact_infophone | Unknown | |
fulfilled_items | Json | |
fulfilled_kits | Json | |
last_printed_date | Unknown | |
marketplace | Unknown | |
marketplace_id | Unknown | |
notes | Unknown | |
printed_status | Unknown | |
sale_date | Unknown | |
seller_sale_id | Unknown | |
shipping_carrier | Unknown | |
shipping_chargea | Unknown | |
shipping_charges | Unknown | |
shipping_class | Unknown | |
shipping_costa | Unknown | |
shipping_costs | Unknown | |
shipping_infoaddress_1 | Unknown | |
shipping_infoaddress_2 | Unknown | |
shipping_infocity | Unknown | |
shipping_infocountry | Unknown | |
shipping_infopostal_code | Unknown | |
shipping_inforegion | Unknown | |
status | Unknown |
item_quantity
| Column | Type | Keys |
|---|---|---|
product_sku | Unknown | PKFK |
last_modified_date_time_utc | Instant |
incoming_item
| Column | Type | Keys |
|---|---|---|
product_sku | Unknown | PKFK |
third_party_logistic_quantity | Unknown |