F03B14

-- ============================================================
-- Table  : F03B14 Receipts detail: one row per application of a receipt against an invoice pay item, splitting the cash into payment, discount, write-off, chargeback, and deduction amounts.
-- Purpose: Column-selected read of F03B14 — auto-generated from field metadata
-- Grain  : One row per RZPYID + RZRC5
-- 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
  f.RZPYID AS "Payment ID linking back to the F03B13 receipt header",
  f.RZRC5 AS "Line number within the receipt — makes each application row unique",
  f.RZCKNU AS "Receipt/check number repeated from the header for convenience",
  f.RZDOC AS "Invoice document number the cash was applied to",
  f.RZDCT AS "Invoice document type",
  f.RZKCO AS "Invoice document company",
  f.RZSFX AS "Invoice pay item the application hit",
  f.RZAN8 AS "Customer address book number",
  f.RZDCTM AS "Matching document type of the receipt (RC)",
  CASE WHEN f.RZDMTJ IS NULL OR f.RZDMTJ = 0 THEN NULL ELSE DATE_ADD(MAKE_DATE(1900 + CAST(f.RZDMTJ AS INT) DIV 1000, 1, 1), CAST(f.RZDMTJ AS INT) % 1000 - 1) END AS "Receipt date",  -- CYYDDD Julian → DATE
  CASE WHEN f.RZDGJ IS NULL OR f.RZDGJ = 0 THEN NULL ELSE DATE_ADD(MAKE_DATE(1900 + CAST(f.RZDGJ AS INT) DIV 1000, 1, 1), CAST(f.RZDGJ AS INT) % 1000 - 1) END AS "G/L date of the application",  -- CYYDDD Julian → DATE
  f.RZPOST AS "G/L posted code for the application row",
  f.RZGLC AS "G/L offset class used to resolve the A/R trade account",
  f.RZCTRY AS "Century of the G/L date",
  f.RZFY AS "Fiscal year of the G/L date",
  f.RZPN AS "Fiscal period of the G/L date",
  f.RZCO AS "Company of the application",
  f.RZICUT AS "Batch type (RB)",
  f.RZICU AS "Batch number of the receipt batch",
  CASE WHEN f.RZDICJ IS NULL OR f.RZDICJ = 0 THEN NULL ELSE DATE_ADD(MAKE_DATE(1900 + CAST(f.RZDICJ AS INT) DIV 1000, 1, 1), CAST(f.RZDICJ AS INT) % 1000 - 1) END AS "Batch date",  -- CYYDDD Julian → DATE
  f.RZPAAP / POWER(10, 2) AS "Amount of this receipt applied to the invoice, domestic currency",  -- implied decimals: 2 (verify in F9210)
  f.RZADSC / POWER(10, 2) AS "Discount that was available on the invoice at application time",  -- implied decimals: 2 (verify in F9210)
  f.RZADSA / POWER(10, 2) AS "Discount taken as part of the application",  -- implied decimals: 2 (verify in F9210)
  f.RZAAAJ / POWER(10, 2) AS "Amount written off during application",  -- implied decimals: 2 (verify in F9210)
  f.RZECBA / POWER(10, 2) AS "Chargeback amount generated — creates a new invoice for the disputed piece",  -- implied decimals: 2 (verify in F9210)
  f.RZDDA / POWER(10, 2) AS "Deduction amount routed to deduction processing",  -- implied decimals: 2 (verify in F9210)
  f.RZBCRC AS "Base (domestic) currency",
  f.RZCRRM AS "Currency mode — domestic or foreign entry",
  f.RZCRCD AS "Transaction currency of the receipt",
  f.RZCRR AS "Exchange rate used for the application; implied decimals vary by setup",
  f.RZPFAP / POWER(10, 2) AS "Applied amount in the foreign currency",  -- implied decimals: 2 (verify in F9210)
  f.RZAGL / POWER(10, 2) AS "Realized gain or loss recognized on the application",  -- implied decimals: 2 (verify in F9210)
  f.RZRSCO AS "Write-off reason code",
  f.RZECBR AS "Chargeback reason code",
  f.RZDDEX AS "Deduction reason code",
  f.RZTYIN AS "Receipt type code from the header",
  TRIM(f.RZMCU) AS "Business unit of the application",
  f.RZPDLT AS "Partial payment flag",
  CASE WHEN f.RZDDJ IS NULL OR f.RZDDJ = 0 THEN NULL ELSE DATE_ADD(MAKE_DATE(1900 + CAST(f.RZDDJ AS INT) DIV 1000, 1, 1), CAST(f.RZDDJ AS INT) % 1000 - 1) END AS "Net due date of the invoice being paid, useful for on-time payment analysis"  -- CYYDDD Julian → DATE
FROM <catalog>.<schema_data>.f03b14 f
WHERE
  f.RZDGJ >= <DGJ_FROM>  -- Julian CYYDDD, e.g. 126001
  -- AND f.RZDGJ <= <DGJ_TO>  -- Julian CYYDDD, e.g. 126365
ORDER BY f.RZPYID;