# Cin7 schema ERD

Table and field reference for the Fivetran Cin7 connector.

## Table & Field Reference

### quote_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | FK |
| product_option_id | Unknown | FK |
| transaction_id | Unknown | FK |
| barcode | String |  |
| code | String |  |
| created_date | Unknown |  |
| discount | Double |  |
| holding_qty | Double |  |
| integration_ref | String |  |
| line_comments | String |  |
| name | String |  |
| option_1 | String |  |
| option_2 | String |  |
| option_3 | String |  |
| parent_id | Unknown |  |
| qty | Double |  |
| qty_shipped | Double |  |
| size_codes | String |  |
| sort | Unknown |  |
| style_code | String |  |
| unit_cost | Double |  |
| unit_price | Double |  |

### quote

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| branch_id | Unknown | FK |
| acceptance_date | Unknown |  |
| alternative_tax_rate | String |  |
| billing_address_1 | String |  |
| billing_address_2 | String |  |
| billing_city | String |  |
| billing_company | String |  |
| billing_country | String |  |
| billing_first_name | String |  |
| billing_last_name | String |  |
| billing_postal_code | String |  |
| billing_state | String |  |
| company | String |  |
| cost_center | String |  |
| created_by | Unknown |  |
| created_date | Unknown |  |
| currency_code | String |  |
| currency_rate | Double |  |
| currency_symbol | String |  |
| customer_order_no | String |  |
| delivery_address_1 | String |  |
| delivery_address_2 | String |  |
| delivery_city | String |  |
| delivery_company | String |  |
| delivery_country | String |  |
| delivery_first_name | String |  |
| delivery_instructions | String |  |
| delivery_last_name | String |  |
| delivery_postal_code | String |  |
| delivery_state | String |  |
| discount_description | String |  |
| discount_total | Double |  |
| email | String |  |
| estimated_delivery_date | Unknown |  |
| expected_order_date | Unknown |  |
| fax | String |  |
| first_name | String |  |
| freight_description | String |  |
| freight_total | Double |  |
| internal_comments | String |  |
| is_approved | Boolean |  |
| last_name | String |  |
| member_alternative_tax_rate | String |  |
| member_cost_center | String |  |
| member_email | String |  |
| member_id | Unknown |  |
| mobile | String |  |
| modified_date | Unknown |  |
| payment_terms | String |  |
| phone | String |  |
| probability | Double |  |
| processed_by | Unknown |  |
| product_total | Double |  |
| project_name | String |  |
| reference | String |  |
| sales_person_email | String |  |
| sales_person_id | Unknown |  |
| source | String |  |
| stage | String |  |
| status | String |  |
| surcharge | Double |  |
| surcharge_description | String |  |
| tax_rate | Double |  |
| tax_status | String |  |
| total | Double |  |
| tracking_code | String |  |
| voucher_code | String |  |

### payment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| branch_id | Unknown | FK |
| order_id | Unknown | FK |
| amount | Double |  |
| batch_reference | String |  |
| comments | String |  |
| created_date | Unknown |  |
| is_authorized | Boolean |  |
| method | String |  |
| modified_date | Unknown |  |
| order_ref | String |  |
| order_type | String |  |
| payment_date | Unknown |  |
| payment_imported_ref | String |  |
| reconcile_date | Unknown |  |
| transaction_ref | String |  |

### secondary_contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| company | String |  |
| email | String |  |
| first_name | String |  |
| job_title | String |  |
| last_name | String |  |
| mobile | String |  |
| phone | String |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_number | String |  |
| accounting_integration_id_quick_books_desktop | Unknown |  |
| accounting_integration_id_quick_books_online | Unknown |  |
| accounting_integration_id_xero | Unknown |  |
| accounts_first_name | String |  |
| accounts_last_name | String |  |
| accounts_phone | String |  |
| address_1 | String |  |
| address_2 | String |  |
| balance_owing | Double |  |
| billing_company | String |  |
| billing_cost_center | String |  |
| billing_email | String |  |
| billing_id | Unknown |  |
| city | String |  |
| company | String |  |
| cost_center | String |  |
| country | String |  |
| created_date | Unknown |  |
| credit_limit | Double |  |
| email | String |  |
| fax | String |  |
| first_name | String |  |
| groups | String |  |
| integration_ref | String |  |
| is_active | Boolean |  |
| job_title | String |  |
| last_name | String |  |
| mobile | String |  |
| modified_date | Unknown |  |
| notes | String |  |
| on_hold | Boolean |  |
| payment_terms | String |  |
| percentage_off | Double |  |
| phone | String |  |
| post_code | String |  |
| postal_address_1 | String |  |
| postal_address_2 | String |  |
| postal_city | String |  |
| postal_country | String |  |
| postal_post_code | String |  |
| postal_state | String |  |
| price_column | String |  |
| sales_person_id | Unknown |  |
| stages | String |  |
| state | String |  |
| sub_group | String |  |
| tax_number | String |  |
| tax_status | String |  |
| type | String |  |
| website | String |  |
| custom_** |  |  |

### stock

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| branch_id | Unknown | FK |
| product_id | Unknown | FK |
| product_option_id | Unknown | FK |
| available | Double |  |
| barcode | String |  |
| branch_name | String |  |
| code | String |  |
| holding | Double |  |
| incoming | Double |  |
| modified_date | Unknown |  |
| open_sales | Double |  |
| option_1 | String |  |
| option_2 | String |  |
| option_3 | String |  |
| product_name | String |  |
| size | String |  |
| stock_on_hand | Double |  |
| style_code | String |  |
| virtual | Double |  |

### branch_transfer_line_item_size

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| branch_transfer_line_item_id | Unknown | FK |
| barcode | String |  |
| code | String |  |
| name | String |  |
| qty | Double |  |

### branch_transfer_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| branch_transfer_id | Unknown | PK, FK |
| product_id | Unknown | FK |
| product_option_id | Unknown | FK |
| transaction_id | Unknown | FK |
| code | String |  |
| created_date | Unknown |  |
| integration_ref | String |  |
| name | String |  |
| option_1 | String |  |
| option_2 | String |  |
| option_3 | String |  |
| parent_id | Unknown |  |
| qty | Double |  |
| qty_transferred | Unknown |  |
| sort | Unknown |  |
| unit_cost | Double |  |

### branch_transfer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| approved_by | Unknown | FK |
| created_by | Unknown | FK |
| destination_branch_id | Unknown | FK |
| processed_by | Unknown | FK |
| source_branch_id | Unknown | FK |
| approval_date | Unknown |  |
| branch_email | String |  |
| company | String |  |
| created_date | Unknown |  |
| delivery_instructions | String |  |
| dispatched_date | Unknown |  |
| email | String |  |
| fax | String |  |
| first_name | String |  |
| internal_comments | String |  |
| is_approved | Unknown |  |
| last_name | String |  |
| mobile | Unknown |  |
| modified_date | Unknown |  |
| phone | Unknown |  |
| product_total | Unknown |  |
| project_name | String |  |
| received_date | Unknown |  |
| reference | String |  |
| source | String |  |
| stage | String |  |
| tracking_code | Unknown |  |
| custom_** |  |  |

### serial_number

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| branch_id | Unknown | FK |
| product_id | Unknown | FK |
| product_option_id | Unknown | FK |
| available | Double |  |
| code | String |  |
| holding_group | String |  |
| line_item_id | Unknown |  |
| serial_number | String |  |

### sales_order_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | FK |
| product_option_id | Unknown | FK |
| transaction_id | Unknown | FK |
| account_code | String |  |
| barcode | String |  |
| code | String |  |
| created_date | Unknown |  |
| discount | Double |  |
| holding_qty | Double |  |
| integration_ref | String |  |
| line_comments | String |  |
| name | String |  |
| option_1 | String |  |
| option_2 | String |  |
| option_3 | String |  |
| parent_id | Unknown |  |
| qty | Double |  |
| qty_shipped | Double |  |
| size_codes | String |  |
| sizes | Json |  |
| sort | Unknown |  |
| stock_control | String |  |
| style_code | String |  |
| unit_cost | Double |  |
| unit_price | Double |  |

### sales_order

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| branch_id | Unknown | FK |
| created_by | Unknown | FK |
| processed_by | Unknown | FK |
| accounting_attribute_accounting_import_status | Unknown |  |
| accounting_attribute_import_date | Unknown |  |
| alternative_tax_rate | String |  |
| billing_address_1 | String |  |
| billing_address_2 | String |  |
| billing_city | String |  |
| billing_company | String |  |
| billing_country | String |  |
| billing_first_name | String |  |
| billing_last_name | String |  |
| billing_postal_code | String |  |
| billing_state | String |  |
| branch_email | String |  |
| company | String |  |
| cost_center | String |  |
| created_date | Unknown |  |
| currency_code | String |  |
| currency_rate | Double |  |
| currency_symbol | String |  |
| customer_order_no | String |  |
| delivery_address_1 | String |  |
| delivery_address_2 | String |  |
| delivery_city | String |  |
| delivery_company | String |  |
| delivery_country | String |  |
| delivery_first_name | String |  |
| delivery_instructions | String |  |
| delivery_last_name | String |  |
| delivery_postal_code | String |  |
| delivery_state | String |  |
| department_number | String |  |
| discount_description | String |  |
| discount_total | Double |  |
| dispatched_date | Unknown |  |
| distribution_branch_id | Unknown |  |
| distribution_center | String |  |
| edi_status | Unknown |  |
| email | String |  |
| estimated_delivery_date | Unknown |  |
| fax | String |  |
| first_name | String |  |
| freight_description | String |  |
| freight_total | Double |  |
| internal_comments | String |  |
| invoice_date | Unknown |  |
| invoice_number | Unknown |  |
| is_approved | Boolean |  |
| is_void | Boolean |  |
| last_name | String |  |
| logistics_carrier | String |  |
| logistics_status | Unknown |  |
| member_alternative_tax_rate | String |  |
| member_cost_center | String |  |
| member_email | String |  |
| member_id | Unknown |  |
| mobile | String |  |
| modified_date | Unknown |  |
| payment_terms | String |  |
| phone | String |  |
| product_total | Double |  |
| project_name | String |  |
| reference | String |  |
| sales_person_email | String |  |
| sales_person_id | Unknown |  |
| source | String |  |
| stage | String |  |
| status | String |  |
| store_location_number | String |  |
| surcharge | Double |  |
| surcharge_description | String |  |
| tax_rate | Double |  |
| tax_status | String |  |
| total | Double |  |
| tracking_code | String |  |
| voucher_code | String |  |

### product_image

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| product_id | Unknown | FK |
| link | String |  |

### product_category_ids

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

### product_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | FK |
| barcode | String |  |
| code | String |  |
| created_date | Unknown |  |
| image | String |  |
| modified_date | Unknown |  |
| option_1 | String |  |
| option_2 | String |  |
| option_3 | String |  |
| option_weight | Double |  |
| price_columns_cost_cad | Unknown |  |
| price_columns_cost_eur | Unknown |  |
| price_columns_cost_usd | Unknown |  |
| price_columns_price_aud | Unknown |  |
| price_columns_price_cad | Unknown |  |
| price_columns_retail_usd | Unknown |  |
| price_columns_special_price | Unknown |  |
| price_columns_vip_usd | Unknown |  |
| price_columns_wholesale_usd | Unknown |  |
| product_option_barcode | String |  |
| product_option_code | String |  |
| product_option_size_barcode | String |  |
| product_option_size_code | String |  |
| retail_price | Double |  |
| size | String |  |
| special_days | Unknown |  |
| special_price | Double |  |
| specials_start_date | Unknown |  |
| status | String |  |
| stock_available | Double |  |
| stock_on_hand | Double |  |
| supplier_code | String |  |
| vip_price | Double |  |
| wholesale_price | Double |  |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| brand | String |  |
| category | String |  |
| category_id_array | Json |  |
| channels | String |  |
| created_date | Unknown |  |
| description | String |  |
| height | Double |  |
| import_customs_duty | String |  |
| length | Double |  |
| modified_date | Unknown |  |
| name | String |  |
| option_label_1 | String |  |
| option_label_2 | String |  |
| option_label_3 | String |  |
| order_type | String |  |
| pdf_description | String |  |
| pdf_upload | String |  |
| product_subtype | String |  |
| product_type | String |  |
| project_name | String |  |
| purchases_account | String |  |
| sales_account | String |  |
| status | Unknown |  |
| stock_control | Unknown |  |
| style_code | String |  |
| sub_category | String |  |
| supplier_id | Unknown |  |
| volume | Double |  |
| weight | Double |  |
| width | Double |  |
| custom_** |  |  |

### branch_location_bin

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| branch_id | Unknown | PK, FK |
| branch_location_zone | String | PK, FK |
| bin | Unknown |  |

### branch_location

| Column | Type | Keys |
| --- | --- | --- |
| zone | String | PK |
| branch_id | Unknown | PK, FK |

### branch

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_number | String |  |
| address_1 | String |  |
| address_2 | String |  |
| branch_type | String |  |
| city | String |  |
| company | String |  |
| country | String |  |
| created_date | Unknown |  |
| email | String |  |
| fax | String |  |
| first_name | String |  |
| integration_ref | String |  |
| is_active | Boolean |  |
| job_title | String |  |
| last_name | String |  |
| mobile | String |  |
| modified_date | Unknown |  |
| notes | String |  |
| phone | String |  |
| post_code | String |  |
| postal_address_1 | String |  |
| postal_address_2 | String |  |
| postal_city | String |  |
| postal_country | String |  |
| postal_post_code | String |  |
| postal_state | String |  |
| state | String |  |
| stock_control_options | String |  |
| tax_status | String |  |
| website | String |  |
| custom_** |  |  |

### production_job

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| branch_id | Unknown | FK |
| completed_by | Unknown | FK |
| created_by | Unknown | FK |
| company | String |  |
| completed_date | Unknown |  |
| created_date | Unknown |  |
| due_date | Unknown |  |
| is_approved | Boolean |  |
| modified_date | Unknown |  |
| production_notes | String |  |
| project_name | String |  |
| reference | String |  |
| source | String |  |
| total_cost | Double |  |
| custom_** |  |  |

### adjustment_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| adjustment_id | Unknown | FK |
| product_id | Unknown | FK |
| product_option_id | Unknown | FK |
| transaction_id | Unknown | FK |
| account | String |  |
| code | String |  |
| created_date | String |  |
| holding_qty | Double |  |
| integration_ref | String |  |
| name | String |  |
| option_1 | String |  |
| option_2 | String |  |
| option_3 | String |  |
| parent_id | Unknown |  |
| qty | Double |  |
| qty_adjusted | Double |  |
| sort | Unknown |  |
| unit_cost | Double |  |

### adjustment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| branch_id | Unknown | FK |
| created_by_user_id | Unknown | FK |
| processed_by_user_id | Unknown | FK |
| adjust_in_accounting_system | String |  |
| adjustment_reason | String |  |
| alternative_account_code | String |  |
| completed_date | Unknown |  |
| created_date | Unknown |  |
| is_approved | Boolean |  |
| modified_date | Unknown |  |
| product_total | Double |  |
| reference | String |  |
| source | String |  |

### purchase_order_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | FK |
| product_option_id | Unknown | FK |
| transaction_id | Unknown | FK |
| account_code | String |  |
| barcode | String |  |
| code | String |  |
| created_date | Unknown |  |
| discount | Double |  |
| holding_qty | Double |  |
| integration_ref | String |  |
| line_comments | String |  |
| name | String |  |
| option_1 | String |  |
| option_2 | String |  |
| option_3 | String |  |
| parent_id | Unknown |  |
| qty | Double |  |
| qty_shipped | Double |  |
| size_codes | String |  |
| sort | Unknown |  |
| style_code | String |  |
| unit_price | Double |  |

### purchase_order

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| branch_id | Unknown | FK |
| accounting_attribute_accounting_import_status | Unknown |  |
| accounting_attribute_import_date | Unknown |  |
| alternative_tax_rate | String |  |
| billing_address_1 | String |  |
| billing_address_2 | String |  |
| billing_city | String |  |
| billing_company | String |  |
| billing_country | String |  |
| billing_first_name | String |  |
| billing_last_name | String |  |
| billing_postal_code | String |  |
| billing_state | String |  |
| branch_email | String |  |
| company | String |  |
| cost_center | String |  |
| created_by | Unknown |  |
| created_date | Unknown |  |
| currency_code | String |  |
| currency_rate | Double |  |
| currency_symbol | String |  |
| customer_order_no | String |  |
| delivery_address_1 | String |  |
| delivery_address_2 | String |  |
| delivery_city | String |  |
| delivery_company | String |  |
| delivery_country | String |  |
| delivery_first_name | String |  |
| delivery_instructions | String |  |
| delivery_last_name | String |  |
| delivery_postal_code | String |  |
| delivery_state | String |  |
| discount_description | String |  |
| discount_total | Double |  |
| email | String |  |
| estimated_arrival_date | Unknown |  |
| estimated_delivery_date | Unknown |  |
| fax | String |  |
| first_name | String |  |
| freight_description | String |  |
| freight_total | Double |  |
| fully_received_date | Unknown |  |
| internal_comments | String |  |
| invoice_date | Unknown |  |
| is_approved | Boolean |  |
| is_void | Boolean |  |
| last_name | String |  |
| logistics_carrier | String |  |
| logistics_status | Unknown |  |
| member_alternative_tax_rate | String |  |
| member_cost_center | String |  |
| member_email | String |  |
| member_id | Unknown |  |
| mobile | String |  |
| modified_date | Unknown |  |
| payment_terms | String |  |
| phone | String |  |
| port | String |  |
| processed_by | Unknown |  |
| product_total | Double |  |
| project_name | String |  |
| reference | String |  |
| sales_person_email | String |  |
| sales_person_id | Unknown |  |
| source | String |  |
| stage | String |  |
| status | String |  |
| supplier_acceptance_date | Unknown |  |
| supplier_invoice_reference | String |  |
| surcharge | Double |  |
| surcharge_description | String |  |
| tax_rate | Double |  |
| tax_status | String |  |
| total | Double |  |
| tracking_code | String |  |
| voucher_code | String |  |

### product_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | String |  |
| image | String |  |
| is_active | Boolean |  |
| name | String |  |
| parent_id | Unknown |  |
| sort | Unknown |  |

### credit_note_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| credit_note_id | Unknown | FK |
| product_id | Unknown | FK |
| product_option_id | Unknown | FK |
| transaction_id | Unknown | FK |
| account_code | String |  |
| barcode | String |  |
| code | String |  |
| created_date | Unknown |  |
| discount | Double |  |
| integration_ref | String |  |
| line_comments | String |  |
| name | String |  |
| option_1 | String |  |
| option_2 | String |  |
| option_3 | String |  |
| parent_id | Unknown |  |
| qty | Double |  |
| qty_shipped | Double |  |
| size_codes | String |  |
| sort | Unknown |  |
| style_code | String |  |
| unit_cost | Double |  |
| unit_price | Double |  |

### credit_note

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| branch_id | Unknown | FK |
| created_by | Unknown | FK |
| processed_by | Unknown | FK |
| accounting_attribute_accounting_import_status | Unknown |  |
| accounting_attribute_import_date | Unknown |  |
| alternative_account_code | String |  |
| billing_address_1 | String |  |
| billing_address_2 | String |  |
| billing_city | String |  |
| billing_company | String |  |
| billing_country | String |  |
| billing_first_name | String |  |
| billing_last_name | String |  |
| billing_postal_code | String |  |
| billing_state | String |  |
| company | String |  |
| completed_date | Unknown |  |
| created_date | Unknown |  |
| credit_note_date | Unknown |  |
| credit_note_number | Unknown |  |
| currency_code | String |  |
| currency_rate | Double |  |
| currency_symbol | String |  |
| customer_report | String |  |
| delivery_address_1 | String |  |
| delivery_address_2 | String |  |
| delivery_city | String |  |
| delivery_company | String |  |
| delivery_country | String |  |
| delivery_first_name | String |  |
| delivery_last_name | String |  |
| delivery_postal_code | String |  |
| delivery_state | String |  |
| discount_description | String |  |
| discount_total | Double |  |
| email | String |  |
| fax | String |  |
| first_name | String |  |
| freight_description | String |  |
| freight_total | Double |  |
| internal_comments | String |  |
| is_approved | Boolean |  |
| last_name | String |  |
| logistics_carrier | String |  |
| logistics_status | Unknown |  |
| member_email | String |  |
| member_id | Unknown |  |
| mobile | String |  |
| modified_date | Unknown |  |
| phone | String |  |
| product_total | Double |  |
| project_name | String |  |
| reference | String |  |
| sales_person_id | Unknown |  |
| sales_reference | String |  |
| source | String |  |
| status | String |  |
| surcharge | Double |  |
| surcharge_description | String |  |
| tax_rate | Double |  |
| tax_status | String |  |
| total | Double |  |
| tracking_code | String |  |

### bom_master_component

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| bom_master_id | Unknown | PK, FK |
| product_id | Unknown | FK |
| product_option_id | Unknown | FK |
| code | Unknown |  |
| quantity | Unknown |  |
| sort | Unknown |  |
| unit_cost | Unknown |  |

### bom_master

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| modified_by | Unknown | FK |
| product_id | Unknown | FK |
| product_option_id | Unknown | FK |
| created_date | Unknown |  |
| modified_date | Unknown |  |
| product_code | Unknown |  |
| product_notes | Unknown |  |
| product_quantity | Unknown |  |
| product_sort | Unknown |  |
| product_unit_cost | Unknown |  |
| product_uu_id | Unknown |  |
| production_note | Unknown |  |
| reference | Unknown |  |

### voucher

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| amount | Double |  |
| code | String |  |
| created_date | Unknown |  |
| customer_email | String |  |
| customer_id | Unknown |  |
| description | String |  |
| expiry_date | Unknown |  |
| redeemed_amount | Double |  |
| redeemed_count | Unknown |  |
| redeemed_count_limit | Unknown |  |
| status | String |  |
| type | String |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| email | String |  |
| first_name | String |  |
| is_active | Boolean |  |
| job_title | String |  |
| last_name | String |  |

## Relationships

- quote_line_item(product_id) → product(id)
- quote_line_item(product_option_id) → product_option(id)
- quote_line_item(transaction_id) → quote(id)
- quote(branch_id) → branch(id)
- payment(order_id) → sales_order(id)
- payment(branch_id) → branch(id)
- secondary_contact(contact_id) → contact(id)
- stock(product_id) → product(id)
- stock(product_option_id) → product_option(id)
- stock(branch_id) → branch(id)
- branch_transfer_line_item_size(branch_transfer_line_item_id) → branch_transfer_line_item(id)
- branch_transfer_line_item(product_id) → product(id)
- branch_transfer_line_item(product_option_id) → product_option(id)
- branch_transfer_line_item(transaction_id) → purchase_order(id)
- branch_transfer_line_item(branch_transfer_id) → branch_transfer(id)
- branch_transfer(destination_branch_id) → branch(id)
- branch_transfer(created_by) → users(id)
- branch_transfer(approved_by) → users(id)
- branch_transfer(processed_by) → users(id)
- branch_transfer(source_branch_id) → branch(id)
- serial_number(product_id) → product(id)
- serial_number(product_option_id) → product_option(id)
- serial_number(branch_id) → branch(id)
- sales_order_line_item(product_id) → product(id)
- sales_order_line_item(product_option_id) → product_option(id)
- sales_order_line_item(transaction_id) → sales_order(id)
- sales_order(created_by) → users(id)
- sales_order(processed_by) → users(id)
- sales_order(branch_id) → branch(id)
- product_image(product_id) → product(id)
- product_category_ids(product_id) → product(id)
- product_option(product_id) → product(id)
- branch_location_bin(branch_location_zone) → branch_location(zone)
- branch_location_bin(branch_id) → branch_location(branch_id)
- branch_location(branch_id) → branch(id)
- production_job(created_by) → users(id)
- production_job(completed_by) → users(id)
- production_job(branch_id) → branch(id)
- adjustment_line_item(product_id) → product(id)
- adjustment_line_item(product_option_id) → product_option(id)
- adjustment_line_item(transaction_id) → sales_order(id)
- adjustment_line_item(adjustment_id) → adjustment(id)
- adjustment(processed_by_user_id) → users(id)
- adjustment(created_by_user_id) → users(id)
- adjustment(branch_id) → branch(id)
- purchase_order_line_item(product_id) → product(id)
- purchase_order_line_item(product_option_id) → product_option(id)
- purchase_order_line_item(transaction_id) → purchase_order(id)
- purchase_order(branch_id) → branch(id)
- credit_note_line_item(product_id) → product(id)
- credit_note_line_item(product_option_id) → product_option(id)
- credit_note_line_item(transaction_id) → sales_order(id)
- credit_note_line_item(credit_note_id) → credit_note(id)
- credit_note(created_by) → users(id)
- credit_note(processed_by) → users(id)
- credit_note(branch_id) → branch(id)
- bom_master_component(product_id) → product(id)
- bom_master_component(product_option_id) → product_option(id)
- bom_master_component(bom_master_id) → bom_master(id)
- bom_master(created_by) → users(id)
- bom_master(modified_by) → users(id)
- bom_master(product_id) → product(id)
- bom_master(product_option_id) → product_option(id)