📊 Pharma Data File Flow - Overview 1 RAW Daily Files (Input Layer) 📁 852 Daily – Inventory Data

📊 Pharma Data File Flow - Overview 1. RAW Daily Files (Input Layer) 📁 852 Daily – Inventory Data (On Order, Available, Sales) 📁 867 Daily – Sales Data (By Specialty Pharmacy) 📁 SRx Daily – Customer Sales Journey (Prescriber to Delivery) ⬇️ (data passes through Quality Control and MDM processing) 2. Control Files (QC Layer) ✅ Cntrl 852 – Record count + Total Sales ✅ Cntrl 867 – Record count + Total Sales ✅ Cntrl SRx – Record count + Total Sales 3. Fallout Files (MDM Exceptions) ⚠️ 867 Fallout – Excluded records from MDM ⚠️ SRx Fallout – Excluded records from MDM 4. Changelog (VCID Mastering) 🔄 Changelog1 – Merged VCID records 🔀 Changelog2 – Split VCID records 5. Weekly Mastered Files (Reporting Output) 📦 852 Weekly – Final Inventory Data (SOT) 📦 867 Weekly – Final Sales Data (SOT) 📦 SRx Weekly – Final Customer Journey Data (SOT) can you make this in image way

24.07.2025 16:33