F0401

-- ============================================================
-- Table  : F0401 Supplier master - A/P defaults, payment controls, and purchasing settings for each supplier address number
-- Purpose: Column-selected read of F0401 — auto-generated from field metadata
-- Grain  : One row per A6AN8
-- 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.A6AN8 AS "Supplier address book number - joins to F0101",
  f.A6APC AS "Default G/L class controlling the A/P trade offset account",
  TRIM(f.A6MCUP) AS "Default business unit for A/P vouchers; right-justified, space-padded to 12",
  f.A6OBAP AS "Default expense object account for voucher distribution",
  f.A6AIDP AS "Default subsidiary for voucher distribution",
  f.A6CRRP AS "Default currency for vouchers to this supplier",
  f.A6TXA2 AS "Default tax rate/area for purchases from this supplier",
  f.A6EXR2 AS "Default tax explanation code for purchases",
  f.A6HDPY AS "Payment hold code - blocks payments to this supplier when set",
  f.A6TRAP AS "Default A/P payment terms",
  f.A6SCK AS "Payment creation method (one check per voucher vs summarized)",
  f.A6PYIN AS "Default payment instrument (check, EFT, draft, etc.)",
  f.A6SNTO AS "Approver address number for logged vouchers",
  f.A6FLD AS "Float days added when scheduling payments",
  f.A6CRCA AS "Currency the address book amount buckets are held in",
  f.A6AYPD / POWER(10, 2) AS "Amount vouchered year-to-date",  -- implied decimals: 2 (verify in F9210)
  f.A6APPD / POWER(10, 2) AS "Amount vouchered in the prior year",  -- implied decimals: 2 (verify in F9210)
  f.A6ABAM / POWER(10, 2) AS "User-maintained address book amount bucket",  -- implied decimals: 2 (verify in F9210)
  f.A6ABA1 / POWER(10, 2) AS "Second user-maintained address book amount bucket",  -- implied decimals: 2 (verify in F9210)
  f.A6APRC / POWER(10, 2) AS "Open purchase order amount outstanding with this supplier",  -- implied decimals: 2 (verify in F9210)
  f.A6MINO AS "Minimum allowed order value",
  f.A6MAXO AS "Maximum allowed order value",
  f.A6AN8R AS "Related address number (e.g. parent company or factor/payee)",
  f.A6CPGP AS "Price group used for supplier pricing",
  f.A6ORTP AS "Default order template",
  f.A6INMG AS "Print message code",
  f.A6HOLD AS "Hold code automatically applied to new orders for this supplier",
  f.A6ROUT AS "Delivery route code",
  f.A6STOP AS "Delivery stop code",
  f.A6ZON AS "Delivery zone code",
  f.A6ANCR AS "Preferred carrier address number",
  f.A6CARS AS "Secondary carrier address number",
  f.A6LTDT AS "Transit lead time in days",
  f.A6FRTH AS "Freight handling code",
  f.A6INVC AS "Number of invoice copies to print",
  f.A6EDPM AS "EDI batch processing mode",
  f.A6ASN AS "Price and adjustment schedule",
  f.A6CRMD AS "Preferred method for sending documents to this supplier",
  f.A6AVCH AS "Evaluated receipt settlement flag - voucher created automatically at receipt",
  f.A6ATRL AS "Voucher-automation rule for this supplier"
FROM <catalog>.<schema_data>.f0401 f
WHERE
  f.A6AN8 = <AN8>
ORDER BY f.A6AN8;