SW-284920
Completed with warningsAcme Manufacturing GmbH
LegacyERP 8
switonaNovaERP Cloud
switonaNovaERP CloudYour switching path
LegacyERP 8File handover
Switona4 entities analysed · 93% mapped
NovaERP CloudFile handover
Result & evidence
An auditable record of the configuration, approvals, counts and retention policy. Package delivery is recorded separately from import into a destination system.
Source records9
Intentionally excluded2
Ready7
Rejected0
Temporary data scheduled for deletion
Technical details
{
"demo": true,
"caseId": "SW-284920",
"customer": "Acme Manufacturing GmbH",
"source": "LegacyERP 8",
"destination": "NovaERP Cloud",
"initiator": "NovaERP",
"participants": [
{
"name": "NovaERP",
"roles": [
"initiator",
"destination_provider",
"billing_party"
]
},
{
"name": "Acme Manufacturing GmbH",
"roles": [
"data_owner",
"approver"
]
},
{
"name": "LegacyERP",
"roles": [
"source_provider"
]
}
],
"billingParty": "NovaERP",
"pricingMode": "sponsored",
"scope": [
{
"entity": "organization",
"included": false
},
{
"entity": "person",
"included": false
},
{
"entity": "customer",
"included": true
},
{
"entity": "supplier",
"included": false
},
{
"entity": "address",
"included": false
},
{
"entity": "product",
"included": true
},
{
"entity": "order",
"included": false
},
{
"entity": "orderItem",
"included": false
},
{
"entity": "invoice",
"included": true,
"dateField": "date",
"from": "2024-01-01",
"to": "2025-12-31"
},
{
"entity": "invoiceItem",
"included": false
},
{
"entity": "payment",
"included": false
},
{
"entity": "contract",
"included": false
},
{
"entity": "document",
"included": true,
"dateField": "date",
"from": "2025-01-01",
"to": "2026-09-30"
},
{
"entity": "activity",
"included": false
},
{
"entity": "user",
"included": false
}
],
"inputHashes": [
{
"name": "synthetic-demo.json",
"sha256": "88105f50cbc1e2df2706676ac9031f0b9167badfea9aff5c47826cc45342ce2f",
"bytes": 743
}
],
"sourceSchema": [
{
"name": "customers",
"rows": [],
"entity": "customer",
"fields": [
{
"name": "DebNr",
"type": "string",
"nullRate": 0,
"uniqueRate": 1,
"canonical": "customer.externalId",
"confidence": 0.95
},
{
"name": "Firma",
"type": "string",
"nullRate": 0,
"uniqueRate": 1,
"canonical": "customer.companyName",
"confidence": 0.95
},
{
"name": "Email",
"type": "email",
"nullRate": 0,
"uniqueRate": 1,
"canonical": "customer.email",
"confidence": 0.95
},
{
"name": "InternalNote",
"type": "string",
"nullRate": 0,
"uniqueRate": 0.5,
"canonical": null,
"confidence": 0
}
]
},
{
"name": "products",
"rows": [],
"entity": "product",
"fields": [
{
"name": "id",
"type": "string",
"nullRate": 0,
"uniqueRate": 1,
"canonical": "product.externalId",
"confidence": 0.95
},
{
"name": "name",
"type": "string",
"nullRate": 0,
"uniqueRate": 1,
"canonical": "product.name",
"confidence": 0.95
}
]
},
{
"name": "invoices",
"rows": [],
"entity": "invoice",
"fields": [
{
"name": "id",
"type": "string",
"nullRate": 0,
"uniqueRate": 1,
"canonical": "invoice.externalId",
"confidence": 0.95
},
{
"name": "customer_id",
"type": "string",
"nullRate": 0,
"uniqueRate": 0.6666666666666666,
"canonical": "invoice.customerId",
"confidence": 0.95
},
{
"name": "date",
"type": "date",
"nullRate": 0,
"uniqueRate": 1,
"canonical": "invoice.date",
"confidence": 0.95
},
{
"name": "status",
"type": "string",
"nullRate": 0,
"uniqueRate": 0.6666666666666666,
"canonical": "invoice.status",
"confidence": 0.95
},
{
"name": "amount",
"type": "number",
"nullRate": 0,
"uniqueRate": 1,
"canonical": "invoice.amount",
"confidence": 0.95
}
]
},
{
"name": "documents",
"rows": [],
"entity": "document",
"fields": [
{
"name": "id",
"type": "string",
"nullRate": 0,
"uniqueRate": 1,
"canonical": "document.externalId",
"confidence": 0.95
},
{
"name": "name",
"type": "string",
"nullRate": 0,
"uniqueRate": 1,
"canonical": "document.name",
"confidence": 0.95
},
{
"name": "date",
"type": "date",
"nullRate": 0,
"uniqueRate": 1,
"canonical": "document.date",
"confidence": 0.95
}
]
}
],
"destinationSchema": {
"tables": [
{
"name": "nova_customers",
"rows": [],
"entity": "customer",
"fields": [
{
"name": "customerNumber",
"type": "string",
"nullRate": 0,
"uniqueRate": 1,
"canonical": "customer.externalId",
"confidence": 0.95,
"required": true
},
{
"name": "companyName",
"type": "string",
"nullRate": 0,
"uniqueRate": 1,
"canonical": "customer.companyName",
"confidence": 0.95,
"required": false
},
{
"name": "email",
"type": "email",
"nullRate": 0,
"uniqueRate": 1,
"canonical": "customer.email",
"confidence": 0.95,
"required": false
}
]
},
{
"name": "nova_products",
"rows": [],
"entity": "product",
"fields": [
{
"name": "id",
"type": "string",
"nullRate": 0,
"uniqueRate": 1,
"canonical": "product.externalId",
"confidence": 0.95,
"required": true
},
{
"name": "name",
"type": "string",
"nullRate": 0,
"uniqueRate": 1,
"canonical": "product.name",
"confidence": 0.95,
"required": false
}
]
},
{
"name": "nova_invoices",
"rows": [],
"entity": "invoice",
"fields": [
{
"name": "id",
"type": "string",
"nullRate": 0,
"uniqueRate": 1,
"canonical": "invoice.externalId",
"confidence": 0.95,
"required": true
},
{
"name": "customer_id",
"type": "string",
"nullRate": 0,
"uniqueRate": 0.6666666666666666,
"canonical": "invoice.customerId",
"confidence": 0.95,
"required": false
},
{
"name": "date",
"type": "date",
"nullRate": 0,
"uniqueRate": 1,
"canonical": "invoice.date",
"confidence": 0.95,
"required": false
},
{
"name": "status",
"type": "string",
"nullRate": 0,
"uniqueRate": 0.6666666666666666,
"canonical": "invoice.status",
"confidence": 0.95,
"required": false,
"enum": [
"open",
"paid",
"cancelled"
]
},
{
"name": "amount",
"type": "number",
"nullRate": 0,
"uniqueRate": 1,
"canonical": "invoice.amount",
"confidence": 0.95,
"required": false
}
]
},
{
"name": "nova_documents",
"rows": [],
"entity": "document",
"fields": [
{
"name": "id",
"type": "string",
"nullRate": 0,
"uniqueRate": 1,
"canonical": "document.externalId",
"confidence": 0.95,
"required": true
},
{
"name": "name",
"type": "string",
"nullRate": 0,
"uniqueRate": 1,
"canonical": "document.name",
"confidence": 0.95,
"required": false
},
{
"name": "date",
"type": "date",
"nullRate": 0,
"uniqueRate": 1,
"canonical": "document.date",
"confidence": 0.95,
"required": false
}
]
}
],
"hashes": []
},
"mappingVersion": 1,
"transformationVersion": "1.0.0",
"plan": {
"version": 1,
"fingerprint": "6453723f26e85e8a5265a5ba2188cadd4917f47bded651e7b2bd66b69ddd5253",
"order": [
"customers",
"products",
"documents",
"invoices"
],
"relationships": [
{
"from": "invoices",
"field": "customer_id",
"to": "customers",
"targetField": "DebNr",
"confirmed": true
}
],
"steps": [
{
"table": "customers",
"operations": [
"read",
"apply_scope",
"canonicalize",
"resolve_relationships",
"transform",
"validate",
"write_destination",
"verify_destination",
"reconcile"
]
},
{
"table": "products",
"operations": [
"read",
"apply_scope",
"canonicalize",
"resolve_relationships",
"transform",
"validate",
"write_destination",
"verify_destination",
"reconcile"
]
},
{
"table": "documents",
"operations": [
"read",
"apply_scope",
"canonicalize",
"resolve_relationships",
"transform",
"validate",
"write_destination",
"verify_destination",
"reconcile"
]
},
{
"table": "invoices",
"operations": [
"read",
"apply_scope",
"canonicalize",
"resolve_relationships",
"transform",
"validate",
"write_destination",
"verify_destination",
"reconcile"
]
}
]
},
"reconciliation": {
"source": 9,
"outOfScope": 2,
"inScope": 7,
"exported": 7,
"failed": 0,
"unexplained": 0,
"balanced": true
},
"warnings": [
{
"code": "FIELD_EXCLUDED",
"table": "customers",
"row": null,
"field": "InternalNote",
"detail": "",
"severity": "warning"
}
],
"approvals": [
{
"kind": "scope",
"revision": 1,
"user_id": "demo",
"created_at": "2026-09-28T10:00:00.000Z"
},
{
"kind": "mapping",
"revision": 1,
"user_id": "demo",
"created_at": "2026-09-28T10:00:00.000Z"
},
{
"kind": "billing",
"revision": 1,
"user_id": "demo",
"created_at": "2026-09-28T10:00:00.000Z"
},
{
"kind": "execution",
"revision": 1,
"user_id": "demo",
"created_at": "2026-09-28T10:00:00.000Z"
},
{
"kind": "completion",
"revision": 1,
"user_id": "demo",
"created_at": "2026-09-28T10:00:00.000Z"
}
],
"createdAt": "2026-09-28T10:00:00.000Z",
"completedAt": "2026-09-28T10:00:00.000Z",
"retention": {
"hours": 24,
"status": "demo_only"
},
"delivery": "destination_ready_package",
"destinationImportVerified": false
}