Data Upload · 数据导入
Standardized CSV templates aligned with existing DERP reports.
Data Quality Check 数据质量检查
Last import 2026-06-03 22:14 · 1,284 rows · Integration Readiness Score below
Integration Readiness 集成就绪
86%
Up from 78% last week
Rows Loaded 行数
1,284
6 templates · 4 sources
Quality Issues 质量问题
23
14 blocking · 9 warnings
Pending Inventory 待处理
118 u
Excluded from available
Last Sync 同步时间
T-8h
Next: 22:00 CST
| Issue 检查项 | Severity | Count | Source Report | Suggested Fix |
|---|---|---|---|---|
| Missing required field (Warehouse Name) | high | 4 | T1 Inventory Shelf Life | Map column 仓库名称 → warehouse_name |
| Invalid DPT / CYL format | high | 7 | T1 Inventory Shelf Life | Normalize to DPT -08.00 / CYL +01.50 |
| Missing expiry date | high | 3 | T1 Inventory Shelf Life | Require expiry_date for stock rows |
| Duplicate batch number | medium | 2 | T1 Inventory Shelf Life | De-dupe by batch + warehouse |
| Warehouse status 待处理 not classified | medium | 5 | T1 Inventory Shelf Life | Mark as Pending/Hold, exclude from available |
| Inventory quantity mismatch (DERP vs Order) | medium | 2 | Order Report | Reconcile committed vs on-hand |
SKU Master · 产品主数据
Product catalogue, dimensions, supplier mapping, shelf life
| product_code | product_family | product_category | product_specification | dpt | cyl | unit | supplier | lead_time_days | shelf_life_months |
|---|---|---|---|---|---|---|---|---|---|
| ICL-EVO-TORIC-M080-C100-S126 | AT LISA TORIC 909M | 高端晶体 | AT LISA TORIC 909M CN DPT 08.00 CYL 01.00 | DPT -08.00 | CYL +01.00 | 盒 | Shanghai Pharma | 45 | 36 |
| ICL-EVO-SPH-M075-S126 | EVO Visian ICL V4c | 标准晶体 | EVO Visian ICL V4c CN DPT 07.50 | DPT -07.50 | — | 盒 | Shanghai Pharma | 45 | 36 |
Last upload: 2 days ago · 1,284 rows · 0 errors
T1 Inventory Shelf Life Report · T1 库存效期报表
DERP report — drives expiry risk, warehouse stock visibility, SKU availability
| Report Date | Product Family | Product Category | Product Code | Product Name | Product Specification | DPT | CYL | Unit | Inventory QTY | Expiry Date | Shelf Life Day | Shelf Life Month | Warehouse Name |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-06-04 | AT LISA TORIC 909M | 高端晶体 | ICL-EVO-TORIC-M000-C150-S121 | 人工晶状体 | AT LISA TORIC 909M CN DPT 00.0 CYL 01.5 | DPT 00.0 | CYL 01.5 | 盒 | 18 | 2030-08-04 | 1521 | 50 | 绥德西库合格 |
| 2026-06-04 | EVO Visian ICL V4c | 标准晶体 | ICL-EVO-SPH-M075-S126 | 人工晶状体 | EVO Visian ICL V4c CN DPT 07.50 | DPT -07.50 | — | 盒 | 42 | 2028-09-15 | 830 | 27 | 上海中心库合格 |
| 2026-06-04 | AT LISA TORIC 909M | 高端晶体 | ICL-EVO-TORIC-M080-C100-S126 | 人工晶状体 | AT LISA TORIC 909M CN DPT 08.0 CYL 01.0 | DPT -08.0 | CYL +01.0 | 盒 | 6 | 2026-11-20 | 169 | 5 | 上海中心库待处理 |
| 2026-06-04 | AT LISA TRI 839MP | 高端晶体 | ICL-EVOP-TORIC-M120-C300-S132 | 人工晶状体 | AT LISA TRI 839MP CN DPT 12.0 CYL 03.0 | DPT -12.0 | CYL +03.0 | 盒 | 12 | 2027-02-10 | 251 | 8 | 广州区域库待处理 |
Rows with warehouse status 待处理 must NOT be counted as available stock — they require QA release first.
Last upload: 2 days ago · 1,284 rows · 0 errors
T1 Sales Report · T1 销售报表
Drives demand forecast, regional trend, SKU consumption history
| Date | Product Code | Product Family | Product Category | Customer | Region | Sales Qty |
|---|---|---|---|---|---|---|
| 2026-05-12 | ICL-EVO-SPH-M075-S126 | EVO Visian ICL V4c | 标准晶体 | Shanghai Eye Center | East China | 3 |
| 2026-05-13 | ICL-EVO-TORIC-M080-C100-S126 | AT LISA TORIC 909M | 高端晶体 | Shenzhen Premium Eye Clinic | South China | 2 |
Last upload: 2 days ago · 1,284 rows · 0 errors
Order Report · 订单报表
Dealer / platform orders — drives committed stock & replenishment
| order_date | po_id | dealer | platform | product_code | order_qty | order_status |
|---|---|---|---|---|---|---|
| 2026-05-22 | PO-2026-0451 | Shanghai Pharma | DERP | ICL-EVO-TORIC-M080-C100-S126 | 60 | Fulfilled |
| 2026-05-25 | PO-2026-0452 | Supplier B | DERP | ICL-EVOP-SPH-M100-S132 | 30 | In Transit |
Last upload: 2 days ago · 1,284 rows · 0 errors
Consignment Report · 寄售报表
Hospital / dealer consignment stock control
| hospital_or_dealer | consignment_stock | used_stock | returned_stock | available_stock |
|---|---|---|---|---|
| Shanghai Eye Center | 24 | 9 | 1 | 14 |
| Guangzhou Vision Hospital | 18 | 6 | 0 | 12 |
Last upload: 2 days ago · 1,284 rows · 0 errors
Supplier Performance · 供应商履约
PO-level on-time delivery, fulfillment accuracy, lead time
| po_id | supplier | order_date | promised_date | received_date | ordered_qty | received_qty |
|---|---|---|---|---|---|---|
| PO-2026-0451 | Shanghai Pharma | 2026-04-08 | 2026-05-23 | 2026-05-22 | 60 | 60 |
| PO-2026-0452 | Supplier B | 2026-04-10 | 2026-05-25 | 2026-05-28 | 30 | 28 |
Last upload: 2 days ago · 1,284 rows · 0 errors