Shipment Register

Everything that is moving, across three owning systems · inbound supplier freight (i3), outbound customer shipments (ops2), inter-location transfers (i3 module 07) · 74 active · AED 786K in motion · 5 exceptions

This register is a view, not a table. i3 writes only the inbound rows. Outbound rows are mirrored read-only from ops2 and transfer rows from module 07, because materialising them here would create a fourth writer for facts three other systems already own. Every row links out to its owner, and the Ledger column shows what each shipment actually posted. ops2 feed →

Shipment types

Click to filter · one physical shipment can carry more than one type, for example an RTS riding on a store transfer

74 active · AED 786K

Carrier split

74 active shipments

Aramex · 28 shipments · 38% · on-time 92.4% DHL · 18 shipments · 24% · on-time 88.0% · carries all inbound freight Swftbox · 13 shipments · 18% · on-time 83.1% Porterex · 7 shipments · 9% · on-time 71.4% · lost rate 3.2% against a 1% SLA Self and manual · 8 shipments · 11% · on-time 97.2% · includes the sea container 74 active
  • Aramex28
  • DHL18
  • Swftbox13
  • Porterex7
  • Self / manual8

SLA band

Click a segment to filter the register · SLA is per carrier and per shipment type, not one global number

5 breached
On time
81%
60 shipments · AED 594K
At risk
12%
9 · within 24h of breach
Breached
7%
5 · escalated
Aramex
92%
DHL
88%
Swftbox
83%
Porterex
71%
Quiqup
90%
Self
97%
All 74
Inbound 6
Outbound 52
Transfers 16
Exceptions 5
At customs 2
Delivered today 31
Aramex 28
DHL 18
Swftbox 13
Porterex 7
Air 9
Sea 1
Lulwa 6

Register

every row deep-links to the module that owns it 18 of 74 shown
ScopeReferenceType From → ToCarrierMode AWB / containerLinesUnits Value AEDStateException LedgerOwner
INB INB-2026-0719-005 Inbound freight CIC → HQ_319 DHLair 442911884041,180 268,400At customs SDEC lodged 3d 2 rows i3 inbound →
INB INB-2026-0702-001 Inbound freight CIC → HQ_319 Manualsea MSCU7719396 41,200Customs hold demurrage 6d · AED 3,840 2 rows i3 inbound →
INB INB-2026-0723-006 Inbound freight VJ Jewels → HQ_319 DHLair 44291133023640 214,800In transit none 2 rows i3 inbound →
INB INB-2026-0715-010 Inbound freight Brasswork Milano → HQ_319 DHLcou 4429117001124 8,900Exception AWB 404 · silent 14d 2 rows drift case →
INB SMP-2026-0728-2244 Sample receipt VJ Jewels → HQ_319 DHLcou 442912190414 3,900In transit SAMPLE_QC 72h on arrival 1 row samples →
OUT DSP-2026-0729-04182 Direct dispatch HQ_319 → Dubai Marina · #MIN10482 Aramexcou AX-9021333 3,480In transit none 3 rows ops2 →
OUT DSP-2026-0729-04185 Direct dispatch MCC → Al Ain · #MIN10488 Porterexcou PX-4412011 1,240NDR address failed · retry 2 of 3 1 row ops2 →
OUT REF-2026-0728-00091 Refulfill HQ_319 → Sharjah · #MIN10402 (re) Swftboxcou SWF-778211 2,180In transit original serial stays sold 1 row ops2 →
OUT DUP-2026-0727-00014 Duplicate voided HQ_319 → Dubai · #MIN10391 Aramexcou AX-9010420 0Voided no double deduction 0 rows ops2 →
TRF TRF-2026-0728-01 Store transfer HQ_319 → MCC Aramexcou AX-88421464 12,800In transit none 8 rows transfers →
TRF TRF-2026-0727-04 Store transfer HQ_319 → YAS Swftboxcou SWF-7644692 18,400Delivered 2 units short at receive 12 rows transfers →
TRF TRF-2026-0726-09 Replenishment HQ_319 → HQ_325 Selfroad SELF-RX-330114318 14,800Delivered none 28 rows transfers →
TRF TRF-2026-0725-11 Store transfer AJM → CCZ Quiqupcou QQ-11208321 6,700Overdue 4d in transit · SLA 2d 6 rows transfers →
OUT RTS-2026-0119 RTS supplier HQ_319 → CIC DHLair 4429122840412 3,512Pending ship QC reject_supplier · claim open 2 rows RTS →
OUT RTS-2026-0117 RTS supplier HQ_319 → Brasswork Milano DHLair 4429119908248 23,400In transit credit note expected 2 rows RTS →
INB RTC-2026-0728-0022 RTS customer Dubai · CSD-4821 → HQ_319 Aramexcou AX-9118011 1,780In transit IN_TRANSIT_RETURN 2 rows returns →
OUT INF-2026-0724-0044 Influencer HQ_319 → @noura.lifestyle · Riyadh DHLcou DHL-8820-441255 1,240In transit INFLUENCER_POOL loan 2 rows influencer →
OUT SLF-2026-0729-00218 Self delivery CCZ → Jumeirah · #MIN10491 Selfroad SELF-DX-118811 4,260Delivered none 1 row ops2 →
Shown · 18 of 74 2,511645,124 5 exceptions across 3 owners 77 rows
The Ledger column is the point of the page. A shipment that moved stock produced ledger rows; a shipment that did not, did not. The voided duplicate shows 0 rows, which is the visible proof that ops2's duplicate-shipment voiding did not double-deduct. A shipment showing units but 0 rows and no legitimate reason is a drift case, and the daily reconciler opens one automatically.

Exception queue

Customs hold
MSCU7719 · day 6 · AED 640/dayOpen
Silent 14 days
4429117001 · AWB 404 both APIs · 24 u in GITOpen
NDR · address failed
PX-44120 · retry 2 of 3 · PorterexOpen
NDR · customer unreachable
PX-44088 · retry 3 of 3 · RTS nextOpen
Transfer overdue
TRF-2026-0725-11 · 4d against a 2d SLAOpen
Auto-escalation fires at 7d silence and at 3 NDR attempts

Lost rate · rolling 90d

Percentage of shipments marked lost or unresolved · bars scaled 0 to 5% · SLA is 1%
Porterex
3.2%
Swftbox
1.1%
Aramex
0.4%
Quiqup
0.3%
DHL
0.2%
Self
0.0%
Porterex is 3.2x over SLA. Every lost shipment posts LOST_IN_TRANSIT and holds inventory value until the claim resolves, so a carrier lost rate is an inventory-accuracy problem, not only a service problem.

Dispatch to delivered · median

Aramex
1.8d
Swftbox
2.1d
Porterex
4.1d
Self
0.9d
DHL air inbound
6.2d
Sea inbound
32d
Carrier report →rolling 30d

One register, three owners

i3 writes only the inbound rows. Supplier freight, sample receipts and RTS-to-supplier are module 05's, because i3 owns the supplier pipeline (master plan authority matrix: "PO/PI/production status = i3"). Everything else is mirrored.

ops2 owns dispatch and AWB. Direct dispatch, refulfill, duplicate-void, NDR, RTO and COD are ops2 facts. i3 consumes them as signed events and mirrors them here read-only. i3 never books an outbound AWB.

Module 07 owns transfers. Store transfers and replenishment have their own state machine with 2N ledger postings; this page shows them and links out, and does not duplicate the state.

CREATE VIEW shipment_register AS
  SELECT 'inbound', … FROM inbound_shipments
UNION ALL
  SELECT 'outbound', … FROM ops2_shipment_mirror
UNION ALL
  SELECT 'transfer', … FROM transfer_shipments

A view, never a table. Materialising it would
create a fourth writer for facts three other
modules already own, and the fourth writer
always drifts.

Degradation. If ops2 is down the register shows inbound and transfers with a stale banner and a mirror age; the ops2 rows are not deleted, they are marked stale. If module 07 is unavailable, transfers drop out the same way. i3's own inbound rows are always live, because i3 is their source.

Connected to

Goods in transit → POs + PI → PO detail → Production → Transfers → Transfer detail → Returns → Return to supplier → Influencer → Samples → GRN + QC → ops2 events → CSD events → Cartons → Drift → Ops health → Reports → Dashboard →