Rotterdam Control Tower

Unified operating picture across sea, air and road legs for 217 suppliers in 14 countries.

All core services healthy

Active shipments

1,284

+6.2% vs last week

Open exceptions

37

7 critical · 4h clock active

D&D exposure

€284.6k

€42.8k at risk this week

Weekly supplier OTIF

91.8%

+2.4 pts · target 95%

Priority exception queue

Critical · 3h 12m left

ETA drift · SHP-48291
Ningbo → Rotterdam Maasvlakte · 40ft hydraulic valves

High · 1h 48m left

Port dwell · CNT-90812
Maersk · Supplier Ningbo Hydraulic

Critical · overdue

Customs field missing · SHP-48177
CMR-2024-1881 · EUR.1 country of origin

Weekly performance trend

Week 38

100%75%50%25%

W31W32W33W34W35W36W37W38

OTIF 91.8%SLA breach 6.4%Closure 84%

Integration health

SAP S/4HANA EWMSynced 2m ago

Descartes MacroPointSynced 4m ago

project44Degraded mode

Schema alerts

1 confirmation required
DSV CSV v4 added eta_local. Rows are quarantined until Sanne confirms mapping.

Savings trajectory

€638k

Realized toward €1.4M annual target

46% of annualized target · View exposure

ANNOTATION · Rotterdam Control Tower

Route: /control-tower

Unified KPI cards, exception queue, trends and integration health.
Lieke can triage critical exceptions and inspect source provenance.
Buttons navigate to exception, exposure, notification and federation workflows.

Shipment Ledger

Single queryable ledger consolidating carrier EDI 214/315, forwarder CSV, SAP EWM, Descartes MacroPoint and project44 provenance.

1,284 shipment records

Latest ingestion 38 sec ago

Shipment	Supplier	Lane / leg	Status	ETA	Source provenance	Residency
SHP-48291 BoL MRSU-778201	Ningbo Hydraulic Parts	NINGBO → RTM Sea	ETA drift	24 Sep 2024 +38h	EDI 214 · MacroPoint Conflict	EU resident
SHP-48276 BoL HLCU-193884	Rhein Components GmbH	HAMBURG → RTM Road	In transit	21 Sep 2024	Forwarder CSV · SAP EWM	EU resident
SHP-48177 BoL CMAU-641109	Atlas Industrial Controls	SHENZHEN → AMS Air	Customs hold	20 Sep 2024	Forwarder CSV · project44	EU resident
SHP-48012 BoL MSCU-512880	Nordic Seal Systems	BUSAN → RTM Sea	Delivered	18 Sep 2024	EDI 315 · SAP EWM	EU resident

ANNOTATION · Shipment Ledger

Route: /shipments

Search and filters preserve source feed and sea/air/road provenance.
Rows expose conflict markers, EU residency and latest status.
Open a record to follow Shipment → event → BoL/PO/ASN evidence.

SHP-48291 · Ningbo hydraulic valves

Shipment record with procurement evidence, multimodal provenance and conflicting ETA events.

ETA drift +38h

Current status

Port dwell

Rotterdam Maasvlakte · 6d 04h

Predicted ETA

24 Sep

Contract SLA exceeded by 38h

Container

MSCU-90812

40ft HC · demurrage €8,420

Data residency

EU

Cloud SQL · eu-west

Source event timeline

2 conflicting ETA values

Carrier EDI 214 · ETA 24 Sep, 18:00 Conflict

Source event EDI-214-7781 · received 19 Sep 08:41 CET · Carrier: Maersk · vessel YM Trust

Descartes MacroPoint · ETA 23 Sep, 04:00 Divergence

Event MP-91277 · received 19 Sep 08:45 CET · last geofence Rotterdam Maasvlakte

Forwarder CSV · dwell started

DSV-CSV-4417 · received 18 Sep 14:11 CET · raw payload retained, hash 8f4a…c92d

SAP S/4HANA EWM · PO receipt linked

PO 4500098217 · line 30 · ASN 856-448201 · linkage confirmed 17 Sep

Procurement evidence

Supplier: Ningbo Hydraulic Parts Co.
Purchase order: 4500098217 / line 30
ASN: 856-448201
Bill of Lading: MRSU-778201
Forwarder: DSV Road & Sea
Leg: Sea · Ningbo → Rotterdam
Last update: 19 Sep 2024, 08:45 CET

Conflicting source events are preserved; no ETA has been silently overwritten.

Customs artefacts and exposure

Artefact	Validation	Retention	Exposure	Action
CMR-2024-1881	Valid	31 Dec 2034	€8,420 demurrage
EUR.1-8810	Origin review	31 Dec 2034	€1,180 detention

ANNOTATION · Shipment Record

Route: /shipments/:shipmentId

Source timeline visibly preserves EDI/MacroPoint conflict.
Procurement evidence follows Mohammed's drill-down path.
Links open AI transparency, exception, customs and residency details.

Bill of Lading Reconciliation Workbench

Match incoming BoL numbers to PO Lines and ASNs across sea, air and road shipment legs.

12 unmatched

Processed today

486

99.2% auto-matched

Unmatched BoL

12

4 new since 08:00

Conflicting ETA

8

Source events retained

Last job

2m ago

Reconciliation healthy

Bill of Lading	Shipment / leg	PO Line	ASN	Source feeds	Reason code	State
MRSU-778201	SHP-48291 Sea	4500098217 / 30	856-448201	EDI 214 · CSV	ETA_CONFLICT	Review
MSCU-512880	SHP-48012 Sea	4500098011 / 10	856-447991	EDI 315 · SAP	—	Matched
HLCU-193884	SHP-48276 Road	4500098290 / 20	Missing	CSV	ASN_NOT_FOUND	Unmatched

ANNOTATION · BoL Reconciliation

Route: /reconciliation/bills-of-lading

Work queue exposes every match, not only aggregate counts.
Drill-down preserves source events and linked PO/ASN evidence.
Unmatched records route to procurement mismatch handling.

ETA Drift and Port-Dwell Exceptions

Monitor contractual SLA drift, Rotterdam Maasvlakte dwell thresholds and exception-generation health.

Engine running

Shipments evaluated

1,284

Last cycle 09:42:16

ETA drift alerts

18

Threshold ≥ 24h

Port dwell alerts

11

Free-time remaining ≤ 24h

Duplicate suppression

100%

Cooling window 6h

Detection rules

Rule	Scope	Threshold	Last triggered	Status
ETA drift	All active sea/air/road	≥ 24 hours	3 min ago	Active
Maasvlakte dwell	Rotterdam port	≥ 5 days	8 min ago	Active
Free-time exposure	Per forwarder contract	≤ 24h remaining	11 min ago	Active

Feed conflict monitor

8 conflicting ETA pairs
EDI 214 and Descartes MacroPoint disagree. Both values are retained on the Shipment record.

SHP-48291 · MRSU-77820138h delta

SHP-48102 · CMAU-64110919h delta

SHP-47988 · MSCU-31120714h delta

ANNOTATION · Detection Health

Route: /exceptions/detection

Shows live SLA, port-dwell and duplicate suppression rules.
Conflict monitor links to structured exception handling.
Rule thresholds and engine health are visible to operators.

Exception Queue

Structured operational exceptions replacing forwarded Outlook threads and Teams pings. Filters persist for Lieke's 15-minute triage loops.

7 critical

37 open exceptions

Clock starts at routing · acknowledgement SLA 4 hours

Severity	Exception	Shipment / container	Forwarder	Source event	Clock	Owner
Critical	ETA drift Contract SLA divergence	SHP-48291 MSCU-90812	DSV Road & Sea	EDI-214-7781 MacroPoint MP-91277	3h 12m left	Lieke
High	Port dwell Free-time nearing limit	SHP-48102 CNT-88109	Kuehne+Nagel	CSV-4421	1h 48m left	Lieke
Critical	Customs validation EUR.1 origin missing	SHP-48177 AMSU-12201	DSV Air	CMR-2024-1881	Overdue 22m	Sanne
Medium	Schema change New CSV field detected	DSV feed Batch 2024-09-19	DSV Road & Sea	CSV-SCHEMA-91	2h 33m left	Sanne

ANNOTATION · Exception Queue

Route: /exceptions

Persistent filters support Lieke's lane, Supplier, Forwarder and state workflow.
Rows show severity, provenance, clock, ownership and next action.
Acknowledge or review routes to a single-pane playbook detail.

EX-1048 · ETA drift on SHP-48291

Named operational playbook for the Ningbo → Rotterdam Maasvlakte shipment.

Critical · acknowledgement required

Clock remaining

3h 12m

Started 19 Sep · 08:46 CET

Predicted ETA

24 Sep 18:00

38h beyond SLA

Assigned role

Analyst

Supply chain analyst

Escalation step

1 of 3

Procurement manager next

Exception context

Source conflict

Category: ETA drift / port dwell
Shipment: SHP-48291 · Ningbo hydraulic valves
Container: MSCU-90812 · 40ft HC
Forwarder: DSV Road & Sea
Leg: Sea · Ningbo → Rotterdam
Contract SLA: 21 Sep 2024, 04:00 CET
Source event IDs: EDI-214-7781 · MP-91277 · DSV-CSV-4417
Original timestamp: 19 Sep 2024, 08:45 CET

Playbook routing

Supply chain analyst Current

Supply chain analyst · routed 08:46 CET · 4-hour acknowledgement clock

Procurement Manager

Procurement manager · escalates at timeout

COO

COO · executive escalation after second timeout

Notes and attachments

Immutable action history

Exception routed to Lieke08:46 · Azure AD

Source conflict recorded08:45 · system

ETA drift rule fired08:45 · engine

ANNOTATION · Exception Playbook

Route: /exceptions/:exceptionId

Single pane combines SLA clock, provenance, routing and history.
Acknowledge action stops the clock and records Lieke's Azure AD identity.
Escalation path and immutable audit actions remain visible.

CMR and Customs Documentation Validation

Validate CMR, EUR.1 and 10-digit HS-code completeness before Rotterdam customs risk materialises.

9 field alerts

Customs-bound shipments

84

Across 3 legs

Complete documents

75

89.3% pass rate

Invalid HS codes

3

Must be 10 digits

Missing EUR.1 origin

6

Forwarder alert sent

Document	Shipment / BoL	Forwarder	HS-code	EUR.1 origin	CMR status	Retention
CMR-2024-1881 DOC-7741	SHP-48177 CMAU-641109	DSV Air	8471.80.0000	Missing	Correction	31 Dec 2034
CMR-2024-1874 DOC-7732	SHP-48291 MRSU-778201	DSV Road & Sea	8481.90.0000	DE	Valid	31 Dec 2034
CMR-2024-1868 DOC-7718	SHP-48044 HLCU-193220	Kuehne+Nagel	8A-991	NL	Invalid	31 Dec 2034

ANNOTATION · Customs Validation

Route: /customs/documents

Field-level validation is visible without opening every document.
Alerts route to Sanne and show Shipment, BoL, Container and Forwarder context.
Retention dates support UCC record-keeping.

CMR-2024-1881 · Validation detail

Field-level evidence for a customs-bound document associated with SHP-48177.

Correction required

Document evidence

EU resident

Raw CMR payload retained in Cloud Storage eu-west. SHA-256: 62db…f18a

Document preview

CMR · DSV AIR CARGO · SHP-48177

Validation results

Shipment reference

SHP-48177 matched

Pass

HS-code

8471.80.0000 · 10 digits

Pass

EUR.1 country of origin

Required value not present

Fail

Bill of Lading

CMAU-641109 linked

Pass

Shipment context

Shipment: SHP-48177 · Atlas Industrial Controls
Container: AMSU-12201
Forwarder: DSV Air
Route: Shenzhen → Amsterdam · Air leg
Retention expiry: 31 December 2034 · UCC policy
Responsible role: Forwarder Coordinator · forwarder coordinator

Correction history

Field alert delivered

19 Sep 2024, 08:51 CET · Forwarder Coordinator · Azure AD identity recorded

Document ingested

19 Sep 2024, 08:47 CET · DSV Air CSV feed · raw payload retained

ANNOTATION · Customs Detail

Route: /customs/documents/:documentId

Document evidence, invalid field, context and retention appear together.
Request correction creates an attributable immutable action.
Controlled copy respects EU residency and access context.

Demurrage and Detention Exposure

Near-real-time container exposure calculated from dwell events, contractual free-time and SLA inputs.

Recalculated 2m ago

Total exposure

€284.6k

196 active containers

At-risk this week

€42.8k

31 containers

Free-time consumed

78%

Weighted average

Annual target

46%

€638k of €1.4M realized

Container	Shipment / lane	Forwarder	Dwell	Free-time	Demurrage	Detention	Delta
MSCU-90812	SHP-48291 Ningbo → RTM	DSV Road & Sea	6d 04h	5d	€8,420	€1,180	+€2,100
CNT-88109	SHP-48102 Yantian → RTM	Kuehne+Nagel	4d 19h	7d	€0	€820	+€420
MSCU-512880	SHP-48012 Busan → RTM	Maersk	3d 02h	10d	€0	€0	-€210

Realized savings trajectory

Target €1.4M annual

€1.4M€1.0M€0.7M€0

W31W32W33W34W35W36W37W38

ANNOTATION · Exposure Workspace

Route: /exposure

Container table exposes contractual inputs and historical delta.
Drill-down lets Lieke defend the calculation with dwell events.
COO savings trajectory shows realized value against €1.4M target.

MSCU-90812 · Container exposure

Defensible Demurrage and Detention calculation for SHP-48291.

€9,600 total exposure

Demurrage

€8,420

€1,200 / day after day 5

Detention

€1,180

Gate-out delay input

Dwell duration

6d 04h

Rotterdam Maasvlakte

Free-time remaining

0h

Over by 28 hours

Contractual terms

Forwarder: DSV Road & Sea
Contract version: DSV-2024-Q3 · effective 01 Jul 2024
Free-time: 5 calendar days
Demurrage rate: €1,200 per container/day
Detention rate: €295 per container/day
Lead-time SLA: 21 Sep 2024, 04:00 CET
Calculation run: 19 Sep 2024, 09:42 CET

Dwell milestones

Discharged at Maasvlakte

13 Sep · 05:10 CET · EDI 214

Free-time threshold crossed

18 Sep · 05:10 CET · Exposure engine

Last location update

19 Sep · 08:45 CET · MacroPoint

Calculation history

Timestamp	Previous value	New value	Delta	Cause	Source
19 Sep 09:42	€7,500	€9,600	+€2,100	Free-time crossed	EDI 214 + MacroPoint
18 Sep 09:42	€0	€7,500	+€7,500	Dwell threshold	DSV CSV

ANNOTATION · Container Exposure

Route: /containers/:containerId/exposure

Contract terms, milestones and source provenance defend exposure.
History records recalculation deltas when terms or dwell change.
Actions link to the originating exception and evidence export.

Supplier and Forwarder Scorecards

Week 38 QBR-ready performance across 217 suppliers, 14 countries and active forwarder lanes.

Generated Fri 09:00

Suppliers scored

217

14 countries

Supplier OTIF

91.8%

1,092 / 1,190 shipments

Forwarder performance

88.4%

412 / 466 milestones

Exceptions included

126

Evidence preserved

Supplier / forwarder	Country	Numerator	Denominator	OTIF / score	Grace band	Exceptions
Ningbo Hydraulic Parts	China	42 on time	50 shipments	84.0%	48h	9
Rhein Components GmbH	Germany	67 on time	70 shipments	95.7%	None	2
DSV Road & Sea	EU network	186 milestones	212 milestones	87.7%	Subjective notes	14

ANNOTATION · Scorecard Hub

Route: /scorecards

Transparent numerator, denominator, exceptions and grace-band treatment.
Mohammed can drill from supplier to shipment, event and evidence.
Exports include QBR spreadsheet and immutable audit-trail PDF.

Ningbo Hydraulic Parts · Week 38

Evidence-first OTIF drill-down from scorecard to shipment, event, Bill of Lading, PO Line and ASN.

84.0% adjusted OTIF

On-time numerator

42

Unadjusted: 39

Denominator

50

All eligible shipments

Grace band

48h

Effective 01 Sep 2024

Exceptions

9

3 ETA drift · 6 customs

Evidence chain

Scorecard → shipment → event → procurement

Scorecard result · 84.0% adjusted OTIF

42 / 50 shipments on time after 48-hour supplier grace band. Original value 78.0%.

SHP-48291 · ETA drift exception

Predicted ETA 24 Sep vs contractual 21 Sep. Source events EDI-214-7781 and MP-91277 conflict.

Bill of Lading MRSU-778201

Matched to PO 4500098217 line 30 and ASN 856-448201.

Acknowledgement evidence

Exception routed to Supply chain analyst at 08:46 CET. Azure AD identity and timestamp included in export.

QBR annotation

ANNOTATION · Scorecard Evidence

Route: /scorecards/:scorecardId

Evidence chain mirrors Mohammed's scorecard drill-down workflow.
Adjusted and unadjusted OTIF values remain transparent.
Annotations are preserved separately from historical scorecard values.

Structured Exception Notifications

In-product disruption notifications with attributed Forwarder, Shipment reference and source event provenance.

4 unread

Critical disruptions

4

Require acknowledgement

Feed events today

486

100% source attributed

Schema changes

1

Mapping confirmation pending

NEW · ETA drift

DSV Road & Sea reported conflicting ETA for SHP-48291. Event EDI-214-7781 · 08:45 CET.

NEW · Schema change

DSV CSV v4 introduced eta_local; new rows quarantined pending mapping confirmation.

INFO · Port dwell

Maersk container CNT-88109 has 19 hours of contractual free-time remaining.

ANNOTATION · Notifications

Route: /notifications

Replaces ad-hoc email and Teams pings with structured events.
Every notification includes Forwarder, Shipment, source ID and timestamp.
Actions open the operational queue, mapping or exposure workspace.

AI-assisted ETA transparency

Inline model basis, confidence interval, contributing feeds and EU AI Act disclosure for SHP-48291.

Disclosure recorded

Predicted arrival

24 Sep 18:00

Rotterdam Maasvlakte

Confidence interval

±18 hours

80% confidence

Model version

ETA-3.7

Production · 19 Sep 2024

Why this prediction?

The model predicts a 38-hour SLA divergence because the container has exceeded Rotterdam Maasvlakte dwell norms and the carrier and MacroPoint events disagree.

Contributing factors

Port dwell duration+22h impact

Carrier EDI 214 ETA+12h impact

MacroPoint location signal+8h impact

Historical Ningbo lane transit-4h impact

Contributing data sources

Carrier EDI 214Maersk · EDI-214-7781

Descartes MacroPointMP-91277

Forwarder CSVDSV-CSV-4417

Track-and-trace attributionStored

EU AI Act and privacy disclosure

This is an AI-assisted prediction, not a guaranteed arrival time.
The prediction is generated from consolidated carrier EDI, Descartes MacroPoint, forwarder CSV and historical lane data. The model basis, confidence interval and source systems are shown inline so the user can understand and challenge the output. This disclosure view is logged against the named Azure AD identity.

Viewed by Supply chain analystAzure AD · 19 Sep 09:04 CETAudit event AI-DISC-281

ANNOTATION · AI ETA Transparency

Route: /shipments/:shipmentId/eta-transparency

Rationale, confidence, sources and plain-language disclosure are inline.
Prediction view is auditable against Azure AD identity and timestamp.
Back link returns to source timeline; exception action remains available.

Middleware Federation Operations

Versioned data federation through existing middleware to SAP S/4HANA EWM, Descartes MacroPoint and project44.

1 degraded endpoint

SAP S/4HANA EWM

Healthy

Adapter v2.4 · last sync 2m ago

1,284 / 1,284 synced

Descartes MacroPoint

Healthy

Adapter v1.9 · last sync 4m ago

984 / 984 synced

project44

Degraded

Adapter v3.1 · endpoint timeout

42 queued payloads

Federation event log

Raw payload retention enabled

Event	Entity	Destination	Adapter	State	Timestamp	Action
FED-883210	SHP-48291	SAP EWM	v2.4	Delivered	09:42 CET	View payload
FED-883211	EX-1048	project44	v3.1	Queued	09:41 CET	Replay
FED-883166	SC-W38	Descartes	v1.9	Delivered	09:00 CET	View payload

Degraded mode is active for project44. New federation payloads are queued with bounded concurrency; raw payloads are retained against adapter v3.1 for reconciliation.

ANNOTATION · Federation Operations

Route: /integrations/federation

Endpoint health, adapter versions and queued degraded-mode payloads are visible.
Operators can inspect or replay federation events.
Raw payload retention supports adapter upgrade reconciliation.

Azure AD SSO and Role Access

Azure AD is the canonical identity source; Clerk mediates OAuth 2.0 / OpenID Connect sessions.

Azure AD connected

Identity provider

Azure AD

OAuth 2.0 / OpenID Connect

Token renewal via Clerk

Current identity

Lieke

Azure AD object mapped

Supply chain analyst

Session

Active

Last re-auth 07:58 CET

Expires in 7h 12m

Role capability matrix

Capability	Supply chain analyst	Procurement manager	Forwarder coordinator	COO executive
View Shipment ledger	Allowed	Allowed	Allowed	Read-only
Acknowledge Exceptions	Allowed	Allowed	Allowed	Denied
Configure OTIF grace bands	Denied	Allowed	Denied	Read-only
Map forwarder CSV schemas	Denied	Denied	Allowed	Read-only
Executive savings view	Allowed	Allowed	Allowed	Allowed

Recent access decisions

Viewed SHP-48291Allowed · 09:04

Attempted OTIF grace-band editDenied · 08:56

SSO token renewed by ClerkSuccess · 07:58

ANNOTATION · Access and SSO

Route: /settings/access

Shows canonical Azure AD identity, Clerk session and role mapping.
Capability matrix communicates least privilege and read-only COO access.
Denied attempts are logged with identity and timestamp.

GDPR, UCC and Data Residency Controls

EU-resident storage, retention, data-subject workflows and PDPA accountability in one governance workspace.

EU residency compliant

EU-resident records

100%

Cloud SQL · GCP eu-west

UCC artefacts retained

8,421

Retention policy active

DSAR workflows

2

Within 30-day SLA

Audit coverage

100%

Immutable event chain

Storage and retention controls

Shipment ledgerCloud SQL · eu-west

CMR and EUR.1 documentsCloud Storage · eu-west

Raw EDI / CSV payloadsWORM retention

Retention period10 years · UCC

PostHog analyticsEU endpoint · PII scrubbed

Data-subject workflows

Access request · DSAR-019

Azure AD identity · due 04 Oct 2024

In progress

Rectification · DSAR-018

Correction evidence attached

Completed

DPO contact

dpo@rotterdam-operations.example

Published

Accountability notice: staff identity, role and audit trail are processed for shipment, exception and scorecard workflows. Direct marketing is not in scope. Any external AI prediction view requires explicit consent.

ANNOTATION · Data Controls

Route: /governance/data-controls

EU storage, UCC retention, GDPR DSAR and PDPA accountability are surfaced.
Per-record residency links lead to the inspector screen.
Governance reports include retention and analytics-region evidence.

Immutable Audit Log

Append-only record of mutations, routing decisions, acknowledgements, escalations, disclosures and access denials.

Hash chain valid

Events today

2,418

Append-only

Identities attributed

100%

Azure AD verified

Hash chain

Valid

Last checkpoint 09:45

Corrections

3

Originals preserved

Event ID	Timestamp	Event	Entity	Azure AD identity	Before / after	Integrity
AUD-994821	19 Sep 09:04	AI disclosure view	SHP-48291	lieke.vanderberg	Viewed / recorded	Verified
AUD-994820	19 Sep 08:56	Capability denied	OTIF grace band	lieke.vanderberg	Attempt / denied	Verified
AUD-994819	19 Sep 08:46	Exception routed	EX-1048	system · Lieke recipient	Created / assigned	Verified
AUD-994818	19 Sep 08:21	Mapping change	DSV CSV v4	sanne.visser	v3 / v4 draft	Verified

ANNOTATION · Immutable Audit Log

Route: /governance/audit-log

Append-only events expose identity, timestamps and before/after state.
Hash verification and export support disputes and governance.
Corrections create new entries rather than overwriting originals.

PostHog Governance Analytics

Privacy-safe operational telemetry for exception categories, acknowledgement latency, dwell, adoption and closure.

EU endpoint · PII scrubbed

4h acknowledgement compliance

94.6%

+5.1 pts week over week

Exception closure rate

84%

Last 7 days

Median ack latency

46m

Target under 4 hours

Active users

42

4 role groups

Exception category volume

Last 7 days

806040200

MonTueWedThuFriSatSun

Schema validation outcomes

Privacy-safe aggregate

Accepted rows98.1%

Quarantined rows1.4%

Rejected with reason code0.5%

Events sent to PostHog12,840

Analytics payloads use the EU PostHog endpoint and omit names, emails, Azure AD object IDs, Bill of Lading numbers and free-text identifiers.

ANNOTATION · Governance Analytics

Route: /governance/analytics

Governance KPIs connect telemetry to SLA and closure outcomes.
Charts show aggregate category and validation trends.
Privacy callout makes EU endpoint and PII scrubbing explicit.

Forwarder CSV Schema Mapping

Map forwarder schemas into the unified Shipment model with per-field confidence and approval gates.

1 draft requires approval

DSV Road & Sea · v4 draft

86%

Overall mapping confidence

Approval required

Required fields

12 / 12

Mapped and validated

No silent acceptance

Quarantined rows

18

New eta_local field

Awaiting confirmation

Field mapping · DSV CSV v4

Draft version 4

Incoming field	Unified model field	Required	Sample value	Confidence	Validation	Action
container_no	Container.identifier	Yes	MSCU-90812	99%	Pattern passed	Edit
eta_local	Shipment.predicted_eta	Yes	24-09-2024 18:00	72%	Timezone ambiguous
bol_number	BillOfLading.number	Yes	MRSU-778201	98%	Pattern passed	Edit
leg_type	ShipmentLeg.mode	Yes	SEA	96%	Enum passed	Edit

ANNOTATION · CSV Schema Mapping

Route: /integrations/forwarder-mappings

Sanne sees field-level confidence, required status and sample values.
Schema drift quarantines affected rows until approval.
Approval creates a versioned mapping change in the audit log.

BoL-to-PO Mismatch List

Every unmatched or conflicting Bill of Lading with linked Shipment, PO Line, ASN, feeds and reason code.

12 mismatches

BoL	Shipment	Supplier	PO Line	ASN	Source feeds	Reason	Root cause
HLCU-193884	SHP-48276	Rhein Components	4500098290 / 20	Missing	CSV	ASN_NOT_FOUND	Pending
MRSU-778201	SHP-48291	Ningbo Hydraulic	4500098217 / 30	856-448201	EDI · CSV	ETA_CONFLICT	Carrier timing
CMAU-641109	SHP-48177	Atlas Industrial	4500098172 / 10	856-448091	CSV · p44	PO_LINE_MISMATCH	Pending

Root-cause Pareto

ASN not found · 42%PO line mismatch · 33%Source conflict · 25%

ANNOTATION · BoL Mismatch List

Route: /procurement/mismatches

Procurement sees the complete mismatch list instead of only a count.
Root causes are annotatable and aggregate into Pareto reporting.
Shipment drill-down preserves PO, ASN and source evidence.

Supplier OTIF Grace Bands

Configure negotiated per-Supplier grace periods with effective dates, approvals and transparent scorecard impact.

Procurement manager

Supplier	Country	Grace band	Effective from	Unadjusted OTIF	Adjusted OTIF	Approval
Ningbo Hydraulic Parts	China	48 hours	01 Sep 2024	78.0%	84.0%	Approved
Atlas Industrial Controls	China	24 hours	15 Sep 2024	88.1%	90.3%	Pending
Rhein Components GmbH	Germany	None	—	95.7%	95.7%	Not applicable

Scorecard transparency: exports include both original promise-date OTIF and grace-band-adjusted OTIF for each named Supplier.

ANNOTATION · OTIF Grace Bands

Route: /procurement/otif-grace-bands

Mohammed configures effective, approved Supplier grace periods.
Unadjusted and adjusted values remain side by side.
Changes are attributable and appear in future scorecards.

Executive Anomaly Alerts

Early warning center for SLA breach spikes, exposure changes and deviation from the €1.4M savings trajectory.

2 active anomalies

Critical · SLA breach rate

Breach rate reached 18%

Threshold 15% · affected Suppliers: Ningbo Hydraulic, Atlas Industrial · categories: ETA drift and customs.

Warning · savings trajectory

€42.8k exposure added

Weekly exposure is 12% above plan, primarily driven by Maasvlakte dwell.

Resolved · closure rate

Closure rate recovered

84% this week after playbook routing change. No action required.

Executive decision summary

Decision requested: approve temporary forwarder escalation for the Ningbo lane before the next QBR. Estimated preventable exposure over the next seven days: €18.4k.

ANNOTATION · Executive Alerts

Route: /executive/alerts

Pieter gets three numbers: what changed, whether on plan and decision needed.
Alerts link directly to scorecards and exposure evidence.
Read-only executive actions preserve operational segregation.

Bulk Corrective Action Plans

Select multiple breached Shipments from one Supplier and attach a shared plan without altering historical scorecards.

Procurement workflow

Shipment	BoL	Exception	Breach	Existing plan
SHP-48291	MRSU-778201	ETA drift	38h	None
SHP-48102	CNT-88109	Port dwell	19h	None
SHP-47988	MSCU-311207	ETA drift	26h	Existing draft

Plan details

Corrective action title

Due date

Actions and owner

ANNOTATION · Corrective Actions

Route: /procurement/corrective-actions

Bulk selection is constrained to one Supplier.
Shared plan links to every selected Shipment without mutating history.
Plan details capture owner, due date and evidence requirements.

SHP-48291 · Residency inspector

Per-shipment and per-document storage location, retention expiry and permitted access context.

EU resident

Shipment ledger row

EU

GCP Cloud SQL · eu-west

Encrypted at rest

Documents

2 / 2

CMR and EUR.1 stored in EU

Document-level verified

Retention

2034

UCC retention expiry

10-year policy

Record residency and access context

Record	Storage location	Residency	Retention expiry	Permitted roles	Last access
Shipment SHP-48291	Cloud SQL · eu-west	EU	31 Dec 2034	Analyst · Procurement · Forwarder · COO read-only	19 Sep 09:04 · Lieke
CMR-2024-1874	Cloud Storage · eu-west	EU	31 Dec 2034	Analyst · Forwarder · Procurement	19 Sep 08:51 · Sanne
EUR.1-8810	Cloud Storage · eu-west	EU	31 Dec 2034	Analyst · Forwarder · Procurement	19 Sep 08:51 · Sanne
Raw source payload	WORM bucket · eu-west	EU	31 Dec 2034	Platform administrators	19 Sep 08:45 · system

Answer for supplier or DPO: Shipment and customs artefacts are stored on EU-resident GCP infrastructure in eu-west. Retention and role-based access are enforced and every access is attributable to an Azure AD identity.

ANNOTATION · Residency Inspector

Route: /governance/residency/:recordId

Per-record and per-document EU indicators are visible on one screen.
Retention expiry, storage location and permitted roles are explicit.
Report action supports DPO, COO and supplier data-residency questions.