Cin7

Explore the interactive ERD

Table & Field Reference

quote_line_item

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

quote

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

payment

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

secondary_contact

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

contact

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

stock

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

branch_transfer_line_item_size

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

branch_transfer_line_item

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

branch_transfer

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

serial_number

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

sales_order_line_item

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

sales_order

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

product_image

Column	Type	Keys
`_fivetran_id`	String	PK
`product_id`	Unknown	FK
`link`	String

product_category_ids

Column	Type	Keys
`category_id`	Unknown	PK
`product_id`	Unknown	PKFK

product_option

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

product

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

branch_location_bin

Column	Type	Keys
`index`	Unknown	PK
`branch_id`	Unknown	PKFK
`branch_location_zone`	String	PKFK
`bin`	Unknown

branch_location

Column	Type	Keys
`zone`	String	PK
`branch_id`	Unknown	PKFK

branch

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

production_job

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

adjustment_line_item

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

adjustment

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

purchase_order_line_item

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

purchase_order

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

product_category

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

credit_note_line_item

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

credit_note

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

bom_master_component

Column	Type	Keys
`id`	Unknown	PK
`bom_master_id`	Unknown	PKFK
`product_id`	Unknown	FK
`product_option_id`	Unknown	FK
`code`	Unknown
`quantity`	Unknown
`sort`	Unknown
`unit_cost`	Unknown

bom_master

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

voucher

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

users

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