Katana
Explore the interactive ERD
Table & Field Reference
manufacturing_ordering_recipe_batch_transaction
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
manufacturing_ordering_recipe_id | Unknown | PKFK |
batch_id | Unknown | FK |
quantity | Unknown |
manufacturing_ordering_recipe
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
manufacturing_order_id | Unknown | FK |
variant_id | Unknown | FK |
cost | Unknown | |
created_at | Unknown | |
deleted_at | Instant | |
ingredient_availability | Unknown | |
ingredient_expected_date | Unknown | |
notes | Unknown | |
planned_quantity_per_unit | Unknown | |
total_actual_quantity | Unknown | |
total_consumed_quantity | Unknown | |
total_remaining_quantity | Unknown | |
updated_at | Unknown |
stock_adjustment_row_batch_transaction
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
stock_adjustment_id | Unknown | PKFK |
stock_adjustment_row_id | Unknown | PKFK |
batch_id | Unknown | FK |
quantity | Unknown |
stock_adjustment_row
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
stock_adjustment_id | Unknown | PKFK |
variant_id | Unknown | FK |
cost_per_unit | Unknown | |
created_at | Unknown | |
deleted_at | Unknown | |
quantity | Unknown | |
updated_at | Unknown |
stock_adjustment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
location_id | Unknown | FK |
additional_info | Unknown | |
created_at | Unknown | |
deleted_at | Unknown | |
reason | Unknown | |
stock_adjustment_date | Unknown | |
stock_adjustment_number | Unknown | |
updated_at | Unknown |
tax_rate
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Unknown | |
display_name | Unknown | |
is_default_purchases | Unknown | |
is_default_sales | Unknown | |
name | Unknown | |
rate | Unknown | |
updated_at | Unknown |
supplier_address
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
supplier_id | Unknown | PKFK |
city | Unknown | |
country | Unknown | |
created_at | Unknown | |
line_1 | Unknown | |
line_2 | Unknown | |
state | Unknown | |
updated_at | Unknown | |
zip | Unknown |
supplier
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
comment | Unknown | |
created_at | Unknown | |
currency | Unknown | |
default_address_id | Unknown | |
deleted_at | Unknown | |
email | Unknown | |
name | Unknown | |
updated_at | Unknown |
variant_config_attribute
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
variant_id | Unknown | FK |
config_name | Unknown | |
config_value | Unknown |
variant_supplier_item_code
| Column | Type | Keys |
|---|---|---|
supplier_item_code | Unknown | PK |
variant_id | Unknown | PKFK |
variant
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
material_id | Unknown | FK |
product_id | Unknown | FK |
created_at | Unknown | |
deleted_at | Unknown | |
internal_barcode | Unknown | |
purchase_price | Unknown | |
registered_barcode | Unknown | |
sales_price | Unknown | |
sku | Unknown | |
type | Unknown | |
updated_at | Unknown |
stock_transfer_row_batch_transaction
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
stock_transfer_id | Unknown | PKFK |
stock_transfer_row_id | Unknown | PKFK |
batch_id | Unknown | FK |
quantity | Unknown |
stock_transfer_row
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
stock_transfer_id | Unknown | PKFK |
cost_per_unit | Unknown | |
deleted_at | Unknown | |
quantity | Unknown | |
variant_id | Unknown |
stock_transfer
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
source_location_id | Unknown | FK |
target_location_id | Unknown | FK |
additional_info | Unknown | |
created_at | Unknown | |
deleted_at | Unknown | |
stock_transfer_number | Unknown | |
transfer_date | Unknown | |
updated_at | Unknown |
manufacture_order_operation
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
completed_at | Unknown | |
cost_per_hour | Unknown | |
created_at | Unknown | |
deleted_at | Unknown | |
manufacturing_order_id | Unknown | |
operation_id | Unknown | |
operation_name | Unknown | |
planned_cost_per_unit | Unknown | |
planned_time_per_unit | Unknown | |
rank | Unknown | |
resource_id | Unknown | |
resource_name | Unknown | |
status | Unknown | |
total_actual_cost | Unknown | |
total_actual_time | Unknown | |
total_consumed_time | Unknown | |
total_remaining_time | Unknown | |
updated_at | Unknown |
manufacturing_order_operator
| Column | Type | Keys |
|---|---|---|
operator_id | Unknown | PK |
manufacture_order_operation_id | Unknown | PKFK |
deleted_at | Unknown | |
name | Unknown | |
type | Unknown |
customer_address
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_id | Unknown | FK |
city | Unknown | |
company | Unknown | |
country | Unknown | |
created_at | Unknown | |
deleted_at | Instant | |
entity_type | Unknown | |
first_name | Unknown | |
last_name | Unknown | |
line_1 | Unknown | |
line_2 | Unknown | |
phone | Unknown | |
state | Unknown | |
updated_at | Unknown | |
zip | Unknown |
inventory_movement
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
location_id | Unknown | FK |
variant_id | Unknown | FK |
average_cost_after | Unknown | |
balance_after | Unknown | |
caused_by_order_no | Unknown | |
caused_by_resource_id | Unknown | |
created_at | Unknown | |
movement_date | Unknown | |
quantity_change | Unknown | |
rank | Unknown | |
resource_id | Unknown | |
resource_type | Unknown | |
updated_at | Unknown | |
value_in_stock_after | Unknown | |
value_per_unit | Unknown |
batch
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
location_id | Unknown | FK |
variant_id | Unknown | FK |
batch_barcode | Unknown | |
batch_created_date | Unknown | |
batch_number | Unknown | |
expiration_date | Unknown | |
quantity_in_stock | Unknown |
outsource_purchase_batch_transaction
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
outsource_purchase_order_id | Unknown | PKFK |
batch_id | Unknown | FK |
quantity | Unknown |
outsource_purchase_order_recipe
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
ingredient_variant_id | Unknown | FK |
purchase_order_id | Unknown | FK |
purchase_order_row_id | Unknown | FK |
cost | Unknown | |
ingredient_availability | Unknown | |
ingredient_expected_date | Unknown | |
notes | Unknown | |
planned_quantity_per_unit | Unknown |
purchase_order_purchase_order_row
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
purchase_order_id | Unknown | PKFK |
purchase_order
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
location_id | Unknown | FK |
supplier_id | Unknown | FK |
tracking_location_id | Unknown | FK |
additional_info | Unknown | |
billing_status | Unknown | |
created_at | Unknown | |
currency | Unknown | |
deleted_at | Unknown | |
entity_type | Unknown | |
expected_arrival_date | Unknown | |
ingredient_availability | Unknown | |
ingredient_expected_date | Unknown | |
last_document_status | Unknown | |
order_created_date | Unknown | |
order_no | Unknown | |
status | Unknown | |
total | Unknown | |
total_in_base_currency | Unknown | |
updated_at | Unknown |
manufacturing_order_batch_transaction
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
manufacturing_order_id | Unknown | PKFK |
batch_id | Unknown | FK |
quantity | Unknown |
manufacturing_order_serial_number
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
manufacturing_order_id | Unknown | PKFK |
resource_id | Unknown | |
resource_type | Unknown | |
serial_number | Unknown | |
transaction_date | Unknown | |
transaction_id | Unknown |
manufacturing_order
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
location_id | Unknown | FK |
sales_order_id | Unknown | FK |
sales_order_row_id | Unknown | FK |
variant_id | Unknown | FK |
actual_quantity | Unknown | |
additional_info | Unknown | |
completed_quantity | Unknown | |
created_at | Unknown | |
deleted_at | Unknown | |
done_date | Unknown | |
includes_partial_completions | Unknown | |
ingredient_availability | Unknown | |
is_linked_to_sales_order | Unknown | |
material_cost | Unknown | |
operations_cost | Unknown | |
order_created_date | Unknown | |
order_no | Unknown | |
planned_quantity | Unknown | |
production_deadline_date | Unknown | |
remaining_quantity | Unknown | |
sales_order_delivery_deadline | Unknown | |
status | Unknown | |
subassemblies_cost | Unknown | |
total_actual_time | Unknown | |
total_cost | Unknown | |
total_planned_time | Unknown | |
updated_at | Unknown |
sales_order_fuiliment_row
| Column | Type | Keys |
|---|---|---|
sales_order_fulfillment_id | Unknown | PKFK |
sales_order_row_id | Unknown | PKFK |
quantity | Unknown |
sales_order_fulfillment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
sales_order_id | Unknown | FK |
conversion_date | Unknown | |
conversion_rate | Unknown | |
invoice_status | Unknown | |
picked_date | Unknown | |
status | Unknown | |
tracking_carrier | Unknown | |
tracking_method | Unknown | |
tracking_number | Unknown | |
tracking_url | Unknown |
inventory
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
location_id | Unknown | FK |
variant_id | Unknown | FK |
average_cost | Unknown | |
quantity_committed | Unknown | |
quantity_expected | Unknown | |
quantity_in_stock | Unknown | |
quantity_missing_or_excess | Unknown | |
reorder_point | Unknown | |
value_in_stock | Unknown |
sales_order_address
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
sales_order_id | Unknown | FK |
city | Unknown | |
company | Unknown | |
country | Unknown | |
created_at | Unknown | |
deleted_at | Unknown | |
entity_type | Unknown | |
first_name | Unknown | |
last_name | Unknown | |
line_1 | Unknown | |
line_2 | Unknown | |
phone | Unknown | |
state | Unknown | |
updated_at | Unknown | |
zip | Unknown |
production_operation
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
operation_id | Unknown | FK |
product_id | Unknown | FK |
cost_per_hour | Unknown | |
created_at | Unknown | |
operation_name | Unknown | |
planned_cost_per_unit | Unknown | |
planned_time_per_unit | Unknown | |
product_operation_row_id | Unknown | |
product_variant_id | Unknown | |
rank | Unknown | |
resource_id | Unknown | |
resource_name | Unknown | |
updated_at | Unknown |
purchase_order_row_batch_transaction
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
purchase_order_row_id | Unknown | PKFK |
batch_id | Unknown | FK |
quantity | Unknown |
purchase_order_row
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
purchase_order_id | Unknown | FK |
tax_rate_id | Unknown | FK |
variant_id | Unknown | FK |
conversion_date | Unknown | |
conversion_rate | Unknown | |
created_at | Unknown | |
currency | Unknown | |
deleted_at | Unknown | |
price_per_unit | Unknown | |
purchase_uom | Unknown | |
purchase_uom_conversion_rate | Unknown | |
quantity | Unknown | |
received_date | Unknown | |
total | Unknown | |
total_in_base_currency | Unknown | |
updated_at | Unknown |
sales_order_row_batch_transaction
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
sales_order_row_id | Unknown | PKFK |
batch_id | Unknown | FK |
quantity | Unknown |
sales_order_row
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
linked_manufacturing_order_id | Unknown | FK |
sales_order_id | Unknown | FK |
tax_rate_id | Unknown | FK |
variant_id | Unknown | FK |
conversion_date | Unknown | |
conversion_rate | Unknown | |
created_at | Unknown | |
deleted_at | Unknown | |
price_per_unit | Unknown | |
price_per_unit_in_base_currency | Unknown | |
quantity | Unknown | |
serial_numbers | Json | |
total | Unknown | |
total_in_base_currency | Unknown | |
updated_at | Unknown | |
custom_** |
factory
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
default_manufacturing_location_id | Unknown | FK |
default_purchases_location_id | Unknown | FK |
default_sales_location_id | Unknown | FK |
base_currency_code | Unknown | |
default_po_lead_time | Unknown | |
default_so_delivery_time | Unknown | |
display_name | Unknown | |
inventory_closing_date | Unknown | |
legal_address_city | Unknown | |
legal_address_country | Unknown | |
legal_address_line_1 | Unknown | |
legal_address_line_2 | Unknown | |
legal_address_state | Unknown | |
legal_address_zip | Unknown | |
legal_name | Unknown |
product_config_value
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
product_config_id | Unknown | PKFK |
product_id | Unknown | PKFK |
value | Unknown |
product_config
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
product_id | Unknown | PKFK |
name | Unknown |
product_variant
| Column | Type | Keys |
|---|---|---|
product_id | Unknown | PKFK |
variant_id | Unknown | PKFK |
product
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
default_supplier_id | Unknown | FK |
additional_info | Unknown | |
batch_tracked | Unknown | |
category_name | Unknown | |
created_at | Unknown | |
deleted_at | Unknown | |
is_producible | Unknown | |
is_purchasable | Unknown | |
name | Unknown | |
purchase_uom | Unknown | |
purchase_uom_conversion_rate | Unknown | |
serial_tracked | Unknown | |
type | Unknown | |
uom | Unknown | |
updated_at | Unknown |
bom_row
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
ingredient_variant_id | Unknown | FK |
product_item_id | Unknown | FK |
product_variant_id | Unknown | FK |
created_at | Instant | |
notes | Unknown | |
quantity | Unknown | |
rank | Unknown | |
updated_at | Instant |
material_config_value
| Column | Type | Keys |
|---|---|---|
value | Unknown | PK |
material_config_id | Unknown | PKFK |
material_id | Unknown | PKFK |
material_config
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
material_id | Unknown | PKFK |
product_id | Unknown | FK |
name | Unknown |
material_variant
| Column | Type | Keys |
|---|---|---|
material_id | Unknown | PKFK |
variant_id | Unknown | PKFK |
material_supplier_item_code
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
material_id | Unknown | FK |
code | Unknown |
material
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
default_supplier_id | Unknown | FK |
additional_info | Unknown | |
batch_tracked | Unknown | |
category_name | Unknown | |
created_at | Unknown | |
deleted_at | Unknown | |
name | Unknown | |
purchase_uom | Unknown | |
purchase_uom_conversion_rate | Unknown | |
serial_tracked | Unknown | |
type | Unknown | |
uom | Unknown | |
updated_at | Unknown |
location
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
address | Unknown | |
address_city | Unknown | |
address_country | Unknown | |
address_id | Unknown | |
address_line_1 | Unknown | |
address_line_2 | Unknown | |
address_state | Unknown | |
address_zip | Unknown | |
created_at | Unknown | |
deleted_at | Unknown | |
is_primary | Unknown | |
legal_name | Unknown | |
manufacturing_allowed | Unknown | |
name | Unknown | |
purchase_allowed | Unknown | |
sales_allowed | Unknown | |
updated_at | Unknown |
sales_order_sales_order_row
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
sales_order_id | Unknown | PKFK |
sales_order
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
billing_address_id | Unknown | FK |
customer_id | Unknown | FK |
location_id | Unknown | FK |
shipping_address_id | Unknown | FK |
additional_info | Unknown | |
conversion_date | Unknown | |
conversion_rate | Unknown | |
created_at | Unknown | |
currency | Unknown | |
deleted_at | Instant | |
delivery_date | Unknown | |
ecommerce_order_id | Unknown | |
ecommerce_order_type | Unknown | |
ecommerce_store_name | Unknown | |
ingredient_availability | Unknown | |
ingredient_expected_date | Unknown | |
invoicing_status | Unknown | |
order_created_date | Unknown | |
order_no | Unknown | |
picked_date | Unknown | |
product_availability | Unknown | |
product_expected_date | Unknown | |
production_status | Unknown | |
source | Unknown | |
status | Unknown | |
total | Unknown | |
total_in_base_currency | Unknown | |
tracking_number | Unknown | |
tracking_number_url | Unknown | |
updated_at | Unknown |
customer
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
default_billing_id | Unknown | FK |
default_shipping_id | Unknown | FK |
comment | Unknown | |
company | Unknown | |
created_at | Unknown | |
currency | Unknown | |
deleted_at | Instant | |
email | Unknown | |
first_name | Unknown | |
last_name | Unknown | |
name | Unknown | |
phone | Unknown | |
updated_at | Unknown |
sales_order_accounting_metadata
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
fulfillment_id | Unknown | FK |
sales_order_id | Unknown | FK |
created_at | Unknown | |
integration_type | Unknown | |
invoice_id | Unknown |