deletedrecord

-- ============================================================
-- Table  : deletedrecord — The deletion ledger: one row per deleted record with its type, name, script id, who deleted it and when. The only public evidence that something disappeared.
-- Purpose: Column-selected read of deletedrecord — auto-generated from field metadata
-- Grain  : One row per record — see the Fields section for the full key
-- Caution: this ledger records deleted RECORDS, not deleted LINES — a line removed from a surviving transaction never appears here, so line tables need a periodic full refresh; see quirks #deletes.
-- 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.recordtypeid AS "Record type deleted, as text",
  t.type AS "Type of the deleted record, as text",
  t.name AS "Name of the deleted record",
  t.scriptid AS "Script id of the deleted record",
  t.deleteddate AS "When the record was deleted",
  t.deletedby AS "Who deleted it (internal id)",
  t.context AS "Context the deletion came from (internal id)",
  t.iscustomrecord AS "Deleted record was a custom record",  -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
  t.iscustomlist AS "Deleted record was a custom list",  -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
  t.iscustomtransaction AS "Deleted record was a custom transaction"  -- 'T'/'F' string — compare = 'T', or CAST via CASE; see quirks #tf-booleans
FROM <catalog>.<schema>.deletedrecord t
WHERE
  1 = 1  -- no partition column on this record; the filters below are optional
  -- AND t.deleteddate >= TIMESTAMP '<DATE_FROM>'
  -- AND t.deleteddate <= TIMESTAMP '<DATE_TO>'
  -- no lastmodifieddate on this record — there is no watermark column, so incremental extraction must full-refresh it (see quirks #deletes)
;