shipitem

-- ============================================================
-- Table  : shipitem — The shipping-item record — which in NetSuite is also the shipping METHOD: one row per method a document can be shipped on, carrying its carrier service codes and the whole rate-and-handling rule set behind the quoted freight.
-- Purpose: Column-selected read of shipitem — auto-generated from field metadata
-- Grain  : One row per id
-- Caution: sixty-six columns, most of them PRICING RULES rather than facts — flat rate, per-item, per-weight, percent-of-total and table-driven variants all coexist, and only the one costbasis names is in force. Read the basis column before reading any rate column.
-- 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.itemid AS "Ship name — the method as named on a document",
  t.displayname AS "Display name/code",
  t.description AS "Description",
  t.costbasis AS "Shipping rate basis (internal id) — decides WHICH rate column below is in force",
  t.shippingflatrateamount AS "Flat shipping rate",
  t.shippingperitemamount AS "Shipping rate charged per item",
  t.shippingbyweightamount AS "Shipping rate charged by weight",
  t.shippingaspercentageoftotal AS "Shipping rate as a percentage of the order total",
  t.minimumshippingcost AS "Minimum shipping cost",
  t.maximumshippingcost AS "Maximum shipping cost",
  t.handlingcost AS "Handling rate basis (internal id) — the handling-side twin of costbasis",
  t.handlingflatrateamount AS "Flat handling rate",
  t.ratingserviceselect AS "Carrier service the rate is quoted against (internal id)",
  t.servicecode AS "Shipper service code (internal id)",
  t.isonline AS "Offered in the web store",  -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
  t.isinactive AS "Inactive",  -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
  t.subsidiary AS "Subsidiaries — labeled in the plural, so no equality anchor is emitted",
  t.externalid AS "External ID"
FROM <catalog>.<schema>.shipitem 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;