job_lines_v1
Job lines are financial lines captured against a job.
| Column | Data type | Description |
|---|---|---|
| id | VARCHAR(32) | The unique identifier of the job line. |
| job_reference | VARCHAR(88) | The reference of the job that is inputted as free text. |
| job_group_reference | VARCHAR(88) | The reference of the job group that is inputted as free text. |
| status | VARCHAR(50) | The status of the line. Possible values: 'Complete', 'Incomplete'. |
| type | VARCHAR(50) | The type of the job line. Possible values: 'FreeText', 'Predefined', 'StockItem', 'Worksheet', 'DrivingPlanned', 'DrivingActual', 'WorkPlanned', 'WorkActual', 'Expense', 'Invoice', 'Stock', 'Created', 'RatingTable'. |
| line_order | NUMBER(38,0) | The order in which job lines are captured, represented as a number. |
| created_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of job line creation. |
| deleted_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of job line deletion. |
| description | VARCHAR(2000) | The description of an item on the job line. |
| quantity | NUMBER(8,3) | The quantity of the item described on the job line. |
| currency | VARCHAR(3) | The ISO 4217 currency code of the job line currency. |
| unit_price | NUMBER(10,2) | Price per unit expressed in the currency defined in the 'currency' column. |
| unit_price_GBP | NUMBER(10,2) | The unit price converted into GBP based on the exchange rate on the day that the job line is created. |
| net_price | NUMBER(10,2) | The final price a customer pays for a product or service, excluding any additional fees, taxes, or shipping costs; in the currency defined in the 'currency' column. |
| net_price_GBP | NUMBER(10,2) | The net price converted into GBP based on the exchange rate on the day that the job line is created. |
| tax_amount | NUMBER(10,2) | The tax (VAT) amount in the currency defined in the 'currency' column. |
| tax_amount_GBP | NUMBER(10,2) | The tax (VAT) amount converted into GBP based on the exchange rate on the day that the job line is created. |
| unit_tax_amount | NUMBER(10,2) | The tax (VAT) amount per unit, in the currency defined in the 'currency' column. |
| unit_tax_amount_GBP | NUMBER(10,2) | Unit tax (VAT) amount converted into GBP based on the exchange rate on the day that the job line is created. |
| cost_price | NUMBER(10,2) | Cost incurred to produce or acquire a product or service per unit, expressed in the currency defined in the 'currency' column. |
| cost_price_GBP | NUMBER(10,2) | The cost price converted into GBP based on the exchange rate on the day that the job line is created. |
| cost | NUMBER(10,2) | Cost incurred to produce or acquire a product or service, expressed in the currency defined in the 'currency' column. |
| cost_GBP | NUMBER(10,2) | The cost converted into GBP based on the exchange rate on the day that the job line is created. |
| gross_amount | NUMBER(10,2) | Revenue generated from a transaction before any deductions such as taxes, discounts, fees etc. expressed in the currency defined in the 'currency' column. |
| gross_amount_GBP | NUMBER(10,2) | The gross amount converted into GBP based on the exchange rate on the day that the job line is created. |
| discounted_value | NUMBER(10,2) | The discounted value in the currency defined in the 'currency' column. |
| discounted_value_GBP | NUMBER(10,2) | The discounted value converted into GBP based on the exchange rate on the day that the job line is created. |
| discounted_percentage | NUMBER(5,2) | The discounted percentage. |
| markup_value | NUMBER(10,2) | The markup value in the currency defined in the 'currency' column. |
| markup_value_GBP | NUMBER(10,2) | The markup value converted into GBP based on the exchange rate on the day that the job line is created. |
| markup_percentage | NUMBER(5,2) | The markup percentage. |
| nominal_code | VARCHAR(100) | The nominal code. |
| nominal_code_description | VARCHAR(200) | The nominal code description. |
| department_code | VARCHAR(16) | The department code. |
| department_code_description | VARCHAR(200) | The department code description. |
| tracking_code_1 | NUMBER(38,0) | A code or identifier used to track or categorise specific information related to the job when financial integration is set to Xero. This could be used for various purposes such as project tracking, cost allocation, or analysis. |
| tracking_code_2 | NUMBER(38,0) | Another code or identifier used to track or categorise additional information related to the job when financial integration is set to Xero. Similar to tracking_code_1, it can be used for various purposes based on the organisation's needs. |
| tax_percentage | NUMBER(4,2) | The tax (VAT) percentage. |
| tax_code | VARCHAR(100) | The tax code used to calculate the tax amount. |
| _job_id | NUMBER(38,0) | The identifier of the job associated with the job line. |
| _job_group_id | NUMBER(38,0) | The identifier of the job group associated with the job line. |
| _contract_id | NUMBER(38,0) | The identifier of the contract associated with the line. |
| _contact_id | NUMBER(38,0) | The identifier of the contact associated with the line. |
| _last_sync_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of when the job line record was last refreshed. |