Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| independent_contractor_invoice_id | int8 |
|
|
|
| source_type | varchar |
|
|
|
| source_id | int8 |
|
|
|
| quantity | numeric |
|
|
The number of units the invoice is for. @example: 2 |
| unit_type | varchar |
|
|
|
| price_cents | int4 |
|
|
The price per unit in cents. @example: 6250 |
| price_currency | varchar |
|
|
The currency of the price. @example: ‘AUD’ |
| tax_id | int8 |
|
|
The foreign key for the associated tax. @example: 1 |
| tax_rate | numeric |
|
|
The tax rate. @example: 0.1 |
| tax_amount_cents | int4 |
|
|
The tax portion of the amount in cents gross. @example: 6250 |
| tax_amount_currency | varchar |
|
|
The currency of the tax amount. @example: ‘AUD’ |
| gross_amount_cents | int4 |
|
|
The amount in cents, gross. @example: 12500 |
| gross_amount_currency | varchar |
|
|
The currency of the gross amount. @example: ‘AUD’ |
| standard_invoice_line_id | int8 |
|
|
Foreign key to the corresponding invoice line. @example 1 |
| company_id | int8 |
|
|
Foreign key to the tenant company. @example 1 |
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
| item_code | text |
|
|
An optional external id for the line item. @example ‘SKU-033’ |
| label | varchar |
|
|
The category label of the line. @example provider_travel_time_fee |
| created_at_in_company_tz | timestamp |
|
|
|
| updated_at_in_company_tz | timestamp |
|
|
|
| company_timezone | varchar |
|
|
The company timezone. E.g. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| edge_independent_contractor_invoice_lines_pkey | Primary key | Asc | id |
| idx_2c9ac893a4ad555e53e136f4bf9eb6a4 | Performance | Asc | standard_invoice_line_id |
| idx_b595ec57e43c14185156a24c007efef1 | Performance | Asc | independent_contractor_invoice_id |
| idx_edge_independent_contractor_invoice_lines_company_id | Performance | Asc | company_id |
| idx_edge_independent_contractor_invoice_lines_source_id | Performance | Asc | source_id |
| idx_edge_independent_contractor_invoice_lines_tax_id | Performance | Asc | tax_id |