Wherefour
Explore the interactive ERD
Table & Field Reference
quote_line_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
quote_id | Unknown | PKFK |
inventory_id | Unknown | FK |
category_name | Unknown | |
cost | Unknown | |
count | Unknown | |
created_at | Unknown | |
name | Unknown | |
sku | Unknown | |
updated_at | Unknown |
quote
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_id | Unknown | FK |
created_at | Unknown | |
date | Unknown | |
delivery_method_id | Unknown | |
discount | Unknown | |
expiration_date | Unknown | |
instruction | Unknown | |
number | Unknown | |
payment_term_id | Unknown | |
salesperson_name | Unknown | |
shipping | Unknown | |
status | Unknown | |
subtotal | Unknown | |
tax | Unknown | |
total | Unknown | |
updated_at | Unknown |
shipment_address
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
shipment_id | Unknown | PKFK |
city | Unknown | |
country | Unknown | |
country_subdivision_code | Unknown | |
created_at | Unknown | |
descriptive_name | Unknown | |
line_1 | Unknown | |
line_2 | Unknown | |
line_3 | Unknown | |
line_4 | Unknown | |
line_5 | Unknown | |
postal_code | Unknown | |
updated_at | Unknown |
shipment_item_auto_ship
| Column | Type | Keys |
|---|---|---|
adjustment_id | Unknown | PK |
shipment_id | Unknown | PKFK |
shipment_item_id | Unknown | PKFK |
barcode | Unknown | |
change | Unknown | |
count | Unknown | |
lot_code | Unknown | |
reason | Unknown | |
stock_id | Unknown |
shipment_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
shipment_id | Unknown | PKFK |
count | Unknown | |
inventory_name | Unknown | |
inventory_sku | Unknown | |
part_of_kit | Unknown |
shipment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_id | Unknown | FK |
order_id | Unknown | FK |
created_at | Unknown | |
delivery_driver | Unknown | |
delivery_vehicle | Unknown | |
note | Unknown | |
number | Unknown | |
ship_date | Unknown | |
tracking_number | Unknown | |
updated_at | Unknown | |
user_name | Unknown |
purchase_line_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
purchase_id | Unknown | PKFK |
inventory_id | Unknown | FK |
category_name | Unknown | |
cost | Unknown | |
count | Unknown | |
created_at | Unknown | |
name | Unknown | |
sku | Unknown | |
updated_at | Unknown |
purchase
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
vendor_id | Unknown | FK |
created_at | Unknown | |
date | Unknown | |
deliver_by_date | Unknown | |
delivery_method_id | Unknown | |
delivery_method_instruction | Unknown | |
delivery_method_kind | Unknown | |
delivery_method_name | Unknown | |
discount | Unknown | |
instruction | Unknown | |
number | Unknown | |
shipping | Unknown | |
status | Unknown | |
subtotal | Unknown | |
tax | Unknown | |
total | Unknown | |
updated_at | Unknown |
inventory_conversion
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
inventory_id | Unknown | FK |
catch_weight | Unknown | |
from_count | Unknown | |
maximum_weight | Unknown | |
minimum_weight | Unknown | |
to_count | Unknown | |
unit_of_measurement | Unknown |
inventory_custom_field_value
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
inventory_id | Unknown | PKFK |
active_stock_id | Unknown | |
created_at | Unknown | |
updated_at | Unknown | |
value | Unknown | |
value_type | Unknown | |
custom_** |
inventory
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
category_name | Unknown | |
created_at | Unknown | |
height | Unknown | |
lead_time | Unknown | |
length | Unknown | |
name | Unknown | |
on_hand | Unknown | |
property | Unknown | |
pull_strategy | Unknown | |
purchase_conversion | Unknown | |
quantity_not_tracked | Unknown | |
reorder_point | Unknown | |
retired | Unknown | |
sku | Unknown | |
unit_of_dimension | Unknown | |
unit_of_invoice | Unknown | |
unit_of_order | Unknown | |
unit_of_pick_and_ship | Unknown | |
unit_of_purchase | Unknown | |
unit_of_use | Unknown | |
unit_of_weight | Unknown | |
updated_at | Unknown | |
waste_percentage | Unknown | |
weight | Unknown | |
width | Unknown |
order_line_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
order_id | Unknown | PKFK |
inventory_id | Unknown | FK |
category_name | Unknown | |
cost | Unknown | |
count | Unknown | |
created_at | Unknown | |
name | Unknown | |
sku | Unknown | |
updated_at | Unknown |
order_billing_address
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
orders_id | Unknown | PKFK |
city | Unknown | |
country | Unknown | |
country_subdivision_code | Unknown | |
created_at | Unknown | |
descriptive_name | Unknown | |
line_1 | Unknown | |
line_2 | Unknown | |
line_3 | Unknown | |
line_4 | Unknown | |
line_5 | Unknown | |
postal_code | Unknown | |
updated_at | Unknown |
order_shipping_address
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
orders_id | Unknown | PKFK |
city | Unknown | |
country | Unknown | |
country_subdivision_code | Unknown | |
created_at | Unknown | |
descriptive_name | Unknown | |
line_1 | Unknown | |
line_2 | Unknown | |
line_3 | Unknown | |
line_4 | Unknown | |
line_5 | Unknown | |
postal_code | Unknown | |
updated_at | Unknown |
order_ship_from_address
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
orders_id | Unknown | PKFK |
city | Unknown | |
country | Unknown | |
country_subdivision_code | Unknown | |
created_at | Unknown | |
descriptive_name | Unknown | |
line_1 | Unknown | |
line_2 | Unknown | |
line_3 | Unknown | |
line_4 | Unknown | |
line_5 | Unknown | |
postal_code | Unknown | |
updated_at | Unknown |
orders
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_id | Unknown | FK |
created_at | Unknown | |
deliver_date | Unknown | |
delivery_method_id | Unknown | |
discount | Unknown | |
instruction | Unknown | |
invoiced | Unknown | |
invoiced_at | Unknown | |
order_date | Unknown | |
order_number | Unknown | |
payment_term_id | Unknown | |
po_number | Unknown | |
produce_date | Unknown | |
sales_channel_name | Unknown | |
sales_person_name | Unknown | |
ship_date | Unknown | |
shipping | Unknown | |
status | Unknown | |
subtotal | Unknown | |
tax | Unknown | |
total | Unknown | |
updated_at | Unknown |
customer_address
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_id | Unknown | PKFK |
city | Unknown | |
country | Unknown | |
country_subdivision_code | Unknown | |
created_at | Unknown | |
descriptive_name | Unknown | |
line_1 | Unknown | |
line_2 | Unknown | |
line_3 | Unknown | |
line_4 | Unknown | |
line_5 | Unknown | |
postal_code | Unknown | |
updated_at | Unknown |
customer_billing_address
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_id | Unknown | PKFK |
city | Unknown | |
country | Unknown | |
country_subdivision_code | Unknown | |
created_at | Unknown | |
descriptive_name | Unknown | |
line_1 | Unknown | |
line_2 | Unknown | |
line_3 | Unknown | |
line_4 | Unknown | |
line_5 | Unknown | |
postal_code | Unknown | |
updated_at | Unknown |
customer_shipping_address
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_id | Unknown | PKFK |
city | Unknown | |
country | Unknown | |
country_subdivision_code | Unknown | |
created_at | Unknown | |
descriptive_name | Unknown | |
line_1 | Unknown | |
line_2 | Unknown | |
line_3 | Unknown | |
line_4 | Unknown | |
line_5 | Unknown | |
postal_code | Unknown | |
updated_at | Unknown |
customer
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
business_license_number | Unknown | |
created_at | Unknown | |
default_special_instructions | Unknown | |
delivery_driver | Unknown | |
delivery_method | Unknown | |
delivery_method_id | Unknown | |
delivery_vehicle | Unknown | |
display_name | Unknown | |
email | Unknown | |
fax | Unknown | |
first_name | Unknown | |
kind | Unknown | |
last_name | Unknown | |
mobile | Unknown | |
note | Unknown | |
payment_terms | Unknown | |
phone | Unknown | |
sales_channel | Unknown | |
salesperson | Unknown | |
updated_at | Unknown | |
website | Unknown | |
custom_** |
invoice_line_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
invoice_id | Unknown | PKFK |
inventory_id | Unknown | FK |
category_name | Unknown | |
cost | Unknown | |
count | Unknown | |
created_at | Unknown | |
name | Unknown | |
sku | Unknown | |
updated_at | Unknown |
invoice_billing_address
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
invoice_id | Unknown | PKFK |
city | Unknown | |
country | Unknown | |
country_subdivision_code | Unknown | |
created_at | Unknown | |
descriptive_name | Unknown | |
line_1 | Unknown | |
line_2 | Unknown | |
line_3 | Unknown | |
line_4 | Unknown | |
line_5 | Unknown | |
postal_code | Unknown | |
updated_at | Unknown |
invoice_shipping_address
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
invoice_id | Unknown | PKFK |
city | Unknown | |
country | Unknown | |
country_subdivision_code | Unknown | |
created_at | Unknown | |
descriptive_name | Unknown | |
line_1 | Unknown | |
line_2 | Unknown | |
line_3 | Unknown | |
line_4 | Unknown | |
line_5 | Unknown | |
postal_code | Unknown | |
updated_at | Unknown |
invoice
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_id | Unknown | FK |
created_at | Unknown | |
date | Unknown | |
delivery_method_id | Unknown | |
discount | Unknown | |
instruction | Unknown | |
invoice_number | Unknown | |
payment_term_id | Unknown | |
sales_channel | Unknown | |
sales_person_id | Unknown | |
salesperson_name | Unknown | |
shipping | Unknown | |
status | Unknown | |
subtotal | Unknown | |
tax | Unknown | |
total | Unknown | |
updated_at | Unknown |
categories
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown |
vendor_billing_address
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
vendor_id | Unknown | PKFK |
city | Unknown | |
country | Unknown | |
country_subdivision_code | Unknown | |
created_at | Unknown | |
descriptive_name | Unknown | |
line_1 | Unknown | |
line_2 | Unknown | |
line_3 | Unknown | |
line_4 | Unknown | |
line_5 | Unknown | |
postal_code | Unknown | |
updated_at | Unknown |
vendor_shipping_address
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
vendor_id | Unknown | PKFK |
city | Unknown | |
country | Unknown | |
country_subdivision_code | Unknown | |
created_at | Unknown | |
descriptive_name | Unknown | |
line_1 | Unknown | |
line_2 | Unknown | |
line_3 | Unknown | |
line_4 | Unknown | |
line_5 | Unknown | |
postal_code | Unknown | |
updated_at | Unknown |
vendor
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
business_license_number | Unknown | |
created_at | Unknown | |
delivery_method_id | Unknown | |
delivery_method_kind | Unknown | |
delivery_method_name | Unknown | |
display_name | Unknown | |
email | Unknown | |
fax | Unknown | |
first_name | Unknown | |
kind | Unknown | |
last_name | Unknown | |
mobile | Unknown | |
note | Unknown | |
payment_term_id | Unknown | |
payment_term_name | Unknown | |
payment_term_net | Unknown | |
phone | Unknown | |
updated_at | Unknown | |
website | Unknown | |
custom_** |