What is an 852 EDI Product Activity Data Document?
Many retailers benefit from their EDI 852 data. It provides the retailer with the detailed product activity of the items they are selling in their locations (stores).
There’s 2 specific areas the activity data it provides:
- The POS (point of sale) information of sales
- Current products inventory
With these 2 areas of information the detailed components consist of:
- POS – units sold by SKU
- POS – units sold in retail OR wholesale
- Inventory – On hand quantities by SKU detail
These components can be summarized by either a physical store location OR distribution center depending on setup.
With this information provided to both the retailer and supplier the retail metrics can be calculated to measure performance levels:
- Sell Thru %
- Days/Weeks of Supply
- Sales forecasting
- YTD Sales, MTD, and WTD sales
- Year over year, month over month comparisons
- Replenishment of product
The 852 EDI file typically is exchanged in an X12 format. Raw example below shown:
ISA00 00 08925485US00 125551234567 2112152308*:005018521005830P*>
GSPD925485US005551234567202112182308852100583X005010
ST852100583
XQH20211214
N9IA740012560
N9FI01ST
N1FRWALMARTUL0078742000008
N1TOGROWER FARMS LLC.
DTM09720211218
LIN000001UP783975629553IN577321454VN*63033
PO4*1
ZAQS13*EA
LIN000002UP783975611474IN577472754VN*611463
PO4*1
ZAQS2*EA
LIN000003UP783975656942IN586246840VN*656952
PO4*1
ZAQS6*EA
CTT*23
SE78100694
GE1852100694
IEA1852100694