Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| purchase_order_id | int8 |
|
|
|
| quantity | numeric |
|
|
|
| price_cents | int4 |
|
|
|
| price_currency | 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 |
|
|
|
| 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 |
| external_id | varchar |
|
|
The optional external ID associated with this PO line, which could refer to a government service code. @example ‘123’ |
| billable_price_cents | int4 |
|
|
Amount in cents that a PO line will be on-charged to clients, inclusive of the unit price. @example 50000 |
| billable_price_currency | varchar |
|
|
The billable price currency code. @example ‘AUD’ |
| billable_price_metadata_id | int8 |
|
|
The billable price metadata ID this purchase order line is associated with. @example 1 |
| unit_type | varchar |
|
|
The unit type of the purchase order line @example: item |
| margin_percentage | numeric |
|
|
The difference between the billable price and the price expressed as a percentage. @example 25.25 |
| status | varchar |
|
|
The status of the service fulfilment. @example scheduled |
| canceled_at | timestamp |
|
|
The time when the service was canceled. @example 2025-07-01T00:00:00Z |
| checkout_link_resent_at | timestamp |
|
|
The time when the checkout link was resent. @example 2025-07-01T00:00:00Z |
| checkout_link_revoked_at | timestamp |
|
|
The time when the checkout link was revoked. @example 2025-07-01T00:00:00Z |
| checkout_link_sent_at | timestamp |
|
|
The time when the checkout link was sent. @example 2025-07-01T00:00:00Z |
| delivered_at | timestamp |
|
|
The time of the service delivery. @example 2025-07-01T00:00:00Z |
| checkout_location_accuracy | float8 |
|
|
The accuracy in metres for the delivery confirmation location. @example 71.958739712940,-29.180364980250 |
| cancelation_reason_id | int8 |
|
|
The reason for cancellation. @example 1 |
| vendor_contact_id | int8 |
|
|
The ID of the vendor contact who is expected to deliver the associated service or goods. @example 1 |
| checked_in_at | timestamp |
|
|
The time of the service check in. @example 2025-07-01T00:00:00Z |
| check_in_location_accuracy | float8 |
|
|
The accuracy in metres for the service check in location. @example 5.5 |
| skip_claims | bool |
|
|
Invoice lines generated from this purchase order line will be excluded from all claims. @example ‘false’ |
| created_at_in_company_tz | timestamp |
|
|
|
| updated_at_in_company_tz | timestamp |
|
|
|
| beginning_at_in_company_tz | timestamp |
|
|
|
| ending_at_in_company_tz | timestamp |
|
|
|
| canceled_at_in_company_tz | timestamp |
|
|
|
| checkout_link_resent_at_in_company_tz | timestamp |
|
|
|
| checkout_link_revoked_at_in_company_tz | timestamp |
|
|
|
| checkout_link_sent_at_in_company_tz | timestamp |
|
|
|
| delivered_at_in_company_tz | timestamp |
|
|
|
| checked_in_at_in_company_tz | timestamp |
|
|
|
| company_timezone | varchar |
|
|
The company timezone. E.g. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| edge_purchase_order_lines_pkey | Primary key | Asc | id |
| idx_edge_purchase_order_lines_billable_price_metadata_id | Performance | Asc | billable_price_metadata_id |
| idx_edge_purchase_order_lines_cancelation_reason_id | Performance | Asc | cancelation_reason_id |
| idx_edge_purchase_order_lines_company_id | Performance | Asc | company_id |
| idx_edge_purchase_order_lines_external_id | Performance | Asc | external_id |
| idx_edge_purchase_order_lines_purchase_order_id | Performance | Asc | purchase_order_id |
| idx_edge_purchase_order_lines_rate_id | Performance | Asc | rate_id |
| idx_edge_purchase_order_lines_supplier_generated_invoice_id | Performance | Asc | supplier_generated_invoice_id |
| idx_edge_purchase_order_lines_tax_id | Performance | Asc | tax_id |
| idx_edge_purchase_order_lines_vendor_contact_id | Performance | Asc | vendor_contact_id |