itemvendor

-- ============================================================
-- Table  : itemvendor — The item sourcing sublist: one row per item, vendor and subsidiary, with the vendor's part code, preferred flag and purchase price.
-- Purpose: Column-selected read of itemvendor — auto-generated from field metadata
-- Grain  : One row per item + vendor + 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.vendor AS "Vendor (internal id)",
  t.subsidiary AS "Subsidiary (internal id)",
  t.vendorcode AS "The vendor's own code for this item",
  t.preferredvendor AS "Preferred source for this item",  -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
  t.purchaseprice AS "Purchase price",
  t.vendorcost AS "Vendor cost",
  t.vendorcostentered AS "Price as entered",
  t.vendorcurrencyid AS "Currency of the vendor cost (internal id)",
  t.schedule AS "Purchase price schedule (internal id)"
FROM <catalog>.<schema>.itemvendor t
WHERE
  t.subsidiary = <subsidiary_id>  -- OneWorld partition — see quirks guide #oneworld
  -- AND t.item = <item>
  -- AND t.vendor = <vendor>
  -- no lastmodifieddate on this record — there is no watermark column, so incremental extraction must full-refresh it (see quirks #deletes)
ORDER BY t.item;