previoustransactionlinelink

-- ============================================================
-- Table  : previoustransactionlinelink — The backward line-link table: the exact mirror of nexttransactionlinelink, travelling upstream from an invoice line to the sales-order line it originated on.
-- Purpose: Column-selected read of previoustransactionlinelink — auto-generated from field metadata
-- Grain  : One row per previousdoc + previousline + nextdoc + nextline
-- 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.previousdoc AS "Upstream document being linked to (internal id)",
  t.previousline AS "Upstream line being linked to (internal id)",
  t.nextdoc AS "The document you are standing on (internal id)",
  t.nextline AS "The line you are standing on (internal id)",
  t.previoustype AS "Type of the upstream document",
  t.nexttype AS "Type of the document you are standing on",
  t.linktype AS "Link type (internal id)",
  t.foreignamount AS "Linked amount in transaction currency"
FROM <catalog>.<schema>.previoustransactionlinelink t
WHERE
  1 = 1  -- no partition column on this record; the filters below are optional
  -- AND t.previousdoc = <previousdoc>
  -- AND t.previousline = <previousline>
  -- AND t.nextdoc = <nextdoc>
  -- AND t.nextline = <nextline>
  -- no lastmodifieddate on this record — there is no watermark column, so incremental extraction must full-refresh it (see quirks #deletes)
ORDER BY t.previousdoc;