P04571

-- ============================================================
-- Program: P04571 Work With Payment Groups — the screen that steps payment groups through write and update: printing checks or EFT files, then posting payments against vouchers.
-- Purpose: Work With Payment Groups — the screen that steps payment groups through write and update: printing checks or EFT files, then posting payments against vouchers. — auto-generated boilerplate from program-table-map
-- Grain  : F0413 × F0414 — 1:N joins yield one row per detail line
-- Tables : F0413, F0414
-- Notes  : Auto-generated skeleton. Julian dates are converted to DATE and implied-decimal amounts are scaled (verify decimals in F9210). 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.
-- Omitted: F0411, F0911 are cataloged for this program, but no verified join condition connects them to F0413, so they are left out of this skeleton. Add the join yourself using the key fields on each table's page.
-- ============================================================
SELECT
  h.RMPYID AS "System-assigned payment ID — the key detail application rows hang off",
  f.RNRC5 AS "Line number within the payment — makes each application row unique"
FROM <catalog>.<schema_data>.f0413 h
LEFT JOIN <catalog>.<schema_data>.f0414 f
  ON f.RNPYID = h.RMPYID
ORDER BY h.RMPYID;