EDI Implementation Guidelines 850/856/997 - Commport Communications

Bartell Drugs EDI Implementation Guide: Version 3.7 EDI Implementation Guidelines 850/856/997 Revised: Version 3.7 January 2019 Latest additions: Updated LIN02 and LIN03 from Used to Mandatory in the 856. Changed the qualifier in the DTM01 in the 850 to “002” from “011” for Delivery Requested Date. Changed Bartell EDI Contact to EDI Support email address. Added New Bartell Logo to Document. Added Highlights to draw attention to Mandatory Requirements and updated dates and notes. Added N1 Highlights for Store Number in 856. Added LIN01 Element for Line numbering in the Ship Notice/Manifest (856). Added PO101 Element for Line numbering in the 850. Added PO4 Segment to the 850 for the PO401 element. Added the AMT Segment to the 850 for the AMT01 and AMT02 elements. Page 1 of 10 1/02/2018

Bartell Drugs EDI Implementation Guide: Version 3.7 Table of Contents EDI Contacts .3 EDI Trading Partner ID's . . 3 Transaction Specifications 850 Purchase Order (Layout & Example) . . .4-6 856 Advanced Shipping Notice (Layout & Example) . 7-9 997 Functional Acknowledgement (Layout & Example) .10 Page 2 of 10 1/02/2018

Bartell Drugs EDI Implementation Guide: Version 3.7 EDI Contacts: Bartell EDI Support: EDI Support Email: EDISupport@bartelldrugs.com Commport VAN: EDI Help Desk Phone: (905) 727-6782 – EDI Option Fax: (905) 727-7251 Email : support@commport.com Bartell EDI ID: Qualifier 12 ISA ID 2067671376 GS ID 2067671376 Bartell EDI Version 004010 X12 Network COMMPORT Page 3 of 10 1/02/2018

Bartell Drugs EDI Implementation Guide: Version 3.7 850 Purchase Order: 004010 SEGMENT ELEMENT BEG NAME USAGE BEGINNING SEGMENT FOR PURCHASE ORDER 01 353 02 92 03 324 TRANSACTION SET PURPOSE CODE PURCHASE ORDER TYPE CODE PURCHASE ORDER NUMBER DATE 05 Code identifying purpose of transaction set (00- Original) Code specifying the type of purchase order (SA-Stand-alone order) Identifying number for po assigned by orderer/purchaser Date expressed as CCYYMMDD 374 373 N1 DATE / TIME QUALIFIER DATE 01 98 ENTITY IDENTIFIER CODE 02 03 93 66 NAME IDENTIFICATION CODE QUALIFIER IDENTIFICATION CODE 04 67 “002” – Requested Delivery Date Date expressed as CCYYMMDD 166 166 N4 19 156 116 26 2/2 M 1/22 ADDRESS INFORMATION ADDRESS INFORMATION CITY NAME STATE CODE ZIP CODE COUNTRY CODE 8/8 M C 3/3 8/8 Code identifying Bartell Drugs ST- Ship To Free form name "91" Assigned Bartell DC Number M 2/3 C C 1/60 1/2 Bartell D.C. Number C 2/80 O Address information Address information GEOGRAPHIC LOCATION 01 02 03 04 M M ADDRESS INFORMATION 01 02 2/2 O NAME N3 M M DATE/TIME REFERENCE 01 02 LENGTH M 373 DTM RE Q' D M O 1/55 1/55 O Free-form text for city name Code for State Zip Code Code identifying the Country “USA”-United States O O O O 2/30 2/2 3/15 2/3 Page 4 of 10 1/02/2018

Bartell Drugs EDI Implementation Guide: Version 3.7 P01 BASELINE ITEM DATA M 01 02 03 350 380 355 ASSIGNED IDENTIFICATION QUANTITY ORDERED UNIT OR BASIS FOR MEASUREMENT CODE Line numbering Quantity ordered Code specifying the units in which a value is being expressed. 04 212 UNIT PRICE Price per unit of product, service, commodity, etc. “VC” 06 235 PRODUCT/SERVICE ID QUALIFIER 07 08 234 235 PRODUCT/SERVICE ID PRODUCT/SERVICE ID QUALIFIER 09 234 PRODUCT/SERVICE ID Vendor Code “UI” M C O 1/20 1/15 2/2 C 1/17 C 2/2 C C 1/48 2/2 C 1/48 UPC Code PO4 (US ED) O Item Physical Details 01 356 CTT PACK The number of inner containers, or number of eaches if there are no inner containers, per outer container 354 AMT NUMBER OF LINE ITEMS Total number of line items on the transaction set 522 782 Amount Qualifier Code Monetary Amount 1/6 M (US ED) O Monetary Amount Information 01 02 O (US ED) O TRANSACTION TOTALS 01 1/6 Code to qualify amount “TT” Monetary amount 1/3 1/18 M M Page 5 of 10 1/02/2018

Bartell Drugs EDI Implementation Guide: Version 3.7 Example 850 – Purchase Order ISA*00* *00* *12*2067671376 *ZZ*VENDOR *170104*1511*U*00401*000000001*0*P* GS*PO*2067671376* VENDOR *20170104*1511*1*X*004010 ST*850*0001 BEG*00*SA*S18-11111**20170104 DTM*011*20170104 N1*ST*BARTELL #18 Kingsgate*91*018 N3*14442 124th Avenue NE N4*Kirkland*WA*98034*USA PO1*1*12*EA*0.11**VC*111111*UI*000011111115 PO4*1 PO1*2*12*EA*0.22**VC*222222*UI*000002222226 PO4*1 PO1*3*24*EA*0.33**VC*333333*UI*000003333334 PO4*1 CTT*3 AMT*TT*11.88 SE*15*0001 GE*1*1 IEA*00001*000000001 Page 6 of 10 1/02/2018

Bartell Drugs EDI Implementation Guide: Version 3.7 856 Advanced Shipping Notice: 004010 SEGMENT ELEMENT BSN USAGE BEGINNING 01 353 02 03 04 05 92 373 337 1005 HL TRANSACTION SET PURPOSE CODE SHIPMENT IDENTIFICATION DATE TIME HIERARCHICAL STRUCTURE CODE 628 735 TD1 HIERARCHICAL ID NUMBER HIERARCHICAL LEVEL CODE Code identifying purpose of transaction set (00- Original) ASN Number Date expressed as CCYYMMDD Shipment Time “0001” - SOPI 103 80 187 81 355 TD5 PACKAGING CODE LADING QUANTITY WEIGHT QUALIFIER WEIGHT WEIGHT UNIT OF MEASURE “1” “S” - Shipment 66 67 91 05 06 387 368 REF ID CODE QUALIFIER ID CODE TRANSPORTATION METHOD/TYPE CODE ROUTING SHIPMENT ORDER/STATUS CODE e.g “CTN76” Total Containers “G” Total Shipment Weight “LB” 128 127 DTM ID CODE QUALIFIER ID CODE 374 373 N1 DATE / TIME QUALIFIER DATE 98 93 66 04 67 ENTITY IDENTIFIER CODE NAME IDENTIFICATION CODE QUALIFIER IDENTIFICATION CODE NAME 2/30 8/8 4/8 4/4 M M 1/12 1/2 O M C O C 3/5 1/7 1/2 1/10 2/2 C O O 1/2 2/80 1/2 CARRIER NAME “CC” – Complete or “PR” Partial O O 1/35 2/2 M “BM” BILL OF LADING NUMBER M M 1/12 1/2 O 010- Requested Ship “CCYYMMDD” NAME 01 02 03 M M M M “2” – SCAC Code SCAC Code “U” OR “M” DATE/TIME REFERENCE 01 02 2/2 M REFERENCE IDENTIFICATION 01 02 M M CARRIER DETAILS(ROUTING) 02 03 04 LENGTH M CARRIER DETAILS(QTY & WT) 01 02 06 07 08 REQ'D M HIERARCHICAL LEVEL 01 03 N1 NAME M C 3/3 8/8 M “ST” Free form name "92" Assigned by Seller M O M 2/3 1/60 1/2 Bartell Store Number M 2/80 M Page 7 of 10 1/02/2018

Bartell Drugs EDI Implementation Guide: Version 3.7 01 02 03 98 93 66 04 67 N3 ENTITY IDENTIFIER CODE NAME IDENTIFICATION CODE QUALIFIER IDENTIFICATION CODE “SF” Free form name "92” Assigned by Seller M O C 2/3 1/60 1/2 Vendor Number C 2/80 ADDRESS INFORMATION 01 02 166 166 N4 ADDRESS INFORMATION ADDRESS INFORMATION O Address information Address information GEOGRAPHIC LOCATION 01 02 03 04 19 156 116 26 HL CITY NAME STATE CODE ZIP CODE COUNTRY CODE 628 734 735 PRF HIERARCHICAL ID NUMBER HIERARCHICAL PARENT ID HIERARCHICAL LEVEL CODE Free-form text for city name Code for Province or State Zip Code Code identifying the Country USA-United States 324 373 TD1 PO NUMBER PO DATE “2” HL # of Parent HL “O” - Order 103 80 HL PACKAGING CODE LADING QUANTITY PO Number “CCYYMMDD” 628 734 735 MAN HIERARCHICAL ID NUMBER HIERARCHICAL PARENT ID HIERARCHICAL LEVEL CODE e.g “CTN76” Total Containers per Order 88 87 HL QUALIFIER MARKS AND NUMBERS “3” HL # of Parent HL “P” - Order 628 734 735 LIN HIERARCHICAL ID NUMBER HIERARCHICAL PARENT ID HIERARCHICAL LEVEL CODE M O 1/22 8/8 O M 3/5 1/7 M M M 1/12 1/12 1/2 O “GM” UCC128 20 Digit Code HIERARCHICAL LEVEL 01 02 03 1/12 1/12 1/2 O MARKS AND NUMBERS 01 02 M M M O HIERARCHICAL LEVEL 01 02 03 2/30 2/2 3/15 2/3 M CARRIER DETAILS(QTY & WT) 01 02 O O O O M PO REFERENCE 01 04 1/55 1/55 O HIERARCHICAL LEVEL 01 02 03 M O M M 1/2 1/48 M “4” HL # of Parent HL “I” - Order BASELINE ITEM DATA M M M 1/12 1/12 1/2 M 01 350 ASSIGNED IDENTIFICATION Line Numbering must match the PO line number for ordered item, even if “0” Quantity shipped. M 1/20 02 235 ID QUALIFIER “UP” M 2/2 Page 8 of 10 1/02/2018

Bartell Drugs EDI Implementation Guide: Version 3.7 03 04 05 234 235 234 SN1 ID ID QUALIFIER ID UPC Code “VC” Vendor Code ITEM DETAIL (SHIPMENT) 02 03 382 355 SLN NUMBER OF UNITS SHIPPED UNIT OF MEASURE 350 662 380 C001 212 PID ASSIGNED ID RELATIONSHIP CODE QUANTITY COMPOSITE UNIT OF MEASURE UNIT PRICE Item Quantity “EA” 349 352 CTT ITEM DESCRIPTION TYPE DESCRIPTION Item Line Number “I” – Included 35 NUMBER OF LINE ITEMS 1/10 2/2 M M M C C 1/20 2/2 1/15 1/17 O “F” – Free form TRANSACTION TOTALS 01 M M O ITEM DESCRIPTION 01 05 1/48 2/2 1/48 M SUBLINE ITEM DETAIL 01 03 04 05 06 M U U M M 1/1 1/80 O Total number of HL’s in the transaction set M 1/6 Example 856 – Advance Shipment Notice ISA*00* *00* *ZZ*VENDOR *12*2067671376 GS*SH*VENDOR*2067671376*20170105*1015*1*X*004010 ST*856*0001 BSN*00*12121212*20170105*1015*0001 HL*1**S TD1*CTN25*11****G*1439*LB TD5**2*RDWY***CC REF*BM*22222222 DTM*011*20170105 N1*ST*BARTELL #18 Kingsgate*92*018 N1*SF*VENDOR*92*V123456 N3*123 ANY ST. N4*SEATTLE*WA*98101 HL*2*1*O PRF*S18-11111***20070104 TD1*CTN25*11 HL*3*2*P MAN*GM*00000111111111111112 HL*4*3*I LIN*1*UP*000011111115*VC*111111 SN1**18*EA SLN*1**I*18*EA*0.51 PID*F****PRODUCT DESCRIPTION SE*22*0001 GE*1*1 IEA*1*000000001 *170105*1015*U*00401*000000001*0*P* Page 9 of 10 1/02/2018

Bartell Drugs EDI Implementation Guide: Version 3.7 SEGMENT ELEMENT AK1 NAME USAGE FUNCTIONAL GROUP RESPONSE HEADER 01 02 479 28 AK2 FUNCTIONAL ID CODE GROUP CONTROL NUMBER 143 329 AK5 TRANSACTION SET ID CODE DATE “SH” – ASN. ETC. 717 718 718 718 718 718 AK9 TRANSACTION ACK CODE SYNTAX ERROR CODE SYNTAX ERROR CODE SYNTAX ERROR CODE SYNTAX ERROR CODE SYNTAX ERROR CODE “856” ETC. Date expressed as CCYYMMDD 715 97 123 2 716 716 716 716 716 GROUP ACK CODE NUMBER OF INCL. SETS NUMBER OF RCVD SETS NUMBER OF ACCEPTED SETS SYNTAX ERROR CODE SYNTAX ERROR CODE SYNTAX ERROR CODE SYNTAX ERROR CODE SYNTAX ERROR CODE 2/2 1/9 M M 3/3 8/8 M “A”, “R”, “P” FUNCTIONAL GROUP RESPONSE TRAILER 01 02 03 04 05 06 07 08 09 M M O NAME 01 02 03 04 05 06 LENGTH M TRANSACTION SET RESPONSE HEADER 01 02 REQ'D M O O O O O 1/1 1/3 1/3 1/3 1/3 1/3 M “A” M M M M M M M M M 1/1 1/6 1/6 1/6 1/3 1/3 1/3 1/3 1/3 Example 997 – Functional Acknowledgement ISA*00* *00* *12*2067671376 *12*5032888151 *170110*1312*U*00401*000142592*0*T* *004010 ST*997*402065 AK1*SH*30413 AK2*856*139436 AK5*A AK9*A*1*1*1 SE*6*402065 GE*1*142781 IEA*00001*000142592 Page 10 of 10 1/02/2018

Bartell Drugs EDI Implementation Guide: Version 3.7 Page 1 of 10 1/02/2018 EDI Implementation Guidelines 850/856/997 Revised: Version 3.7 January 2019 Latest additions: Updated LIN02 and LIN03 from Used to Mandatory in the 856. Changed the qualifier in the DTM01 in the 850 to "002" from "011" for Delivery Requested Date.