customersubsidiaryrelationship

-- ============================================================
-- Table  : customersubsidiaryrelationship — The OneWorld customer bridge: one row per customer per subsidiary the customer is shared with, carrying that subsidiary's receivable, deposit and unbilled-order balances.
-- Purpose: Column-selected read of customersubsidiaryrelationship — 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 "Customer (internal id)",
  t.subsidiary AS "Subsidiary (internal id)",
  t.isprimarysub AS "The customer'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.balance AS "Receivable balance for this subsidiary",
  t.depositbalance AS "Customer deposits held by this subsidiary",
  t.unbilledorders AS "Unbilled orders for this subsidiary",
  t.name AS "Relationship name (unlabeled on the browser page)",
  t.externalid AS "External ID"
FROM <catalog>.<schema>.customersubsidiaryrelationship 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;