F0002

-- ============================================================
-- Table  : F0002 Next numbers — the per-system counters JDE uses to assign document and record numbers
-- Purpose: Column-selected read of F0002 — auto-generated from field metadata
-- Grain  : One row per NNSY
-- Notes  : Auto-generated skeleton. Julian dates (CYYDDD) are converted to DATE and implied-decimal amounts are scaled (verify decimals in F9210); padded business-unit/UDC keys are TRIMmed. Audit columns (…USER/…PID/…UPMJ) are omitted — see the quirks guide. Set catalog/schema to your Unity Catalog location; fill remaining placeholders (<...>) for your tenant.
-- ============================================================
SELECT
  nn.NNSY AS "System code the next-number ranges belong to",
  nn.NNUD01 AS "Label describing what next-number range 1 is used for",
  nn.NNUD02 AS "Label describing what next-number range 2 is used for",
  nn.NNUD03 AS "Label describing what next-number range 3 is used for",
  nn.NNUD04 AS "Label describing what next-number range 4 is used for",
  nn.NNUD05 AS "Label describing what next-number range 5 is used for",
  nn.NNUD06 AS "Label describing what next-number range 6 is used for",
  nn.NNUD07 AS "Label describing what next-number range 7 is used for",
  nn.NNUD08 AS "Label describing what next-number range 8 is used for",
  nn.NNUD09 AS "Label describing what next-number range 9 is used for",
  nn.NNUD10 AS "Label describing what next-number range 10 is used for",
  nn.NNN001 AS "Current next number for range 1",
  nn.NNN002 AS "Current next number for range 2",
  nn.NNN003 AS "Current next number for range 3",
  nn.NNN004 AS "Current next number for range 4",
  nn.NNN005 AS "Current next number for range 5",
  nn.NNN006 AS "Current next number for range 6",
  nn.NNN007 AS "Current next number for range 7",
  nn.NNN008 AS "Current next number for range 8",
  nn.NNN009 AS "Current next number for range 9",
  nn.NNN010 AS "Current next number for range 10",
  nn.NNCK01 AS "Check-digit flag for range 1",
  nn.NNCK02 AS "Check-digit flag for range 2",
  nn.NNCK03 AS "Check-digit flag for range 3",
  nn.NNCK04 AS "Check-digit flag for range 4",
  nn.NNCK05 AS "Check-digit flag for range 5",
  nn.NNCK06 AS "Check-digit flag for range 6",
  nn.NNCK07 AS "Check-digit flag for range 7",
  nn.NNCK08 AS "Check-digit flag for range 8",
  nn.NNCK09 AS "Check-digit flag for range 9",
  nn.NNCK10 AS "Check-digit flag for range 10"
FROM <catalog>.<schema_ctl>.f0002 nn
ORDER BY nn.NNSY;