PurchaseOrderLineItems
Query PurchaseOrderLines within Sage UK 50 Accounts.
Table Specific Information
Select
The PurchaseOrderLineItems table returns purchase order line item information for a Sage 50 UK company dataset.
SELECT * FROM PurchaseOrderLineItems WHERE PurchaseOrderNumber = 'PO123'
Columns
Name | Type | Description |
PurchaseOrderLineItemUUID [KEY] | String | PurchaseOrderLine UUID |
CommodityUUID | String | PurchaseOrderLine Commodity UUID |
CommodityProductCode | String | PurchaseOrderLine Commodity Product Code |
CommodityName | String | PurchaseOrderLine Commodity Name |
PurchaseOrderNumber | String | PurchaseOrderLine Reference |
LineNumber | Decimal | PurchaseOrderLine Number |
DueDate | Date | PurchaseOrderLine Due Date |
Description | String | PurchaseOrderLine Text |
Quantity | Decimal | PurchaseOrderLine Quantity |
InitialPrice | Decimal | PurchaseOrderLine Initial Price |
ActualPrice | Decimal | PurchaseOrderLine Actual Price |
NetTotal | Decimal | PurchaseOrderLine Net Total |
DiscountTotal | Decimal | PurchaseOrderLine Discount Total |
TaxTotal | Decimal | PurchaseOrderLine Tax Total |
GrossTotal | Decimal | PurchaseOrderLine Gross Total |
UnitDescription | String | PurchaseOrderLine UnitOfMeasure Description |
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. |