This simple SuiteQL query returns the pricing from a selected list of price levels for an item:

http://SELECT

    p.item,

    p.pricelevel,

    BUILTIN.DF(p.pricelevel) AS price_level_name,

    p.priceqty AS quantity_break,

    p.price AS unit_price

FROM

    itemprice p

WHERE

    p.item = 1786

AND

    p.pricelevel IN (215,216,217,218,219,220)


ORDER BY

    p.item, p.pricelevel, p.priceqty

The item has quantity pricing applied:

The SuiteQL returns this:

It would appear the priceqty field is some kind of ID for the actual quantity that is set on each Item record here:

Is there a way to access the actual value of the quantity break using SuiteQL?