quantitypricingschedule

-- ============================================================
-- Table  : quantitypricingschedule — Volume-break pricing schedules: one row per schedule, naming the base discount, the unit the breaks are counted in, and whether the discount applies marginally or to the whole order.
-- Purpose: Column-selected read of quantitypricingschedule — auto-generated from field metadata
-- Grain  : One row per id
-- Caution: this record exposes no lastmodifieddate — there is no watermark column here, so incremental extraction must full-refresh the schedules. The BREAKS are not here: this record is the schedule's settings, and the per-level quantity and discount rows live on satellite records this catalog does not carry.
-- Notes  : Auto-generated skeleton for NetSuite data landed in your lakehouse from a SuiteAnalytics Connect (or SuiteQL) extract — it never addresses live NetSuite. Identifiers are lowercase as NetSuite2.com renders them. Select-type columns hold numeric internal ids: BUILTIN.DF() display resolution exists only at extraction time, so decode ids by joining the landed list records; see quirks #display-values. Check-box columns arrive as 'T'/'F' strings; see quirks #tf-booleans.
-- ============================================================
SELECT
  t.id AS "Internal ID",
  t.name AS "Schedule name",
  t.basediscount AS "Discount percentage applied before the breaks",
  t.overallquantitypricingtype AS "What the break quantity is counted over — the line, the item across the order, or the parent item (internal id, no public value list)",
  t.usemarginalrates AS "Discount applies only to the units above each break",  -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
  t.unit AS "Unit the break quantities are stated in (internal id) — resolves to unitstypeuom.internalid",
  t.unitstype AS "Unit-of-measure family (internal id)",
  t.vendor AS "Vendor the schedule applies to (internal id)",
  t.isinactive AS "Inactive",  -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
  t.externalid AS "External ID"
FROM <catalog>.<schema>.quantitypricingschedule t
WHERE
  1 = 1  -- no partition column on this record; the filters below are optional
  -- AND t.id = <id>
  -- no lastmodifieddate on this record — there is no watermark column, so incremental extraction must full-refresh it (see quirks #deletes)
ORDER BY t.id;