P03B102

-- ============================================================
-- Program: P03B102 Standard Receipts Entry — the screen where cash receipts are entered and applied against open invoices, handling short pays, chargebacks, and unearned discounts.
-- Purpose: Standard Receipts Entry — the screen where cash receipts are entered and applied against open invoices, handling short pays, chargebacks, and unearned discounts. — auto-generated boilerplate from program-table-map
-- Grain  : F03B13 × F03B14 — 1:N joins yield one row per detail line
-- Tables : F03B13, F03B14
-- 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: F03B11, F03012, F0911 are cataloged for this program, but no verified join condition connects them to F03B13, so they are left out of this skeleton. Add the join yourself using the key fields on each table's page.
-- ============================================================
SELECT
  h.RYPYID AS "System-assigned payment ID — the key that receipt detail rows hang off",
  h.RYALPH AS "Customer name captured at entry, handy for quick lookups without joining F0101",
  f.RZRC5 AS "Line number within the receipt — makes each application row unique"
FROM <catalog>.<schema_data>.f03b13 h
LEFT JOIN <catalog>.<schema_data>.f03b14 f
  ON f.RZPYID = h.RYPYID
ORDER BY h.RYPYID;