nexttransactionlinelink

-- ============================================================
-- Table  : nexttransactionlinelink — The forward line-link table: one row per line-to-line link travelling downstream — a sales-order line to its fulfillment line, a fulfillment line to its invoice line — with the link type and linked amount.
-- Purpose: Column-selected read of nexttransactionlinelink — 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 "The document you are standing on (internal id)",
  t.previousline AS "The line you are standing on (internal id)",
  t.nextdoc AS "Downstream document (internal id)",
  t.nextline AS "Downstream line (internal id)",
  t.previoustype AS "Type of the document you are standing on",
  t.nexttype AS "Type of the downstream document",
  t.linktype AS "Link type (internal id)",
  t.foreignamount AS "Linked amount in transaction currency"
FROM <catalog>.<schema>.nexttransactionlinelink 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;