Emerson Data Source Memo
Client: LMNT | Data source: Emerson LMNT share | Date: 2026-04-08 (ingestion scope date)
Summary
The Emerson share gives one connected view of retailer order-to-cash operations, warehouse activity, and retailer sell-through. It is broad enough to support daily execution and executive reporting.
What is newly available
Newly available here means newly available in our Snowflake warehouse from this Emerson ingestion. It does not mean newly created in Emerson source systems.
Retailer order-to-cash data (B2B)
This includes open orders, invoiced orders, shipment tracking, cuts, allocations, ending accounts receivable, and paid accounts receivable. It supports a clear view of demand, fulfillment, and cash collection in one flow.
Geodis warehouse data
This includes current inventory, inventory history, inventory aging over time, receipt detail, and open order detail history. It provides warehouse-level visibility and operational trend history from 3PL extracts.
Walmart hierarchy mapping data
This includes an additional Walmart item attribute table used for alternate hierarchy mapping.
What this unlocks
This source supports commercial, operations, and finance reporting in one place. We can connect open pipeline to shipped and invoiced outcomes, track warehouse and inventory behavior over time, and monitor retailer sell-through across Walmart and Target.
Questions we can now answer
- What is currently open by customer, week, and product, and how does that compare to invoiced and shipped volume?
- Where are cuts, short shipments, or delays happening most often?
- What is the current and historical inventory position in Geodis?
- How does Target and Walmart sell-through change by day, item, and location?
- What is outstanding in receivables, and where are deductions or delayed collections concentrated?
Recommended next step
Use this source set as the base for a structured retailer order-to-cash and retail sell-through reporting layer with clear definitions for open, shipped, invoiced, and collected metrics. Delivery and data leads should complete the first reporting cut this month.
What is already documented and discussed
Walmart retail data and Target retail data are already documented and discussed. This includes the core Walmart sales, inventory, calendar, store, and item structures, plus Target daily sales, daily inventory, and item planning structures used for regular reporting.