Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| tax_id | int8 |
|
|
The unique tax ID, e.g. 8413. |
| code | varchar |
|
|
The tax code used within the app. This is used for imports and exports. E.g. “gst”, “gst-free”, etc. |
| name | varchar |
|
|
The name of the tax within the app. E.g. “GST”, “GST Free”, etc. |
| rate | numeric |
|
|
The rate expressed as a decimal value. E.g. 0.1 for 10%. |
| company_id | int8 |
|
|
The company ID. E.g. 345. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| dim_taxes_pkey | Primary key | Asc | tax_id |
| dim_taxes_company_id_idx | Performance | Asc | company_id |