F0414

-- ============================================================
-- Table  : F0414 A/P matching document detail: one row per application of a payment against a voucher pay item, carrying the paid amount and discount taken in both currencies.
-- Purpose: Column-selected read of F0414 — auto-generated from field metadata
-- Grain  : One row per RNPYID + RNRC5
-- 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.RNPYID AS "Payment ID linking back to the F0413 payment header",
  f.RNRC5 AS "Line number within the payment — makes each application row unique",
  f.RNDCTM AS "Matching document type of the payment",
  f.RNKCO AS "Voucher document company",
  f.RNDCT AS "Voucher document type",
  f.RNDOC AS "Voucher document number the payment was applied to",
  f.RNSFX AS "Voucher pay item the application hit",
  f.RNSFXE AS "Pay item extension of the voucher",
  f.RNPAAP / POWER(10, 2) AS "Amount of this payment applied to the voucher, domestic currency",  -- implied decimals: 2 (verify in F9210)
  f.RNADSC / POWER(10, 2) AS "Discount that was available on the voucher",  -- implied decimals: 2 (verify in F9210)
  f.RNADSA / POWER(10, 2) AS "Discount taken as part of the payment",  -- implied decimals: 2 (verify in F9210)
  f.RNPFAP / POWER(10, 2) AS "Applied amount in the foreign currency",  -- implied decimals: 2 (verify in F9210)
  f.RNCDS / POWER(10, 2) AS "Foreign discount available",  -- implied decimals: 2 (verify in F9210)
  f.RNCDSA / POWER(10, 2) AS "Foreign discount taken",  -- implied decimals: 2 (verify in F9210)
  f.RNCRRM AS "Currency mode — domestic or foreign entry",
  f.RNCRCD AS "Transaction currency of the payment",
  f.RNCRR AS "Exchange rate used for the application; implied decimals vary by setup",
  f.RNGLC AS "G/L offset class used to resolve the A/P trade account",
  f.RNPOST AS "G/L posted code for the application row",
  f.RNPN AS "Fiscal period of the G/L date",
  f.RNFY AS "Fiscal year of the G/L date",
  f.RNCTRY AS "Century of the G/L date",
  f.RNAN8 AS "Supplier address book number",
  f.RNCO AS "Company of the application",
  TRIM(f.RNMCU) AS "Business unit of the application",
  f.RNPO AS "Purchase order reference carried from the voucher",
  f.RNBCRC AS "Base (domestic) currency",
  f.RNDRCO AS "Discount reason code"
FROM <catalog>.<schema_data>.f0414 f
ORDER BY f.RNPYID;