inventorynumber

-- ============================================================
-- Table  : inventorynumber — The lot and serial master: one row per lot or serial number per item, with the expiration date and the quantity rollups for that number.
-- Purpose: Column-selected read of inventorynumber — auto-generated from field metadata
-- Grain  : One row per id + item
-- 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.item AS "Item (internal id)",
  t.inventorynumber AS "The lot or serial number itself",
  t.expirationdate AS "Expiration date — the only place it is recorded",
  t.quantityonhand AS "Quantity on hand for this number",
  t.quantityavailable AS "Quantity available",
  t.quantityintransit AS "Quantity in transit",
  t.quantityonorder AS "Quantity on order",
  t.memo AS "Memo",
  t.externalid AS "External ID"
FROM <catalog>.<schema>.inventorynumber t
WHERE
  1 = 1  -- no partition column on this record; the filters below are optional
  -- AND t.id = <id>
  -- AND t.item = <item>
  -- AND t.expirationdate >= DATE '<DATE_FROM>'
  -- AND t.expirationdate <= DATE '<DATE_TO>'
  -- no lastmodifieddate on this record — there is no watermark column, so incremental extraction must full-refresh it (see quirks #deletes)
ORDER BY t.id;