Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| purchase_order_id | int8 |
|
|
|
| quantity | numeric |
|
|
|
| price_cents | int4 |
|
|
|
| price_currency | varchar |
|
|
|
| description | varchar |
|
|
|
| gross_amount_cents | int4 |
|
|
|
| gross_amount_currency | varchar |
|
|
|
| tax_amount_cents | int4 |
|
|
|
| tax_amount_currency | varchar |
|
|
|
| tax_id | int8 |
|
|
|
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
| extended_description | text |
|
|
|
| supplier_generated_invoice_id | int8 |
|
|
|
| estimated_delivery_date | date |
|
|
|
| actual_delivery_date | date |
|
|
|
| start_time | time |
|
|
|
| end_time | time |
|
|
|
| all_day | bool |
|
|
|
| beginning_at | timestamp |
|
|
|
| ending_at | timestamp |
|
|
|
| visible_to_care_app | bool |
|
|
|
| company_id | int8 |
|
|
|
| rate_id | int8 |
|
|
The foreign key for the associated rate. @example 123 |
| client_contribution_amount_cents | int4 |
|
|
Amount in cents that a client pays towards the corresponding purchase order line amount. @example 500 |
| client_contribution_amount_currency | varchar |
|
|
Currency code for client contribution amount. @example AUD |
| unit_type | varchar |
|
|
Unit type for the purchase order line item. @example “cost”, “item”, “hours” |
| created_at_in_company_tz | timestamp |
|
|
|
| updated_at_in_company_tz | timestamp |
|
|
|
| beginning_at_in_company_tz | timestamp |
|
|
|
| ending_at_in_company_tz | timestamp |
|
|
|
| company_timezone | varchar |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| edge_purchase_order_lines_pkey | Primary key | Asc | id |