InvPriceListEntry

Provides line-item level pricing data for price lists, including quantity breaks, item-specific pricing, and related conditions.

Columns


Name	Type	Description
Recordno [KEY]	String	The unique identifier for the invoice price list entry record.
Pricelistid	String	The ID of the price list associated with this entry.
Itemid	String	The unique identifier of the item in this price list entry.
Itemname	String	The name of the item in this price list entry.
Productlineid	String	The ID of the product line that the item belongs to.
Datefrom	Datetime	The start date of the price list entry validity.
Dateto	Datetime	The end date of the price list entry validity.
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 or value associated with this entry.
Valuetype	String	The type of value (e.g., fixed, percentage) applied to this entry.
Fixed	String	Indicates whether the price is fixed for this entry.
Sale	String	Indicates whether the entry is for sale.
Status	String	The 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 key identifying the employee associated with this entry.
Record_url	String	The URL linking to the invoice price list entry record.