CustPackingSlipTrans

-- ============================================================
-- Table  : CustPackingSlipTrans Posted packing-slip line - one row per order line on each shipment posted against a sales order, with the shipped quantity and the ship date; a line shipped in several deliveries has one row per delivery, so this is the split trail that on-time and in-full measures read
-- Purpose: Column-selected read of CustPackingSlipTrans — auto-generated from field metadata
-- Grain  : One row per company (dataareaid) + recid (surrogate key)
-- 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 "Packing slip this line was posted on; with SalesId and DeliveryDate it identifies the CustPackingSlipJour header",
  c.salesid AS "Sales order the shipped line came from; part of the join to the CustPackingSlipJour header",
  c.deliverydate AS "Posting date of the packing slip, repeated on the line - the ship date for line-level delivery analysis; part of the join to the CustPackingSlipJour header",
  c.linenum AS "Line number within the packing slip",
  c.inventtransid AS "Lot ID of the sales order line this row ships - the join back to SalesLine.InventTransId, and the key to group every delivery of one order line",
  c.itemid AS "Item shipped on the line",
  c.inventdimid AS "Inventory-dimension combination the line shipped from; join to InventDim to resolve site / warehouse / batch",
  c.qty AS "Quantity shipped on this packing-slip line, in the sales unit; a line shipped in several deliveries has one row per delivery, so sum across rows for the delivered total",
  c.salesunit AS "Sales unit of measure for the shipped quantity",
  c.inventqty AS "Quantity shipped on this packing slip, in the inventory unit (note the CDM lowercase-i casing)",
  c.ordered AS "Quantity ordered on the sales order line, as it stood when this packing slip was posted",
  c.remain AS "Quantity of the order line still left to ship after this packing slip, in the sales unit",
  CASE WHEN CAST(c.saleslineshippingdateconfirmed AS DATE) = DATE '1900-01-01' THEN NULL ELSE CAST(c.saleslineshippingdateconfirmed AS DATE) END AS "Confirmed ship date of the sales order line, copied onto the packing-slip line; unconfirmed lines carry the 1900-01-01 sentinel",  -- 1900-01-01 sentinel → NULL
  c.saleslineshippingdaterequested AS "Requested ship date of the sales order line, copied onto the packing-slip line",
  c.origsalesid AS "Original sales order, when the shipped line references an earlier order",
  c.externalitemid AS "The customer's own item number for the shipped item, when maintained"
FROM <catalog>.<schema>.custpackingsliptrans c
-- Dimension expansion: uncomment to resolve site / warehouse / location / batch
-- LEFT JOIN <catalog>.<schema>.inventdim id ON id.inventdimid = c.inventdimid AND id.dataareaid = c.dataareaid
WHERE
  c.dataareaid = '<company>'
  -- AND c.deliverydate >= '<DATE_FROM>'  -- yyyy-MM-dd (UTC)
  -- AND c.deliverydate <= '<DATE_TO>'  -- yyyy-MM-dd (UTC)
;