Logistics
Shipments, proof of delivery, delivery exceptions and attempts, routes, carrier charges and settlements.
447
Source rows at Day-0
27
Populated tables
28
Exported tables
Collections
Shipments9
Shipments and the ERP delivery or transfer each carries. Items and status history appear inside each.
Proof of Delivery7
Delivery evidence. A superseded proof stays visible as source history.
Delivery Exceptions2
Delays and delivery problems.
Delivery Attempts3
Each attempt to deliver, and its outcome.
Routes2
Delivery routes and their stops.
Transport Charges2
Carrier charges, and the ERP payable each became.
Carrier Settlements1
A carrier's settlement period, and the ERP journal that posted it.
Representative records
What these records become
Shipment ×9
Canonical records projected from Logistics source records. A source record's own page links to the canonical record it resolves or projects to.
Cross-system journeys
Technical schema — 28 exported tables in log_src
- audit_event134
- carrier1
- carrier_settlement_ref1
- delivery_attempt3
- delivery_exception2
- document_sequence3
- driver_ref2
- eta_snapshot3
- gps_position5
- idempotency_key133
- location_ref4
- outbox_event22
- package0
- proof_of_delivery7
- role5
- route2
- route_deviation1
- route_stop7
- service_level4
- shipment9
- shipment_address4
- shipment_item10
- shipment_status_history49
- stop_event20
- transport_charge2
- user_account6
- user_role6
- vehicle_ref2