itemsubsidiarymap

-- ============================================================
-- Table  : itemsubsidiarymap — The item-to-subsidiary bridge: two columns, one row per item per subsidiary the item is available in. This is the item side of OneWorld scoping.
-- Purpose: Column-selected read of itemsubsidiarymap — auto-generated from field metadata
-- Grain  : One row per item + subsidiary
-- 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.item AS "Item (internal id)",
  t.subsidiary AS "Subsidiary (internal id)"
FROM <catalog>.<schema>.itemsubsidiarymap t
WHERE
  t.subsidiary = <subsidiary_id>  -- OneWorld partition — see quirks guide #oneworld
  -- AND t.item = <item>
  -- no lastmodifieddate on this record — there is no watermark column, so incremental extraction must full-refresh it (see quirks #deletes)
ORDER BY t.item;