transactionaccountingline

-- ============================================================
-- Table  : transactionaccountingline — The accounting projection of a transaction line: base-currency amount, debit, credit and net, per accounting book, with the GL account and audit-number stamps.
-- Purpose: Column-selected read of transactionaccountingline — auto-generated from field metadata
-- Grain  : One row per transaction + transactionline + accountingbook
-- Caution: this record duplicates once per accounting book (up to five) and states amounts in the subsidiary's BASE currency, while transactionline states them in transaction currency — anchor an accounting book or every amount multiplies; see quirks #tal-and-books.
-- 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.transaction AS "Transaction (internal id)",
  t.transactionline AS "Transaction line (internal id)",
  t.accountingbook AS "Accounting book (internal id) — anchor this or amounts multiply",
  t.account AS "GL account (internal id)",
  t.posting AS "Line posts to the GL",  -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
  t.amount AS "Amount in the subsidiary's BASE currency",
  t.credit AS "Credit in base currency",
  t.debit AS "Debit in base currency",
  t.netamount AS "Net amount in base currency",
  t.amountpaid AS "Amount paid in base currency",
  t.amountunpaid AS "Amount unpaid in base currency",
  t.exchangerate AS "Exchange rate applied to this book",
  t.glauditnumber AS "GL audit number",
  t.glauditnumberdate AS "GL audit number date",
  t.overheadparentitem AS "Material overhead parent item (internal id)"
FROM <catalog>.<schema>.transactionaccountingline t
WHERE
  1 = 1  -- no partition column on this record; the filters below are optional
  -- AND t.transaction = <transaction>
  -- AND t.transactionline = <transactionline>
  -- AND t.accountingbook = <accountingbook>
  -- no lastmodifieddate on this record — there is no watermark column, so incremental extraction must full-refresh it (see quirks #deletes)
ORDER BY t.transaction;