Data Mart ETL - Release Notes
Date: 2026-03-26
New Fields
SalesOrderLines
| Field | Type | Description |
|---|
| Note | string | The user-defined note text connected to the sales order line, sourced from the ERP Note table. |
| ExtPrice | decimal | The extended price in currency for the sales order line, mapped from SOLine.CuryExtPrice. |
| LastModifiedDateTime | DateTime | The last modified timestamp of the sales order line. |
SupplierDocumentLines
| Field | Type | Description |
|---|
| DeferralSchedule | string | The deferral schedule code associated with the invoice line, replacing the deprecated DeferredCode field. |
| TermStartDate | DateTime | The start date of the deferral term. |
| TermEndDate | DateTime | The end date of the deferral term. |
SupplierPaymentLines
| Field | Type | Description |
|---|
| LastModifiedDateTime | DateTime | The last modified timestamp of the supplier payment line. |
Renamed Fields
SalesOrderLines
Old names remain available but are marked [Obsolete] and will be removed in a future release.
| Old name | New name |
|---|
| 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 |
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.
- 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.
- 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.
- CustomerDocumentLine and Warehouse SQL join mismatch between COUNT and UPSERT queries has been fixed, ensuring accurate row counts.
Deprecations
- SupplierDocumentLines.DeferredCode - Deprecated in favor of
DeferralSchedule. The DeferredCode field still exists and is populated, but will be removed in a future release.
- SalesOrderLines - 16 fields have been renamed (see Renamed Fields above). The old field names still exist and are populated, but are marked
[Obsolete] and will be removed in a future release.