DERP Data Mapping · 数据集成映射
How existing DERP reports and order interfaces feed the LensFlow AI control tower.
Source Systems · 数据源
DERP · Agent Order Portal · Manufacturer UI
Ingest Cadence · 同步频率
Daily T+1 batch · Order interface near real-time
Pending Inventory Rule · 待处理库存规则
Excluded from Available — flagged as Pending/Hold
Existing Report → Control Tower Module Mapping
Every existing DERP feed maps to one or more LensFlow AI modules.
| Existing Report | Source | Key Fields | Used For (Control Tower Module) |
|---|---|---|---|
T1 Sales Report T1 销售报表 | DERP | Sales QtyProduct CodeProduct FamilyProduct CategoryCustomerRegionDate |
|
T1 Inventory Shelf Life Report T1 库存效期报表 | DERP | Report DateProduct FamilyProduct CategoryProduct CodeProduct NameProduct SpecificationDPTCYLUnitInventory QTYExpiry DateShelf Life DayShelf Life MonthWarehouse Name |
|
Consignment Report 寄售报表 | DERP | Hospital / DealerConsignment StockUsed StockReturned StockAvailable Stock |
|
Inventory Aging Report 库存账龄报表 | DERP | BatchInventory AgeWarehouseStatusAvailable Quantity |
|
Order Report 订单报表 | Agent-to-Platform + Manufacturer UI | Dealer OrderPlatform OrderProduct CodeOrder QuantityOrder StatusOrder Date |
|
Pipeline Diagram · 数据流向
DERP & order interfaces → unified inventory + forecast control tower
1 · Source
- • T1 Sales Report
- • T1 Inventory Shelf Life Report
- • Consignment Report
- • Inventory Aging Report
- • Agent / Manufacturer Order Interface
2 · LensFlow Data Layer
- • SKU master harmonization
- • Warehouse / batch / expiry normalization
- • Available = On-Hand − Committed − Pending/Hold
- • 45-day ROP & shelf-life buckets
3 · Control Tower Modules
- • Executive Dashboard
- • Inventory Control · 45-day plan
- • Demand Forecast · 3 scenarios
- • Expiry & Shelf-Life Risk
- • Supplier Performance