ERD for Unleashed

Loading diagram…

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

-duration_comments

string

-comments

string

-sales_order_number

string

-quantity

double

-can_assemble_quantity

double

-supplier_costs_sub_total

double

-supplier_costs_tax

double

-disassemble_cost_total

double

-total

double

-total_cost

double

-assemble_by

date

-assembly_date

date

-estimated_start_date

date

-product_guid

string

-product_product_code

string

-product_product_description

string

-production_person_guid

string

-production_person_full_name

string

-production_person_email

string

-source_warehouse_guid

string

-source_warehouse_warehouse_code

string

-source_warehouse_warehouse_name

string

-destination_warehouse_guid

string

-destination_warehouse_warehouse_code

string

-destination_warehouse_warehouse_name

string

-batch_numbers

string

-serial_numbers

string

-supplier_costs

string

-created_by

string

-created_on

date

-last_modified_by

string

-last_modified_on

date

-_weld_synced

date

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

-last_modified_on

date

-product_guid

string

-product_product_code

string

-product_product_description

string

-batch_numbers

string

-serial_numbers

string

-_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

bill_of_materials

-guid

string

-bill_number

string

-average_duration

string

-expected_duration

string

-duration_type

string

-can_auto_assemble

boolean

-can_auto_disassemble

boolean

-obsolete

boolean

-sort_by_product_code

boolean

-production_days_per_week

string

-production_hours_per_day

long

-last_modified_on

date

-product_guid

string

-product_product_code

string

-product_product_description

string

-_weld_synced

date

bill_of_materials_line

-bill_of_materials_guid

string

-guid

string

-line_number

long

-quantity

double

-total_cost

double

-total_line_cost

double

-wastage_quantity

double

-product_guid

string

-product_product_code

string

-product_product_description

string

-created_by

string

-created_on

date

-last_modified_by

string

-last_modified_on

date

-_weld_synced

date

credit_note

-guid

string

-credit_number

string

-credit_type

string

-invoice_number

string

-reference

string

-status

string

-comments

string

-bc_sub_total

double

-bc_total

double

-sub_total

double

-tax_rate

double

-tax_total

double

-total

double

-credit_date

date

-required_delivery_date

date

-sales_invoice_date

date

-customer_guid

string

-customer_customer_code

string

-customer_customer_name

string

-currency_guid

string

-currency_currency_code

string

-currency_description

string

-sales_order_guid

string

-sales_order_order_number

string

-tax_guid

string

-tax_tax_code

string

-tax_tax_rate

double

-tax_description

string

-warehouse_guid

string

-warehouse_warehouse_code

string

-warehouse_warehouse_name

string

-created_by

string

-created_on

date

-last_modified_by

string

-last_modified_on

date

-_weld_synced

date

credit_note_line

-credit_note_guid

string

-line_number

long

-line_type

string

-credit_price

double

-credit_quantity

double

-order_quantity

double

-line_tax

double

-line_tax_code

string

-line_total

double

-bc_line_tax

double

-bc_line_total

double

-average_landed_price_at_time_of_sale

double

-tax_rate

double

-comments

string

-cost_of_goods_account

string

-reason

string

-disassemble

boolean

-return_to_stock

boolean

-xero_sales_account

string

-xero_tax_code

string

-last_modified_on

date

-product_guid

string

-product_product_code

string

-product_product_description

string

-batch_numbers

string

-serial_numbers

string

-pending_batch_numbers

string

-pending_serial_numbers

string

-_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

-bank_branch

string

-bank_account

string

-email

string

-email_cc

string

-website

string

-phone_number

string

-fax_number

string

-mobile_number

string

-ddi_number

string

-toll_free_number

string

-contact_first_name

string

-contact_last_name

string

-notes

string

-reminder

string

-tax_code

string

-tax_rate

double

-taxable

boolean

-discount_rate

double

-credit_limit

double

-has_credit_limit

boolean

-stop_credit

boolean

-print_invoice

boolean

-print_packing_slip_instead_of_invoice

boolean

-obsolete

boolean

-xero_sales_account

string

-xero_cost_of_goods_account

string

-sell_price_tier

string

-payment_term

string

-delivery_instruction

string

-delivery_method

string

-sales_order_group

string

-currency_currency_code

string

-currency_description

string

-currency_guid

string

-default_warehouse_guid

string

-default_warehouse_warehouse_code

string

-default_warehouse_warehouse_name

string

-salesperson_guid

string

-salesperson_full_name

string

-salesperson_email

string

-created_by

string

-created_on

date

-last_modified_by

string

-last_modified_on

date

-_weld_synced

date

customer_address

-customer_guid

string

-guid

string

-address_type

string

-address_name

string

-street_address

string

-street_address_2

string

-suburb

string

-city

string

-region

string

-country

string

-postal_code

string

-is_default

boolean

-delivery_instruction

string

-last_modified_on

date

-_weld_synced

date

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

-ddi_number

string

-fax_number

string

-toll_free_number

string

-website

string

-delivery_address

string

-notes

string

-is_default

boolean

-for_invoicing

boolean

-for_ordering

boolean

-for_shipping

boolean

-_weld_synced

date

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

-region

string

-country

string

-postal_code

string

-obsolete

boolean

-delivery_instruction

string

-last_modified_on

date

-_weld_synced

date

product

-guid

string

-product_code

string

-product_description

string

-barcode

string

-source_id

string

-source_variant_parent_id

string

-commerce_code

string

-customs_description

string

-supplementary_classification_abbreviation

string

-icc_country_code

string

-icc_country_name

string

-pack_size

double

-width

double

-height

double

-depth

double

-weight

double

-min_stock_alert_level

double

-max_stock_alert_level

double

-last_cost

double

-default_purchase_price

double

-default_sell_price

double

-customer_sell_price

double

-average_land_price

double

-nominal_cost

double

-automatic_charge_cost

double

-minimum_sell_price

double

-minimum_sale_quantity

double

-minimum_order_quantity

double

-never_diminishing

boolean

-obsolete

boolean

-is_component

boolean

-is_assembled_product

boolean

-is_serialized

boolean

-is_batch_tracked

boolean

-is_purchasable

boolean

-is_sellable

boolean

-copy_comments_for_sales

boolean

-copy_comments_for_purchases

boolean

-notes

string

-reminder

string

-comments

string

-image_url

string

-bin_location

string

-purchase_account

string

-taxable_purchase

boolean

-taxable_sales

boolean

-xero_tax_code

string

-xero_tax_rate

double

-xero_sales_tax_code

string

-xero_sales_tax_rate

double

-xero_sales_account

string

-xero_cost_of_goods_account

string

-unit_of_measure_guid

string

-unit_of_measure_name

string

-unit_of_measure_obsolete

boolean

-default_purchases_unit_of_measure_guid

string

-default_purchases_unit_of_measure_name

string

-default_purchases_unit_of_measure_obsolete

boolean

-sell_price_tier1_name

string

-sell_price_tier1_value

double

-sell_price_tier2_name

string

-sell_price_tier2_value

double

-sell_price_tier3_name

string

-sell_price_tier3_value

double

-sell_price_tier4_name

string

-sell_price_tier4_value

double

-sell_price_tier5_name

string

-sell_price_tier5_value

double

-sell_price_tier6_name

string

-sell_price_tier6_value

double

-sell_price_tier7_name

string

-sell_price_tier7_value

double

-sell_price_tier8_name

string

-sell_price_tier8_value

double

-sell_price_tier9_name

string

-sell_price_tier9_value

double

-sell_price_tier10_name

string

-sell_price_tier10_value

double

-product_group_guid

string

-product_group_group_name

string

-product_group_parent_group_guid

string

-product_group_last_modified_on

date

-product_sub_group_guid

string

-product_sub_group_group_name

string

-product_sub_group_parent_group_guid

string

-product_sub_group_last_modified_on

date

-product_brand_guid

string

-product_brand_brand_name

string

-product_brand_last_modified_on

date

-supplier_guid

string

-supplier_supplier_code

string

-supplier_supplier_name

string

-supplier_supplier_product_code

string

-supplier_supplier_product_description

string

-supplier_supplier_product_price

double

-supplier_minimum_order_quantity

double

-supplier_lead_time_days

int

-supplier_unit_of_measure_guid

string

-supplier_unit_of_measure_name

string

-supplier_unit_of_measure_obsolete

boolean

-created_by

string

-created_on

date

-last_modified_by

string

-last_modified_on

date

-_weld_synced

date

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

-width

double

-height

double

-depth

double

-cubic_total

double

-_weld_synced

date

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

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

-printed

boolean

-discount_rate

double

-exchange_rate

double

-tax_rate

double

-sub_total

double

-tax_total

double

-total

double

-total_volume

double

-total_weight

double

-bc_sub_total

double

-bc_tax_total

double

-bc_total

double

-delivery_name

string

-delivery_street_address

string

-delivery_street_address2

string

-delivery_suburb

string

-delivery_city

string

-delivery_region

string

-delivery_country

string

-delivery_post_code

string

-order_date

date

-completed_date

date

-delivery_date

date

-received_date

date

-supplier_invoice_date

date

-currency_guid

string

-currency_currency_code

string

-currency_description

string

-supplier_guid

string

-supplier_supplier_code

string

-supplier_supplier_name

string

-tax_guid

string

-tax_tax_code

string

-tax_tax_rate

double

-warehouse_guid

string

-warehouse_warehouse_code

string

-warehouse_warehouse_name

string

-sales_orders

string

-created_by

string

-created_on

date

-last_modified_by

string

-last_modified_on

date

-_weld_synced

date

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

-discounted_unit_price

double

-discount_rate

double

-line_tax

double

-line_tax_code

string

-line_tax_rate

double

-line_total

double

-bc_cost_total

double

-bc_landed_cost

double

-bc_sub_total

double

-bc_unit_price

double

-volume

double

-weight

double

-comments

string

-delivery_date

date

-product_guid

string

-product_product_code

string

-product_product_description

string

-product_supplier_product_code

string

-product_supplier_product_description

string

-unit_of_measure_guid

string

-unit_of_measure_name

string

-batch_numbers

string

-serial_numbers

string

-pending_batch_numbers

string

-pending_serial_numbers

string

-created_by

string

-created_on

date

-last_modified_by

string

-last_modified_on

date

-_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

-payment_received

boolean

-exchange_rate

double

-sub_total

double

-tax_total

double

-total

double

-bc_sub_total

double

-bc_tax_total

double

-bc_total

double

-invoice_date

date

-due_date

date

-currency_guid

string

-currency_currency_code

string

-currency_description

string

-customer_guid

string

-customer_customer_code

string

-customer_customer_name

string

-customer_currency_id

long

-delivery_address_address_type

string

-delivery_address_address_name

string

-delivery_address_street_address

string

-delivery_address_street_address_2

string

-delivery_address_suburb

string

-delivery_address_city

string

-delivery_address_region

string

-delivery_address_country

string

-delivery_address_postal_code

string

-postal_address_address_type

string

-postal_address_address_name

string

-postal_address_street_address

string

-postal_address_street_address_2

string

-postal_address_suburb

string

-postal_address_city

string

-postal_address_region

string

-postal_address_country

string

-postal_address_postal_code

string

-created_by

string

-created_on

date

-last_modified_by

string

-last_modified_on

date

-_weld_synced

date

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

-line_total

double

-tax_rate

double

-line_tax

double

-bc_unit_price

double

-comments

string

-last_modified_on

date

-product_guid

string

-product_product_code

string

-product_product_description

string

-batch_numbers

string

-serial_numbers

string

-_weld_synced

date

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_account

string

-xero_tax_code

string

-discount_rate

double

-exchange_rate

double

-sub_total

double

-tax_rate

double

-tax_total

double

-total

double

-total_volume

double

-total_weight

double

-bc_sub_total

double

-bc_tax_total

double

-bc_total

double

-delivery_method

string

-delivery_instruction

string

-delivery_name

string

-delivery_street_address

string

-delivery_street_address2

string

-delivery_suburb

string

-delivery_city

string

-delivery_region

string

-delivery_country

string

-delivery_post_code

string

-order_date

date

-completed_date

date

-payment_due_date

date

-received_date

date

-required_date

date

-currency_guid

string

-currency_currency_code

string

-currency_description

string

-customer_guid

string

-customer_customer_code

string

-customer_customer_name

string

-delivery_contact_guid

string

-delivery_contact_first_name

string

-delivery_contact_last_name

string

-delivery_contact_email_address

string

-delivery_contact_mobile_phone

string

-delivery_contact_office_phone

string

-delivery_contact_phone_number

string

-salesperson_guid

string

-salesperson_full_name

string

-salesperson_email

string

-tax_guid

string

-tax_tax_code

string

-tax_tax_rate

double

-warehouse_guid

string

-warehouse_warehouse_code

string

-warehouse_warehouse_name

string

-created_by

string

-created_on

date

-last_modified_by

string

-last_modified_on

date

-_weld_synced

date

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

-line_tax

double

-line_tax_code

string

-line_total

double

-tax_rate

double

-bc_line_tax

double

-bc_line_total

double

-bc_unit_price

double

-volume

double

-weight

double

-comments

string

-cost_of_goods_account

string

-xero_sales_account

string

-xero_tax_code

string

-last_modified_on

date

-product_guid

string

-product_product_code

string

-product_product_description

string

-assembly_guid

string

-assembly_assembly_number

string

-assembly_assembly_status

string

-batch_numbers

string

-serial_numbers

string

-_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

-xero_tax_code

string

-discount_rate

double

-exchange_rate

double

-tax_rate

double

-sub_total

double

-tax_total

double

-total

double

-total_volume

double

-total_weight

double

-bc_sub_total

double

-bc_tax_total

double

-bc_total

double

-delivery_name

string

-delivery_street_address

string

-delivery_street_address_2

string

-delivery_suburb

string

-delivery_city

string

-delivery_region

string

-delivery_country

string

-delivery_post_code

string

-quote_date

date

-quote_expiry_date

date

-accepted_date

date

-customer_guid

string

-customer_customer_code

string

-customer_customer_name

string

-customer_currency_id

long

-warehouse_guid

string

-warehouse_warehouse_code

string

-warehouse_warehouse_name

string

-warehouse_is_default

boolean

-currency_guid

string

-currency_currency_code

string

-currency_description

string

-tax_guid

string

-tax_tax_code

string

-tax_tax_rate

double

-salesperson_guid

string

-salesperson_full_name

string

-salesperson_email

string

-created_by

string

-created_on

date

-last_modified_by

string

-last_modified_on

date

-_weld_synced

date

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

-line_total

double

-line_tax

double

-line_tax_code

string

-tax_rate

double

-bc_unit_price

double

-bc_line_total

double

-bc_line_tax

double

-volume

double

-weight

double

-comments

string

-xero_sales_account

string

-xero_tax_code

string

-last_modified_on

date

-product_guid

string

-product_product_code

string

-product_product_description

string

-_weld_synced

date

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

-order_number

string

-order_guid

string

-customer_ref

string

-comments

string

-incoterm

string

-nature_of_transaction_code

string

-number_of_packages

long

-receiver_eori

string

-shipper_eori

string

-shipment_weight

string

-total_commercial_value

double

-tracking_number

string

-delivery_name

string

-delivery_street_address

string

-delivery_street_address2

string

-delivery_suburb

string

-delivery_city

string

-delivery_region

string

-delivery_country

string

-delivery_post_code

string

-delivery_instruction

string

-dispatch_date

date

-customer_guid

string

-customer_customer_code

string

-customer_customer_name

string

-delivery_contact_guid

string

-delivery_contact_first_name

string

-delivery_contact_last_name

string

-delivery_contact_email_address

string

-delivery_contact_mobile_phone

string

-delivery_contact_office_phone

string

-delivery_contact_phone_number

string

-shipping_company_guid

string

-shipping_company_name

string

-warehouse_guid

string

-warehouse_warehouse_code

string

-warehouse_warehouse_name

string

-created_by

string

-created_on

date

-last_modified_by

string

-last_modified_on

date

-_weld_synced

date

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

-product_guid

string

-product_product_code

string

-product_product_description

string

-batch_numbers

string

-serial_numbers

string

-created_by

string

-created_on

date

-last_modified_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

-warehouse_guid

string

-warehouse_warehouse_code

string

-warehouse_warehouse_name

string

-created_by

string

-created_on

date

-last_modified_by

string

-last_modified_on

date

-_weld_synced

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

-product_product_code

string

-product_description

string

-batch_numbers

string

-serial_numbers

string

-_weld_synced

date

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

-completed_date

date

-last_modified_on

date

-warehouse_guid

string

-warehouse_warehouse_code

string

-warehouse_warehouse_name

string

-_weld_synced

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

-receipt_fifo_date

date

-last_modified_on

date

-product_guid

string

-product_product_code

string

-product_product_description

string

-_weld_synced

date

supplier

-guid

string

-supplier_code

string

-supplier_name

string

-gstvat_number

string

-bank_name

string

-bank_branch

string

-bank_account

string

-website

string

-phone_number

string

-fax_number

string

-mobile_number

string

-ddi_number

string

-toll_free_number

string

-email

string

-notes

string

-reminder

string

-purchase_order_cost_distribution_method

string

-purchase_order_print_template

string

-supplier_return_print_template

string

-payment_term

string

-xero_contact_id

string

-taxable

boolean

-obsolete

boolean

-lead_time_days

int

-tax_rate

double

-minimum_order_value

double

-last_modified_on

date

-default_warehouse_guid

string

-default_warehouse_warehouse_code

string

-default_warehouse_warehouse_name

string

-_weld_synced

date

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

-tax_rate

double

-tax_total

double

-total

double

-base_return_cost_tax_total

double

-base_return_cost_total

double

-base_sub_total

double

-base_tax_total

double

-base_total

double

-return_date

date

-currency_guid

string

-currency_currency_code

string

-currency_description

string

-supplier_guid

string

-supplier_supplier_code

string

-supplier_supplier_name

string

-purchase_order_guid

string

-purchase_order_order_number

string

-purchase_order_order_date

date

-warehouse_guid

string

-warehouse_warehouse_code

string

-warehouse_warehouse_name

string

-product_batches

string

-product_serials

string

-created_by

string

-created_on

date

-last_modified_by

string

-last_modified_on

date

-_weld_synced

date

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

-return_quantity

double

-return_reason

string

-return_to_supplier

boolean

-purchase_unit_order_quantity

double

-purchase_unit_return_quantity

double

-average_landed_price_after_return

double

-average_landed_price_before_return

double

-stock_on_hand_before_return

double

-line_tax

double

-tax_rate

double

-required_date

date

-xero_cost_of_goods_account

string

-xero_sales_account

string

-xero_tax_code

string

-product_guid

string

-product_product_code

string

-product_product_description

string

-_weld_synced

date

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

-refund

boolean

-bc_cost

double

-bc_tax_cost

double

-bc_total_cost

double

-cost_date

date

-supplier_guid

string

-supplier_supplier_code

string

-supplier_supplier_name

string

-_weld_synced

date

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

-source_warehouse_warehouse_name

string

-destination_warehouse_guid

string

-destination_warehouse_warehouse_code

string

-destination_warehouse_warehouse_name

string

-created_by

string

-created_on

date

-last_modified_by

string

-last_modified_on

date

-_weld_synced

date

warehouse_stock_transfer_detail

-warehouse_stock_transfer_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

-source_warehouse_stock_on_hand_before_transfer

double

-destination_warehouse_id

long

-destination_warehouse_location_id

long

-source_warehouse_id

long

-transfer_order_id

long

-warehouse_location_id

long

-warehouse_product_code

string

-warehouse_product_id

long

-receipt_fifo_date

date

-product_guid

string

-product_product_code

string

-_weld_synced

date

account

-account_code

string

-account_name

string

-account_type

string

-_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

-created_by

string

-created_on

date

-last_modified_by

string

-last_modified_on

date

-_weld_synced

date

company

-guid

string

-company_name

string

-base_currency_code

string

-default_tax_rate

double

-_weld_synced

date

currency

-guid

string

-currency_code

string

-description

string

-default_buy_rate

double

-default_sell_rate

double

-last_modified_on

date

-_weld_synced

date

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_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

-comments

string

-last_modified_on

date

-product_guid

string

-product_product_code

string

-product_product_description

string

-product_group_guid

string

-product_group_group_name

string

-product_group_last_modified_on

date

-customer_guid

string

-customer_customer_code

string

-customer_customer_name

string

-customer_currency_id

long

-customer_last_modified_on

date

-_weld_synced

date

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_order_group

-guid

string

-name

string

-last_modified_on

date

-_weld_synced

date

salesperson

-guid

string

-full_name

string

-email

string

-obsolete

boolean

-last_modified_on

date

-_weld_synced

date

sample

string

-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_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

-days_since_last_sale

int

-on_purchase

double

-allocated_qty

double

-available_qty

double

-qty_on_hand

double

-avg_cost

double

-total_cost

double

-last_modified_on

date

-_weld_synced

date

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

-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

-region

string

-country

string

-post_code

string

-phone_number

string

-fax_number

string

-mobile_number

string

-ddi_number

string

-contact_name

string

-obsolete

boolean

-last_modified_on

date

-_weld_synced

date

Table

Sub table