VendInvoiceTrans

-- ============================================================
-- Table  : VendInvoiceTrans Posted vendor invoice line — one row per invoiced line with quantity, price, and the links back to its purchase order and inventory movements
-- Purpose: Column-selected read of VendInvoiceTrans — auto-generated from field metadata
-- Grain  : One row per company (dataareaid) + InvoiceId + InvoiceDate + LineNum
-- 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.invoiceid AS "The invoice this line belongs to; 20 chars by default, 50 where the 10.0.40+ extended vendor invoice number feature is enabled",
  v.invoicedate AS "Invoice date — part of the join back to the header",
  v.linenum AS "Line number within the invoice",
  v.purchid AS "Purchase order the line was invoiced against — note the field really is spelled PurchID, not PurchId",
  v.origpurchid AS "Original purchase order, kept when delivery schedules split the order",
  v.inventtransid AS "Inventory transaction reference (lot id) linking the line to its inventory movements",
  v.itemid AS "Item invoiced on the line",
  v.inventdimid AS "Inventory-dimension combination the line was invoiced against; join to InventDim to resolve site / warehouse",
  v.name AS "Line description",
  v.qty AS "Quantity invoiced",
  v.purchunit AS "Purchase unit of measure",
  v.purchprice AS "Unit price in the invoice currency",
  v.lineamount AS "Net line amount in the invoice currency",
  v.currencycode AS "Invoice currency",
  v.discamount AS "Line discount amount",
  v.discpercent AS "Line discount percentage",
  v.internalinvoiceid AS "Internal invoice number, shared with the header",
  v.ledgerdimension AS "RecId of the ledger account combination the line posted to (DimensionAttributeValueCombination)"
FROM <catalog>.<schema>.vendinvoicetrans v
-- Dimension expansion: uncomment to resolve site / warehouse / location / batch
-- LEFT JOIN <catalog>.<schema>.inventdim id ON id.inventdimid = v.inventdimid AND id.dataareaid = v.dataareaid
WHERE
  v.dataareaid = '<company>'
ORDER BY v.invoiceid;