ODBC Driver for NetSuite

Build 25.0.9434

InvtItemPriceHistory

Tracks historical price adjustments for inventory items, supporting pricing analysis and audit requirements.

Columns

Name Type References Description
internalid [KEY] Integer A unique internal identifier assigned to each price history record for inventory items, used for tracking and referencing specific records.
currency String The currency in which the item's price is recorded, helping in multi-currency environments to differentiate pricing for different regions or transactions.
discount Double The percentage or fixed amount of discount applied to the item, representing markdowns or negotiated reductions in pricing.
item String The identifier or name of the inventory item associated with this pricing history record. This links the price change to a specific product or stock-keeping unit (SKU).
price Decimal The actual price of the inventory item at the time of the recorded entry. This reflects the selling price or cost based on historical data.
pricetype String The price level associated with the recorded price can vary based on the pricing structure set in NetSuite, with examples including 'Base Price,' 'Wholesale Price,' and 'Retail Price.'
quantity Double The minimum purchase quantity required for this price to be applicable, commonly used for volume-based pricing tiers.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434