15 posts tagged with "ETL"

Changes to the Data Mart ETL pipeline

Data Mart ETL - 2026-04-28

April 28, 2026

Visma Net ERP Data Mart

Field	Type	Description
DeferralScheduleNbr	string	The deferral schedule's business number, populated separately from the existing `DeferralSchedule` (description) and `DeferredCode` (code) values.

April 15, 2026

Visma Net ERP Data Mart

Customer payments with document type DRM (Debit Note) are now correctly processed. Previously, these records caused a mapping error during the ETL transform step and were not synced to MongoDB.

April 3, 2026

Visma Net ERP Data Mart

Field	Type	Description
LineType	string	The line type on the customer document line, making it possible to distinguish between different line categories.
ManualAmount	decimal	The manually entered amount override on the customer document line.
ManualAmountInCurrency	decimal	The manually entered amount override expressed in the document's currency.

April 1, 2026

Visma Net ERP Data Mart

No integrator-facing changes in this release.

March 26, 2026

Visma Net ERP Data Mart

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.