System Blueprint

Architecture & Cross-Module Data Lineage

5 layers + 6 stages — ทุก entity ระบุ upstream/downstream ชัดเจน

SCM Flow Spine
1
Demand & MPS/MRP
Forecast → S&OP → MPS → MRP
2
Procurement
RFQ → PO → 3-way match
3
Production & QC
Work Orders → Mill/Polish → QC
4
Warehouse
FEFO putaway · zone pick · trace
5
Order Management
Multi-channel capture · ATP · allocate
6
Logistics & ePOD
Route opt · GPS · ePOD

Channel Layer

วิธีที่ลูกค้า/คู่ค้า ติดต่อระบบ
EDI/AS2 (MT)REST API (E-Com)Vendor PortalDistributor AppCustomer PortalExport L/C Gateway

Application Layer · Odoo v19

Core ERP modules
Sales / OMSPurchase / RFQManufacturingInventory & WMSQuality (QC)Accounting (3-way)HR & Multi-Co

Intelligence Layer · Lovable AI

Agentic + RAG + analytics
Demand ForecastingRoute OptimizationAnomaly DetectionDocument Q&A (RAG)Agentic ActionsConversational SCM

Data Layer

Source of truth
PostgreSQL (Odoo)Data LakeDocument StoreEvent StreamAudit Log

Platform & Security

Trust layer
SSO (Azure AD)RBACMulti-Company × 7ISO 27001Backup & DR
Data Lineage

ข้อมูลไหลข้ามโมดูลอย่างไร

ตัวอย่างจริงจาก mock dataset — แสดงว่าทุก document มี upstream + downstream

1Demand & MPS/MRP
in: POS · sell-through · promo calendar
out: Net req → Procurement signal
2Procurement
in: MRP signal · AVL
out: GRN → Raw material to Production/WH
3Production & QC
in: Paddy · packaging · BOM
out: FG lot → FEFO putaway
4Warehouse
in: FG lot · ASN
out: ATP stock → OMS allocation
5Order Management
in: Channel orders · ATP
out: Pick wave → Logistics
6Logistics & ePOD
in: Pick wave · fleet
out: ePOD → AR → Returns

Concrete Trace · MBK-HM-25

ติดตาม 1 SKU ตั้งแต่ forecast ถึง ePOD

Upstream chain
ForecastFCST-W26 · MBK-HM-25 · 3,200 units
MRPMRP-2026W23-001 · req paddy 4,700 kg
RFQ → POPO-2026-0142 · สหกรณ์การเกษตรทุ่งกุลาร้องไห้
GRN targetWH-LLK-A03
Downstream chain
Production lotLOT-2026W19-C · yield 68.3%
PutawayWH-LLK-A03 · FEFO exp 2027-01-12
Sales OrderSO-2026-8847 · Hanoi Trading Co.
RouteRT-EX-LCL-VN · Container LCL → Hanoi

Phase 1 · Q3-Q4

  • • Core ERP + OMS
  • • Master data + Multi-co setup
  • • MT EDI go-live

Phase 2 · Q1-Q2

  • • Manufacturing + WMS
  • • AI Copilot rollout
  • • TT distributor app

Phase 3

  • • Export L/C automation
  • • Advanced analytics
  • • Vendor portal