CustPackingSlipJour

-- ============================================================
-- Table  : CustPackingSlipJour Posted packing-slip header — one row per shipment document posted against a sales order, with delivery date, ship-to address reference, and carrier details
-- Purpose: Column-selected read of CustPackingSlipJour — auto-generated from field metadata
-- Grain  : One row per company (dataareaid) + PackingSlipId + SalesId + DeliveryDate
-- 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
  c.packingslipid AS "The packing-slip number; unique together with SalesId and DeliveryDate",
  c.salesid AS "Sales order the shipment was posted against; part of the composite key",
  c.deliverydate AS "Date the shipment was posted — the primary analysis date for outbound-shipment reporting; part of the composite key",
  c.orderaccount AS "Customer account that placed the shipped order",
  c.invoiceaccount AS "Customer account the shipment will be invoiced to",
  c.deliverypostaladdress AS "RecId of the ship-to address in LogisticsPostalAddress",
  c.dlvmode AS "Mode of delivery for the shipment",
  c.dlvterm AS "Terms of delivery for the shipment",
  c.qty AS "Total quantity shipped across the packing-slip lines",
  c.volume AS "Total volume of the shipment",
  c.weight AS "Total weight of the shipment",
  c.inventlocationid AS "Warehouse the shipment left from (note the CDM lowercase-i casing)",
  c.customerref AS "The customer's own reference for the order",
  c.purchaseorder AS "The customer's purchase order number for the shipped order",
  CASE WHEN CAST(c.documentdate AS DATE) = DATE '1900-01-01' THEN NULL ELSE CAST(c.documentdate AS DATE) END AS "Document date printed on the packing slip, when it differs from the posting date; unset rows carry the 1900-01-01 sentinel",  -- 1900-01-01 sentinel → NULL
  c.ledgervoucher AS "Ledger voucher for the shipment posting, when packing slips post to the ledger",
  c.printed AS "Whether the packing-slip document has been printed"  -- enum: decode c.printed via GlobalOptionsetMetadata join — see quirks guide #enums
FROM <catalog>.<schema>.custpackingslipjour c
-- Resolve LogisticsPostalAddress (via DeliveryPostalAddress): uncomment to join on its RecId surrogate key
-- LEFT JOIN <catalog>.<schema>.logisticspostaladdress log ON log.recid = c.deliverypostaladdress
WHERE
  c.dataareaid = '<company>'
  -- AND c.salesid = '<SalesId>'
  -- AND c.deliverydate >= '<DATE_FROM>'  -- yyyy-MM-dd (UTC)
  -- AND c.deliverydate <= '<DATE_TO>'  -- yyyy-MM-dd (UTC)
ORDER BY c.packingslipid;