EZOfficeInventory

Explore the interactive ERD

Table & Field Reference

location

Column	Type	Keys
`id`	Unknown	PK
`parent_id`	Unknown	FK
`city`	Unknown
`comments_count`	Unknown
`country`	Unknown
`created_at`	Unknown
`deltas`	Unknown
`description`	Unknown
`documents_count`	Unknown
`hidden_on_web_store`	Unknown
`identification_number`	Unknown
`latitude`	Unknown
`longitude`	Unknown
`manual_lat_long`	Unknown
`name`	Unknown
`secure_code`	Unknown
`sequence_num`	Unknown
`state`	Unknown
`status`	Unknown
`street_1`	Unknown
`street_2`	Unknown
`updated_at`	Unknown
`visible_on_web_store`	Unknown
`zipcode`	Unknown
`custom_`

group_depreciation_rate

Column	Type	Keys
`id`	Unknown	PK
`groups_id`	Unknown	PKFK
`created_at`	Unknown
`depreciation_method_id`	Unknown
`depreciation_method_name`	Unknown
`rate`	Unknown
`updated_at`	Unknown
`useful_life`	Unknown

groups

Column	Type	Keys
`id`	Unknown	PK
`allow_staff_to_set_checkout_duration`	Unknown
`asset_depreciation_mode`	Unknown
`assets_count`	Unknown
`comments_count`	Unknown
`company_id`	Unknown
`created_at`	Unknown
`deltas`	Unknown
`description`	Unknown
`document`	Json
`documents_count`	Unknown
`enable_service_triage`	Unknown
`hidden_on_web_store`	Unknown
`indefinite_triage_completion_period`	Unknown
`name`	Unknown
`pricing_bracket_interval`	Unknown
`staff_checkout_duration_day`	Unknown
`staff_checkout_duration_hour`	Unknown
`staff_checkout_duration_minute`	Unknown
`staff_checkout_duration_month`	Unknown
`staff_checkout_duration_week`	Unknown
`triage_completion_period`	Unknown
`triage_completion_period_basis`	Unknown
`updated_at`	Unknown
`visible_on_web_store`	Unknown

asset_stock_history

Column	Type	Keys
`_fivetran_id`	String	PK
`asset_stock_id`	Unknown	FK
`basket_asset_id`	Unknown	FK
`basket_id`	Unknown	FK
`purchase_order_id`	Unknown	FK
`retire_reason_id`	Unknown	FK
`service_id`	Unknown	FK
`vendor_id`	Unknown	FK
`action_source`	Unknown
`agreement_accepted`	Unknown
`agreement_document_id`	Unknown
`asset_name`	Unknown
`check_out_to_asset_id`	Unknown
`checked_in_from_location_id`	Unknown
`checked_out_to_location_id`	Unknown
`checkin_due_on`	Unknown
`checkin_on`	Unknown
`checkout_line_item_id`	Unknown
`checkout_on`	Unknown
`comment`	Unknown
`company_id`	Unknown
`cost_price`	Unknown
`cost_valuation_method`	Unknown
`created_at`	Unknown
`created_by_id`	Unknown
`deleted_at`	Unknown
`deleted_by_id`	Unknown
`for_retiring_checked_out_stock`	Unknown
`hidden_at`	Unknown
`hidden_by_id`	Unknown
`is_custody_transfer`	Unknown
`is_transfer`	Unknown
`item_audit_id`	Unknown
`order_type`	Unknown
`original_quantity`	Unknown
`paired_transfer_line_item_id`	Unknown
`price`	Unknown
`project_id`	Unknown
`purchased_on`	Unknown
`quantity`	Unknown
`quantity_after_transaction`	Unknown
`remaining_quantity`	Unknown
`retire_reason`	Unknown
`signature_image_id`	Unknown
`signed_by_name`	Unknown
`task_id`	Unknown
`transfer_from_location_id`	Unknown
`transition_from_substate_id`	Unknown
`transition_to_substate_id`	Unknown
`unit_cost_price`	Unknown
`updated_at`	Unknown
`user_full_name`	Unknown

member

Column	Type	Keys
`id`	Unknown	PK
`account_name`	Unknown
`address`	Unknown
`address_line_2`	Unknown
`address_name`	Unknown
`alert_type`	Unknown
`already_rated`	Unknown
`attach_invoice_with_order_alert`	Unknown
`auto_sync_with_ldap`	Unknown
`automation_user`	Unknown
`billing_address_id`	Unknown
`business_id`	Unknown
`category_id`	Unknown
`cc_business_in_alert`	Unknown
`cc_secondary_emails_in_alert`	Unknown
`city`	Unknown
`collect_tax`	Unknown
`comments_count`	Unknown
`compact_view`	Unknown
`company_default_payment_term`	Unknown
`consumed_timestep`	Unknown
`contact_owner`	Unknown
`contact_type`	Unknown
`country`	Unknown
`created_at`	Unknown
`created_by_id`	Unknown
`created_by_scim`	Unknown
`creation_source`	Unknown
`credit_memo_amount`	Unknown
`customer_category_id`	Unknown
`deactivated_at`	Unknown
`default_address_id`	Unknown
`default_triage_setting_id`	Unknown
`deleted_at`	Unknown
`department`	Unknown
`description`	Unknown
`display_picture_content_type`	Unknown
`display_picture_file_name`	Unknown
`display_picture_file_size`	Unknown
`display_picture_updated_at`	Unknown
`documents_count`	Unknown
`email`	Unknown
`employee_id`	Unknown
`employee_identification_number`	Unknown
`external_id`	Unknown
`fax`	Unknown
`first_name`	Unknown
`full_name`	Unknown
`guest_user`	Unknown
`hourly_rate`	Unknown
`iframe_request_sign_in_time`	Unknown
`inactive_by_id`	Unknown
`is_gsuite_user`	Unknown
`is_ldap_user`	Unknown
`jira_account_id`	Unknown
`last_name`	Unknown
`last_sync_date`	Unknown
`last_sync_source`	Unknown
`last_used_ffos_at`	Unknown
`manager_id`	Unknown
`offboarding_date`	Unknown
`otp_required_for_login`	Unknown
`password_changed_at`	Unknown
`payment_term_id`	Unknown
`payment_term_same_as_business`	Unknown
`phone_number`	Unknown
`role_id`	Unknown
`salesforce_id`	Unknown
`saml_session_index_id`	Unknown
`saml_user`	Unknown
`scim_action`	Unknown
`secure_code`	Unknown
`services_count`	Unknown
`settings_access`	Unknown
`show_announcement`	Unknown
`show_app_update`	Unknown
`signature`	Unknown
`single_step_addresses_qr_printing`	Unknown
`single_step_baskets_qr_printing`	Unknown
`single_step_bundles_qr_printing`	Unknown
`single_step_contacts_qr_printing`	Unknown
`single_step_customers_qr_printing`	Unknown
`single_step_locations_qr_printing`	Unknown
`single_step_members_qr_printing`	Unknown
`state`	Unknown
`status`	Unknown
`stock_asset_current_checkout_view`	Unknown
`stock_asset_group_by_column`	Unknown
`subscribed_to_email`	Unknown
`team_id`	Unknown
`transaction_started_at`	Unknown
`unseen_app_updates_count`	Unknown
`unsubscribed_by_id`	Unknown
`updated_at`	Unknown
`use_business_contact_detail`	Unknown
`user_listing_id`	Unknown
`web_store_sign_up_privacy_policy_agreed_on`	Unknown
`web_store_sign_up_terms_agreed_on`	Unknown
`web_store_signup`	Unknown
`webstore_authentication_token`	Unknown
`zendesk_account_id`	Unknown
`zip_code`	Unknown
`custom_`

retire_reason

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`name`	Unknown
`updated_at`	Unknown

inventory_line_item

Column	Type	Keys
`id`	Unknown	PK
`inventory_id`	Unknown	PKFK
`comment`	Unknown
`created_at`	Unknown
`order_type`	Unknown
`price`	Unknown
`quantity`	Unknown
`quantity_after_transaction`	Unknown
`remaining_quantity`	Unknown
`updated_at`	Unknown

inventory

Column	Type	Keys
`id`	Unknown	PK
`group_id`	Unknown	FK
`location_id`	Unknown	FK
`purchase_order_id`	Unknown	FK
`retire_reason_id`	Unknown	FK
`sub_group_id`	Unknown	FK
`vendor_id`	Unknown	FK
`action`	Unknown
`advanced_pricing`	Unknown
`arbitration`	Unknown
`asset_type`	Unknown
`assigned_to_user_email`	Unknown
`audit_pending`	Unknown
`available_for_sale`	Unknown
`average_cost_per_unit`	Unknown
`bulk_import_id`	Unknown
`candidate_email`	Unknown
`checkin_due_on`	Unknown
`checkout_on`	Unknown
`clone_from_asset_id`	Unknown
`comments_count`	Unknown
`created_at`	Unknown
`created_by_itam`	Unknown
`current_meter_reading`	Unknown
`default_excess_location_threshold`	Unknown
`depreciation_calculation_required`	Unknown
`description`	Unknown
`display_image`	Unknown
`document`	Json
`document_url`	Json
`documents_count`	Unknown
`external_asset`	Unknown
`featured_item`	Unknown
`group_rule_provisioned`	Unknown
`hidden_on_web_store`	Unknown
`holder_id`	Unknown
`identifier`	Unknown
`image_url`	Json
`initial_stock_quantity`	Unknown
`inventory_threshold`	Unknown
`is_processed`	Unknown
`it_asset_source`	Unknown
`itam_hardware_id`	Unknown
`item_audit_id`	Unknown
`last_assigned_to_id`	Unknown
`last_checked_in_at`	Unknown
`last_checked_out_at`	Unknown
`last_history_id`	Unknown
`latest_contract_id`	Unknown
`location_based_threshold`	Unknown
`location_name`	Unknown
`location_rule_provisioned`	Unknown
`merge_date`	Unknown
`name`	Unknown
`net_quantity`	Unknown
`network_asset`	Unknown
`package_id`	Unknown
`pending_verification`	Unknown
`price`	Unknown
`product_changed_manually`	Unknown
`product_id`	Unknown
`product_identity`	Unknown
`product_model_number`	Unknown
`purchased_on`	Unknown
`qbd_item_name`	Unknown
`quickbooks_item_id`	Unknown
`rent_collected`	Unknown
`rental_meter`	Unknown
`rental_meter_threshold`	Unknown
`retire_comment`	Unknown
`retire_reason`	Unknown
`retired_by_id`	Unknown
`retired_on`	Unknown
`sale_price`	Unknown
`salvage_value`	Unknown
`send_usage_meter_threshold_recurring_alert`	Unknown
`services_count`	Unknown
`state`	Unknown
`sub_checked_out_to_id`	Unknown
`sunshine_id`	Unknown
`synced_with_jira_at`	Unknown
`tax_free`	Unknown
`update_counter`	Unknown
`updated_at`	Unknown
`usage_meter_threshold`	Unknown
`visible_on_web_store`	Unknown
`custom_`

asset

Column	Type	Keys
`id`	Unknown	PK
`group_id`	Unknown	FK
`location_id`	Unknown	FK
`purchase_order_id`	Unknown	FK
`retire_reason_id`	Unknown	FK
`sub_group_id`	Unknown	FK
`vendor_id`	Unknown	FK
`action`	Unknown
`active_sub_checkout`	Unknown
`advanced_pricing`	Unknown
`arbitration`	Unknown
`asset_type`	Unknown
`assigned_to_user_email`	Unknown
`assigned_to_user_name`	Unknown
`audit_pending`	Unknown
`available_for_sale`	Unknown
`average_cost_per_unit`	Unknown
`bulk_import_id`	Unknown
`candidate_email`	Unknown
`checkin_due_on`	Unknown
`checkout_on`	Unknown
`clone_from_asset_id`	Unknown
`comments_count`	Unknown
`created_at`	Unknown
`created_by_itam`	Unknown
`current_meter_reading`	Unknown
`custom_substate_id`	Unknown
`default_excess_location_threshold`	Unknown
`depreciated_value_straight_line`	Unknown
`depreciation_calculation_required`	Unknown
`description`	Unknown
`display_image`	Unknown
`document`	Json
`document_url`	Json
`documents_count`	Unknown
`external_asset`	Unknown
`featured_item`	Unknown
`group_rule_provisioned`	Unknown
`hidden_on_web_store`	Unknown
`holder_id`	Unknown
`identifier`	Unknown
`image_url`	Json
`initial_stock_quantity`	Unknown
`inventory_threshold`	Unknown
`is_processed`	Unknown
`it_asset_source`	Unknown
`itam_hardware_id`	Unknown
`item_audit_id`	Unknown
`last_assigned_to_id`	Unknown
`last_checked_in_at`	Unknown
`last_checked_out_at`	Unknown
`last_history_id`	Unknown
`latest_contract_id`	Unknown
`location_based_threshold`	Unknown
`location_name`	Unknown
`location_number`	Unknown
`location_rule_provisioned`	Unknown
`merge_date`	Unknown
`name`	Unknown
`net_quantity`	Unknown
`network_asset`	Unknown
`package_id`	Unknown
`pending_verification`	Unknown
`price`	Unknown
`product_changed_manually`	Unknown
`product_id`	Unknown
`product_identity`	Unknown
`product_model_number`	Unknown
`purchased_on`	Unknown
`qbd_item_name`	Unknown
`quickbooks_item_id`	Unknown
`rent_collected`	Unknown
`rental_meter`	Unknown
`rental_meter_threshold`	Unknown
`retire_comment`	Unknown
`retire_reason`	Unknown
`retired_by_id`	Unknown
`retired_on`	Unknown
`sale_price`	Unknown
`salvage_value`	Unknown
`send_usage_meter_threshold_recurring_alert`	Unknown
`services_count`	Unknown
`state`	Unknown
`sub_checked_out_to_full_name`	Unknown
`sub_checked_out_to_id`	Unknown
`sunshine_id`	Unknown
`synced_with_jira_at`	Unknown
`tax_free`	Unknown
`update_counter`	Unknown
`updated_at`	Unknown
`usage_meter_threshold`	Unknown
`visible_on_web_store`	Unknown

asset_depreciation_rate

Column	Type	Keys
`id`	Unknown	PK
`asset_id`	Unknown	PKFK
`group_id`	Unknown	FK
`created_at`	Unknown
`depreciation_method_id`	Unknown
`depreciation_method_name`	Unknown
`rate`	Unknown
`updated_at`	Unknown
`useful_life`	Unknown

asset_history

Column	Type	Keys
`id`	Unknown	PK
`asset_id`	Unknown	FK
`basket_asset_id`	Unknown	FK
`basket_id`	Unknown	FK
`location_id`	Unknown	FK
`action_source`	Unknown
`actual_checkin_on`	Unknown
`agreement_accepted`	Unknown
`agreement_document_id`	Unknown
`assigned_asset`	Unknown
`assigned_to_id`	Unknown
`assigned_to_name`	Unknown
`assigned_to_type`	Unknown
`checked_out_duration_in_seconds`	Unknown
`checkin_due_on`	Unknown
`checkin_on`	Unknown
`checkout_on`	Unknown
`comments_count`	Unknown
`company_id`	Unknown
`created_at`	Unknown
`created_by_id`	Unknown
`is_checkout`	Unknown
`is_transfer`	Unknown
`package_id`	Unknown
`past_checkout`	Unknown
`project_id`	Unknown
`rent_collected`	Unknown
`signature_image_id`	Unknown
`signed_by_name`	Unknown
`updated_at`	Unknown

member_default_address

Column	Type	Keys
`_fivetran_id`	String	PK
`member_id`	Unknown	FK
`default_address`	Json

subgroup

Column	Type	Keys
`id`	Unknown	PK
`group_id`	Unknown	FK
`allow_staff_to_set_checkout_duration`	Unknown
`assets_count`	Unknown
`created_at`	Unknown
`description`	Unknown
`enable_service_triage`	Unknown
`hidden_on_web_store`	Unknown
`indefinite_triage_completion_period`	Unknown
`lft`	Unknown
`name`	Unknown
`parent_id`	Unknown
`rgt`	Unknown
`staff_checkout_duration_day`	Unknown
`staff_checkout_duration_hour`	Unknown
`staff_checkout_duration_minute`	Unknown
`staff_checkout_duration_month`	Unknown
`staff_checkout_duration_week`	Unknown
`subgroup_path`	Unknown
`triage_completion_period`	Unknown
`triage_completion_period_basis`	Unknown
`triage_same_as_group`	Unknown
`updated_at`	Unknown
`visible_on_web_store`	Unknown

asset_stock_line_item

Column	Type	Keys
`id`	Unknown	PK
`asset_stock_id`	Unknown	PKFK
`comment`	Unknown
`created_at`	Unknown
`order_type`	Unknown
`price`	Unknown
`quantity`	Unknown
`quantity_after_transaction`	Unknown
`remaining_quantity`	Unknown
`updated_at`	Unknown

asset_stock

Column	Type	Keys
`id`	Unknown	PK
`group_id`	Unknown	FK
`location_id`	Unknown	FK
`purchase_order_id`	Unknown	FK
`retire_reason_id`	Unknown	FK
`sub_group_id`	Unknown	FK
`vendor_id`	Unknown	FK
`action`	Unknown
`advanced_pricing`	Unknown
`arbitration`	Unknown
`asset_type`	Unknown
`assigned_to_user_email`	Unknown
`audit_pending`	Unknown
`available_for_sale`	Unknown
`available_quantity`	Unknown
`average_cost_per_unit`	Unknown
`bulk_import_id`	Unknown
`candidate_email`	Unknown
`checkin_due_on`	Unknown
`checkout_on`	Unknown
`clone_from_asset_id`	Unknown
`comments_count`	Unknown
`created_at`	Unknown
`created_by_itam`	Unknown
`current_meter_reading`	Unknown
`default_excess_location_threshold`	Unknown
`depreciation_calculation_required`	Unknown
`description`	Unknown
`display_image`	Unknown
`document`	Json
`document_url`	Json
`documents_count`	Unknown
`external_asset`	Unknown
`featured_item`	Unknown
`group_rule_provisioned`	Unknown
`hidden_on_web_store`	Unknown
`holder_id`	Unknown
`identifier`	Unknown
`image_url`	Json
`initial_stock_quantity`	Unknown
`inventory_threshold`	Unknown
`is_processed`	Unknown
`it_asset_source`	Unknown
`itam_hardware_id`	Unknown
`item_audit_id`	Unknown
`last_assigned_to_id`	Unknown
`last_checked_in_at`	Unknown
`last_checked_out_at`	Unknown
`last_history_id`	Unknown
`latest_contract_id`	Unknown
`location_based_threshold`	Unknown
`location_name`	Unknown
`location_rule_provisioned`	Unknown
`merge_date`	Unknown
`name`	Unknown
`net_quantity`	Unknown
`network_asset`	Unknown
`package_id`	Unknown
`pending_verification`	Unknown
`price`	Unknown
`product_changed_manually`	Unknown
`product_id`	Unknown
`product_identity`	Unknown
`product_model_number`	Unknown
`purchased_on`	Unknown
`qbd_item_name`	Unknown
`quickbooks_item_id`	Unknown
`rent_collected`	Unknown
`rental_meter`	Unknown
`rental_meter_threshold`	Unknown
`retire_comment`	Unknown
`retire_reason`	Unknown
`retired_by_id`	Unknown
`retired_on`	Unknown
`sale_price`	Unknown
`salvage_value`	Unknown
`send_usage_meter_threshold_recurring_alert`	Unknown
`services_count`	Unknown
`state`	Unknown
`sub_checked_out_to_id`	Unknown
`sunshine_id`	Unknown
`synced_with_jira_at`	Unknown
`tax_free`	Unknown
`update_counter`	Unknown
`updated_at`	Unknown
`usage_meter_threshold`	Unknown
`visible_on_web_store`	Unknown
`custom_`

inventory_history

Column	Type	Keys
`_fivetran_id`	String	PK
`basket_asset_id`	Unknown	FK
`basket_id`	Unknown	FK
`inventory_id`	Unknown	FK
`purchase_order_id`	Unknown	FK
`retire_reason_id`	Unknown	FK
`service_id`	Unknown	FK
`vendor_id`	Unknown	FK
`action_source`	Unknown
`asset_name`	Unknown
`check_out_to_asset_id`	Unknown
`checked_in_from_location_id`	Unknown
`checked_out_to_location_id`	Unknown
`checkin_due_on`	Unknown
`checkin_on`	Unknown
`checkout_line_item_id`	Unknown
`checkout_on`	Unknown
`comment`	Unknown
`company_id`	Unknown
`cost_price`	Unknown
`cost_valuation_method`	Unknown
`created_at`	Unknown
`created_by_id`	Unknown
`deleted_at`	Unknown
`deleted_by_id`	Unknown
`for_retiring_checked_out_stock`	Unknown
`hidden_at`	Unknown
`hidden_by_id`	Unknown
`is_custody_transfer`	Unknown
`is_transfer`	Unknown
`item_audit_id`	Unknown
`order_type`	Unknown
`original_quantity`	Unknown
`paired_transfer_line_item_id`	Unknown
`price`	Unknown
`project_id`	Unknown
`purchased_on`	Unknown
`quantity`	Unknown
`quantity_after_transaction`	Unknown
`remaining_quantity`	Unknown
`retire_reason`	Unknown
`signature_image_id`	Unknown
`signed_by_name`	Unknown
`task_id`	Unknown
`transfer_from_location_id`	Unknown
`transition_from_substate_id`	Unknown
`transition_to_substate_id`	Unknown
`unit_cost_price`	Unknown
`updated_at`	Unknown
`user_full_name`	Unknown

member_check_in_out_history

Column	Type	Keys
`id`	Unknown	PK
`basket_asset_id`	Unknown	FK
`basket_id`	Unknown	FK
`location_id`	Unknown	FK
`member_id`	Unknown	FK
`action_source`	Unknown
`actual_checkin_on`	Unknown
`agreement_accepted`	Unknown
`agreement_document_id`	Unknown
`assigned_asset`	Unknown
`assigned_to_id`	Unknown
`assigned_to_name`	Unknown
`assigned_to_type`	Unknown
`checked_out_duration_in_second`	Unknown
`checkin_due_on`	Unknown
`checkin_on`	Unknown
`checkout_on`	Unknown
`comments_count`	Unknown
`company_id`	Unknown
`created_at`	Unknown
`created_by_id`	Unknown
`is_checkout`	Unknown
`is_transfer`	Unknown
`package_id`	Unknown
`past_checkout`	Unknown
`project_id`	Unknown
`rent_collected`	Unknown
`signature_image_id`	Unknown
`signed_by_name`	Unknown
`updated_at`	Unknown

asset_service_detail

Column	Type	Keys
`service_id`	Unknown	PK
`asset_sequence_num`	Unknown	FK
`actual_end_date`	Unknown
`actual_start_date`	Unknown
`cost`	Unknown
`created_by`	Unknown
`end_date`	Unknown
`linked_inventory_item`	Unknown
`services_by`	Unknown
`start_date`	Unknown

purchase_order

Column	Type	Keys
`id`	Unknown	PK
`vendor_id`	Unknown	FK
`approved_by_id`	Unknown
`approver_id`	Unknown
`approver_type`	Unknown
`comments_count`	Unknown
`company_id`	Unknown
`completed_on`	Unknown
`contract_id`	Unknown
`created_at`	Unknown
`created_by_id`	Unknown
`delivery_date`	Unknown
`delivery_location_id`	Unknown
`deltas`	Unknown
`description`	Unknown
`documents_count`	Unknown
`identification_number`	Unknown
`invoice_number`	Unknown
`net_amount`	Unknown
`note`	Unknown
`paid_amount`	Unknown
`parent_id`	Unknown
`payable_amount`	Unknown
`payment_term`	Unknown
`po_type`	Unknown
`project_id`	Unknown
`purchase_orders_asset`	Json
`receiving_note`	Unknown
`requested_by_id`	Unknown
`sequence_num`	Unknown
`shipment_term`	Unknown
`state`	Unknown
`stock_request_id`	Unknown
`tax_amount`	Unknown
`title`	Unknown
`updated_at`	Unknown

location_item_quantity

Column	Type	Keys
`_fivetran_id`	String	PK
`asset_num`	Unknown	FK
`location_sequence_num`	Unknown
`total_quantity`	Unknown

vendor

Column	Type	Keys
`id`	Unknown	PK
`address`	Unknown
`assets_count`	Unknown
`bulk_import_id`	Unknown
`comments_count`	Unknown
`company_id`	Unknown
`contact_person_name`	Unknown
`created_at`	Unknown
`deleted_at`	Unknown
`deltas`	Unknown
`description`	Unknown
`documents_count`	Unknown
`email`	Unknown
`fax`	Unknown
`name`	Unknown
`phone`	Unknown
`services_count`	Unknown
`status`	Unknown
`updated_at`	Unknown
`website`	Unknown

work_order_type

Column	Type	Keys
`id`	Unknown	PK
`category`	Unknown
`description`	Unknown
`name`	Unknown

cart_order_line_item

Column	Type	Keys
`id`	Unknown	PK
`cart_id`	Unknown	PKFK
`asset_sequence_num`	Unknown	FK
`asset_name`	Unknown

cart

Column	Type	Keys
`id`	Unknown	PK
`location_id`	Unknown	FK
`applied_taxes_on_line_item`	Unknown
`assigned_to_id`	Unknown
`associated_customer`	Unknown
`basket_payment_history`	Json
`basket_recurring_line_item`	Json
`basket_state`	Unknown
`baskets_sub_rent_item`	Json
`best_pricing_applies`	Unknown
`bill_duration`	Unknown
`bill_from`	Unknown
`bill_to`	Unknown
`billing_address_id`	Unknown
`billing_contact_id`	Unknown
`bundle_price`	Unknown
`bundle_pricing_adjustment`	Json
`bundle_snapshot_applied`	Unknown
`bundle_tax_amount`	Unknown
`cancelled_by_id`	Unknown
`checked_out_by_id`	Unknown
`checked_out_on`	Unknown
`checked_out_to_id`	Unknown
`clone_from_basket_id`	Unknown
`comments_count`	Unknown
`comments_on_damage`	Unknown
`comments_on_pre_payment`	Unknown
`comments_on_refund`	Unknown
`completed_by_id`	Unknown
`completed_on`	Unknown
`consistency_qb_tax_run_at`	Unknown
`contact_person_id`	Unknown
`coupon_to_apply`	Unknown
`coupons_applied`	Unknown
`coupons_discounts_detail`	Unknown
`created_at`	Unknown
`custom_attribute`	Json
`custom_entry`	Json
`custom_substate_id`	Unknown
`customer_collect_tax`	Unknown
`damage_amount`	Unknown
`delivery_cost`	Unknown
`delivery_date`	Unknown
`delivery_note`	Unknown
`delivery_person_id`	Unknown
`delivery_status`	Unknown
`delivery_time`	Unknown
`deltas`	Unknown
`description`	Unknown
`documents_count`	Unknown
`drop_off_location_id`	Unknown
`due_date`	Unknown
`duration`	Unknown
`dynamic_line_item`	Json
`enable_customers_pricing`	Unknown
`enable_working_day`	Unknown
`expected_checkedout_date`	Unknown
`fixed_asset_rent`	Json
`frozen_state`	Unknown
`gross_amount`	Unknown
`hide_time`	Unknown
`identification_number`	Unknown
`identification_number_last_updated_at`	Unknown
`inclusive_time_order`	Unknown
`inventory_price`	Json
`invoice_heading`	Unknown
`is_negative_tax`	Unknown
`is_sold`	Unknown
`item_level_charge`	Unknown
`item_level_discount`	Unknown
`item_level_discount_applied`	Unknown
`last_action`	Unknown
`last_sync_at`	Unknown
`last_synced_with_qbd`	Unknown
`last_synced_with_quickbooks`	Unknown
`last_synced_with_xero`	Unknown
`late_due_date`	Unknown
`late_fee`	Json
`late_fee_amount`	Unknown
`late_fee_applied`	Unknown
`line_item_damages_applied`	Unknown
`line_item_total_price`	Unknown
`location_for_delivery`	Unknown
`location_for_pickup`	Unknown
`marked_void_by_id`	Unknown
`max_verification_count`	Unknown
`net_amount`	Unknown
`net_amount_modified`	Unknown
`net_order_discount`	Unknown
`no_of_days_in_month`	Unknown
`occurrence_number`	Unknown
`order_discount`	Unknown
`order_state`	Unknown
`order_type`	Unknown
`overage_charge`	Unknown
`overridden_tax_amount`	Unknown
`payable_amount`	Unknown
`payment_completed_on`	Unknown
`payment_method_for_pre_payment`	Unknown
`payment_method_for_return`	Unknown
`payment_note`	Unknown
`payment_start_time`	Unknown
`payment_term_date`	Unknown
`payment_term_due_date_updated_at`	Unknown
`payment_term_due_date_updated_by_id`	Unknown
`payment_term_edited`	Unknown
`persist_items_present_in_order_location`	Unknown
`persist_location_based_searching`	Unknown
`persist_only_available_assets_check`	Unknown
`persist_show_only_available_bundle`	Unknown
`pick_up_address_id`	Unknown
`pick_up_location_id`	Unknown
`pickup_cost`	Unknown
`pickup_date`	Unknown
`pickup_note`	Unknown
`pickup_person_id`	Unknown
`pickup_status`	Unknown
`pickup_time`	Unknown
`pre_paid_amount`	Unknown
`prices_calculated_by_snapshot`	Unknown
`pricing_coupon_discount`	Unknown
`pricing_model`	Unknown
`pricing_updated_at`	Unknown
`project_id`	Unknown
`promotional_discount`	Unknown
`qb_tax_amount`	Unknown
`qbd_due_date`	Unknown
`qbd_txn_date`	Unknown
`quantity`	Unknown
`quickbooks_invoice_id`	Unknown
`quickbooks_last_sync_order_status`	Unknown
`quickbooks_last_sync_payment_status`	Unknown
`quickbooks_sync_failed_count`	Unknown
`quickbooks_tax_sync_failed_at`	Unknown
`recurrence_due_date`	Unknown
`recurrence_id`	Unknown
`refund_amount`	Unknown
`rental_tax`	Unknown
`reserved_by_id`	Unknown
`reserved_for_id`	Unknown
`reserved_on`	Unknown
`resource_id`	Unknown
`resource_type`	Unknown
`rules_and_coupons_enabled`	Unknown
`sales_tax`	Unknown
`secure_code`	Unknown
`service_offering_price`	Json
`shipping_address_id`	Unknown
`shipping_contact_id`	Unknown
`skip_auto_accounting_syncing`	Unknown
`state`	Unknown
`stock_asset_rent`	Json
`sync_qbd_discount_as_service`	Unknown
`tax`	Unknown
`tax_amount`	Json
`taxable_amount`	Unknown
`time_zone`	Unknown
`total_expenses`	Unknown
`transaction_started_at`	Unknown
`unvoided_by_id`	Unknown
`unvoided_on`	Unknown
`updated_at`	Unknown
`usage_charge`	Unknown
`user_id`	Unknown
`user_listing_id`	Unknown
`working_day`	Unknown
`xero_invoice_id`	Unknown
`xero_last_sync_order_status`	Unknown
`xero_last_sync_payment_status`	Unknown
`xero_sync_failed_count`	Unknown