POZ_SUPPLIERS

-- ============================================================
-- Table  : POZ_SUPPLIERS — The supplier master — one row per supplier with the supplier number, type, business relationship level, and tax attributes, backed by the trading community architecture through its party id
-- Purpose: Column-selected read of POZ_SUPPLIERS — auto-generated from field metadata
-- Grain  : One row per VENDOR_ID
-- Notes  : Auto-generated skeleton for Oracle Fusion Cloud data landed in your lakehouse by a BICC extract — there is no SQL path to the SaaS database. Column names follow Oracle's table documentation — if your landed data still carries PVO attribute headers, map names first; see quirks #pvo-drift. Dates are real DATE/TIMESTAMP columns — no conversion needed. WHO audit columns omitted (see the quirks guide); the optional LAST_UPDATE_DATE watermark filter supports incremental extracts.
-- ============================================================
SELECT
  t.VENDOR_ID AS "Supplier surrogate key — what every PO table joins on",
  t.PARTY_ID AS "TCA party — where the supplier NAME lives; there is no name column here",
  t.SEGMENT1 AS "The supplier number — a naming collision with flexfields, not a flexfield",
  t.VENDOR_TYPE_LOOKUP_CODE AS "Supplier type classification",
  t.BUSINESS_RELATIONSHIP AS "Prospective vs spend-authorized relationship level",
  t.START_DATE_ACTIVE AS "Active-from date",
  t.END_DATE_ACTIVE AS "Active-to date",
  t.ONE_TIME_FLAG AS "One-time supplier indicator",
  t.PARENT_VENDOR_ID AS "Parent supplier in a hierarchy",
  t.CUSTOMER_NUM AS "Your account number with the supplier",
  t.FEDERAL_REPORTABLE_FLAG AS "US 1099 federal reportability",
  t.ORGANIZATION_TYPE_LOOKUP_CODE AS "IRS organization type"
FROM <catalog>.<schema>.POZ_SUPPLIERS t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.VENDOR_ID = <VENDOR_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.VENDOR_ID;