# EZOfficeInventory schema ERD

Table and field reference for the Fivetran EZOfficeInventory connector.

## 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 |  |

## Relationships

- location(parent_id) → location(id)
- group_depreciation_rate(groups_id) → groups(id)
- asset_stock_history(basket_asset_id) → cart_order_line_item(id)
- asset_stock_history(vendor_id) → vendor(id)
- asset_stock_history(purchase_order_id) → purchase_order(id)
- asset_stock_history(service_id) → asset_service_detail(service_id)
- asset_stock_history(retire_reason_id) → retire_reason(id)
- asset_stock_history(basket_id) → cart(id)
- asset_stock_history(asset_stock_id) → asset_stock(id)
- inventory_line_item(inventory_id) → inventory(id)
- inventory(sub_group_id) → subgroup(id)
- inventory(vendor_id) → vendor(id)
- inventory(purchase_order_id) → purchase_order(id)
- inventory(group_id) → groups(id)
- inventory(retire_reason_id) → retire_reason(id)
- inventory(location_id) → location(id)
- asset(sub_group_id) → subgroup(id)
- asset(vendor_id) → vendor(id)
- asset(purchase_order_id) → purchase_order(id)
- asset(group_id) → groups(id)
- asset(retire_reason_id) → retire_reason(id)
- asset(location_id) → location(id)
- asset_depreciation_rate(group_id) → groups(id)
- asset_depreciation_rate(asset_id) → asset(id)
- asset_history(basket_asset_id) → cart_order_line_item(id)
- asset_history(location_id) → location(id)
- asset_history(basket_id) → cart(id)
- asset_history(asset_id) → asset(id)
- member_default_address(member_id) → member(id)
- subgroup(group_id) → groups(id)
- asset_stock_line_item(asset_stock_id) → asset_stock(id)
- asset_stock(sub_group_id) → subgroup(id)
- asset_stock(vendor_id) → vendor(id)
- asset_stock(purchase_order_id) → purchase_order(id)
- asset_stock(group_id) → groups(id)
- asset_stock(retire_reason_id) → retire_reason(id)
- asset_stock(location_id) → location(id)
- inventory_history(basket_asset_id) → cart_order_line_item(id)
- inventory_history(vendor_id) → vendor(id)
- inventory_history(purchase_order_id) → purchase_order(id)
- inventory_history(service_id) → asset_service_detail(service_id)
- inventory_history(retire_reason_id) → retire_reason(id)
- inventory_history(basket_id) → cart(id)
- inventory_history(inventory_id) → inventory(id)
- member_check_in_out_history(basket_asset_id) → cart_order_line_item(id)
- member_check_in_out_history(location_id) → location(id)
- member_check_in_out_history(basket_id) → cart(id)
- member_check_in_out_history(member_id) → member(id)
- asset_service_detail(asset_sequence_num) → asset(id)
- purchase_order(vendor_id) → vendor(id)
- location_item_quantity(asset_num) → asset(id)
- cart_order_line_item(asset_sequence_num) → asset(id)
- cart_order_line_item(cart_id) → cart(id)
- cart(location_id) → location(id)