CDW Corporation

September 15, 2000

ANSI X12 850 Out Bound

Guidelines

September 15, 2000

The following pages are the guidelines for implementing the ANSI X12 850 document with CDW. The segments listed below are a subset of the 850 document. This represents all the segments that CDW is capable of sending.

Segment Max. Loop

ID Name Req Use Repeat

(Header)

ST Transaction Set Header M 1

BEG Beginning Segment for Purchase Order M 1

REF Reference Numbers O >1

PER Administrative Communications Contact O 1

TAX Tax Reference O 1

FOB F.O.B. Related Instructions O 1

ITD Terms of Sale/Deferred Terms of Sale O 1

DTM Date/Time Reference O 1

N1 loop O 200

N1 Name O 1

N2 Additional Name Information O 1

N3 Address Information O 1

N4 Geographic Location O 1

PER Administrative Communications Contact O >1

(Detail)

PO1 Baseline Item Data O 1 100,000

PID loop O 1,000

PID Product/Item Description O 1

REF Reference Numbers O >1

DTM Date/Time Reference O 1

(Trailer)

CTT Transactions Totals M 1

AMT Monetary Amount O 1

SE Transaction Set Trailer M 1

Here is an example of an outbound 850 document:

ST~850~010921382

BEG~00~NE~1014288~~20000911

REF~EU~000907

REF~PD~PAF

REF~CO~000907

N1~BS~CDW COMPUTER CENTERS, INC.~1~107627952

N3~200 NORTH MILWAUKEE AVENUE

N4~VERNON HILLS~IL~60061

PER~BD~Buyer Name~TE~8474656000

N1~EN~KATHY BARKER

N3~1 NASH AV

N4~FT DRUM~NY~136025088

PER~IC~SFC BAKER~TE~315558940

TAX~33-3310735~~~~~~~~~~~3

PO1~0000001~1~EA~154.06~~BP~010076

PID~F~~~~LANTRONIX MIRCRO PRINT SERVER

PO1~0000002~1~EA~19.05~~BP~060951

PID~F~~~~NEATO WHITE LABELS 100PK 2UP

PO1~0000003~1~EA~66.85~~BP~990672

PID~F~~~~SYMANTEC NORTON UTILITIES V3.0

PO1~0000004~1~EA~57.88~~BP~277352

PID~F~~~~PARTITION MAGIC

CTT~4~4

SE~32~010921382

Please note that the segment terminators are not shown.

The following is a guide to the notation that is used to present the specifications:

Req - Required or Usage

C Conditional

M Mandatory

O Optional

X Relational

TP - Element Type

AN Alpha Numeric

DT Date, in the form of YYMMDD

ID Identifier or Qualifier

Nx Numeric, where ‘x’ is the number of decimal positions

R Decimal, with the decimal point included

TM Time, in the form of HHMM


Header

ST - Transaction Set Header

Reference
Element / Number / Description / Qual/Def / Req / Type / Min / Max
ST01 / 143 / Transaction Set Identifier / 850 – Purchase Order / M / ID / 3 / 3
ST02 / 329 / Transaction Set Control Number / Sequential #
(Same as SE02) / M / AN / 4 / 9

BEG - Beginning Segment for Purchase Order

Reference
Element / Number / Description / Qual/Def / Req / Type / Min / Max
BEG01 / 353 / Transaction Set Purpose Code / ‘00’ – Original / M / ID / 2 / 2
BEG02 / 92 / Purchase Order Type Code / ‘SA’ - Stand Alone
‘NE’ – New order
‘DS’ - Drop ships
‘TM’ - Configuration
Government/Education
Software licensing
TP can specify PO type / M / ID / 2 / 2
BEG03 / 324 / Purchase Order Number / M / AN / 1 / 22
BEG04 / 328 / Release Number / O / AN / 1 / 30
BEG05 / 323 / Purchase Order Date / CCYYMMDD / M / DT / 8 / 8
BEG06 / 367 / Contract Number / O / AN / 1 / 30
BEG07 / 587 / Acknowledgement Type / O / ID / 2 / 2

REF – Reference Numbers

Reference
Element / Number / Description / Qual/Def / Req / Type / Min / Max
REF01 / 128 / Reference Number Qualifier / PO – CDW purchase order number
EU – CDw’s customer’s purchase order number
Authorization number / M / ID / 2 / 3
REF02 / 127 / Reference Number / X / AN / 1 / 30
REF03 / 352 / Description / X / AN / 1 / 80

PER – Administrative Communications Contact

Reference
Element / Number / Description / Qual/Def / Req / Type / Min / Max
PER01 / 366 / Contact Function Code / ‘IC’ / M / ID / 2 / 2
PER02 / 93 / Name / Purchasing Agent / O / AN / 1 / 80
PER03 / 365 / Communications Number Qualifier / ‘TE’ – Telephone / X / ID / 2 / 2
PER04 / 364 / Communication Number / Includes Area Code / X / AN / 1 / 80

TAX – Tax Reference

Reference
Element / Number / Description / Qual/Def / Req / Type / Min / Max
TAX01 / 325 / Tax Identification Number / X / AN / 1 / 20
TAX12 / 441 / Tax Exempt Code / O / ID / 1 / 1

FOB – F.O.B. Related Instructions

Reference
Element / Number / Description / Qual/Def / Req / Type / Min / Max
FOB01 / 146 / Shipment Payment Method / M / ID / 2 / 2
FOB02 / 309 / Location Qualifier / X / ID / 1 / 2
FOB03 / 352 / Description / C / AN / 1 / 80

ITD – Terms of Sale/Deferred Terms of Sale

Reference
Element / Number / Description / Qual/Def / Req / Type / Min / Max
ITD01 / 336 / Terms Type Code / O / ID / 1 / 2
ITD02 / 333 / Terms Basis Date Code / O / ID / 1 / 2
ITD03 / 338 / Terms Discount Percentage / O / R / 1 / 6
ITD05 / 351 / Terms Discount Days Due / X / N0 / 1 / 3
ITD07 / 560 / Terms Net Days / O / N0 / 1 / 3

DTM – Date/Time Reference

Reference
Element / Number / Description / Qual/Def / Req / Type / Min / Max
DTM01 / 374 / Date/Time Qualifier / 002 / M / ID / 3 / 3
DTM02 / 373 / Date / Purchase order date / X / DT / 8 / 8

N1 – Name

Reference
Element / Number / Description / Qual/Def / Req / Type / Min / Max
N101 / 98 / Type of Organization / VN – vendor
BS – bill to / ship to
BT – bill to (if other than ship to)
ST – ship to (if other than bill to)
EU – end user / M / ID / 2 / 3
N102 / 93 / Name / X / AN / 1 / 60
N103 / 66 / ID Code Qualifier / ’91’, ‘94’ assigned by seller
‘92’, ‘93’ assigned by buyer / X / ID / 1 / 2
N104 / 67 / Identifying Number / Either a static value assigned or sicc codes for gov/ed / X / AN / 2 / 80

N2 - Additional Name Information

Reference
Element / Number / Description / Qual/Def / Req / Type / Min / Max
N201 / 93 / Name / M / AN / 1 / 60
N202 / 93 / Name / O / AN / 1 / 60

N3 - Address Information

Reference
Element / Number / Description / Qual/Def / Req / Type / Min / Max
N301 / 166 / Address Information / M / AN / 1 / 55
N302 / 166 / Address Information / O / AN / 1 / 55

N4 - Geographic Location

Reference
Element / Number / Description / Qual/Def / Req / Type / Min / Max
N401 / 19 / City Name / O / AN / 2 / 30
N402 / 156 / State/Province Code / O / ID / 2 / 2
N403 / 116 / Postal Code / O / ID / 3 / 15

PER – Administrative Communications Contact

Reference
Element / Number / Description / Qual/Def / Req / Type / Min / Max
PER01 / 366 / Contact Function Code / ‘IC’ / M / ID / 2 / 2
PER02 / 93 / Name / If ship to is CDW, will be purchasing agent. If ship to is CDW customer, will be customer contact / O / AN / 1 / 60
PER03 / 365 / Communications Number Qualifier / ‘TE’ – Telephone / X / ID / 2 / 2
PER04 / 364 / Communication Number / X / AN / 1 / 80

Detail

PO1 - Baseline Item Data

Reference
Element / Number / Description / Qual/Def / Req / Type / Min / Max
PO101 / 350 / Assigned Identification / P.O Line number / O / AN / 1 / 20
PO102 / 330 / Quantity Ordered / X / R / 1 / 15
PO103 / 335 / Unit of Measurement Code / ‘EA’ - Each / O / ID / 2 / 2
PO104 / 212 / Unit Price / X / R / 1 / 17
PO105 / 639 / Basis of Unit Price Code / O / ID / 2 / 2
PO106 / 235 / Product/Service ID Qualifier / See note / X / ID / 2 / 2
PO107 / 234 / Product/Service ID / X / AN / 1 / 48
PO108 / 235 / Product/Service ID Qualifier / X / ID / 2 / 2
PO109 / 234 / Product/Service ID / X / AN / 1 / 48
PO110 / 235 / Product/Service ID Qualifier / X / ID / 2 / 2
PO111 / 234 / Product/Service ID / X / AN / 1 / 48
PO112 / 235 / Product/Service ID Qualifier / X / ID / 2 / 2
PO113 / 234 / Product/Service ID / X / AN / 1 / 48

Note: The following product ids can be sent as required.

BP, CB = CDW’s part number

MG = manufacturer’s part number

VP, VC = vendor’s part number

UP = U.P.C. Consumer Package Code

PID - Product/Item Description

Reference
Element / Number / Description / Qual/Def / Req / Type / Min / Max
PID01 / 349 / Item Description Type / ‘F’ – free form / M / ID / 1 / 1
PID05 / 352 / Description / Product description / X / AN / 1 / 80

REF - Reference Numbers

Reference
Element / Number / Description / Qual/Def / Req / Type / Min / Max
REF01 / 128 / Reference Number Qualifier / M / ID / 2 / 3
REF02 / 127 / Reference Number / X / AN / 1 / 30
REF03 / 352 / Description / X / AN / 1 / 80

DTM – Date/Time Reference

Reference
Element / Number / Description / Qual/Def / Req / Type / Min / Max
DTM01 / 374 / Date/Time Qualifier / M / ID / 3 / 3
DTM02 / 373 / Date / CCYYMMDD / X / DT / 8 / 8

Trailer

CTT - Transaction Totals

Reference

Element / Number / Description / Qual/Def / Req / Type / Min / Max
CTT01 / 354 / Number of Line Items / Number of PO1 segments used / M / N0 / 1 / 6

AMT - Monetary Amount

Reference

Element / Number / Description / Qual/Def / Req / Type / Min / Max
AMT01 / 522 / Amount Qualifier code / TT / M / ID / 1 / 3
AMT02 / 782 / Monetary Amount / M / R / 1 / 18

SE - Transaction Set Trailer

Reference

Element / Number / Description / Qual/Def / Req / Type / Min / Max
SE01 / 96 / Segments in Transaction / ST and SE included / M / N0 / 1 / 10
SE02 / 329 / Transaction Set Control / Same as ST02 / M / AN / 4 / 9

850_O_4010 1