Knowledge base

Data Model Explorer

Our **Data Model Explorer** provides an _Entity Relationship Diagram_ (ERD) of your Zoho Books data, allowing you to see the relationships between your different tables. ### Navigating 1. Drag tables around the workspace, by clicking and dragging anywhere on a table 1. Drag the entire workspace around by clicking and dragging the background 1. Minimize/maximize your workspace to take up your entire browser screen ### Relationships Relationships are depicted by the arrows running between table properties. For a tidier view, you may select the _Relationships Only_ checkbox, which will hide all the other columns which are not part of a relationship ### Endpoints - Bank account - Bill - Chart of accounts - Contact - Credit note - Currency - Customer payment - Custom field - Estimate - Invoice - Item - Journal - Project - Reporting tag - Sales person - Tax - Template - User - Bank account custom field value - Bill document - Bill custom field value - Bill tax - Bill line item - Chart of accounts transaction - Chart of accounts document - Chart of accounts custom field value - Contact address - Contact document - Contact opening balance - Contact person - Contact reporting tag - Contact custom field value - Credit note line item - Credit note credited invoice - Credit note associated contact - Credit note contact - Credit note tax - Credit note shipping charge tax - Credit note document - Credit note custom field value - Customer payment document - Customer payment invoice - Customer payment custom field value - Custom field option - Estimate document - Estimate line item - Estimate tax - Estimate associated contact - Estimate contact - Estimate custom field value - Invoice document - Invoice line item - Invoice tax - Invoice shipping charge tax - Invoice associated contact - Invoice contact - Invoice custom field value - Item reporting tag - Item default price bracket - Item custom field value - Journal custom field value - Journal document - Journal line item - Journal tax - Journal comment - Project user - Project document - Project custom field value - Project task - Reporting tag option - Bank account custom field value option - Bill custom field value option - Bill line item discount - Bill line item tax - Chart of accounts custom field value option - Contact custom field value option - Credit note line item tax - Credit note line item discount - Credit note custom field value option - Customer payment custom field value option - Estimate custom field value option - Invoice line item tax - Invoice line item discount - Invoice custom field value option - Item custom field value option - Journal custom field value option - Journal line item tax - Project custom field value option