transactionshippingaddress

-- ============================================================
-- Table  : transactionshippingaddress — The shipping address as it was stamped on a document: the formatted block plus the parsed lines, city, state, zip, country and phone, keyed by the address key the transaction header points at.
-- Purpose: Column-selected read of transactionshippingaddress — auto-generated from field metadata
-- Grain  : One row per nkey
-- Caution: this is the address AT THE TIME OF THE DOCUMENT, not the customer's current address — never substitute the entity record's address for it when restating history.
-- 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.nkey AS "Address key — what transaction.shippingaddress resolves to",
  t.addressee AS "Addressee",
  t.attention AS "Attention line",
  t.addrtext AS "The whole address as one formatted block",
  t.addr1 AS "Address line 1",
  t.addr2 AS "Address line 2",
  t.addr3 AS "Address line 3",
  t.city AS "City",
  t.state AS "State or province as text",
  t.dropdownstate AS "State or province (internal id)",
  t.zip AS "Postal code",
  t.country AS "Country (internal id)",
  t.addrphone AS "Phone",
  t.override AS "Address was edited away from the entity default on this document"  -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
FROM <catalog>.<schema>.transactionshippingaddress t
WHERE
  1 = 1  -- no partition column on this record; the filters below are optional
  -- no lastmodifieddate on this record — there is no watermark column, so incremental extraction must full-refresh it (see quirks #deletes)
ORDER BY t.nkey;