← Architecture Overview
v2.0 · March 2026 · Metalogix Solutions
Sales & Analytics
Products & Packages
Transport & Comms
Supply Chain
Operations
Finance
Admin & Portals
95+ Routes
110+ Templates
68 DB Tables
19 JS Modules
10 Nav Sections
3 Portals
Tier 1 — Entry Points & Portals
PORTAL
Landing Page
Public home · Tour showcase · Package browsing · Contact & booking CTA
PORTAL · STAFF
Admin Portal
Staff login · Full system access · Role-restricted modules · Dashboard
PORTAL · CLIENT
Client Portal
Browse packages · Track booking · View itinerary · Make payments
PORTAL · SUPPLIER
Supplier Portal
Manage rates · Confirm availability · View vouchers · Performance stats
▾
▾
▾
Tier 2 — Sales Pipeline
SALES
Lead Pipeline
Kanban pipeline · Stage tracking · Source attribution · Follow-up tasks
SALES · CRM
Customers
Profiles · Booking history · Loyalty tiers · Reviews · Communication log
SALES
Trip Planner
Custom itinerary builder · Day-by-day planning · Product selection · Costing
SALES
Quote Builder
Itinerary pricing · Mark-up control · Versioning · PDF & email · Expiry
SALES · B2B
Agents
Agent profiles · Dashboard · Commission tiers · Statements · Performance
DECISION
Quote Accepted?
NO ▶
SALES
Revise / Archive
YES ↓
Tier 3 — Quote → Booking Conversion
RESERVATIONS
Create Booking
From quote · Manual · FIT · Group · MICE · Journey manager · Guest itinerary
RESERVATIONS
Passenger Management
Passports · Visa status · Medical · Emergency contacts · Manifest export
RESERVATIONS
Groups
Group bookings · Rooming lists · Combined manifest · Departure packs
RESERVATIONS
Insurance
Policy recording · Cover types · Provider details · Claim reference tracking
▾
▾
▾
▾
▾
▾
Tier 4 — Product & Service Allocation
PRODUCTS
Accommodation
Hotels · Lodges · Room types · Board basis · Pricing · Allotment
TRANSPORT
Flights
PNR import · Airlines · Seat manifest · Baggage · Flight manifest
TRANSPORT
Transfers
Airport · Hotel · Excursion · Shared & private · Driver allocation
PRODUCTS
Activities
Tours · Excursions · Time-slots · Group capacity · QR voucher
TRANSPORT
Car Rentals
Europcar · Hertz · Vehicle class · Rental period · Insurance options
PRODUCTS
Packages
Builder · Showcase · Templates · Preview · Promotions · Media
▾
Tier 5 — Supply Chain
SUPPLY CHAIN
Supplier Management
Contracts · Rate sheets · Performance · Portal access · Preferred partners
SUPPLY CHAIN
Voucher System
Generate · QR codes · Stock · Templates · Bulk create · Email delivery
SUPPLY CHAIN
Inventory & Pricing
Allotment management · Seasonal pricing · Promotions · Availability windows
supplier & stock coordination
Tier 6 — Operations (System Core)
OPERATIONS · LIVE
Mission Control
Live operations board · Real-time status · Today's departures · Search · Alerts
OPERATIONS
Operations Centre
Daily run sheet · Guide assignment · Vehicle allocation · Incident log
TRANSPORT HUB
Transport Hub
Flights · Fleet · Transfers · Car rentals · Drivers · Scheduling
OPERATIONS
Calendar
Booking schedule · Departure events · Resource availability · Block-outs
OPERATIONS
Field Operations
Mobile guide view · Checklist · On-site passenger & service management
live operational coordination
▾
▾
▾
Tier 7 — Communications & Documents
COMMS
Email & Inbox
Inbox · Compose · Email templates · Correspondence history per booking
COMMS
Campaigns
Email marketing · Campaign builder · Audiences · Scheduling · Analytics
COMMS
Documents
Document builder · Guest itinerary · Template library · PDF output · Branding
OPERATIONS
Travel Alerts & Visa
Weather · Political alerts · Visa requirements by destination · Entry rules
guest communication flow
Tier 8 — Financial Management
FINANCE
Invoicing
Client AR · Pro-forma · Credit notes · Account statements · PDF branded
FINANCE
Payments
Client receipts · Supplier AP · Reconciliation · Unallocated · Balance tracking
FINANCE
Full Accounting
Chart · GL · AR · AP · Revenue recognition · Period-end · Trial balance
FINANCE
Bank Reconciliation
Statement import · Auto-match · Manual match · Exceptions · Period close
double-entry financial flow
Tier 9 — Analytics & Business Intelligence
ANALYTICS
Reports & Dashboard
Revenue · Bookings · Pipeline · Custom builder · Export PDF/CSV/Excel
ANALYTICS
Revenue Forecasting
Projections · Scenario modelling · Pipeline value · Forward booking trends
ANALYTICS
Competitive Intelligence
Competitor pricing · Market positioning · SWOT analysis · Rate benchmarking
ANALYTICS
Agent Commission
Commission tiers · Statements · Payable tracking · Period sign-off
ANALYTICS
Staff Performance
Sales KPIs · Leaderboard · Target tracking · Activity metrics
Tier 10 — Administration & Configuration
ADMIN
Users & Roles
RBAC · Granular permissions · Role templates · Session management
ADMIN
Workflows
Approval flows · Threshold triggers · Auto-notifications · Stage gates
ADMIN
Currencies
Multi-currency · Exchange rates · Base currency · Mark-up defaults
ADMIN
Cancellation Policies
Policy builder · Date-banded penalties · Refund calculator · Per-product
ADMIN
Branding & Languages
White-label · Logo · Colour schemes · Multi-language · Locale formatting
ADMIN
Audit Log & Integrations
Full activity trail · User actions · API integrations · Email gateway
Tier 11 — Data Layer
DATABASE ARCHITECTURE
PostgreSQL 16+ / AWS RDS
68 Tables · 165+ Indexes · 105+ Foreign Keys · 16 Domains · POPIA Compliant · Monthly Partitioned Audit Log
ADMIN
Users & Auth · 4 tables
users · roles · portal_users_client · portal_users_supplier
SALES · CRM
CRM · 6 tables
customers · tags · leads · loyalty · points
SALES
Reviews · 1 table
reviews
SALES
Quotes · 4 tables
quotes · itinerary_days · services · inclusions
RESERVATIONS
Bookings · 7 tables
bookings · status_history · services · passengers · schedules · groups · staff
PRODUCTS
Products · 4 tables
products · seasons · price_rates · inventory_records
PRODUCTS
Packages · 6 tables
packages · days · day_services · promotions · pkg_promo · media
SUPPLY CHAIN
Vouchers · 4 tables
vouchers · stock_packs · templates · recon_log
SUPPLY CHAIN
Suppliers · 3 tables
suppliers · contracts · rate_sheets
SALES · B2B
Agents · 2 tables
agents · agent_commissions
TRANSPORT
Transport · 5 tables
vehicles · drivers · flight_bookings · transfers · car_rentals
FINANCE
Finance · 6 tables
invoices · line_items · payments · currencies · rates · cancellation
FINANCE · GL
Accounting · 6 tables
accounts · journal_entries · journal_lines · bank_statements · stmt_lines · revenue_rec
COMMS
Communications · 3 tables
communications · templates · campaigns
DOCUMENTS
Docs & Media · 2 tables
documents · media_assets
OPERATIONS
Operations · 4 tables
tour_guides · ops_assignments · visa_requirements · travel_alerts
ADMIN · SYSTEM
System · 7 tables
workflows · approvals · integrations · settings · audit_log · notes · activity_log
Identity & Tenancy
BIGINT PKs + UUID external IDs · Future multi-tenant ready (company_id on every table) · Soft delete on 7 entities (deleted_at)
Financial Integrity
NUMERIC(15,2) on all money columns · Multi-currency with exchange_rate_snapshots · Double-entry accounting (journal_entries + journal_lines)
Compliance & Audit
POPIA annotations on all PII columns · Monthly partitioned + immutable audit_log · Trigram indexes for fuzzy name search · GIN indexes on JSONB