invoice_lines_v1
Invoice lines are financial lines captured on an Invoice document.
| Column | Data type | Description |
|---|---|---|
| id | VARCHAR(32) | The unique identifier of the invoice 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 invoice. |
| status | VARCHAR(50) | The status of the invoice. Possible values: 'Sent', 'Created', 'Paid'. |
| type | VARCHAR(50) | The type of the invoice 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 invoice lines are captured, represented as a number. |
| created_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of invoice line creation. |
| deleted_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of invoice line deletion. |
| description | VARCHAR(2000) | The description of an item on the invoice line. |
| quantity | NUMBER(8,3) | The quantity of the described item on an invoice line. |
| currency | VARCHAR(3) | The ISO 4217 currency code of the invoice 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 invoice 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 invoice 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 invoice 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 invoice 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 invoice 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 invoice 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 invoice 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 invoice 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 invoice 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 invoice 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 invoice 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 (VAT) code. |
| _invoice_id | NUMBER(38,0) | The identifier of the invoice. |
| _job_id | NUMBER(38,0) | The identifier of the job associated with the invoice line. |
| _job_group_id | NUMBER(38,0) | The identifier of the job group associated with the invoice 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 invoice line record was last refreshed. |