R03B50

-- ============================================================
-- Program: R03B50 Apply Receipts to Invoices — the batch job that matches unapplied receipts to open invoices using execution-list algorithms, completing automatic cash application.
-- Purpose: Apply Receipts to Invoices — the batch job that matches unapplied receipts to open invoices using execution-list algorithms, completing automatic cash application. — auto-generated boilerplate from program-table-map
-- Grain  : F03B14 × F03B13, F03B11 — 1:N joins yield one row per detail line
-- Tables : F03B14, F03B13, F03B11
-- 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: F0911 is cataloged for this program, but no verified join condition connects it to F03B14, so it is left out of this skeleton. Add the join yourself using the key fields on each table's page.
-- ============================================================
SELECT
  h.RZPYID AS "Payment ID linking back to the F03B13 receipt header",
  h.RZRC5 AS "Line number within the receipt — makes each application row unique",
  h.RZADSC / POWER(10, 2) AS "Discount that was available on the invoice at application time",  -- implied decimals: 2 (verify in F9210)
  f0.RPDCT AS "Invoice document type (RI standard invoice, RM credit memo, RU unapplied cash, etc.)",
  f0.RPKCO AS "Document company that owns the invoice number sequence",
  f0.RPSFX AS "Pay item — one invoice can split into multiple pay items with their own terms"
FROM <catalog>.<schema_data>.f03b14 h
LEFT JOIN <catalog>.<schema_data>.f03b13 f
  ON f.RYPYID = h.RZPYID
LEFT JOIN <catalog>.<schema_data>.f03b11 f0
  ON f0.RPDOC = h.RZDOC
ORDER BY h.RZPYID;