Knowledge base

Data Model Explorer

Our **Data Model Explorer** provides an _Entity Relationship Diagram_ (ERD) of your MYOB Business 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 - Account - Account register - Company preference - Customer - Customer payment - Custom list - Employee - Employee payment detail - Employee payroll detail - Employee standard pay - Employment classification - Inventory item - Inventory location - Job - Job register - Journal transaction - Payroll category - Person - Purchase item bill - Purchase item order - Purchase service bill - Purchase service order - Balance sheet report - Employee payroll advice report - Journal transaction history report - Profit and loss report by fiscal year - Profit and loss report by month - Tax code report by fiscal year - Tax code report by month - Transaction coding report - Sale item invoice - Sale item quote - Sale service invoice - Sale service quote - Superannuation fund - Supplier - Supplier payment - Tax code - Activity - Activity slip - Timesheet - Company email preference - Customer address - Customer identifier - Customer payment invoice - Custom list value - Employee address - Employee custom field - Employee identifier - Employee custom list - Employee payment details bank account - Employee payroll details entitlement - Employee payroll details deduction - Employee payroll details time billing rate - Employee payroll details superannuation category - Employee payroll details employer expense - Employee payroll details wage category - Employee standard pay payroll category - Inventory item location detail - Journal transaction line - Person address - Purchase item bill line - Purchase item order line - Purchase service bill line - Purchase service order line - Balance sheet account - Employee payroll advice report line - Journal transaction history line - Profit and loss report by fiscal year account - Profit and loss report by month account - Tax code report by fiscal year item - Tax code report by month item - Sale item invoice line - Sale item quote line - Sale service invoice line - Sale service quote line - Supplier address - Supplier identifier - Supplier payment line - Timesheet line - Timesheet entry