# SkuVault schema ERD

Table and field reference for the Fivetran SkuVault connector.

## Table & Field Reference

### sale_merchant_item_by_date

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_sku | Unknown | PK, FK |
| sale_by_date_id | Unknown | PK, FK |
| 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 | PK, FK |
| sale_merchant_kit_by_date_index | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| supplier_name | Unknown | PK, FK |
| 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 | PK, FK |

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

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

### available_quantity

| Column | Type | Keys |
| --- | --- | --- |
| product_sku | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| purchase_order_id | Unknown | PK, FK |
| 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 | PK, FK |
| kit_sku | Unknown | PK, FK |
| product_sku | Unknown | PK, FK |
| code | Unknown |  |
| description | Unknown |  |

### kit_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| kit_sku | Unknown | PK, FK |
| combine | Unknown |  |
| line_name | Unknown |  |
| quantity | Unknown |  |

### kit_status

| Column | Type | Keys |
| --- | --- | --- |
| status | Unknown | PK |
| kit_sku | Unknown | PK, FK |

### 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 | PK, FK |
| 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 | PK, FK |
| shipment_sale_id | Unknown | PK, FK |
| shipment_tracking_number | Unknown | PK, FK |
| product_sku | Unknown | FK |
| quantity | Unknown |  |

### shipment_parcel_kit

| Column | Type | Keys |
| --- | --- | --- |
| kit_sku | Unknown | PK, FK |
| shipment_parcel_number | Unknown | PK, FK |
| shipment_sale_id | Unknown | PK, FK |
| shipment_tracking_number | Unknown | PK, FK |

### shipment_parcel

| Column | Type | Keys |
| --- | --- | --- |
| number | Unknown | PK |
| shipment_sale_id | Unknown | PK, FK |
| shipment_tracking_number | Unknown | PK, FK |
| dimensionsheight | Unknown |  |
| dimensionslength | Unknown |  |
| dimensionsunit | Unknown |  |
| dimensionswidth | Unknown |  |
| note | Unknown |  |
| weight | Unknown |  |
| weight_unit | Unknown |  |

### shipment_landed_cost

| Column | Type | Keys |
| --- | --- | --- |
| product_sku | Unknown | PK, FK |
| shipment_sale_id | Unknown | PK, FK |
| shipment_tracking_number | Unknown | PK, FK |
| cost_a | Unknown |  |
| cost_s | Unknown |  |

### shipment

| Column | Type | Keys |
| --- | --- | --- |
| tracking_number | Unknown | PK |
| sale_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| quantity | Unknown |  |

### handling_time_product

| Column | Type | Keys |
| --- | --- | --- |
| account_id | Unknown | PK |
| kit_sku | Unknown | PK, FK |
| quantity | Unknown |  |

### inventory_location

| Column | Type | Keys |
| --- | --- | --- |
| location_code | Unknown | PK |
| sku | Unknown | PK |
| warehouse_code | Unknown | PK, FK |
| quantity | Unknown |  |
| reserve | Unknown |  |

### sale_item_promotion

| Column | Type | Keys |
| --- | --- | --- |
| code | Unknown | PK |
| product_sku | Unknown | PK, FK |
| item_discount_a | Unknown |  |
| item_discount_s | Unknown |  |
| shipping_discount_a | Unknown |  |
| shipping_discount_s | Unknown |  |

### sale_item

| Column | Type | Keys |
| --- | --- | --- |
| product_sku | Unknown | PK, FK |
| sale_id | Unknown | FK |
| quantity | Unknown |  |
| taxes | Unknown |  |
| unit_price_a | Unknown |  |
| unit_price_s | Unknown |  |

### sale_kit

| Column | Type | Keys |
| --- | --- | --- |
| kit_sku | Unknown | PK, FK |
| sale_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| last_modified_date_time_utc | Instant |  |

### incoming_item

| Column | Type | Keys |
| --- | --- | --- |
| product_sku | Unknown | PK, FK |
| third_party_logistic_quantity | Unknown |  |

## Relationships

- sale_merchant_item_by_date(product_sku) → product(sku)
- sale_merchant_item_by_date(sale_by_date_id) → sale_by_date(id)
- sale_merchant_kit_item_by_date(sale_merchant_kit_by_date_index) → sale_merchant_kit_by_date(index)
- sale_merchant_kit_item_by_date(sale_by_date_id) → sale_merchant_kit_by_date(sale_by_date_id)
- sale_merchant_kit_by_date(product_sku) → product(sku)
- sale_merchant_kit_by_date(sale_by_date_id) → sale_by_date(id)
- sale_processed_item_by_date(product_sku) → product(sku)
- sale_processed_item_by_date(sale_by_date_id) → sale_by_date(id)
- product_supplier_info(supplier_name) → supplier(name)
- product_supplier_info(product_sku) → product(sku)
- product_picture(product_sku) → product(sku)
- product_attribute(product_sku) → product(sku)
- product_status(product_sku) → product(sku)
- product(brand) → brand(name)
- product(primary_sku) → product(sku)
- product(supplier) → supplier(name)
- product(classification) → classification(name)
- available_alternate_sku(product_sku) → available_quantity(product_sku)
- available_quantity(product_sku) → product(sku)
- classification_attribute(classification_name) → classification(name)
- external_warehouse_quantitiy(product_sku) → product(sku)
- purchase_order_line_item(product_sku) → product(sku)
- purchase_order_line_item(purchase_order_id) → purchase_order(id)
- purchase_order(supplier_name) → supplier(name)
- kit_line_item(product_sku) → product(sku)
- kit_line_item(kit_sku) → kit_line(kit_sku)
- kit_line_item(kit_line_index) → kit_line(index)
- kit_line(kit_sku) → kit(sku)
- kit_status(kit_sku) → kit(sku)
- location(warehouse_code) → warehouse(code)
- shipment_cost(shipment_sale_id) → shipment(sale_id)
- shipment_cost(shipment_tracking_number) → shipment(tracking_number)
- shipment_parcel_item(product_sku) → product(sku)
- shipment_parcel_item(shipment_parcel_number) → shipment_parcel(number)
- shipment_parcel_item(shipment_sale_id) → shipment_parcel(shipment_sale_id)
- shipment_parcel_item(shipment_tracking_number) → shipment_parcel(shipment_tracking_number)
- shipment_parcel_kit(kit_sku) → kit(sku)
- shipment_parcel_kit(shipment_parcel_number) → shipment_parcel(number)
- shipment_parcel_kit(shipment_sale_id) → shipment_parcel(shipment_sale_id)
- shipment_parcel_kit(shipment_tracking_number) → shipment_parcel(shipment_tracking_number)
- shipment_parcel(shipment_sale_id) → shipment(sale_id)
- shipment_parcel(shipment_tracking_number) → shipment(tracking_number)
- shipment_landed_cost(product_sku) → product(sku)
- shipment_landed_cost(shipment_sale_id) → shipment(sale_id)
- shipment_landed_cost(shipment_tracking_number) → shipment(tracking_number)
- shipment(sale_id) → sale(id)
- shipment(shipped_from_warehouse_code) → warehouse(code)
- transaction(product_sku) → product(sku)
- serial_number(warehouse_code) → warehouse(code)
- serial_number(location_code) → location(location_code)
- receive_history(warehouse) → warehouse(code)
- receive_history(product_sku) → product(sku)
- receive_history(location) → location(location_code)
- receive_correction_quantity_receipt_date(product_sku) → receive_correction(product_sku)
- receive_correction(warehouse) → warehouse(code)
- receive_correction(product_sku) → product(sku)
- handling_time_kit(product_sku) → product(sku)
- handling_time_product(kit_sku) → kit(sku)
- inventory_location(warehouse_code) → warehouse(code)
- sale_item_promotion(product_sku) → sale_item(product_sku)
- sale_item(product_sku) → product(sku)
- sale_item(sale_id) → sale(id)
- sale_kit(kit_sku) → kit(sku)
- sale_kit(sale_id) → sale(id)
- sale_charge(sale_id) → sale(id)
- sale_promotion(sale_id) → sale(id)
- item_quantity(product_sku) → product(sku)
- incoming_item(product_sku) → product(sku)