POPriceListEntry
Captures line-level pricing rules for POs, detailing item-specific rates, quantities, effective dates, and conditions.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | Unique identifier for the price list entry. |
| Pricelistid | String | Identifier for the price list associated with the entry. |
| Itemid | String | Identifier for the item associated with the price list entry. |
| Itemname | String | Name of the item associated with the price list entry. |
| Productlineid | String | Identifier for the product line associated with the entry. |
| Datefrom | Datetime | Start date for the price list entry's validity period. |
| Dateto | Datetime | End date for the price list entry's validity period. |
| Qtylimitmin | Double | Minimum quantity limit for the price list entry. |
| Qtylimitmax | Double | Maximum quantity limit for the price list entry. |
| Value | Double | Value associated with the price list entry. |
| Valuetype | String | Type of value (e.g., fixed or percentage) for the price list entry. |
| Fixed | String | Indicates if the price is fixed for the entry. |
| Sale | String | Indicates if the entry is related to a sale. |
| Status | String | Current status of the price list entry. |
| Currency | String | Currency used for the price list entry. |
| Employeekey | Int64 | Key for the employee associated with the price list entry. |
| Record_url | String | URL linking to the record associated with the price list entry. |