location

-- ============================================================
-- Table  : location — The location master: stocking sites, stores and virtual locations, hierarchical through parent, carrying the inventory-availability, bin and warehouse-management switches that decide how stock behaves at a site.
-- Purpose: Column-selected read of location — auto-generated from field metadata
-- Grain  : One row per id
-- Caution: `subsidiary` on this record is a MULTISELECT (a location can serve several subsidiaries) — it is NOT an equality filter, so no subsidiary anchor is emitted here. The normalized link is a separate location-to-subsidiary map record, which this catalog does not carry.
-- 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.name AS "Location name",
  t.fullname AS "Full hierarchical name",
  t.parent AS "Parent location (internal id)",
  t.subsidiary AS "Subsidiaries — MULTISELECT, not a scalar foreign key",
  t.locationtype AS "Location type (internal id)",
  t.isinactive AS "Inactive",  -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
  t.makeinventoryavailable AS "Stock at this site is available to commit",  -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
  t.includeinsupplyplanning AS "Site participates in supply planning",  -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
  t.includechildren AS "Sublocations roll up",  -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
  t.usebins AS "Bin management enabled",  -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
  t.usewarehousemanagement AS "Warehouse management enabled",  -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
  t.dailyshippingcapacity AS "Daily shipping capacity",
  t.latitude AS "Latitude",
  t.longitude AS "Longitude",
  t.tranprefix AS "Document number prefix",
  t.externalid AS "External ID"
FROM <catalog>.<schema>.location t
WHERE
  1 = 1  -- no partition column on this record; the filters below are optional
  -- AND t.id = <id>
  -- no lastmodifieddate on this record — there is no watermark column, so incremental extraction must full-refresh it (see quirks #deletes)
ORDER BY t.id;