Unleashed schema and ERD

63 tables

Loading diagram…

assembly

attribute_set

bill_of_materials

credit_note

customer

customer_delivery_address

product

purchase_order

sales_invoice

sales_order

sales_quote

sales_shipment

stock_adjustment

stock_count

supplier

supplier_return

warehouse_stock_transfer

account

account_code

string

account_name

string

account_type

string

_weld_synced

date

assembly

guid

string

assembly_number

string

assembly_status

string

assembly_type

string

custom_assembly_status

string

auto_assembly

boolean

actual_duration

string

expected_duration

string

assembly_line

assembly_guid

string

guid

string

quantity

double

unit_cost

double

total_cost

double

disassemble_cost

double

wastage_quantity

double

sub_assembly_guid

string

assembly_status

name

string

is_custom_status

boolean

obsolete

boolean

last_modified_on

date

_weld_synced

date

attribute_set

guid

string

set_name

string

type

string

created_by

string

created_on

date

last_modified_by

string

last_modified_on

date

_weld_synced

date

attribute_set_attribute

attribute_set_guid

string

guid

string

name

string

value

string

is_required

boolean

_weld_synced

date

batch_number

guid

string

number

string

expiry_date

date

quantity

double

original_qty

double

product_code

string

warehouse_code

string

status

string

bill_of_materials

guid

string

bill_number

string

average_duration

string

expected_duration

string

duration_type

string

auto_assign_oldest_batch_serial

boolean

can_auto_assemble

boolean

can_auto_disassemble

boolean

bill_of_materials_line

bill_of_materials_guid

string

guid

string

line_number

long

quantity

double

unit_cost

double

line_total_cost

double

wastage_quantity

double

product_guid

string

company

guid

string

company_name

string

base_currency_code

string

default_tax_rate

double

_weld_synced

date

credit_note

guid

string

credit_note_number

string

credit_type

string

invoice_number

string

reference

string

status

string

comments

string

bc_sub_total

double

credit_note_line

credit_note_guid

string

guid

string

line_number

long

line_type

string

credit_price

double

credit_quantity

double

order_quantity

double

line_tax

double

currency

guid

string

currency_code

string

description

string

default_buy_rate

double

default_sell_rate

double

last_modified_on

date

_weld_synced

date

customer

guid

string

customer_code

string

customer_name

string

customer_type

string

customer_type_guid

string

gstvat_number

string

eori_number

string

bank_name

string

customer_address

customer_guid

string

guid

string

address_type

string

address_name

string

street_address

string

street_address_2

string

suburb

string

city

string

customer_contact

customer_guid

string

guid

string

first_name

string

last_name

string

email_address

string

phone_number

string

mobile_phone

string

office_phone

string

customer_delivery_address

customer_id

long

customer_code

string

address_ids

string

_weld_synced

date

customer_delivery_address_detail

customer_code

string

guid

string

address_type

string

address_name

string

street_address

string

street_address_2

string

suburb

string

city

string

customer_type

guid

string

type_name

string

last_modified_on

date

_weld_synced

date

delivery_method

guid

string

name

string

obsolete

boolean

last_modified_on

date

_weld_synced

date

payment_term

guid

string

type

string

days

int

obsolete

boolean

payment_term_description

string

_weld_synced

date

product

108

guid

string

product_code

string

product_description

string

barcode

string

source_id

string

source_variant_parent_id

string

commerce_code

string

customs_description

string

product_alternate_unit_of_measure

product_guid

string

guid

string

name

string

conversion_rate

double

for_purchases

boolean

barcode

string

pack_size

double

weight

double

product_image

product_guid

string

url

string

is_default

boolean

_weld_synced

date

product_inventory_detail

product_guid

string

index

int

bin_location

string

warehouse_min_stock_alert_level

double

warehouse_max_stock_alert_level

double

warehouse_guid

string

warehouse_warehouse_code

string

warehouse_warehouse_name

string

_weld_synced

date

product_attribute

product_guid

string

guid

string

name

string

value

string

is_required

boolean

_weld_synced

date

product_brand

guid

string

brand_name

string

last_modified_on

date

_weld_synced

date

product_group

guid

string

group_name

string

parent_group_guid

string

last_modified_on

date

_weld_synced

date

product_price

guid

string

price_type

string

discount_value

double

minimum_quantity

double

default_sell_price

double

customer_price

double

valid_from

date

valid_to

date

purchase_order

guid

string

order_number

string

order_status

string

custom_order_status

string

comments

string

supplier_ref

string

supplier_eori

string

tax_code

string

purchase_order_line

purchase_order_guid

string

guid

string

line_number

long

order_quantity

double

receipt_quantity

double

purchase_unit_order_quantity

double

purchase_unit_receipt_quantity

double

unit_price

double

recost_adjustment

purchase_order_guid

string

purchase_order_number

string

supplier_code

string

tax_code

string

currency

string

entry_date

date

completed_date

date

total

double

_weld_synced

date

sales_invoice

guid

string

invoice_number

string

order_number

string

quote_number

string

invoice_status

string

comments

string

delivery_instruction

string

payment_term

string

sales_invoice_line

sales_invoice_guid

string

guid

string

line_number

long

line_type

string

order_quantity

double

invoice_quantity

double

unit_price

double

discount_rate

double

sales_order

guid

string

order_number

string

order_status

string

custom_order_status

string

customer_ref

string

comments

string

source_id

string

sales_order_group

string

sales_order_line

sales_order_guid

string

guid

string

line_number

long

line_type

string

order_quantity

double

unit_price

double

unit_cost

double

discount_rate

double

sales_order_group

guid

string

name

string

obsolete

boolean

last_modified_on

date

_weld_synced

date

sales_order_status

name

string

is_custom_status

boolean

obsolete

boolean

last_modified_on

date

_weld_synced

date

sales_quote

guid

string

quote_number

string

quote_status

string

customer_ref

string

comments

string

source_id

string

sales_order_group

string

delivery_method

string

sales_quote_line

sales_quote_guid

string

guid

string

line_number

long

line_type

string

quote_quantity

double

unit_price

double

unit_cost

double

discount_rate

double

sales_quote_sales_order

sales_quote_guid

string

guid

string

order_number

string

_weld_synced

date

sales_shipment

guid

string

shipment_number

string

shipment_status

string

shipment_status_enum

long

order_number

string

order_guid

string

customer_ref

string

comments

string

sales_shipment_line

sales_order_line_id

long

sales_shipment_guid

string

guid

string

line_number

long

sales_order_line_number

long

shipment_qty

double

unit_cost

double

unit_cost_at_time_of_dispatch

double

commercial_monetary_value

double

salesperson

guid

string

full_name

string

obsolete

boolean

last_modified_on

date

_weld_synced

date

sell_price_tier

tier

int

name

string

_weld_synced

date

serial_number

guid

string

identifier

string

product_code

string

warehouse_code

string

status

string

created_by

string

created_on

date

last_modified_by

string

last_modified_on

date

_weld_synced

date

shipping_company

guid

string

name

string

obsolete

boolean

created_by

string

last_modified_on

date

_weld_synced

date

stock_adjustment

guid

string

adjustment_number

string

adjustment_reason

string

account_code

string

status

string

confirmed_by

string

confirmed_on

date

adjustment_date

date

stock_adjustment_line

stock_adjustment_guid

string

guid

string

line_number

long

comments

string

new_actual_value

double

new_quantity

double

last_modified_on

date

product_guid

string

stock_count

guid

string

stock_take_code

string

stock_take_name

string

count_type

string

status

string

description

string

cost_of_goods_account

string

count_date

date

stock_count_line

stock_count_guid

string

guid

string

line_number

long

available_quantity

double

count_quantity

double

on_hand_quantity

double

average_land_price_at_time_of_stock_take

double

expiry_date

date

stock_on_hand

warehouse_id

string

guid

string

product_guid

string

product_code

string

product_description

string

product_source_id

string

product_group_name

string

warehouse

string

warehouse_code

string

supplier

guid

string

supplier_code

string

supplier_name

string

gstvat_number

string

bank_name

string

bank_branch

string

bank_account

string

website

string

supplier_address

supplier_guid

string

index

int

address_type

string

address_name

string

street_address

string

street_address_2

string

suburb

string

city

string

region

string

country

string

postal_code

string

_weld_synced

date

supplier_return

guid

string

supplier_return_number

string

status

string

comments

string

supplier_ref

string

xero_tax_code

string

exchange_rate

double

sub_total

double

supplier_return_line

supplier_return_guid

string

guid

string

line_number

long

comments

string

order_price

double

order_quantity

double

return_cost

double

return_price

double

supplier_return_cost

supplier_return_guid

string

guid

string

cost

double

tax_cost

double

total_cost

double

tax_code

string

tax_rate

double

exchange_rate

double

supplier_return_reason

reason

string

_weld_synced

date

tax

guid

string

tax_code

string

description

string

tax_rate

double

can_apply_to_expenses

boolean

can_apply_to_revenue

boolean

is_purchase_default

boolean

is_sales_default

boolean

obsolete

boolean

last_modified_on

date

_weld_synced

date

unit_of_measure

guid

string

name

string

obsolete

boolean

_weld_synced

date

warehouse

guid

string

warehouse_code

string

warehouse_name

string

is_default

boolean

street_no

string

address_line_1

string

address_line_2

string

city

string

warehouse_stock_transfer

guid

string

transfer_order_number

string

transfer_status

string

comments

string

order_date

date

delivery_date

date

source_warehouse_guid

string

source_warehouse_warehouse_code

string

warehouse_stock_transfer_detail

warehouse_stock_transfer_guid

string

guid

string

line_number

long

comments

string

available_quantity

double

transfer_quantity

double

average_landed_price_at_time_of_transfer

double

destinate_warehouse_stock_on_hand_before_transfer

double