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",
  c.documentdate AS "Document date printed on the packing slip, when it differs from the posting date",
  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;