# Katana schema ERD

Table and field reference for the Fivetran Katana connector.

## Table & Field Reference

### manufacturing_ordering_recipe_batch_transaction

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| manufacturing_ordering_recipe_id | Unknown | PK, FK |
| 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 | PK, FK |
| stock_adjustment_row_id | Unknown | PK, FK |
| batch_id | Unknown | FK |
| quantity | Unknown |  |

### stock_adjustment_row

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| stock_adjustment_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |

### 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 | PK, FK |
| stock_transfer_row_id | Unknown | PK, FK |
| batch_id | Unknown | FK |
| quantity | Unknown |  |

### stock_transfer_row

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| stock_transfer_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| purchase_order_id | Unknown | PK, FK |

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

### manufacturing_order_serial_number

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| manufacturing_order_id | Unknown | PK, FK |
| 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 | PK, FK |
| sales_order_row_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| product_id | Unknown | PK, FK |
| value | Unknown |  |

### product_config

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | PK, FK |
| name | Unknown |  |

### product_variant

| Column | Type | Keys |
| --- | --- | --- |
| product_id | Unknown | PK, FK |
| variant_id | Unknown | PK, FK |

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

### material_config

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| material_id | Unknown | PK, FK |
| product_id | Unknown | FK |
| name | Unknown |  |

### material_variant

| Column | Type | Keys |
| --- | --- | --- |
| material_id | Unknown | PK, FK |
| variant_id | Unknown | PK, FK |

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

### 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 |  |

## Relationships

- manufacturing_ordering_recipe_batch_transaction(batch_id) → batch(id)
- manufacturing_ordering_recipe_batch_transaction(manufacturing_ordering_recipe_id) → manufacturing_ordering_recipe(id)
- manufacturing_ordering_recipe(manufacturing_order_id) → manufacturing_order(id)
- manufacturing_ordering_recipe(variant_id) → variant(id)
- stock_adjustment_row_batch_transaction(batch_id) → batch(id)
- stock_adjustment_row_batch_transaction(stock_adjustment_id) → stock_adjustment_row(stock_adjustment_id)
- stock_adjustment_row_batch_transaction(stock_adjustment_row_id) → stock_adjustment_row(id)
- stock_adjustment_row(variant_id) → variant(id)
- stock_adjustment_row(stock_adjustment_id) → stock_adjustment(id)
- stock_adjustment(location_id) → location(id)
- supplier_address(supplier_id) → supplier(id)
- variant_config_attribute(variant_id) → variant(id)
- variant_supplier_item_code(variant_id) → variant(id)
- variant(product_id) → product(id)
- variant(material_id) → material(id)
- stock_transfer_row_batch_transaction(batch_id) → batch(id)
- stock_transfer_row_batch_transaction(stock_transfer_row_id) → stock_transfer_row(id)
- stock_transfer_row_batch_transaction(stock_transfer_id) → stock_transfer_row(stock_transfer_id)
- stock_transfer_row(id) → variant(id)
- stock_transfer_row(stock_transfer_id) → stock_transfer(id)
- stock_transfer(source_location_id) → location(id)
- stock_transfer(target_location_id) → location(id)
- manufacturing_order_operator(manufacture_order_operation_id) → manufacture_order_operation(id)
- customer_address(customer_id) → customer(id)
- inventory_movement(variant_id) → variant(id)
- inventory_movement(location_id) → location(id)
- batch(location_id) → location(id)
- batch(variant_id) → variant(id)
- outsource_purchase_batch_transaction(batch_id) → batch(id)
- outsource_purchase_batch_transaction(outsource_purchase_order_id) → outsource_purchase_order_recipe(id)
- outsource_purchase_order_recipe(purchase_order_id) → purchase_order(id)
- outsource_purchase_order_recipe(purchase_order_row_id) → purchase_order_row(id)
- outsource_purchase_order_recipe(ingredient_variant_id) → variant(id)
- purchase_order_purchase_order_row(id) → purchase_order_row(id)
- purchase_order_purchase_order_row(purchase_order_id) → purchase_order(id)
- purchase_order(supplier_id) → supplier(id)
- purchase_order(location_id) → location(id)
- purchase_order(tracking_location_id) → location(id)
- manufacturing_order_batch_transaction(batch_id) → batch(id)
- manufacturing_order_batch_transaction(manufacturing_order_id) → manufacturing_order(id)
- manufacturing_order_serial_number(manufacturing_order_id) → manufacturing_order(id)
- manufacturing_order(sales_order_id) → sales_order(id)
- manufacturing_order(variant_id) → variant(id)
- manufacturing_order(sales_order_row_id) → sales_order_row(id)
- manufacturing_order(location_id) → location(id)
- sales_order_fuiliment_row(sales_order_row_id) → sales_order_row(id)
- sales_order_fuiliment_row(sales_order_fulfillment_id) → sales_order_fulfillment(id)
- sales_order_fulfillment(sales_order_id) → sales_order(id)
- inventory(variant_id) → variant(id)
- inventory(location_id) → location(id)
- sales_order_address(sales_order_id) → sales_order(id)
- production_operation(product_id) → product(id)
- production_operation(operation_id) → manufacture_order_operation(id)
- purchase_order_row_batch_transaction(batch_id) → batch(id)
- purchase_order_row_batch_transaction(purchase_order_row_id) → purchase_order_row(id)
- purchase_order_row(tax_rate_id) → tax_rate(id)
- purchase_order_row(purchase_order_id) → purchase_order(id)
- purchase_order_row(variant_id) → variant(id)
- sales_order_row_batch_transaction(batch_id) → batch(id)
- sales_order_row_batch_transaction(sales_order_row_id) → sales_order_row(id)
- sales_order_row(tax_rate_id) → tax_rate(id)
- sales_order_row(linked_manufacturing_order_id) → manufacturing_order(id)
- sales_order_row(sales_order_id) → sales_order(id)
- sales_order_row(variant_id) → variant(id)
- factory(default_sales_location_id) → location(id)
- factory(default_purchases_location_id) → location(id)
- factory(default_manufacturing_location_id) → location(id)
- product_config_value(product_id) → product_config(product_id)
- product_config_value(product_config_id) → product_config(id)
- product_config(product_id) → product(id)
- product_variant(variant_id) → variant(id)
- product_variant(product_id) → product(id)
- product(default_supplier_id) → supplier(id)
- bom_row(product_item_id) → product(id)
- bom_row(product_variant_id) → product_variant(variant_id)
- bom_row(ingredient_variant_id) → variant(id)
- material_config_value(material_id) → material_config(material_id)
- material_config_value(material_config_id) → material_config(id)
- material_config(product_id) → product(id)
- material_config(material_id) → material(id)
- material_variant(variant_id) → variant(id)
- material_variant(material_id) → material(id)
- material_supplier_item_code(material_id) → material(id)
- material(default_supplier_id) → supplier(id)
- sales_order_sales_order_row(id) → sales_order_row(id)
- sales_order_sales_order_row(sales_order_id) → sales_order(id)
- sales_order(billing_address_id) → sales_order_address(id)
- sales_order(shipping_address_id) → sales_order_address(id)
- sales_order(customer_id) → customer(id)
- sales_order(location_id) → location(id)
- customer(default_shipping_id) → customer_address(id)
- customer(default_billing_id) → customer_address(id)
- sales_order_accounting_metadata(sales_order_id) → sales_order(id)
- sales_order_accounting_metadata(fulfillment_id) → sales_order_fulfillment(id)