xMiddle — ERP & Banking Middleware
Grounded in Oxaxo's enterprise workflow engine and the production Payment Batch Fixer v1.6 architecture, xMiddle sits between legacy ERP/payroll databases and mission-critical banking or AI endpoints. It ingests malformed CSV/EDI/XML exports, runs deterministic field validation, sort-code/account normalization, and line-by-line diff auditing, and emits guaranteed bank-compliant output objects.
ERP Systems ↔ xMiddle Deterministic Kernel ↔ Clearing & AI Apps
SAP · NetSuite · Workday CSV/XML batch exports with unescaped fields.
Sort-code modulus check, 8-digit zero-pad, NFKD ASCII scrubber & SHA-256 diff log.
Zero-rejection clearing batch + normalized Supabase analytics stream.
| Record | Beneficiary | Sort Code | Account No | Bankline Reference (Max 18) | Amount | Audit Diagnosis |
|---|---|---|---|---|---|---|
| REC-001 | A. Lindqvist Consulting | 602407 | 00419283 | PAY 2026 Q4 BONUS | £4,850.00 | Sort-code pad + 8-digit acct pad + illegal Bankline chars (*#!) |
| REC-002 | Müller & Söhne GmbH | 200000 | 88412094 | INV/9941/MULLER-A | £12,400.00 | NFKD Unicode diacritic normalization (Ü→U, Å→A) |
| REC-003 | NorthStar Cloud Services | 401158 | 07104921 | PAYROLL BATCH NOV | £3,190.50 | Truncated to strict 18-char Bankline limit + space stripping |
Deterministic Middleware Architecture
Automated Payroll & Bankline Batch Sanitisation
Parses multi-record payroll and ERP payment batches, detecting non-ASCII characters, invalid sort codes, truncated account numbers, and unbalanced control totals before submission.
- Automatic sort-code & 8-digit account number zero-padding and format repair
- Strict alphanumeric reference scrubbing to prevent whole-batch bank rejection
- Side-by-side visual diff ledger highlighting every auto-repaired cell
Bi-Directional ERP ↔ AI Schema Bridge
Connects legacy on-premise ERP tables with modern cloud APIs, vector databases, and executive analytics without brittle point-to-point scripts.
- Ingests JSON, CSV, XML, EDI, and fixed-width mainframe exports
- Dead-letter queue protection with idempotent retry keys
- Real-time webhook emission on state transition verification
Cryptographic Audit Trail & PII Guard
Every transformation step generates an immutable receipt linking the raw input hash to the sanitized output artifact for financial and regulatory compliance.
- Tamper-proof provenance tracking for internal and external auditors
- Configurable PII masking and GDPR/HIPAA anonymisation filters
- Exportable reconciliation reports in CSV, JSON, and signed PDF
// xMiddle Deterministic Record Normalizer (v1.6)
export function normalizeBanklineRecord(raw: ERPExportRow): VerifiedBanklineObject {
const sortCode = raw.sortCode.replace(/[^0-9]/g, "").padStart(6, "0");
const accountNo = raw.accountNumber.replace(/[^0-9]/g, "").padStart(8, "0");
const cleanRef = raw.reference.normalize("NFKD").replace(/[^a-zA-Z0-9 /\-\.]/g, "").slice(0, 18);
return {
status: "VERIFIED_READY",
sortCode,
accountNo,
amountGBP: Number(raw.amount).toFixed(2),
reference: cleanRef,
checksum: sha256(`${sortCode}:${accountNo}:${raw.amount}:${cleanRef}`),
};
}Deploy xMiddle in your ERP or Treasury Environment
Eliminate rejected payment batches and manual CSV editing with a verifiable O₁ → A → O₂ sanitisation bridge.