SOPriceListEntry
Contains the entries for sales order (SO) price lists, including details for specific items, pricing, quantity limits, and associated employee or sale information.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | A unique identifier for the SO price list entry. |
| Pricelistid | String | The identifier of the price list that this entry belongs to. |
| Itemid | String | The identifier of the item associated with this price list entry. |
| Itemname | String | The name of the item associated with this price list entry. |
| Productlineid | String | The product line identifier associated with this price list entry. |
| Datefrom | Datetime | The start date from which the price for the item is valid. |
| Dateto | Datetime | The end date until which the price for the item is valid. |
| Qtylimitmin | Double | The minimum quantity limit for this price list entry. |
| Qtylimitmax | Double | The maximum quantity limit for this price list entry. |
| Value | Double | The price value for the item in the price list entry. |
| Valuetype | String | The type of value used for pricing, such as fixed, percentage, or discount. |
| Fixed | String | Indicates whether the price is fixed for this item. |
| Sale | String | Indicates whether the price list entry is for a sale. |
| Status | String | The current status of the price list entry (e.g., active, inactive). |
| Currency | String | The currency used for the price in this price list entry. |
| Employeekey | Int64 | The identifier of the employee associated with this price list entry. |
| Record_url | String | The URL to view or access this price list entry. |