SalesOrderLineItems
Query SalesOrderLineItems within Sage UK 50 Accounts.
Table Specific Information
Select
The SalesOrderLineItems table returns sales order line item information for a Sage 50 UK company dataset.
SELECT * FROM SalesOrderLineItems WHERE SalesOrderNumber = 'SO123'
Columns
| Name | Type | Description |
| SalesOrderLineItemUUID [KEY] | String | SalesOrderLine UUID |
| CommodityUUID | String | SalesOrderLine Commodity UUID |
| CommodityProductCode | String | SalesOrderLine Commodity Product Code |
| CommodityName | String | SalesOrderLine Commodity Name |
| SalesOrderNumber | String | SalesOrderLine Reference |
| Reference2 | String | SalesOrderLine Reference2 |
| LineNumber | Decimal | SalesOrderLine Number |
| Type | String | SalesOrderLine Type |
| Description | String | SalesOrderLine Text |
| DueDate | Date | SalesOrderLine Due Date |
| CarrierReference | String | SalesOrderLine Carrier reference |
| Quantity | Decimal | SalesOrderLine Quantity |
| InitialPrice | Decimal | SalesOrderLine Initial Price |
| OrderLineDiscountAmount | Decimal | SalesOrderLine Order Line Discount Amount |
| OrderLineDiscountPercent | Decimal | SalesOrderLine Order Line Discount Perecent |
| ActualPrice | Decimal | SalesOrderLine Actual Price |
| NetTotal | Decimal | SalesOrderLine Net Total |
| DiscountTotal | Decimal | SalesOrderLine Discount Total |
| TaxTotal | Decimal | SalesOrderLine Tax Total |
| GrossTotal | Decimal | SalesOrderLine Gross Total |
| UnitDescription | String | SalesOrderLine 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. |