job_groups_v1
Group job is a container that includes multiple individual jobs, treated as a single entity.
| Column | Data type | Description |
|---|---|---|
| id | NUMBER(38,0) | The unique identifier of the group job. |
| reference | VARCHAR(80) | The reference of the group job that is inputted as free text. |
| title | VARCHAR(100) | The group job title. |
| status | VARCHAR(50) | The status of the group job. Possible values: 'Unscheduled', 'Part Scheduled', 'Scheduled', 'In Progress', 'Completed', 'Financially Completed'. |
| created_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of group job creation. |
| deleted_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of group job record soft deletion. |
| start_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of group job start. |
| planned_start_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of group job planned start. |
| planned_end_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of group job planned end. |
| actual_start_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of group job actual start. |
| actual_end_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of group job actual end. |
| purchase_order_number | VARCHAR(80) | The purchase order number (or order number) supplied by the contact to complete the job, inputted as free text. |
| category_name | VARCHAR(100) | The group job category name. |
| financially_completed_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of group job financial completion. |
| financially_completed_at_date | DATE | The date of the group job financial completion. |
| financial_status | VARCHAR(50) | Indicates if the group job is financially complete or not. Possible values: 'Complete', 'Incomplete'. |
| total_net_selling_price_from_job_lines_GBP | NUMBER(10,2) | The total net selling price from group job lines converted into GBP based on exchange rates on the days that the source documents are created. |
| total_net_cost_price_GBP | NUMBER(10,2) | The total net cost from group job lines converted into GBP based on exchange rates on the days that the source documents are created. |
| total_net_selling_price_from_credit_notes_GBP | NUMBER(10,2) | The total net selling price from credit notes converted into GBP based on exchange rates on the days that the source documents are created. |
| total_net_selling_price_source | VARCHAR(8) | Indicates if the source of 'total net selling price from invoices' is derived from an Invoice or a Proforma invoice. Possible values: 'Invoice', 'Proforma', 'None'. |
| total_net_selling_price_from_invoices_GBP | NUMBER(10,2) | The total net selling price from invoices converted into GBP based on exchange rates on the days that the source documents are created. |
| actual_revenue_GBP | NUMBER(11,2) | The invoiced amount in converted into GBP based on exchange rates on the days that the source documents are created. |
| revenue_left_to_invoice_GBP | NUMBER(12,2) | The value of job that is not invoiced yet, converted into GBP based on exchange rates on the days that the source documents are created. |
| profit_from_job_lines_GBP | NUMBER(11,2) | The profit from job lines converted into GBP based on exchange rates on the days that the source documents are created. This value represents profit calculated using job financial lines only and not invoices. |
| margin_from_job_lines_GBP | NUMBER(22,8) | The margin from job lines converted into GBP based on exchange rates on the days that the source documents are created. This value represents margin calculated using job financial lines only and not invoices. |
| actual_profit_GBP | NUMBER(12,2) | The actual profit converted into GBP based on exchange rates on the days that the source documents are created. This value represents profit calculated using invoices and also excludes any credit notes. |
| actual_margin_GBP | NUMBER(23,8) | The actual margin converted into GBP based on exchange rates on the days that the source documents are created. This value represents margin calculated using invoices and also excludes any credit notes. |
| cost_from_purchase_orders_GBP | NUMBER(10,2) | The cost from purchase orders converted into GBP based on exchange rates on the days that the source documents are created. |
| contact_name | VARCHAR(256) | The name of the contact associated with the group job. |
| parent_contact_name | VARCHAR(256) | The parent contact name of the contact associated with the group job. |
| primary_person | VARCHAR(256) | The primary person of the contact. |
| job_site | VARCHAR(423) | The job site of the contact. |
| contact_reference | VARCHAR(80) | The reference of the contact. |
| contact_group | VARCHAR(100) | The group of the contact. |
| geolocation_latitude | FLOAT | The geolocation latitude of the contact. This is the latitude of the centroid of the shape describing contact location on the map. |
| geolocation_longitude | FLOAT | The geolocation longitude of the contact. This is the longitude of the centroid of the shape describing contact location on the map. |
| geolocation | VARCHAR(64) | The concatenated geolocation latitude and longitude of the contact associated with the group job. |
| vehicle_reference | VARCHAR(80) | The vehicle reference associated with the group job. |
| vehicle_group | VARCHAR(100) | The vehicle group of the vehicle associated with the group job. |
| owner_name | VARCHAR(100) | The owner of the group job. |
| is_recurring | VARCHAR(3) | Indicates if the group job is recurring. |
| _sales_opportunity_id | NUMBER(38,0) | The identifier of the sales opportunity associated with the group job. |
| _resource_id | NUMBER(38,0) | The identifier of the resource that has been assigned to the group job. |
| _contact_id | NUMBER(38,0) | The identifier of the contact associated with the group job. |
| _vehicle_id | NUMBER(38,0) | The identifier of the vehicle associated with the group job. |
| _contract_id | NUMBER(38,0) | The identifier of the contract associated with the group job. |
| _last_sync_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of when the group job record was last refreshed. |