SalesInvoiceLineItems
Query SalesInvoiceLineItems within Sage UK 50 Accounts.
Table Specific Information
Select
The SalesInvoiceLineItems table returns sales invoice line item information for a Sage 50 UK company dataset.
SELECT * FROM SalesInvoiceLineItems WHERE InvoiceNumber = 'INV123'
Columns
| Name | Type | Description |
| SalesInvoiceLineItemUUID [KEY] | String | SalesInvoiceLine UUID |
| CommodityUUID | String | SalesInvoiceLine Commodity UUID |
| CommodityProductCode | String | SalesInvoiceLine Commodity Product Code |
| CommodityName | String | SalesInvoiceLine Commodity Name |
| InvoiceNumber | String | SalesInvoice Reference |
| Reference2 | String | SalesInvoice Reference2 |
| Type | String | SalesInvoiceLine Type |
| LineNumber | Integer | SalesInvoiceLine Number |
| Text | String | SalesInvoiceLine Text |
| DeliveryDate | Date | SalesInvoiceLine Delivery Date |
| Quantity | Decimal | SalesInvoiceLine Quantity |
| InitialPrice | Decimal | SalesInvoiceLine Initial Price |
| InvoiceLineDiscountAmount | Decimal | SalesInvoiceLine Invoice Line Discount Amount |
| InvoiceLineDiscountPercent | Decimal | SalesInvoiceLine Invoice Line Discount Percent |
| ActualPrice | Decimal | SalesInvoiceLine Actual Price |
| NetTotal | Decimal | SalesInvoiceLine Net Total |
| ChargesTotal | Decimal | SalesInvoiceLine Charges Total |
| DiscountTotal | Decimal | SalesInvoiceLine Discount Total |
| TaxTotal | Decimal | SalesInvoiceLine Tax Total |
| GrossTotal | Decimal | SalesInvoiceLine Gross Total |
| UnitDescription | String | SalesInvoiceLine UnitOfMeasure Description |
| TaxCodeUUID | String | SalesOrderLine Tax Code UUID |
| TaxCodeReference | String | SalesOrderLine Tax Code |
| TaxCodeValue | Decimal | SalesOrderLine Tax Code Value |
| TaxCodeDescription | String | SalesOrderLine Tax Code Description |
| TaxCodeType | String | SalesOrderLine Tax Code Type |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Updated | Datetime | An input used internally to filter records updated at a specific datetime. |