clients / parent
Dexus Group
Client
- id
- 12
- parent_id
- null
- name
- Dexus Group
- abn
- 24 060 931 001
- billing_email
- accounts@dexus.example
- xero_contact_id
- 00000000-0000-0000-0000-000000000011
- default_site_id
- null (no useful single default)
- notes
- Property group. Bill the child SPV when the PO is in that name. Group marketing jobs can bill this parent.
People (client_people)
Group-wide people sit on the parent. Available on child jobs via ancestor walk.
| name | title | phone | |
|---|---|---|---|
| Sarah Chen | Marketing | sarah.chen@dexus.example | 0412 555 018 |
| Tom Reid | Development manager | tom.reid@dexus.example | 0418 220 441 |
Children
Same clients table, parent_id = 12. Both billable. Each has its own ABN and Xero Contact.
| name | abn | billing_email | default_site_id | xero_contact_id |
|---|---|---|---|---|
| 10 Smith St by Dexus | 51 612 447 203 | accounts@10smith.example | 10 Smith St | 00000000-0000-0000-0000-000000000012 |
| Collins Wharf by Dexus | 83 447 112 908 | accounts@collinswharf.example | Collins Wharf | 00000000-0000-0000-0000-000000000013 |
Child: 10 Smith St by Dexus
- id
- 41
- parent_id
- 12 (Dexus Group)
- name
- 10 Smith St by Dexus
- abn
- 51 612 447 203 (different ABN to parent)
- billing_email
- accounts@10smith.example
- default_site_id
- 10 Smith St (pre-fill on new jobs)
- xero_contact_id
- 00000000-0000-0000-0000-000000000012
- notes
- SPV for the tower. POs come from this ABN. Sarah still raises the work from the parent.