# Cin7 Core schema ERD

Table and field reference for the Fivetran Cin7 Core connector.

## Table & Field Reference

### chart_of_account

| Column | Type | Keys |
| --- | --- | --- |
| code | Unknown | PK |
| bank_account_number | Unknown |  |
| class | Unknown |  |
| description | Unknown |  |
| display_name | Unknown |  |
| for_payments | Unknown |  |
| name | Unknown |  |
| old_code | Unknown |  |
| status | Unknown |  |
| system_account | Unknown |  |
| system_account_code | Unknown |  |
| type | Unknown |  |

### supplier_contacts

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| supplier_id | Unknown | PK, FK |
| comment | Unknown |  |
| defaults | Unknown |  |
| email | Unknown |  |
| fax | Unknown |  |
| include_in_email | Unknown |  |
| mobile_phone | Unknown |  |
| name | Unknown |  |
| phone | Unknown |  |
| website | Unknown |  |

### supplier_address

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| supplier_id | Unknown | PK, FK |
| city | Unknown |  |
| country | Unknown |  |
| default_for_type | Unknown |  |
| line_1 | Unknown |  |
| line_2 | Unknown |  |
| postcode | Unknown |  |
| state | Unknown |  |
| type | Unknown |  |

### supplier

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_payable | Unknown |  |
| additional_attribute_1 | Unknown |  |
| additional_attribute_10 | Unknown |  |
| additional_attribute_2 | Unknown |  |
| additional_attribute_3 | Unknown |  |
| additional_attribute_4 | Unknown |  |
| additional_attribute_5 | Unknown |  |
| additional_attribute_6 | Unknown |  |
| additional_attribute_7 | Unknown |  |
| additional_attribute_8 | Unknown |  |
| additional_attribute_9 | Unknown |  |
| attribute_set | Unknown |  |
| comments | Unknown |  |
| currency | Unknown |  |
| discount | Unknown |  |
| last_modified_on | Unknown |  |
| name | Unknown |  |
| payment_term | Unknown |  |
| status | Unknown |  |
| tax_number | Unknown |  |
| tax_rule | Unknown |  |

### stock_transfer_line

| Column | Type | Keys |
| --- | --- | --- |
| product_id | Unknown | PK, FK |
| stock_transfer_number | Unknown | PK, FK |
| stock_transfer_task_id | Unknown | PK, FK |
| batch_sn | Unknown |  |
| comment | Unknown |  |
| expiry_date | Unknown |  |
| location_id | Unknown |  |
| product_custom_field_1 | Unknown |  |
| product_custom_field_10 | Unknown |  |
| product_custom_field_2 | Unknown |  |
| product_custom_field_3 | Unknown |  |
| product_custom_field_4 | Unknown |  |
| product_custom_field_5 | Unknown |  |
| product_custom_field_6 | Unknown |  |
| product_custom_field_7 | Unknown |  |
| product_custom_field_8 | Unknown |  |
| product_custom_field_9 | Unknown |  |
| quantity_available | Unknown |  |
| quantity_on_hand | Unknown |  |
| transfer_quantity | Unknown |  |

### stock_transfer_order_line

| Column | Type | Keys |
| --- | --- | --- |
| product_id | Unknown | PK, FK |
| stock_transfer_number | Unknown | PK, FK |
| stock_transfer_task_id | Unknown | PK, FK |
| location_id | Unknown | FK |
| batch_sn | Unknown |  |
| comment | Unknown |  |
| expiry_date | Unknown |  |
| product_custom_field_1 | Unknown |  |
| product_custom_field_10 | Unknown |  |
| product_custom_field_2 | Unknown |  |
| product_custom_field_3 | Unknown |  |
| product_custom_field_4 | Unknown |  |
| product_custom_field_5 | Unknown |  |
| product_custom_field_6 | Unknown |  |
| product_custom_field_7 | Unknown |  |
| product_custom_field_8 | Unknown |  |
| product_custom_field_9 | Unknown |  |
| quantity_available | Unknown |  |
| quantity_on_hand | Unknown |  |
| transfer_quantity | Unknown |  |

### stock_transfer

| Column | Type | Keys |
| --- | --- | --- |
| number | Unknown | PK |
| task_id | Unknown | PK |
| completion_date | Unknown |  |
| cost_distribution_type | Unknown |  |
| departure_date | Unknown |  |
| destination | Unknown |  |
| from_location | Unknown |  |
| in_transit_account | Unknown |  |
| manual_journal | Json |  |
| reference | Unknown |  |
| required_by_date | Unknown |  |
| skip_order | Unknown |  |
| source | Unknown |  |
| status | Unknown |  |
| to_location | Unknown |  |

### opportunity_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| opportunity_id | Unknown | PK, FK |
| product_id | Unknown | FK |
| comment | Unknown |  |
| discount | Unknown |  |
| price | Unknown |  |
| quantity | Unknown |  |
| tax | Unknown |  |
| tax_percent | Unknown |  |
| tax_rule | Unknown |  |
| total | Unknown |  |

### opportunity_additional_charge

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| opportunity_id | Unknown | PK, FK |
| amount | Unknown |  |
| comment | Unknown |  |
| description | Unknown |  |
| discount | Unknown |  |
| quantity | Unknown |  |
| tax | Unknown |  |
| tax_percent | Unknown |  |
| tax_rule | Unknown |  |
| total | Unknown |  |

### opportunity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| lead_id | Unknown | FK |
| billing_address_line_1 | Unknown |  |
| billing_address_line_2 | Unknown |  |
| contact | Unknown |  |
| currency | Unknown |  |
| currency_conversion_rate | Unknown |  |
| custom_field_1 | Unknown |  |
| custom_field_10 | Unknown |  |
| custom_field_2 | Unknown |  |
| custom_field_3 | Unknown |  |
| custom_field_4 | Unknown |  |
| custom_field_5 | Unknown |  |
| custom_field_6 | Unknown |  |
| custom_field_7 | Unknown |  |
| custom_field_8 | Unknown |  |
| custom_field_9 | Unknown |  |
| customer_currency | Unknown |  |
| customer_name | Unknown |  |
| customer_reference | Unknown |  |
| default_account | Unknown |  |
| opportunity_comment | Unknown |  |
| opportunity_date | Unknown |  |
| opportunity_location | Unknown |  |
| opportunity_memo | Unknown |  |
| opportunity_number | Unknown |  |
| phone | Unknown |  |
| price_tier | Unknown |  |
| sales_representative | Unknown |  |
| ship_to_address_1 | Unknown |  |
| ship_to_address_2 | Unknown |  |
| ship_to_city | Unknown |  |
| ship_to_company | Unknown |  |
| ship_to_contact | Unknown |  |
| ship_to_country | Unknown |  |
| ship_to_other | Unknown |  |
| ship_to_post_code | Unknown |  |
| ship_to_state | Unknown |  |
| shipping_address_line_1 | Unknown |  |
| shipping_address_line_2 | Unknown |  |
| tax_inclusive | Unknown |  |
| tax_percent | Unknown |  |
| tax_rule | Unknown |  |
| tax_total | Unknown |  |
| term | Unknown |  |
| term_day | Unknown |  |
| term_due_next_month | Unknown |  |
| term_method | Unknown |  |
| total | Unknown |  |

### production_bom_resource

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_family_production_bom_id | Unknown | PK, FK |
| product_family_production_bom_operation_id | Unknown | PK, FK |
| resource_id | Unknown | FK |
| cost | Unknown |  |
| cost_calculation_type | Unknown |  |
| cycle_time | Unknown |  |
| position | Unknown |  |
| quantity | Unknown |  |

### production_bom_operation_link

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_family_production_bom_id | Unknown | PK, FK |
| product_family_production_bom_operation_id | Unknown | PK, FK |
| related_operation_id | Unknown |  |
| related_operation_name | Unknown |  |
| relation_type | Unknown |  |

### production_bom_finished_product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_family_production_bom_id | Unknown | PK, FK |
| product_family_production_bom_operation_id | Unknown | PK, FK |
| product_family_id | Unknown | FK |
| product_id | Unknown | FK |
| average_cost | Unknown |  |
| cost_calculation_type | Unknown |  |
| costing_method | Unknown |  |
| delivery_to | Unknown |  |
| delivery_to_name | Unknown |  |
| output_quantity | Unknown |  |
| position | Unknown |  |
| price_tier | Unknown |  |
| ratio | Unknown |  |
| unit | Unknown |  |
| wastage_cost | Unknown |  |

### production_bom_variation_component

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_family_production_bom_id | Unknown | PK, FK |
| product_family_production_bom_operation_id | Unknown | PK, FK |
| product_family_id | Unknown | FK |
| costing_method | Unknown |  |
| map_variations_json | Unknown |  |
| position | Unknown |  |
| quantity_option_name | Unknown |  |
| quantity_settings_json | Unknown |  |
| sale_price_tier | Unknown |  |
| unit | Unknown |  |

### product_family_production_bom_operation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_family_production_bom_id | Unknown | PK, FK |
| work_center_id | Unknown | FK |
| attachment | Json |  |
| component | Json |  |
| cycle_time | Unknown |  |
| input_product | Json |  |
| is_drop_ship | Unknown |  |
| name | Unknown |  |
| note | Json |  |
| operation_order | Unknown |  |
| operation_type | Unknown |  |
| output_product | Json |  |
| units_per_cycle | Unknown |  |

### product_family_production_bom

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| delivery_to_id | Unknown | FK |
| buffer_percent | Unknown |  |
| component_production_lead_time | Unknown |  |
| created_date | Unknown |  |
| ignore_cumulative_lead_time | Unknown |  |
| instruction_url | Unknown |  |
| is_default | Unknown |  |
| issue_method | Unknown |  |
| name | Unknown |  |
| output_quantity | Unknown |  |
| version | Unknown |  |

### journal_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| journal_number | Unknown | PK, FK |
| purchase_id | Unknown | PK, FK |
| content_type | Unknown |  |
| download_url | Unknown |  |
| file_name | Unknown |  |

### journal_line

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| journal_number | Unknown | FK |
| purchase_id | Unknown | FK |
| amount | Unknown |  |
| base_amount | Unknown |  |
| credit | Unknown |  |
| debit | Unknown |  |
| reference | Unknown |  |

### journal

| Column | Type | Keys |
| --- | --- | --- |
| journal_number | Unknown | PK |
| purchase_id | Unknown | PK |
| currency | Unknown |  |
| currency_conversion_rate | Unknown |  |
| effective_date | Unknown |  |
| narration | Unknown |  |
| notes | Unknown |  |
| status | Unknown |  |
| task_id | Unknown |  |

### product_availability

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| product_id | Unknown | FK |
| allocated | Unknown |  |
| available | Unknown |  |
| batch | Unknown |  |
| bin | Unknown |  |
| expiry_date | Unknown |  |
| in_transit | Unknown |  |
| location | Unknown |  |
| next_delivery_date | Unknown |  |
| on_hand | Unknown |  |
| on_order | Unknown |  |
| stock_on_hand | Unknown |  |

### product_family_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| object_id | Unknown | PK, FK |
| content_type | Unknown |  |
| file_name | Unknown |  |
| is_default | Unknown |  |
| type | Unknown |  |

### family_product

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

### product_family

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| cogs_account | Unknown | FK |
| revenue_account | Unknown | FK |
| attribute_set | Unknown |  |
| brand | Unknown |  |
| category | Unknown |  |
| costing_method | Unknown |  |
| default_location | Unknown |  |
| description | Unknown |  |
| discount_rule | Unknown |  |
| drop_ship_mode | Unknown |  |
| inventory_account | Unknown |  |
| last_modified_on | Unknown |  |
| minimum_before_reorder | Unknown |  |
| name | Unknown |  |
| option_1_name | Unknown |  |
| option_1_values | Unknown |  |
| option_2_name | Unknown |  |
| option_2_values | Unknown |  |
| option_3_name | Unknown |  |
| option_3_values | Unknown |  |
| price_tier_1 | Unknown |  |
| price_tier_10 | Unknown |  |
| price_tier_2 | Unknown |  |
| price_tier_3 | Unknown |  |
| price_tier_4 | Unknown |  |
| price_tier_5 | Unknown |  |
| price_tier_6 | Unknown |  |
| price_tier_7 | Unknown |  |
| price_tier_8 | Unknown |  |
| price_tier_9 | Unknown |  |
| purchase_tax_rule | Unknown |  |
| reorder_quantity | Unknown |  |
| sale_tax_rule | Unknown |  |
| sku | Unknown |  |
| tags | Unknown |  |
| uom | Unknown |  |
| warranty_name | Unknown |  |

### product_reorder_level

| Column | Type | Keys |
| --- | --- | --- |
| location_id | Unknown | PK |
| product_id | Unknown | PK, FK |
| minimum_before_reorder | Unknown |  |
| pick_zones | Unknown |  |
| reorder_quantity | Unknown |  |
| stock_locator | Unknown |  |

### bill_of_material_product

| Column | Type | Keys |
| --- | --- | --- |
| component_product_id | Unknown | PK, FK |
| product_id | Unknown | PK, FK |
| cost_percentage | Unknown |  |
| name | Unknown |  |
| product_code | Unknown |  |
| quantity | Unknown |  |
| wastage_quantity | Unknown |  |

### bill_of_material_service

| Column | Type | Keys |
| --- | --- | --- |
| component_product_id | Unknown | PK, FK |
| product_id | Unknown | PK, FK |
| expense_account | Unknown | FK |
| name | Unknown |  |
| price_tier | Unknown |  |
| quantity | Unknown |  |

### product_movement

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | Unknown | PK, FK |
| amount | Unknown |  |
| batch_sn | Unknown |  |
| date | Unknown |  |
| expiry_date | Unknown |  |
| from_to | Unknown |  |
| location | Unknown |  |
| number | Unknown |  |
| quantity | Unknown |  |
| task_id | Unknown |  |
| type | Unknown |  |

### product_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | PK, FK |
| content_type | Unknown |  |
| file_name | Unknown |  |

### product_custom_price

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| customer_id | Unknown | FK |
| product_id | Unknown | FK |
| price | Unknown |  |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category_id | Unknown | FK |
| cogs_account | Unknown | FK |
| default_location | Unknown | FK |
| expense_account | Unknown | FK |
| revenue_account | Unknown | FK |
| additional_attribute_1 | Unknown |  |
| additional_attribute_10 | Unknown |  |
| additional_attribute_2 | Unknown |  |
| additional_attribute_3 | Unknown |  |
| additional_attribute_4 | Unknown |  |
| additional_attribute_5 | Unknown |  |
| additional_attribute_6 | Unknown |  |
| additional_attribute_7 | Unknown |  |
| additional_attribute_8 | Unknown |  |
| additional_attribute_9 | Unknown |  |
| assembly_cost_estimation_method | Unknown |  |
| attribute_set | Unknown |  |
| auto_assembly | Unknown |  |
| auto_disassembly | Unknown |  |
| average_cost | Unknown |  |
| barcode | Unknown |  |
| bill_of_material | Unknown |  |
| bom_type | Unknown |  |
| brand | Unknown |  |
| carton_height | Unknown |  |
| carton_inner_quantity | Unknown |  |
| carton_length | Unknown |  |
| carton_quantity | Unknown |  |
| carton_width | Unknown |  |
| costing_method | Unknown |  |
| description | Unknown |  |
| dimension_units | Unknown |  |
| discount_rule | Unknown |  |
| drop_ship_mode | Unknown |  |
| height | Unknown |  |
| internal_note | Unknown |  |
| inventory_account | Unknown |  |
| last_modified_on | Unknown |  |
| length | Unknown |  |
| minimum_before_reorder | Unknown |  |
| name | Unknown |  |
| pick_zones | Unknown |  |
| price_tier_1 | Unknown |  |
| price_tier_10 | Unknown |  |
| price_tier_2 | Unknown |  |
| price_tier_3 | Unknown |  |
| price_tier_4 | Unknown |  |
| price_tier_5 | Unknown |  |
| price_tier_6 | Unknown |  |
| price_tier_7 | Unknown |  |
| price_tier_8 | Unknown |  |
| price_tier_9 | Unknown |  |
| price_tiers_tier_1 | Unknown |  |
| price_tiers_tier_10 | Unknown |  |
| price_tiers_tier_2 | Unknown |  |
| price_tiers_tier_3 | Unknown |  |
| price_tiers_tier_4 | Unknown |  |
| price_tiers_tier_5 | Unknown |  |
| price_tiers_tier_6 | Unknown |  |
| price_tiers_tier_7 | Unknown |  |
| price_tiers_tier_8 | Unknown |  |
| price_tiers_tier_9 | Unknown |  |
| purchase_tax_rule | Unknown |  |
| quantity_to_produce | Unknown |  |
| reorder_quantity | Unknown |  |
| sale_tax_rule | Unknown |  |
| sellable | Unknown |  |
| short_description | Unknown |  |
| sku | Unknown |  |
| status | Unknown |  |
| stock_locator | Unknown |  |
| suppliers | Json |  |
| tags | Unknown |  |
| type | Unknown |  |
| uom | Unknown |  |
| warranty_name | Unknown |  |
| weight | Unknown |  |
| weight_units | Unknown |  |
| width | Unknown |  |

### product_markup_price

| Column | Type | Keys |
| --- | --- | --- |
| tier_number | Unknown | PK |
| product_id | Unknown | FK |
| markup_type | Unknown |  |
| markup_value | Unknown |  |
| use_price_type | Unknown |  |

### factory_calendar_day

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| factory_calendar_year | Unknown | PK, FK |
| break_end_time | Unknown |  |
| break_start_time | Unknown |  |
| capacity | Unknown |  |
| day_of_week | Unknown |  |
| end_time | Unknown |  |
| is_weekend | Unknown |  |
| start_time | Unknown |  |

### factory_calendar_special_day

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| factory_calendar_year | Unknown | PK, FK |
| break_end_time | Unknown |  |
| break_start_time | Unknown |  |
| capacity | Unknown |  |
| comment | Unknown |  |
| date | Unknown |  |
| end_time | Unknown |  |
| is_holiday | Unknown |  |
| is_weekend | Unknown |  |
| start_time | Unknown |  |

### factory_calendar

| Column | Type | Keys |
| --- | --- | --- |
| year | Unknown | PK |
| week_start | Unknown |  |

### lead_contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| lead_id | Unknown | PK, FK |
| comment | Unknown |  |
| defaults | Unknown |  |
| email | Unknown |  |
| fax | Unknown |  |
| include_in_email | Unknown |  |
| job_title | Unknown |  |
| mobile_phone | Unknown |  |
| name | Unknown |  |
| phone | Unknown |  |
| website | Unknown |  |

### lead_address

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| lead_id | Unknown | PK, FK |
| city | Unknown |  |
| country | Unknown |  |
| default_for_type | Unknown |  |
| line_1 | Unknown |  |
| line_2 | Unknown |  |
| postcode | Unknown |  |
| state | Unknown |  |
| type | Unknown |  |

### lead

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| amount | Unknown |  |
| close_chance | Unknown |  |
| close_date | Unknown |  |
| comment | Unknown |  |
| currency | Unknown |  |
| lead_status | Unknown |  |
| name | Unknown |  |
| payment_term | Unknown |  |
| price_tier | Unknown |  |
| sales_representative | Unknown |  |
| tax_rule | Unknown |  |

### sale_quote_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| sale_id | Unknown | PK, FK |
| product_id | Unknown | FK |
| account | Unknown |  |
| comment | Unknown |  |
| dimensions_units | Unknown |  |
| discount | Unknown |  |
| name | Unknown |  |
| price | Unknown |  |
| product_custom_field_1 | Unknown |  |
| product_custom_field_10 | Unknown |  |
| product_custom_field_2 | Unknown |  |
| product_custom_field_3 | Unknown |  |
| product_custom_field_4 | Unknown |  |
| product_custom_field_5 | Unknown |  |
| product_custom_field_6 | Unknown |  |
| product_custom_field_7 | Unknown |  |
| product_custom_field_8 | Unknown |  |
| product_custom_field_9 | Unknown |  |
| quantity | Unknown |  |
| sku | Unknown |  |
| tax | Unknown |  |
| tax_rule | Unknown |  |
| weight_units | Unknown |  |

### sale_quote_additional_charge

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| sale_id | Unknown | FK |
| comment | Unknown |  |
| description | Unknown |  |
| discount | Unknown |  |
| price | Unknown |  |
| quantity | Unknown |  |
| tax | Unknown |  |
| tax_rule | Unknown |  |
| total | Unknown |  |

### sale_order_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| sale_id | Unknown | PK, FK |
| product_id | Unknown | FK |
| average_cost | Unknown |  |
| backorder | Unknown |  |
| backorder_quantity | Unknown |  |
| comment | Unknown |  |
| discount | Unknown |  |
| dropship | Unknown |  |
| price | Unknown |  |
| product_custom_field_1 | Unknown |  |
| product_custom_field_10 | Unknown |  |
| product_custom_field_2 | Unknown |  |
| product_custom_field_3 | Unknown |  |
| product_custom_field_4 | Unknown |  |
| product_custom_field_5 | Unknown |  |
| product_custom_field_6 | Unknown |  |
| product_custom_field_7 | Unknown |  |
| product_custom_field_8 | Unknown |  |
| product_custom_field_9 | Unknown |  |
| quantity | Unknown |  |
| tax | Unknown |  |
| tax_rule | Unknown |  |
| total | Unknown |  |

### sale_order_additional_charge

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| sale_id | Unknown | FK |
| comment | Unknown |  |
| description | Unknown |  |
| discount | Unknown |  |
| price | Unknown |  |
| quantity | Unknown |  |
| tax | Unknown |  |
| tax_rule | Unknown |  |
| total | Unknown |  |

### sale_invoice_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| sale_id | Unknown | PK, FK |
| sale_invoice_task_id | Unknown | PK, FK |
| product_id | Unknown | FK |
| account | Unknown |  |
| average_cost | Unknown |  |
| comment | Unknown |  |
| discount | Unknown |  |
| price | Unknown |  |
| product_custom_field_1 | Unknown |  |
| product_custom_field_10 | Unknown |  |
| product_custom_field_2 | Unknown |  |
| product_custom_field_3 | Unknown |  |
| product_custom_field_4 | Unknown |  |
| product_custom_field_5 | Unknown |  |
| product_custom_field_6 | Unknown |  |
| product_custom_field_7 | Unknown |  |
| product_custom_field_8 | Unknown |  |
| product_custom_field_9 | Unknown |  |
| quantity | Unknown |  |
| tax | Unknown |  |
| tax_rule | Unknown |  |
| total | Unknown |  |

### sale_invoice_additional_charge

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| sale_id | Unknown | FK |
| sale_invoice_task_id | Unknown | FK |
| account | Unknown |  |
| description | Unknown |  |
| discount | Unknown |  |
| price | Unknown |  |
| quantity | Unknown |  |
| tax | Unknown |  |
| tax_rule | Unknown |  |
| total | Unknown |  |

### sale_invoice

| Column | Type | Keys |
| --- | --- | --- |
| task_id | Unknown | PK |
| sale_id | Unknown | PK, FK |
| billing_address_line_1 | Unknown |  |
| billing_address_line_2 | Unknown |  |
| currency_conversion_rate | Unknown |  |
| invoice_date | Unknown |  |
| invoice_due_date | Unknown |  |
| invoice_number | Unknown |  |
| linked_fulfillment_number | Unknown |  |
| memo | Unknown |  |
| paid | Unknown |  |
| payment | Json |  |
| status | Unknown |  |
| tax | Unknown |  |
| total | Unknown |  |
| total_before_tax | Unknown |  |

### sale_credit_note_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| sale_credit_note_task_id | Unknown | PK, FK |
| sale_id | Unknown | PK, FK |
| product_id | Unknown | FK |
| account | Unknown |  |
| comment | Unknown |  |
| discount | Unknown |  |
| price | Unknown |  |
| product_custom_field_1 | Unknown |  |
| product_custom_field_10 | Unknown |  |
| product_custom_field_2 | Unknown |  |
| product_custom_field_3 | Unknown |  |
| product_custom_field_4 | Unknown |  |
| product_custom_field_5 | Unknown |  |
| product_custom_field_6 | Unknown |  |
| product_custom_field_7 | Unknown |  |
| product_custom_field_8 | Unknown |  |
| product_custom_field_9 | Unknown |  |
| quantity | Unknown |  |
| tax | Unknown |  |
| tax_rule | Unknown |  |
| total | Unknown |  |

### sale_credit_note_refund

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| sale_credit_note_task_id | Unknown | PK, FK |
| sale_id | Unknown | PK, FK |
| account | Unknown |  |
| amount | Unknown |  |
| currency_rate | Unknown |  |
| date_created | Unknown |  |
| date_paid | Unknown |  |
| reference | Unknown |  |

### sale_credit_note_restock

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| sale_credit_note_task_id | Unknown | PK, FK |
| sale_id | Unknown | PK, FK |
| product_id | Unknown | FK |
| batch_sn | Unknown |  |
| expiry_date | Unknown |  |
| location | Unknown |  |
| name | Unknown |  |
| quantity | Unknown |  |
| sku | Unknown |  |

### sale_credit_note_additional_charge

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| sale_credit_note_task_id | Unknown | FK |
| sale_id | Unknown | FK |
| account | Unknown |  |
| comment | Unknown |  |
| description | Unknown |  |
| discount | Unknown |  |
| price | Unknown |  |
| quantity | Unknown |  |
| tax | Unknown |  |
| tax_rule | Unknown |  |
| total | Unknown |  |

### sale_credit_note

| Column | Type | Keys |
| --- | --- | --- |
| task_id | Unknown | PK |
| sale_id | Unknown | PK, FK |
| credit_note_conversion_rate | Unknown |  |
| credit_note_date | Unknown |  |
| credit_note_invoice_number | Unknown |  |
| credit_note_number | Unknown |  |
| memo | Unknown |  |
| status | Unknown |  |
| tax | Unknown |  |
| total | Unknown |  |
| total_before_tax | Unknown |  |

### sale_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| sale_id | Unknown | PK, FK |
| content_type | Unknown |  |
| download_url | Unknown |  |
| file_name | Unknown |  |

### sale_fullfillment_pick_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| fulfillment_number | Unknown | PK, FK |
| sale_id | Unknown | PK, FK |
| product_id | Unknown | FK |
| batch_sn | Unknown |  |
| expiry_date | Unknown |  |
| product_custom_field_1 | Unknown |  |
| product_custom_field_10 | Unknown |  |
| product_custom_field_2 | Unknown |  |
| product_custom_field_3 | Unknown |  |
| product_custom_field_4 | Unknown |  |
| product_custom_field_5 | Unknown |  |
| product_custom_field_6 | Unknown |  |
| product_custom_field_7 | Unknown |  |
| product_custom_field_8 | Unknown |  |
| product_custom_field_9 | Unknown |  |
| quantity | Unknown |  |

### sale_fullfillment_pack_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| fulfillment_number | Unknown | PK, FK |
| sale_id | Unknown | PK, FK |
| product_id | Unknown | FK |
| batch_sn | Unknown |  |
| box | Unknown |  |
| expiry_date | Unknown |  |
| location | Unknown |  |
| location_id | Unknown |  |
| product_custom_field_1 | Unknown |  |
| product_custom_field_10 | Unknown |  |
| product_custom_field_2 | Unknown |  |
| product_custom_field_3 | Unknown |  |
| product_custom_field_4 | Unknown |  |
| product_custom_field_5 | Unknown |  |
| product_custom_field_6 | Unknown |  |
| product_custom_field_7 | Unknown |  |
| product_custom_field_8 | Unknown |  |
| product_custom_field_9 | Unknown |  |
| quantity | Unknown |  |

### sale_fullfillment_ship_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| fulfillment_number | Unknown | PK, FK |
| sale_id | Unknown | PK, FK |
| boxes | Unknown |  |
| carrier | Unknown |  |
| is_shipped | Unknown |  |
| shipment_date | Unknown |  |
| tracking_number | Unknown |  |
| tracking_url | Unknown |  |

### sale_fullfillment

| Column | Type | Keys |
| --- | --- | --- |
| fulfillment_number | Unknown | PK |
| task_id | Unknown | PK |
| sale_id | Unknown | PK, FK |
| fulfilment_status | Unknown |  |
| linked_invoice_number | Unknown |  |
| pack_status | Unknown |  |
| pick_status | Unknown |  |
| ship_required_by | Unknown |  |
| ship_shipping_address_city | Unknown |  |
| ship_shipping_address_company | Unknown |  |
| ship_shipping_address_contact | Unknown |  |
| ship_shipping_address_country | Unknown |  |
| ship_shipping_address_display_address_line_1 | Unknown |  |
| ship_shipping_address_display_address_line_2 | Unknown |  |
| ship_shipping_address_line_1 | Unknown |  |
| ship_shipping_address_line_2 | Unknown |  |
| ship_shipping_address_postcode | Unknown |  |
| ship_shipping_address_ship_to_other | Unknown |  |
| ship_shipping_address_state | Unknown |  |
| ship_shipping_note | Unknown |  |
| ship_status | Unknown |  |

### sale_inventory_movement

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| sale_id | Unknown | PK, FK |
| product_id | Unknown | FK |
| cogs | Unknown |  |
| date | Unknown |  |
| product_custom_field_1 | Unknown |  |
| product_custom_field_10 | Unknown |  |
| product_custom_field_2 | Unknown |  |
| product_custom_field_3 | Unknown |  |
| product_custom_field_4 | Unknown |  |
| product_custom_field_5 | Unknown |  |
| product_custom_field_6 | Unknown |  |
| product_custom_field_7 | Unknown |  |
| product_custom_field_8 | Unknown |  |
| product_custom_field_9 | Unknown |  |
| task_id | Unknown |  |

### sale_transaction

| Column | Type | Keys |
| --- | --- | --- |
| sale_id | Unknown | PK, FK |
| transaction_id | Unknown | PK, FK |
| task_id | Unknown |  |

### sale

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| additional_attribute_1 | Unknown |  |
| additional_attribute_10 | Unknown |  |
| additional_attribute_2 | Unknown |  |
| additional_attribute_3 | Unknown |  |
| additional_attribute_4 | Unknown |  |
| additional_attribute_5 | Unknown |  |
| additional_attribute_6 | Unknown |  |
| additional_attribute_7 | Unknown |  |
| additional_attribute_8 | Unknown |  |
| additional_attribute_9 | Unknown |  |
| base_currency | Unknown |  |
| carrier | Unknown |  |
| cogs_amount | Unknown |  |
| combined_invoice_status | Unknown |  |
| combined_packing_status | Unknown |  |
| combined_payment_status | Unknown |  |
| combined_picking_status | Unknown |  |
| combined_shipping_status | Unknown |  |
| combined_tracking_numbers | Unknown |  |
| customer_reference | Unknown |  |
| default_account | Unknown |  |
| external_id | Unknown |  |
| fulfilment_status | Unknown |  |
| last_modified_on | Unknown |  |
| location | Unknown |  |
| manual_journal_line | Json |  |
| manual_journal_status | Unknown |  |
| note | Unknown |  |
| order_date | Unknown |  |
| order_memo | Unknown |  |
| order_number | Unknown |  |
| order_status | Unknown |  |
| order_tax | Unknown |  |
| order_total | Unknown |  |
| order_total_before_tax | Unknown |  |
| price_tier | Unknown |  |
| quote_memo | Unknown |  |
| quote_prepayment | Json |  |
| quote_status | Unknown |  |
| quote_tax | Unknown |  |
| quote_total | Unknown |  |
| quote_total_before_tax | Unknown |  |
| sales_representative | Unknown |  |
| service_only | Unknown |  |
| ship_by | Unknown |  |
| shipping_note | Unknown |  |
| skip_quote | Unknown |  |
| source_channel | Unknown |  |
| status | Unknown |  |
| tax_calculation | Unknown |  |
| tax_rule | Unknown |  |
| term | Unknown |  |
| type | Unknown |  |

### transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| task_id | Unknown | FK |
| amount | Unknown |  |
| credit_account_code | Unknown |  |
| currency_rate | Unknown |  |
| debit_account_code | Unknown |  |
| effective_date | Unknown |  |
| original_amount | Unknown |  |
| reference | Unknown |  |
| transaction | Unknown |  |
| type | Unknown |  |

### product_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

### new_stock_line

| Column | Type | Keys |
| --- | --- | --- |
| product_id | Unknown | PK, FK |
| stock_adjustment_id | Unknown | PK, FK |
| stock_take_number | Unknown | PK, FK |
| batch_sn | Unknown |  |
| comment | Unknown |  |
| expiry_date | Unknown |  |
| location_id | Unknown |  |
| product_custom_field_1 | Unknown |  |
| product_custom_field_10 | Unknown |  |
| product_custom_field_2 | Unknown |  |
| product_custom_field_3 | Unknown |  |
| product_custom_field_4 | Unknown |  |
| product_custom_field_5 | Unknown |  |
| product_custom_field_6 | Unknown |  |
| product_custom_field_7 | Unknown |  |
| product_custom_field_8 | Unknown |  |
| product_custom_field_9 | Unknown |  |
| received_date | Unknown |  |
| unit_cost | Unknown |  |

### stock_adjustment_transaction

| Column | Type | Keys |
| --- | --- | --- |
| stock_adjustment_id | Unknown | PK, FK |
| stock_take_number | Unknown | PK, FK |
| transaction_id | Unknown | PK, FK |

### stock_adjustment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| stock_take_number | Unknown | PK, FK |
| account | Unknown |  |
| effective_date | Unknown |  |
| existing_stock_line | Json |  |
| reference | Unknown |  |
| status | Unknown |  |

### product_production_bom_resource

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_production_bom_id | Unknown | PK, FK |
| product_production_bom_operation_id | Unknown | PK, FK |
| resource_id | Unknown | FK |
| cost | Unknown |  |
| cost_calculation_type | Unknown |  |
| cycle_time | Unknown |  |
| operation_id | Unknown |  |
| position | Unknown |  |
| quantity | Unknown |  |

### product_production_bom_component

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_production_bom_id | Unknown | PK, FK |
| product_production_bom_operation_id | Unknown | PK, FK |
| product_id | Unknown | FK |
| cost | Unknown |  |
| costing_method | Unknown |  |
| is_backflush | Unknown |  |
| operation_id | Unknown |  |
| position | Unknown |  |
| quantity | Unknown |  |
| sale_price_tier | Unknown |  |
| unit | Unknown |  |
| wastage_percent | Unknown |  |
| wastage_qty | Unknown |  |

### product_production_bom_note

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_production_bom_id | Unknown | PK, FK |
| product_production_bom_operation_id | Unknown | PK, FK |
| note | Unknown |  |
| operation_id | Unknown |  |
| position | Unknown |  |

### product_production_bom_output_product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_production_bom_id | Unknown | PK, FK |
| product_production_bom_operation_id | Unknown | PK, FK |
| product_id | Unknown | FK |
| average_cost | Unknown |  |
| cost_calculation_type | Unknown |  |
| costing_method | Unknown |  |
| delivery_to | Unknown |  |
| delivery_to_name | Unknown |  |
| output_quantity | Unknown |  |
| position | Unknown |  |
| price_tier | Unknown |  |
| product_family_id | Unknown |  |
| product_name | Unknown |  |
| product_sku | Unknown |  |
| ratio | Unknown |  |
| unit | Unknown |  |
| wastage_cost | Unknown |  |

### product_production_bom_operation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_production_bom_id | Unknown | PK, FK |
| work_center_id | Unknown | FK |
| attachment | Json |  |
| cycle_time | Unknown |  |
| finished_product | Json |  |
| input_product | Json |  |
| is_backflush | Unknown |  |
| is_drop_ship | Unknown |  |
| name | Unknown |  |
| operation_link | Json |  |
| operation_order | Unknown |  |
| operation_type | Unknown |  |
| units_per_cycle | Unknown |  |
| variation_component | Json |  |

### product_production_bom

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| delivery_to_id | Unknown | FK |
| buffer_percent | Unknown |  |
| component_production_lead_time | Unknown |  |
| created_date | Unknown |  |
| deviation_percent | Unknown |  |
| ignore_cumulative_lead_time | Unknown |  |
| instruction_url | Unknown |  |
| is_default | Unknown |  |
| is_tracing | Unknown |  |
| issue_method | Unknown |  |
| issue_method_component | Unknown |  |
| issue_method_parameter | Unknown |  |
| max_quantity | Unknown |  |
| min_quantity | Unknown |  |
| name | Unknown |  |
| output_quantity | Unknown |  |
| run_size | Unknown |  |
| version | Unknown |  |

### production_order_source_task

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| production_order_id | Unknown | PK, FK |
| is_source_task_voided | Unknown |  |
| source_task_id | Unknown |  |
| source_task_number | Unknown |  |
| source_task_type | Unknown |  |

### production_order

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| location_id | Unknown | FK |
| product_id | Unknown | FK |
| capacity_calc_type | Unknown |  |
| comments | Unknown |  |
| completion_date | Unknown |  |
| finished_goods_account_code | Unknown |  |
| order_number | Unknown |  |
| order_status | Unknown |  |
| quantity | Unknown |  |
| release_date | Unknown |  |
| required_by_date | Unknown |  |
| start_date | Unknown |  |
| status | Unknown |  |
| task_id | Unknown |  |
| type | Unknown |  |
| wip_account_code | Unknown |  |
| custom_** |  |  |

### work_center_location

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| work_center_id | Unknown | PK, FK |
| location_id | Unknown | FK |
| parent_location_id | Unknown |  |
| parent_location_name | Unknown |  |
| type | Unknown |  |
| workcenter_id | Unknown |  |

### work_center

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| code | Unknown |  |
| coman_procurement_type | Unknown |  |
| is_active | Unknown |  |
| is_coman | Unknown |  |
| is_coman_purchase | Unknown |  |
| name | Unknown |  |
| supplier_id | Unknown |  |
| supplier_name | Unknown |  |
| workcenter_locations | Unknown |  |
| workcenter_suppliers | Unknown |  |

### non_zero_stock_on_hand_product

| Column | Type | Keys |
| --- | --- | --- |
| product_id | Unknown | PK, FK |
| stock_take_number | Unknown | PK, FK |
| stock_take_task_id | Unknown | PK, FK |
| adjustment | Unknown |  |
| available | Unknown |  |
| batch_sn | Unknown |  |
| comment | Unknown |  |
| expiry_date | Unknown |  |
| image_content_type | Unknown |  |
| image_download_url | Unknown |  |
| image_file_name | Unknown |  |
| image_id | Unknown |  |
| location_id | Unknown |  |
| product_custom_field_1 | Unknown |  |
| product_custom_field_10 | Unknown |  |
| product_custom_field_2 | Unknown |  |
| product_custom_field_3 | Unknown |  |
| product_custom_field_4 | Unknown |  |
| product_custom_field_5 | Unknown |  |
| product_custom_field_6 | Unknown |  |
| product_custom_field_7 | Unknown |  |
| product_custom_field_8 | Unknown |  |
| product_custom_field_9 | Unknown |  |
| quantity_on_hand | Unknown |  |
| unit | Unknown |  |

### zero_stock_on_hand_product

| Column | Type | Keys |
| --- | --- | --- |
| product_id | Unknown | PK, FK |
| stock_take_number | Unknown | PK, FK |
| stock_take_task_id | Unknown | PK, FK |
| location_id | Unknown | FK |
| adjustment | Unknown |  |
| available | Unknown |  |
| batch_sn | Unknown |  |
| comment | Unknown |  |
| expiry_date | Unknown |  |
| image_content_type | Unknown |  |
| image_download_url | Unknown |  |
| image_file_name | Unknown |  |
| image_id | Unknown |  |
| product_custom_field_1 | Unknown |  |
| product_custom_field_10 | Unknown |  |
| product_custom_field_2 | Unknown |  |
| product_custom_field_3 | Unknown |  |
| product_custom_field_4 | Unknown |  |
| product_custom_field_5 | Unknown |  |
| product_custom_field_6 | Unknown |  |
| product_custom_field_7 | Unknown |  |
| product_custom_field_8 | Unknown |  |
| product_custom_field_9 | Unknown |  |
| quantity_on_hand | Unknown |  |
| unit | Unknown |  |

### stock_take_transaction

| Column | Type | Keys |
| --- | --- | --- |
| stock_take_number | Unknown | PK, FK |
| stock_take_task_id | Unknown | PK, FK |
| transaction_id | Unknown | PK, FK |

### stock_take

| Column | Type | Keys |
| --- | --- | --- |
| stock_take_number | Unknown | PK |
| task_id | Unknown | PK |
| account | Unknown |  |
| bin | Json |  |
| brands | Json |  |
| effective_date | Unknown |  |
| pick_zone | Json |  |
| reference | Unknown |  |
| status | Unknown |  |
| stock_locators | Json |  |

### task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assigned_by | Unknown |  |
| assigned_to | Unknown |  |
| category | Unknown |  |
| completed_date | Unknown |  |
| description | Unknown |  |
| end_date | Unknown |  |
| entity_id | Unknown |  |
| entity_type | Unknown |  |
| is_all_day | Unknown |  |
| is_important | Unknown |  |
| name | Unknown |  |
| start_date | Unknown |  |
| task_status | Unknown |  |
| void_date | Unknown |  |
| workflow_name | Unknown |  |

### suspend_reason_workcenter

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| suspend_reason_suspend_reason_id | Unknown | PK, FK |
| workcenter_id | Unknown | FK |
| id | Unknown |  |

### suspend_reason

| Column | Type | Keys |
| --- | --- | --- |
| suspend_reason_id | Unknown | PK |
| reason | Unknown |  |

### production_resource

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| code | Unknown |  |
| cycle_duration | Unknown |  |
| is_active | Unknown |  |
| is_allow_all_capacity_usage | Unknown |  |
| is_available_on_holidays | Unknown |  |
| is_available_on_weekends | Unknown |  |
| is_infinite | Unknown |  |
| name | Unknown |  |
| resource_type | Unknown |  |
| tags | Unknown |  |

### production_run_operation_component

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| production_run_id | Unknown | PK, FK |
| production_run_operation_id | Unknown | PK, FK |
| location_id | Unknown | FK |
| product_id | Unknown | FK |
| available | Unknown |  |
| batch_sn | Unknown |  |
| costing_method | Unknown |  |
| expected_quantity | Unknown |  |
| expiry_date | Unknown |  |
| is_backflush | Unknown |  |
| is_reserved | Unknown |  |
| product_cost | Unknown |  |
| quantity | Unknown |  |
| reserved_quantity | Unknown |  |
| unit | Unknown |  |
| unit_cost | Unknown |  |
| wastage_percent | Unknown |  |
| wastage_qty | Unknown |  |

### production_run_resource

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| production_run_id | Unknown | PK, FK |
| production_run_operation_id | Unknown | PK, FK |
| resource_id | Unknown | FK |
| available | Unknown |  |
| cost | Unknown |  |
| cycle_time | Unknown |  |
| quantity | Unknown |  |
| unit_cost | Unknown |  |

### production_run_operation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| production_run_id | Unknown | PK, FK |
| work_center_id | Unknown | FK |
| actual_time | Unknown |  |
| attachments | Json |  |
| coman_status | Unknown |  |
| coman_task | Json |  |
| coman_taskline | Json |  |
| due_date | Unknown |  |
| end_date | Unknown |  |
| finished_product | Json |  |
| input_product | Json |  |
| is_backflush | Unknown |  |
| is_drop_ship | Unknown |  |
| manual_enddate | Unknown |  |
| manual_startdate | Unknown |  |
| name | Unknown |  |
| notes | Json |  |
| operation_order | Unknown |  |
| operation_type | Unknown |  |
| output_product | Json |  |
| planned_time | Unknown |  |
| resource_cost | Json |  |
| start_date | Unknown |  |
| status | Unknown |  |
| suspend_reason | Unknown |  |
| units_per_cycle | Unknown |  |
| workcenter_id | Unknown |  |

### production_run_traceability

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| production_run_id | Unknown | PK, FK |
| produced_product_id | Unknown | FK |
| used_product_id | Unknown | FK |
| produced_product_batch_sn | Unknown |  |
| produced_product_expiry_date | Unknown |  |
| used_product_batch_sn | Unknown |  |
| used_product_expiry_date | Unknown |  |

### production_run

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| production_order_id | Unknown | FK |
| due_date | Unknown |  |
| end_date | Unknown |  |
| issue_method_parameter | Unknown |  |
| manual_journals | Json |  |
| output | Json |  |
| pending_output | Json |  |
| quantity | Unknown |  |
| received_date | Unknown |  |
| run_number | Unknown |  |
| schedule_due | Unknown |  |
| schedule_start | Unknown |  |
| start_date | Unknown |  |
| status | Unknown |  |
| wip_account | Unknown |  |

### purchase_inventory_movement

| Column | Type | Keys |
| --- | --- | --- |
| product_id | Unknown | PK, FK |
| purchase_id | Unknown | PK, FK |
| cogs | Unknown |  |
| date | Unknown |  |
| product_custom_field_1 | Unknown |  |
| product_custom_field_10 | Unknown |  |
| product_custom_field_2 | Unknown |  |
| product_custom_field_3 | Unknown |  |
| product_custom_field_4 | Unknown |  |
| product_custom_field_5 | Unknown |  |
| product_custom_field_6 | Unknown |  |
| product_custom_field_7 | Unknown |  |
| product_custom_field_8 | Unknown |  |
| product_custom_field_9 | Unknown |  |
| task_id | Unknown |  |

### purchase_credit_note_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| purchase_credit_not_task_id | Unknown | PK, FK |
| purchase_id | Unknown | PK, FK |
| product_id | Unknown | FK |
| account | Unknown |  |
| comment | Unknown |  |
| discount | Unknown |  |
| price | Unknown |  |
| product_custom_field_1 | Unknown |  |
| product_custom_field_10 | Unknown |  |
| product_custom_field_2 | Unknown |  |
| product_custom_field_3 | Unknown |  |
| product_custom_field_4 | Unknown |  |
| product_custom_field_5 | Unknown |  |
| product_custom_field_6 | Unknown |  |
| product_custom_field_7 | Unknown |  |
| product_custom_field_8 | Unknown |  |
| product_custom_field_9 | Unknown |  |
| quantity | Unknown |  |
| tax | Unknown |  |
| tax_rule | Unknown |  |
| total | Unknown |  |

### purchase_credit_note_refund

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| purchase_credit_not_task_id | Unknown | PK, FK |
| purchase_id | Unknown | PK, FK |
| account | Unknown |  |
| amount | Unknown |  |
| currency_rate | Unknown |  |
| date_created | Unknown |  |
| date_paid | Unknown |  |
| reference | Unknown |  |

### purchase_credit_note_unstock

| Column | Type | Keys |
| --- | --- | --- |
| card_id | Unknown | PK |
| product_id | Unknown | PK, FK |
| purchase_credit_not_task_id | Unknown | PK, FK |
| purchase_id | Unknown | PK, FK |
| batch_sn | Unknown |  |
| date | Unknown |  |
| expiry_date | Unknown |  |
| location | Unknown |  |
| product_custom_field_1 | Unknown |  |
| product_custom_field_10 | Unknown |  |
| product_custom_field_2 | Unknown |  |
| product_custom_field_3 | Unknown |  |
| product_custom_field_4 | Unknown |  |
| product_custom_field_5 | Unknown |  |
| product_custom_field_6 | Unknown |  |
| product_custom_field_7 | Unknown |  |
| product_custom_field_8 | Unknown |  |
| product_custom_field_9 | Unknown |  |
| quantity | Unknown |  |

### purchase_credit_note

| Column | Type | Keys |
| --- | --- | --- |
| task_id | Unknown | PK |
| purchase_id | Unknown | PK, FK |
| additional_charges | Json |  |
| credit_note_date | Unknown |  |
| credit_note_invoice_number | Unknown |  |
| credit_note_number | Unknown |  |
| currency_rate | Unknown |  |
| status | Unknown |  |
| tax | Unknown |  |

### purchase_invoice_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| purchase_id | Unknown | PK, FK |
| purchase_invoice_task_id | Unknown | PK, FK |
| product_id | Unknown | FK |
| account | Unknown |  |
| comment | Unknown |  |
| discount | Unknown |  |
| non_inventory | Unknown |  |
| price | Unknown |  |
| product_custom_field_1 | Unknown |  |
| product_custom_field_10 | Unknown |  |
| product_custom_field_2 | Unknown |  |
| product_custom_field_3 | Unknown |  |
| product_custom_field_4 | Unknown |  |
| product_custom_field_5 | Unknown |  |
| product_custom_field_6 | Unknown |  |
| product_custom_field_7 | Unknown |  |
| product_custom_field_8 | Unknown |  |
| product_custom_field_9 | Unknown |  |
| quantity | Unknown |  |
| tax | Unknown |  |
| tax_rule | Unknown |  |
| total | Unknown |  |

### purchase_invoice_payment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| purchase_id | Unknown | PK, FK |
| purchase_invoice_task_id | Unknown | PK, FK |
| account | Unknown |  |
| amount | Unknown |  |
| currency_rate | Unknown |  |
| date_created | Unknown |  |
| date_paid | Unknown |  |
| reference | Unknown |  |

### purchase_invoice_additional_charge

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| purchase_id | Unknown | FK |
| purchase_invoice_task_id | Unknown | FK |
| account | Unknown |  |
| description | Unknown |  |
| discount | Unknown |  |
| price | Unknown |  |
| quantity | Unknown |  |
| reference | Unknown |  |
| tax | Unknown |  |
| tax_rule | Unknown |  |
| total | Unknown |  |

### purchase_invoice

| Column | Type | Keys |
| --- | --- | --- |
| task_id | Unknown | PK |
| purchase_id | Unknown | PK, FK |
| currency_rate | Unknown |  |
| invoice_date | Unknown |  |
| invoice_due_date | Unknown |  |
| invoice_number | Unknown |  |
| invoicing_and_receiving_number | Unknown |  |
| paid | Unknown |  |
| status | Unknown |  |

### put_away_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| object_task_id | Unknown | PK, FK |
| purchase_id | Unknown | PK, FK |
| product_id | Unknown | FK |
| batch_sn | Unknown |  |
| card_id | Unknown |  |
| date | Unknown |  |
| expiry_date | Unknown |  |
| location | Unknown |  |
| location_id | Unknown |  |
| product_custom_field_1 | Unknown |  |
| product_custom_field_10 | Unknown |  |
| product_custom_field_2 | Unknown |  |
| product_custom_field_3 | Unknown |  |
| product_custom_field_4 | Unknown |  |
| product_custom_field_5 | Unknown |  |
| product_custom_field_6 | Unknown |  |
| product_custom_field_7 | Unknown |  |
| product_custom_field_8 | Unknown |  |
| product_custom_field_9 | Unknown |  |
| quantity | Unknown |  |
| received | Unknown |  |
| supplier_sku | Unknown |  |
| type | Unknown |  |

### put_away

| Column | Type | Keys |
| --- | --- | --- |
| task_id | Unknown | PK |
| purchase_id | Unknown | PK, FK |
| invoicing_and_receiving_number | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |

### stock_received_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| object_task_id | Unknown | PK, FK |
| purchase_id | Unknown | PK, FK |
| product_id | Unknown | FK |
| batch_sn | Unknown |  |
| card_id | Unknown |  |
| date | Unknown |  |
| expiry_date | Unknown |  |
| location_id | Unknown |  |
| product_custom_field_1 | Unknown |  |
| product_custom_field_10 | Unknown |  |
| product_custom_field_2 | Unknown |  |
| product_custom_field_3 | Unknown |  |
| product_custom_field_4 | Unknown |  |
| product_custom_field_5 | Unknown |  |
| product_custom_field_6 | Unknown |  |
| product_custom_field_7 | Unknown |  |
| product_custom_field_8 | Unknown |  |
| product_custom_field_9 | Unknown |  |
| quantity | Unknown |  |
| received | Unknown |  |
| supplier_sku | Unknown |  |
| type | Unknown |  |

### stock_received

| Column | Type | Keys |
| --- | --- | --- |
| task_id | Unknown | PK |
| purchase_id | Unknown | PK, FK |
| invoicing_and_receiving_number | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |

### purchase_order_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| purchase_id | Unknown | PK, FK |
| product_id | Unknown | FK |
| comment | Unknown |  |
| dimensions_unit | Unknown |  |
| discount | Unknown |  |
| price | Unknown |  |
| product_custom_field_1 | Unknown |  |
| product_custom_field_10 | Unknown |  |
| product_custom_field_2 | Unknown |  |
| product_custom_field_3 | Unknown |  |
| product_custom_field_4 | Unknown |  |
| product_custom_field_5 | Unknown |  |
| product_custom_field_6 | Unknown |  |
| product_custom_field_7 | Unknown |  |
| product_custom_field_8 | Unknown |  |
| product_custom_field_9 | Unknown |  |
| quantity | Unknown |  |
| supplier_sku | Unknown |  |
| tax_rule | Unknown |  |

### purchase

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| related_drop_ship_sale_task | Unknown | FK |
| supplier_id | Unknown | FK |
| approach | Unknown |  |
| attachments | Json |  |
| billing_address_city | Unknown |  |
| billing_address_country | Unknown |  |
| billing_address_display_address_line_1 | Unknown |  |
| billing_address_display_address_line_2 | Unknown |  |
| billing_address_line_1 | Unknown |  |
| billing_address_line_2 | Unknown |  |
| billing_address_postcode | Unknown |  |
| billing_address_state | Unknown |  |
| blind_receipt | Unknown |  |
| combined_invoice_status | Unknown |  |
| combined_payment_status | Unknown |  |
| combined_receiving_status | Unknown |  |
| contact | Unknown |  |
| currency_rate | Unknown |  |
| inventory_account | Unknown |  |
| is_service_only | Unknown |  |
| last_updated_date | Unknown |  |
| location | Unknown |  |
| note | Unknown |  |
| order_additional_charges | Json |  |
| order_date | Unknown |  |
| order_memo | Unknown |  |
| order_number | Unknown |  |
| order_prepayments | Json |  |
| order_status | Unknown |  |
| order_tax | Unknown |  |
| order_total_before_tax | Unknown |  |
| phone | Unknown |  |
| required_by | Unknown |  |
| shipping_address_city | Unknown |  |
| shipping_address_company | Unknown |  |
| shipping_address_country | Unknown |  |
| shipping_address_display_address_line_1 | Unknown |  |
| shipping_address_display_address_line_2 | Unknown |  |
| shipping_address_line_1 | Unknown |  |
| shipping_address_line_2 | Unknown |  |
| shipping_address_postcode | Unknown |  |
| shipping_address_ship_to_other | Unknown |  |
| shipping_address_state | Unknown |  |
| status | Unknown |  |
| tax_calculation | Unknown |  |
| tax_rule | Unknown |  |
| terms | Unknown |  |
| type | Unknown |  |

### location_bin

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| location_id | Unknown | PK, FK |
| is_deprecated | Unknown |  |
| is_staging | Unknown |  |
| name | Unknown |  |

### location

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| address_city_suburb | Unknown |  |
| address_country | Unknown |  |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| address_state_province | Unknown |  |
| address_zip_postcode | Unknown |  |
| fixed_assets_location | Unknown |  |
| is_co_man | Unknown |  |
| is_default | Unknown |  |
| is_deprecated | Unknown |  |
| is_shop_floor | Unknown |  |
| is_staging | Unknown |  |
| name | Unknown |  |
| parent_id | Unknown |  |
| parent_name | Unknown |  |
| pick_zone | Unknown |  |
| reference_count | Unknown |  |

### customer_product_price

| Column | Type | Keys |
| --- | --- | --- |
| customer_id | Unknown | PK, FK |
| product_id | Unknown | PK, FK |
| price | Unknown |  |

### customer_contacts

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | PK, FK |
| comment | Unknown |  |
| defaults | Unknown |  |
| email | Unknown |  |
| fax | Unknown |  |
| include_in_email | Unknown |  |
| job_title | Unknown |  |
| mobile_phone | Unknown |  |
| name | Unknown |  |
| phone | Unknown |  |
| website | Unknown |  |

### customer_address

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | PK, FK |
| city | Unknown |  |
| country | Unknown |  |
| default_for_type | Unknown |  |
| line_1 | Unknown |  |
| line_2 | Unknown |  |
| post_code | Unknown |  |
| state | Unknown |  |
| type | Unknown |  |

### customer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| revenue_account | Unknown | FK |
| account_receivable | Unknown |  |
| additional_attribute_1 | Unknown |  |
| additional_attribute_10 | Unknown |  |
| additional_attribute_2 | Unknown |  |
| additional_attribute_3 | Unknown |  |
| additional_attribute_4 | Unknown |  |
| additional_attribute_5 | Unknown |  |
| additional_attribute_6 | Unknown |  |
| additional_attribute_7 | Unknown |  |
| additional_attribute_8 | Unknown |  |
| additional_attribute_9 | Unknown |  |
| attribute_set | Unknown |  |
| carrier | Unknown |  |
| comments | Unknown |  |
| credit_limit | Unknown |  |
| currency | Unknown |  |
| discount | Unknown |  |
| is_on_credit_hold | Unknown |  |
| last_modified_on | Unknown |  |
| location | Unknown |  |
| name | Unknown |  |
| payment_term | Unknown |  |
| price_tier | Unknown |  |
| sales_representative | Unknown |  |
| status | Unknown |  |
| tags | Unknown |  |
| tax_number | Unknown |  |
| tax_rule | Unknown |  |

## Relationships

- supplier_contacts(supplier_id) → supplier(id)
- supplier_address(supplier_id) → supplier(id)
- stock_transfer_line(product_id) → product(id)
- stock_transfer_line(stock_transfer_task_id) → stock_transfer(task_id)
- stock_transfer_line(stock_transfer_number) → stock_transfer(number)
- stock_transfer_order_line(product_id) → product(id)
- stock_transfer_order_line(location_id) → location(id)
- stock_transfer_order_line(stock_transfer_task_id) → stock_transfer(task_id)
- stock_transfer_order_line(stock_transfer_number) → stock_transfer(number)
- opportunity_line(product_id) → product(id)
- opportunity_line(opportunity_id) → opportunity(id)
- opportunity_additional_charge(opportunity_id) → opportunity(id)
- opportunity(lead_id) → lead(id)
- opportunity(customer_id) → customer(id)
- production_bom_resource(resource_id) → production_resource(id)
- production_bom_resource(product_family_production_bom_operation_id) → product_family_production_bom_operation(id)
- production_bom_resource(product_family_production_bom_id) → product_family_production_bom_operation(product_family_production_bom_id)
- production_bom_operation_link(product_family_production_bom_operation_id) → product_family_production_bom_operation(id)
- production_bom_operation_link(product_family_production_bom_id) → product_family_production_bom_operation(product_family_production_bom_id)
- production_bom_finished_product(product_id) → product(id)
- production_bom_finished_product(product_family_id) → product_family_production_bom(id)
- production_bom_finished_product(product_family_production_bom_operation_id) → product_family_production_bom_operation(id)
- production_bom_finished_product(product_family_production_bom_id) → product_family_production_bom_operation(product_family_production_bom_id)
- production_bom_variation_component(product_family_id) → product_family(id)
- production_bom_variation_component(product_family_production_bom_operation_id) → product_family_production_bom_operation(id)
- production_bom_variation_component(product_family_production_bom_id) → product_family_production_bom_operation(product_family_production_bom_id)
- product_family_production_bom_operation(work_center_id) → work_center(id)
- product_family_production_bom_operation(product_family_production_bom_id) → product_family_production_bom(id)
- product_family_production_bom(delivery_to_id) → location(id)
- journal_attachment(purchase_id) → journal(purchase_id)
- journal_attachment(journal_number) → journal(journal_number)
- journal_line(purchase_id) → journal(purchase_id)
- journal_line(journal_number) → journal(journal_number)
- product_availability(product_id) → product(id)
- product_family_attachment(object_id) → product_family(id)
- family_product(product_id) → product(id)
- family_product(product_family_id) → product_family(id)
- product_family(revenue_account) → chart_of_account(code)
- product_family(cogs_account) → chart_of_account(code)
- product_reorder_level(product_id) → product(id)
- bill_of_material_product(component_product_id) → product(id)
- bill_of_material_product(product_id) → product(id)
- bill_of_material_service(component_product_id) → product(id)
- bill_of_material_service(expense_account) → chart_of_account(code)
- bill_of_material_service(product_id) → product(id)
- product_movement(product_id) → product(id)
- product_attachment(product_id) → product(id)
- product_custom_price(product_id) → product(id)
- product_custom_price(customer_id) → customer(id)
- product(category_id) → product_category(id)
- product(revenue_account) → chart_of_account(code)
- product(expense_account) → chart_of_account(code)
- product(cogs_account) → chart_of_account(code)
- product(default_location) → location(id)
- product_markup_price(product_id) → product(id)
- factory_calendar_day(factory_calendar_year) → factory_calendar(year)
- factory_calendar_special_day(factory_calendar_year) → factory_calendar(year)
- lead_contact(lead_id) → lead(id)
- lead_address(lead_id) → lead(id)
- sale_quote_line(product_id) → product(id)
- sale_quote_line(sale_id) → sale(id)
- sale_quote_additional_charge(sale_id) → sale(id)
- sale_order_line(product_id) → product(id)
- sale_order_line(sale_id) → sale(id)
- sale_order_additional_charge(sale_id) → sale(id)
- sale_invoice_line(product_id) → product(id)
- sale_invoice_line(sale_id) → sale_invoice(sale_id)
- sale_invoice_line(sale_invoice_task_id) → sale_invoice(task_id)
- sale_invoice_additional_charge(sale_id) → sale_invoice(sale_id)
- sale_invoice_additional_charge(sale_invoice_task_id) → sale_invoice(task_id)
- sale_invoice(sale_id) → sale(id)
- sale_credit_note_line(product_id) → product(id)
- sale_credit_note_line(sale_id) → sale_credit_note(sale_id)
- sale_credit_note_line(sale_credit_note_task_id) → sale_credit_note(task_id)
- sale_credit_note_refund(sale_id) → sale_credit_note(sale_id)
- sale_credit_note_refund(sale_credit_note_task_id) → sale_credit_note(task_id)
- sale_credit_note_restock(product_id) → product(id)
- sale_credit_note_restock(sale_id) → sale_credit_note(sale_id)
- sale_credit_note_restock(sale_credit_note_task_id) → sale_credit_note(task_id)
- sale_credit_note_additional_charge(sale_id) → sale_credit_note(sale_id)
- sale_credit_note_additional_charge(sale_credit_note_task_id) → sale_credit_note(task_id)
- sale_credit_note(sale_id) → sale(id)
- sale_attachment(sale_id) → sale(id)
- sale_fullfillment_pick_line(product_id) → product(id)
- sale_fullfillment_pick_line(fulfillment_number) → sale_fullfillment(fulfillment_number)
- sale_fullfillment_pick_line(sale_id) → sale_fullfillment(sale_id)
- sale_fullfillment_pack_line(product_id) → product(id)
- sale_fullfillment_pack_line(fulfillment_number) → sale_fullfillment(fulfillment_number)
- sale_fullfillment_pack_line(sale_id) → sale_fullfillment(sale_id)
- sale_fullfillment_ship_line(fulfillment_number) → sale_fullfillment(fulfillment_number)
- sale_fullfillment_ship_line(sale_id) → sale_fullfillment(sale_id)
- sale_fullfillment(sale_id) → sale(id)
- sale_inventory_movement(product_id) → product(id)
- sale_inventory_movement(sale_id) → sale(id)
- sale_transaction(transaction_id) → transaction(id)
- sale_transaction(sale_id) → sale(id)
- sale(customer_id) → customer(id)
- transaction(task_id) → task(id)
- new_stock_line(product_id) → product(id)
- new_stock_line(stock_adjustment_id) → stock_adjustment(id)
- new_stock_line(stock_take_number) → stock_adjustment(stock_take_number)
- stock_adjustment_transaction(transaction_id) → transaction(id)
- stock_adjustment_transaction(stock_adjustment_id) → stock_adjustment(id)
- stock_adjustment_transaction(stock_take_number) → stock_adjustment(stock_take_number)
- stock_adjustment(stock_take_number) → stock_take(stock_take_number)
- product_production_bom_resource(resource_id) → production_resource(id)
- product_production_bom_resource(product_production_bom_operation_id) → product_production_bom_operation(id)
- product_production_bom_resource(product_production_bom_id) → product_production_bom_operation(product_production_bom_id)
- product_production_bom_component(product_id) → product(id)
- product_production_bom_component(product_production_bom_operation_id) → product_production_bom_operation(id)
- product_production_bom_component(product_production_bom_id) → product_production_bom_operation(product_production_bom_id)
- product_production_bom_note(product_production_bom_operation_id) → product_production_bom_operation(id)
- product_production_bom_note(product_production_bom_id) → product_production_bom_operation(product_production_bom_id)
- product_production_bom_output_product(product_id) → product(id)
- product_production_bom_output_product(product_production_bom_operation_id) → product_production_bom_operation(id)
- product_production_bom_output_product(product_production_bom_id) → product_production_bom_operation(product_production_bom_id)
- product_production_bom_operation(work_center_id) → work_center(id)
- product_production_bom_operation(product_production_bom_id) → product_production_bom(id)
- product_production_bom(delivery_to_id) → location(id)
- production_order_source_task(production_order_id) → production_order(id)
- production_order(product_id) → product(id)
- production_order(location_id) → location(id)
- work_center_location(location_id) → location(id)
- work_center_location(work_center_id) → work_center(id)
- non_zero_stock_on_hand_product(product_id) → product(id)
- non_zero_stock_on_hand_product(stock_take_task_id) → stock_take(task_id)
- non_zero_stock_on_hand_product(stock_take_number) → stock_take(stock_take_number)
- zero_stock_on_hand_product(product_id) → product(id)
- zero_stock_on_hand_product(location_id) → location(id)
- zero_stock_on_hand_product(stock_take_task_id) → stock_take(task_id)
- zero_stock_on_hand_product(stock_take_number) → stock_take(stock_take_number)
- stock_take_transaction(transaction_id) → transaction(id)
- stock_take_transaction(stock_take_task_id) → stock_take(task_id)
- stock_take_transaction(stock_take_number) → stock_take(stock_take_number)
- suspend_reason_workcenter(suspend_reason_suspend_reason_id) → suspend_reason(suspend_reason_id)
- suspend_reason_workcenter(workcenter_id) → work_center(id)
- production_run_operation_component(product_id) → product(id)
- production_run_operation_component(location_id) → location(id)
- production_run_operation_component(production_run_operation_id) → production_run_operation(id)
- production_run_operation_component(production_run_id) → production_run_operation(production_run_id)
- production_run_resource(production_run_operation_id) → production_run_operation(id)
- production_run_resource(production_run_id) → production_run_operation(production_run_id)
- production_run_resource(resource_id) → production_resource(id)
- production_run_operation(production_run_id) → production_run(id)
- production_run_operation(work_center_id) → work_center(id)
- production_run_traceability(produced_product_id) → product(id)
- production_run_traceability(used_product_id) → product(id)
- production_run_traceability(production_run_id) → production_run(id)
- production_run(production_order_id) → production_order(id)
- purchase_inventory_movement(product_id) → product(id)
- purchase_inventory_movement(purchase_id) → purchase(id)
- purchase_credit_note_line(product_id) → product(id)
- purchase_credit_note_line(purchase_id) → purchase_credit_note(purchase_id)
- purchase_credit_note_line(purchase_credit_not_task_id) → purchase_credit_note(task_id)
- purchase_credit_note_refund(purchase_id) → purchase_credit_note(purchase_id)
- purchase_credit_note_refund(purchase_credit_not_task_id) → purchase_credit_note(task_id)
- purchase_credit_note_unstock(product_id) → product(id)
- purchase_credit_note_unstock(purchase_id) → purchase_credit_note(purchase_id)
- purchase_credit_note_unstock(purchase_credit_not_task_id) → purchase_credit_note(task_id)
- purchase_credit_note(purchase_id) → purchase(id)
- purchase_invoice_line(product_id) → product(id)
- purchase_invoice_line(purchase_id) → purchase_invoice(purchase_id)
- purchase_invoice_line(purchase_invoice_task_id) → purchase_invoice(task_id)
- purchase_invoice_payment(purchase_id) → purchase_invoice(purchase_id)
- purchase_invoice_payment(purchase_invoice_task_id) → purchase_invoice(task_id)
- purchase_invoice_additional_charge(purchase_id) → purchase_invoice(purchase_id)
- purchase_invoice_additional_charge(purchase_invoice_task_id) → purchase_invoice(task_id)
- purchase_invoice(purchase_id) → purchase(id)
- put_away_line(product_id) → product(id)
- put_away_line(purchase_id) → put_away(purchase_id)
- put_away_line(object_task_id) → put_away(task_id)
- put_away(purchase_id) → purchase(id)
- stock_received_line(product_id) → product(id)
- stock_received_line(purchase_id) → stock_received(purchase_id)
- stock_received_line(object_task_id) → stock_received(task_id)
- stock_received(purchase_id) → purchase(id)
- purchase_order_line(product_id) → product(id)
- purchase_order_line(purchase_id) → purchase(id)
- purchase(supplier_id) → supplier(id)
- purchase(related_drop_ship_sale_task) → task(id)
- location_bin(location_id) → location(id)
- customer_product_price(product_id) → product(id)
- customer_product_price(customer_id) → customer(id)
- customer_contacts(customer_id) → customer(id)
- customer_address(customer_id) → customer(id)
- customer(revenue_account) → chart_of_account(code)