# FellaHost Company Limited
**Project Developers & Software Engineering Specialists**  
**Document Reference:** Section 24 Deliverables for Software Development Team  
**System Designation:** Integrated Clearing, Forwarding & Logistics System (ICFLS)  
**Corporate Entity:** FellaHost Company Limited  
**TIN NO:** 189-723-717 | **B.L.No:** 20000105272  
**Headquarters:** P.O. Box 80079, Dar es Salaam, Tanzania  
**Support Desk:** support@fellahost.co.tz | **Web:** www.fellahost.co.tz  
**System Deployment Host:** `logistics.domain.co.tz` | `api.domain.co.tz`  
**Publication Date:** September 2026 | **Version:** 1.0 (Production Master Engineering Pack)  

---
# 9. Data Migration Templates & Ingestion Guidelines

## Executive Overview
Legacy data from spreadsheet records, isolated accounting software, and manual port manifests must be extracted, cleansed, transformed, and ingested into the ICFLS MariaDB database according to strict ETL validation criteria.

---

## 9.1 Core Migration CSV Schemas

### 9.1.1 Customer Master Template (`customers_import.csv`)
```csv
customer_code,company_name,tin_number,vrn_number,email,phone,credit_limit_tzs,escrow_balance_tzs,status
CUST-001,Kilimanjaro Traders Ltd,104-981-224,40-001241-K,info@kt.co.tz,+255754000111,50000000.00,12500000.00,Active
CUST-002,Victoria Lake Mining Co,118-291-002,,procure@vicmining.co.tz,+255784999888,100000000.00,45000000.00,Active
```

### 9.1.2 Vehicle & Fleet Master Template (`vehicles_import.csv`)
```csv
plate_number,trailer_number,make,model,year,payload_tons,fuel_capacity_liters,status
T-882-DFR,T-104-EAA,Scania,R500,2022,32.0,600,Available
T-419-ABC,T-302-BBA,Volvo,FH16,2021,35.0,750,On_Trip
```

---

## 9.2 Ingestion Validation Pipeline
1. **Deduplication Phase**: Check TIN, VRN, and Container Numbers against active rows. Duplicate records are diverted to `migration_rejects.csv`.
2. **Referential Resolution**: Validate foreign keys (e.g. verify `customer_code` exists prior to attaching jobs).
3. **Escrow Custody Reconciliation**: Starting balances in `escrow_balance_tzs` must balance against historical bank ledger deposit statements.

---

### Regulatory Notice
> **We're Top leading Company Registering under Commercial & Technical ICT Services TIN NO: 189-723-717**  
> *FellaHost Company Limited — Project Developers & Engineering Specialists.*  
> *Confidential & Proprietary Enterprise Asset — All Rights Reserved.*