VendTable

-- ============================================================
-- Table  : VendTable Vendor master — one row per vendor account, with the RecId link to its global-address-book party
-- Purpose: Column-selected read of VendTable — auto-generated from field metadata
-- Grain  : One row per company (dataareaid) + AccountNum
-- Notes  : Auto-generated skeleton for Synapse Link / Fabric Link-landed F&O data (lowercase column names). Enums decoded inline where verified; datetimes stored in UTC; 1900-01-01 dates are sentinels mapped to NULL. System/audit columns omitted — see the quirks guide.
-- ============================================================
SELECT
  v.accountnum AS "The vendor account number — the natural key",
  v.party AS "RecId of the global-address-book party in DirPartyTable this vendor resolves to for its name",
  v.vendgroup AS "Vendor group for posting and reporting",
  v.invoiceaccount AS "Account invoices from this vendor are settled against",
  v.blocked AS "Whether the vendor is blocked for transactions",  -- enum: decode v.blocked via GlobalOptionsetMetadata join — see quirks guide #enums
  v.currency AS "Default currency for the vendor's orders and invoices",
  v.paymtermid AS "Terms of payment agreed with the vendor",
  v.paymmode AS "Default method of payment",
  v.cashdisc AS "Cash discount code agreed with the vendor",
  v.dlvterm AS "Default delivery terms",
  v.dlvmode AS "Default mode of delivery",
  v.taxgroup AS "Sales tax group applied to the vendor's transactions",
  v.vatnum AS "The vendor's VAT / tax registration number",
  v.defaultdimension AS "RecId of the vendor's default financial-dimension value set in DimensionAttributeValueSet",
  v.bankaccount AS "Default vendor bank account payments are sent to",
  v.creditmax AS "Credit limit granted by the vendor",
  v.onetimevendor AS "Whether the account is a one-time vendor",  -- enum: decode v.onetimevendor via GlobalOptionsetMetadata join — see quirks guide #enums
  v.itembuyergroupid AS "Buyer group responsible for the vendor",
  v.inventsiteid AS "Default receiving site for the vendor's orders",
  v.inventlocation AS "Default receiving warehouse — note the field is InventLocation, without the Id suffix",
  v.clearingperiod AS "Payment clearing period for the vendor",
  v.purchpoolid AS "Purchase pool new orders for the vendor default into",
  v.linedisc AS "Line discount group for purchase price lookups",
  v.enddisc AS "Total (end) discount group",
  v.pricegroup AS "Price group used for purchase price lookups"
FROM <catalog>.<schema>.vendtable v
-- Resolve DirPartyTable (via Party): uncomment to join on its RecId surrogate key
-- LEFT JOIN <catalog>.<schema>.dirpartytable dir ON dir.recid = v.party
-- Resolve DimensionAttributeValueSet (via DefaultDimension): uncomment to join on its RecId surrogate key
-- LEFT JOIN <catalog>.<schema>.dimensionattributevalueset dim ON dim.recid = v.defaultdimension
WHERE
  v.dataareaid = '<company>'
  -- AND v.accountnum = '<VendAccount>'
ORDER BY v.accountnum;