SalesCreditLineItems
Query SalesCreditLineItems within Sage UK 50 Accounts.
Table Specific Information
Select
The SalesCreditLineItems table returns sales credit line item information for a Sage 50 UK company dataset.
SELECT * FROM SalesCreditLineItems WHERE CreditNumber = 'CR123'
Columns
| Name | Type | Description |
| SalesCreditLineItemsUUID [KEY] | String | SalesCreditLine UUID |
| CommodityUUID | String | SalesCreditLine Commodity UUID |
| CommodityProductCode | String | SalesCreditLine Commodity Product Code |
| CommodityName | String | SalesCreditLine Commodity Name |
| CreditNumber | String | SalesCredit Reference |
| Reference2 | String | SalesCreditLine Reference2 |
| Type | String | SalesCreditLine Type |
| Number | Decimal | SalesCreditLine Number |
| Description | String | SalesCreditLine Text |
| DeliveryDate | Date | SalesCreditLine Delivery Date |
| Quantity | Decimal | SalesCreditLine Quantity |
| InitialPrice | Decimal | SalesCreditLine Initial Price |
| InvoiceLineDiscountAmount | Decimal | SalesCreditLine Invoice Line Discount Amount |
| InvoiceLineDiscountPercent | Decimal | SalesCreditLine Invoice Line Discount Percent |
| ActualPrice | Decimal | SalesCreditLine Actual Price |
| NetTotal | Decimal | SalesCreditLine Net Total |
| DiscountTotal | Decimal | SalesCreditLine Discount Total |
| TaxTotal | Decimal | SalesCreditLine Tax Total |
| GrossTotal | Decimal | SalesCreditLine Gross Total |
| UnitDescription | String | SalesCreditLine 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. |