EDI Program and Requirements

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~