vendorsubsidiaryrelationship

-- ============================================================
-- Table  : vendorsubsidiaryrelationship — The OneWorld vendor bridge: one row per vendor per subsidiary, with payables, in-transit and unbilled balances in both the relationship currency and the base currency, plus the per-subsidiary credit limit.
-- Purpose: Column-selected read of vendorsubsidiaryrelationship — auto-generated from field metadata
-- Grain  : One row per id + entity + 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.id AS "Internal ID",
  t.entity AS "Vendor (internal id)",
  t.subsidiary AS "Subsidiary (internal id)",
  t.isprimarysub AS "The vendor's primary subsidiary",  -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
  t.primarycurrency AS "Currency for this relationship (internal id)",
  t.basecurrency AS "Base currency of the subsidiary (internal id)",
  t.balance AS "Payable balance in the relationship currency",
  t.balancebase AS "Payable balance in the base currency",
  t.intransitbalance AS "In-transit payments in the relationship currency",
  t.baseintransitbalance AS "In-transit payments in the base currency",
  t.unbilledorders AS "Unbilled orders in the relationship currency",
  t.unbilledordersbase AS "Unbilled orders in the base currency",
  t.creditlimit AS "Credit limit for this subsidiary",
  t.name AS "Relationship name (unlabeled on the browser page)",
  t.externalid AS "External ID"
FROM <catalog>.<schema>.vendorsubsidiaryrelationship t
WHERE
  t.subsidiary = <subsidiary_id>  -- OneWorld partition — see quirks guide #oneworld
  -- AND t.id = <id>
  -- AND t.entity = <entity>
  -- no lastmodifieddate on this record — there is no watermark column, so incremental extraction must full-refresh it (see quirks #deletes)
ORDER BY t.id;