Cin7 Core

Explore the interactive ERD

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	PKFK
`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	PKFK
`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	PKFK
`stock_transfer_number`	Unknown	PKFK
`stock_transfer_task_id`	Unknown	PKFK
`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	PKFK
`stock_transfer_number`	Unknown	PKFK
`stock_transfer_task_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`product_family_production_bom_operation_id`	Unknown	PKFK
`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	PKFK
`product_family_production_bom_operation_id`	Unknown	PKFK
`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	PKFK
`product_family_production_bom_operation_id`	Unknown	PKFK
`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	PKFK
`product_family_production_bom_operation_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`purchase_id`	Unknown	PKFK
`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	PKFK
`content_type`	Unknown
`file_name`	Unknown
`is_default`	Unknown
`type`	Unknown

family_product

Column	Type	Keys
`product_family_id`	Unknown	PKFK
`product_id`	Unknown	PKFK

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	PKFK
`minimum_before_reorder`	Unknown
`pick_zones`	Unknown
`reorder_quantity`	Unknown
`stock_locator`	Unknown

bill_of_material_product

Column	Type	Keys
`component_product_id`	Unknown	PKFK
`product_id`	Unknown	PKFK
`cost_percentage`	Unknown
`name`	Unknown
`product_code`	Unknown
`quantity`	Unknown
`wastage_quantity`	Unknown

bill_of_material_service

Column	Type	Keys
`component_product_id`	Unknown	PKFK
`product_id`	Unknown	PKFK
`expense_account`	Unknown	FK
`name`	Unknown
`price_tier`	Unknown
`quantity`	Unknown

product_movement

Column	Type	Keys
`index`	Unknown	PK
`product_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`sale_invoice_task_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`sale_id`	Unknown	PKFK
`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	PKFK
`sale_id`	Unknown	PKFK
`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	PKFK
`sale_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`content_type`	Unknown
`download_url`	Unknown
`file_name`	Unknown

sale_fullfillment_pick_line

Column	Type	Keys
`index`	Unknown	PK
`fulfillment_number`	Unknown	PKFK
`sale_id`	Unknown	PKFK
`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	PKFK
`sale_id`	Unknown	PKFK
`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	PKFK
`sale_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`transaction_id`	Unknown	PKFK
`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	PKFK
`stock_adjustment_id`	Unknown	PKFK
`stock_take_number`	Unknown	PKFK
`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	PKFK
`stock_take_number`	Unknown	PKFK
`transaction_id`	Unknown	PKFK

stock_adjustment

Column	Type	Keys
`id`	Unknown	PK
`stock_take_number`	Unknown	PKFK
`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	PKFK
`product_production_bom_operation_id`	Unknown	PKFK
`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	PKFK
`product_production_bom_operation_id`	Unknown	PKFK
`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	PKFK
`product_production_bom_operation_id`	Unknown	PKFK
`note`	Unknown
`operation_id`	Unknown
`position`	Unknown

product_production_bom_output_product

Column	Type	Keys
`id`	Unknown	PK
`product_production_bom_id`	Unknown	PKFK
`product_production_bom_operation_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`stock_take_number`	Unknown	PKFK
`stock_take_task_id`	Unknown	PKFK
`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	PKFK
`stock_take_number`	Unknown	PKFK
`stock_take_task_id`	Unknown	PKFK
`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	PKFK
`stock_take_task_id`	Unknown	PKFK
`transaction_id`	Unknown	PKFK

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	PKFK
`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	PKFK
`production_run_operation_id`	Unknown	PKFK
`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	PKFK
`production_run_operation_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`purchase_id`	Unknown	PKFK
`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	PKFK
`purchase_id`	Unknown	PKFK
`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	PKFK
`purchase_id`	Unknown	PKFK
`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	PKFK
`purchase_credit_not_task_id`	Unknown	PKFK
`purchase_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`purchase_invoice_task_id`	Unknown	PKFK
`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	PKFK
`purchase_invoice_task_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`purchase_id`	Unknown	PKFK
`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	PKFK
`invoicing_and_receiving_number`	Unknown
`status`	Unknown
`type`	Unknown

stock_received_line

Column	Type	Keys
`index`	Unknown	PK
`object_task_id`	Unknown	PKFK
`purchase_id`	Unknown	PKFK
`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	PKFK
`invoicing_and_receiving_number`	Unknown
`status`	Unknown
`type`	Unknown

purchase_order_line

Column	Type	Keys
`index`	Unknown	PK
`purchase_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`product_id`	Unknown	PKFK
`price`	Unknown

customer_contacts

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	PKFK
`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	PKFK
`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