VendPackingSlipJour

-- ============================================================
-- Table  : VendPackingSlipJour Posted product receipt (packing slip) header — one row per receipt posted against a purchase order, the record of when goods physically arrived
-- Purpose: Column-selected read of VendPackingSlipJour — auto-generated from field metadata
-- Grain  : One row per company (dataareaid) + PackingSlipId + PurchId
-- 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.packingslipid AS "The vendor's packing slip / product receipt number",
  v.purchid AS "Purchase order the receipt was posted against — the same slip number can recur across vendors, so the order is part of the key",
  v.deliverydate AS "Date the goods were received; the primary analysis date",
  v.orderaccount AS "Vendor account the goods were ordered from",
  v.invoiceaccount AS "Vendor account the eventual invoice settles against",
  CASE WHEN CAST(v.documentdate AS DATE) = DATE '1900-01-01' THEN NULL ELSE CAST(v.documentdate AS DATE) END AS "The vendor's document date; unset rows carry the 1900-01-01 sentinel",  -- 1900-01-01 sentinel → NULL
  v.deliveryname AS "Name at the receiving address",
  v.dlvmode AS "Mode of delivery for the receipt",
  v.dlvterm AS "Delivery terms for the receipt",
  v.purchasetype AS "Kind of order the receipt belongs to",  -- enum: decode v.purchasetype via GlobalOptionsetMetadata join — see quirks guide #enums
  v.requester AS "RecId of the worker who requested the goods",
  v.intercompanysalesid AS "Intercompany sales order that shipped the goods, when sourced from a sister company",
  v.freightslipnum AS "Freight slip number from the carrier",
  v.numbersequencegroup AS "Number sequence group the receipt number was drawn from",
  v.defaultdimension AS "RecId of the receipt's default financial-dimension value set in DimensionAttributeValueSet"
FROM <catalog>.<schema>.vendpackingslipjour v
WHERE
  v.dataareaid = '<company>'
  -- AND v.purchid = '<PurchId>'
  -- AND v.deliverydate >= '<DATE_FROM>'  -- yyyy-MM-dd (UTC)
  -- AND v.deliverydate <= '<DATE_TO>'  -- yyyy-MM-dd (UTC)
ORDER BY v.packingslipid;