quote_lines_v1
Quote lines are financial lines captured on a Quote document.
| Column | Data type | Description |
|---|---|---|
| id | VARCHAR(32) | The unique identifier of the quote 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. |
| reference | VARCHAR(80) | The reference of the quote. |
| status | VARCHAR(50) | The status of the quote. Possible values: 'Sent', 'Created', 'Paid'. |
| type | VARCHAR(50) | The type of the quote 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 quote lines are captured, represented as a number. |
| created_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of quote line creation. |
| deleted_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of quote line deletion. |
| description | VARCHAR(2000) | The description of an item on quote line. |
| quantity | NUMBER(8,3) | The quantity of the described item on the quote line. |
| currency | VARCHAR(3) | The ISO 4217 currency code of the quote 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 quote 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 quote 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 quote 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 quote 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 quote 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 quote 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 quote 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 quote 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 quote 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. |
| tax_percentage | NUMBER(4,2) | The tax (VAT) percentage. |
| tax_code | VARCHAR(100) | The tax (VAT) code. |
| tracking_code_1 | NUMBER(38,0) | A code or identifier used to track or categorise specific information related to the quote 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 quote 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. |
| _quote_id | NUMBER(38,0) | The identifier of the quote. |
| _job_id | NUMBER(38,0) | The identifier of the job associated with the quote line. |
| _job_group_id | NUMBER(38,0) | The identifier of the job group associated with the quote 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 quote line record was last refreshed. |