ODBC Driver for NetSuite

Build 25.0.9434

quantityPricingSchedule

Contains details about quantity-based pricing structures, including pricing tiers and applicable discounts for bulk purchases.

Columns

Name Type References Description
id [KEY] Integer The internal identifier (Id) for the quantity pricing schedule. This unique Id is automatically assigned by NetSuite and is used to reference the schedule in scripts, reports, and integrations.
basediscount Double The base percentage discount applied to pricing tiers. This discount serves as a foundational reduction before any additional quantity-based adjustments are applied.
isinactive Boolean Indicates whether the quantity pricing schedule is inactive. When set to 'true,' the schedule is no longer available for use in pricing calculations.
name String The name assigned to the quantity pricing schedule. This name is used for reference within NetSuite when selecting or managing pricing schedules.
overallquantitypricingtype String Defines how quantity-based discounts are calculated for this schedule. Possible values determine whether discounts are applied cumulatively or based on individual pricing tiers.
unit String The unit of measure associated with this quantity pricing schedule. This determines how quantity breaks are measured, such as by individual items, cases, or another unit type.
unitstype String The classification of units applicable to this pricing schedule. This ensures that the correct units are used for quantity-based discount calculations.
usemarginalrates Boolean Specifies whether marginal rates are used when applying discounts. If enabled, discount rates are applied incrementally across pricing tiers instead of using a flat rate.

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