Skip to main content

Data Mart ETL — Release Notes

From: production-4.0.0.27 To: HEAD (46880636) Date: 2026-03-26

New Fields​

  • SalesOrderLines.Note (string?) — The user-defined note text connected to the sales order line, sourced from the ERP Note table (VNEDM-1632)
  • SalesOrderLines.ExtPrice (decimal?) — The extended price in currency for the sales order line, mapped from SOLine.CuryExtPrice (VNEDM-1632)
  • SalesOrderLines.LastModifiedDateTime (DateTime) — The last modified timestamp of the sales order line (VNEDM-1632)
  • SalesOrderLines — Multiple fields renamed to more descriptive names. Old names remain available but are marked [Obsolete]: ExpireDate→ExpirationDate, OrderQty→Quantity, ShippedQty→QtyOnShipments, CuryUnitPrice→UnitPriceInBaseCurrency, TranDesc→LineDescription, ManualDisc→ManualDiscount, DiscPct→DiscountPercent, DiscAmt→DiscountAmount, CompleteQtyMin→UndershipThreshold, CompleteQtyMax→OvershipThreshold, ShipDate→ShipOn, RequestDate→RequestOn, DiscountID→DiscountCode, IsFree→FreeItem, POCreate→MarkForPO, NoteId→Note (VNEDM-1632)
  • SupplierDocumentLines.DeferralSchedule (string?) — The deferral schedule code associated with the invoice line, replacing the deprecated DeferredCode field (VNEDM-1807)
  • SupplierDocumentLines.TermStartDate (DateTime?) — The start date of the deferral term (VNEDM-1807)
  • SupplierDocumentLines.TermEndDate (DateTime?) — The end date of the deferral term (VNEDM-1807)
  • SupplierPaymentLines.LastModifiedDateTime (DateTime) — The last modified timestamp of the supplier payment line

Data Quality Improvements​

  • Added corrector flow for all 32 ETL entities, ensuring near-real-time updates that were previously missed due to SQL Server rowversion race conditions are now automatically caught and corrected using LastModifiedDateTime-based lookback (VNEDM-1787, VNEDM-1823)
  • The @partOfKey GraphQL directive and (PK) markers are now present on all primary key fields across all entities, making it clear which fields uniquely identify a document (VNEDM-1831)
  • Added companyId + rowVersion compound index to all MongoDB collections for improved query performance

Bug Fixes​

  • CustomerDocument no longer produces duplicate documents — branchId and customerId were incorrectly included in the primary key, causing the same document to appear multiple times. The PK is now CompanyId + DocumentType + ReferenceNumber (SIGMA-90690)
  • CustomerDocumentLine and Warehouse SQL join mismatch between COUNT and UPSERT queries has been fixed, ensuring accurate row counts (VNEDM-1779)

Deprecations​

  • SupplierDocumentLines.DeferredCode — Deprecated in favor of DeferralSchedule. The DeferredCode field still exists and is populated, but will be removed in a future release (VNEDM-1807)
  • SalesOrderLines — 16 fields have been renamed (see New Fields above). The old field names still exist and are populated, but are marked [Obsolete] and will be removed in a future release (VNEDM-1632)