F0014

-- ============================================================
-- Table  : F0014 Payment terms definitions: discount percentage and window, net days to pay, and split/installment settings referenced by customer and supplier masters.
-- Purpose: Column-selected read of F0014 — auto-generated from field metadata
-- Grain  : One row per PNPTC
-- 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.PNPTC AS "Payment terms code referenced by customers, suppliers, invoices, and vouchers.",
  f.PNPTD AS "Payment terms name.",
  f.PNDCP AS "Early-payment discount percentage, stored as a decimal fraction. Implied decimals vary by setup, so no fixed scaling is applied.",
  f.PNDCD AS "Number of days the discount window stays open.",
  f.PNNDTP AS "Days from the base date until net payment is due.",
  CASE WHEN f.PNDDJ IS NULL OR f.PNDDJ = 0 THEN NULL ELSE DATE_ADD(MAKE_DATE(1900 + CAST(f.PNDDJ AS INT) DIV 1000, 1, 1), CAST(f.PNDDJ AS INT) % 1000 - 1) END AS "Fixed due date used instead of day counts, when populated.",  -- CYYDDD Julian → DATE
  f.PNNSP AS "Number of equal split payments the terms create.",
  f.PNDTPA AS "Days-to-pay figure used for aging comparisons.",
  f.PNEIR AS "Effective annual interest rate implied by the terms. Implied decimals vary by setup, so no fixed scaling is applied.",
  f.PNPXDM AS "Due month used by proximate-date terms.",
  f.PNPXDD AS "Due day used by proximate-date terms."
FROM <catalog>.<schema_data>.f0014 f
ORDER BY f.PNPTC;