Kroger EDI Web

Pharmacy 867 Product Transfer
& Resale

OVERVIEW

The Kroger Pharmacy Procurement area has Inventory Management Agreements in place with several pharmaceutical manufacturers. The agreements reward Kroger with incentives for transmitting store level 867 data (sales and returns) to participating pharmacy companies once a week. The data is transmitted weekly on Tuesday for previous Saturday thru Friday movement.

If you are a pharmacy company and would like to participate in the incentive program and to receive the 867-pharmacy transaction, please contact: Bob Breetz Coordinator Pharmacy Procurement, The Kroger Co. Phone: 513 762-1503 E-mail: bob.breetz@kroger.com.

Kroger will extract the data from our own in-house product movement history file and create the pharmacy 867. The originating Peyton distribution centers will be listed on the 867 along with the Kroger store movement. The distribution center and the DEA# will be provided on the N1*DB immediately following the N1*SU (supplier).

Peyton Distribution Centers
No.	Distribution Center Name	DEA Qual	DEA Number
1.	Kroger - Peytons Bluffton	11	PP0220828
2.	Kroger - Peytons Cleveland	11	RK0233180
3.	Kroger - Peytons Pheonix	11	RS0261379

The data will be sorted by supplier, report end date (DTM*091), report start date (DTM*090), DC DEA# (N104 DB), store DDEA (N104 ST), Return or Sales (PTD02), invoice date (DTM*003), invoice # (REF02). Thus for each pharmacy supplier there can be up to three 867s (STs) created, one for each DC.

Maps for the pharmacy 867 is located on the Kroger EDI web site: http://edi.kroger.com

Below is an example of the format with multiple Peyton DC’s per pharmacy supplier.

ST*867*00017001~ BPT*00**20080331*SS~ DTM*090*20080322~ DTM*091*20080328~ N1*SU*XYZ Company*11*RA000000~ N1*DB*Kroger - Peytons Bluffton*11*PP0220828~ PTD*RP~ DTM*003*20080328~ REF*IK*000001~ N1*ST*FRED MEYER 025*11*AB5944497~ N3*800 LAKEWAY DRIVE~ N4*BELLINGHAM*WA*98226~ QTY*76*2*EA~ LIN**N4*00074331290*PI*111111~ UIT*EA*-000.00*WH~ AMT*1*-000.00~ PID*F****ANY TYPE DRUG 90 CT~ ....

...

ST*867*00017002~ BPT*00**20080331*SS~ DTM*090*20080322~ DTM*091*20080328~ N1*SU*XYZ Company*11*RA0000000~ N1*DB*Kroger - Peytons Cleveland*11*RK0233180~ PTD*SS~ DTM*003*20080324~ REF*IK*536034~ N1*ST*KROGER L-86*11*AK1363035~ N3*4400 LEBANON RD~ N4*HERMITAGE*TN*37076~ QTY*32*1*EA~ LIN**N4*00074612290*PI*111111~ UIT*EA*11.11*WH~ AMT*1*11.11~ PID*F****ANY TYPE DRUG 90 CT~

....

ST*867*00017003~ BPT*00**20080331*SS~ DTM*090*20080322~ DTM*091*20080328~ N1*SU*XYZ Company*11*RA0000000~ N1*DB*Kroger - Peytons Pheonix*11*RS0261379~ PTD*SS~ DTM*003*20080322~ REF*IK*223975~ N1*ST*CITY MARKETS 02*11*AC1381273~ N3*131 MARKET STREET~ N4*ALAMOSA*CO*81101~ QTY*32*3*EA~ LIN**N4*00074307490*PI*111111~ UIT*EA* 111.1111*WH~ AMT*1*111.11~ PID*F****ANY TYPE DRUG 90 CT~

....

...

SE*17017*00017003~ GE*3*17~ IEA*1*000000159~

«Back