R03B551

-- ============================================================
-- Program: R03B551 Update Receipts Header — the batch job in the automatic receipts process that turns uploaded bank payment records into unapplied receipt headers ready for matching.
-- Purpose: Update Receipts Header — the batch job in the automatic receipts process that turns uploaded bank payment records into unapplied receipt headers ready for matching. — auto-generated boilerplate from program-table-map
-- Grain  : One row per F03B13
-- Tables : F03B13
-- 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 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"
FROM <catalog>.<schema_data>.f03b13 h
ORDER BY h.RYPYID;