Data Model Explorer
Our Data Model Explorer provides an Entity Relationship Diagram (ERD) of your Xero Payroll NZ data, allowing you to see the relationships between your different tables.
Navigating
- Drag tables around the workspace, by clicking and dragging anywhere on a table
- Drag the entire workspace around by clicking and dragging the background
- 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
- Earnings rate
- Employee
- Employee leave
- Employee leave balance
- Employee leave type
- Employee salary and wage
- Leave type
- Pay run
- Payroll calendar
- Payslip
- Reimbursement
- Superannuation
- Timesheet
- Employee leave period
- Payslip earnings line
- Payslip superannuation line
- Payslip leave accrual line
- Payslip payment line
- Payslip employee tax line
- Payslip employer tax line
- Timesheet line