Transcription
850 Purchase OrderFunctional Group POVersion 005010Mapping Procedures and Tips on Associated Wholesale Grocers’ 850DocumentAssociated Wholesale Grocers utilizes the 850 Purchase Order Transaction Set for all divisionswithin the company. The 850 Transaction Set can be used to provide for customary andestablished business and industry practice relative to the placement of purchase orders for goodsand services.Any questions concerning mapping requirements should be directed to Edict Systems DNameReq.Des.0100STTransaction Set HeaderM0200BEGBeginning Segment for Purchase OrderM10600PERAdministrative Communications ContactO1*Max Use1LOOP ID – SAC251200SACService, Promotion, Allowance, or Charge InformationO11500DTMDate/Time ReferenceM*1*LOOP ID – N910002950N9Extended Reference InformationO13000MTXTextO 1LOOP ID – N12003100N1Party IdentificationM*3700FOBF.O.B. Related InstructionsO13900TD5Carrier Details (Routing Sequence/Transit Time)O1*850 v.5010LoopRepeatCreated Date: June 13, 2014Associated Wholesale Grocers - Version 1.01Page 1 of 19
Detail:Pos.No.Seg.ID0100PO10500PIDReq.Des.NameMax UseLOOP ID – PO1100000Baseline Item DataM1O1LOOP ID – PID1000Product/Item DescriptionLOOP ID – SAC1300SACLoopRepeat25Service, Promotion, Allowance, or Charge InformationO1Summary:Pos.No.Seg.IDReq.Des.NameMax UseLOOP ID – CTTLoopRepeat10100CTTTransaction TotalsM*10200AMTMonetary Amount InformationM*10300SETransaction Set TrailerM1Notes: Any segments and elements used that are not included in this specification may preventdocuments from being processed or may be ignored.If any segments of a loop are used, the first segment of the loop is always required.* Denotes usage requirements that deviate from EDI standards.850 v.5010Created Date: June 13, 2014Associated Wholesale Grocers - Version 1.0Page 2 of 19
Segment:Position:Loop:Level:Usage:Max Use:Syntax Notes:ST Transaction Set Header0100N/AHeaderMandatory1Data Element SummaryRef.Des.ST01ST02DataElement Name143Transaction Set Identifier CodeCodeDescription850Purchase Order329Transaction Set Control Number850 v.5010Created Date: June 13, 2014Associated Wholesale Grocers - Version 1.0Req.MTypeIDMANMin/Max3/34/9Page 3 of 19
Segment:Position:Loop:Level:Usage:Max Use:Syntax Notes:BEG Beginning Segment for Purchase Order0200N/AHeaderMandatory1Data Element SummaryRef.Des.BEG01BEG02BEG03BEG05DataElement NameReq. Type Min/Max353Transaction Set Purpose CodeMID2/2CodeDescription00Original92Purchase Order Type CodeMID2/2CodeDescriptionCFConfirmationNENew Order324Purchase Order NumberMAN1/22373DateMDT8/8Note: BEG05 is the date assigned by the purchaser to purchase order.850 v.5010Created Date: June 13, 2014Associated Wholesale Grocers - Version 1.0Page 4 of 19
Segment:Position:Loop:Level:Usage:Max Use:Syntax Notes:PER Administrative Communications Contact0600N/AHeaderOptional1*1.If either PER03 or PER04 is present, then the other is required.Data Element SummaryRef.DataDes.Element NamePER01 366Contact Function CodeCodeDescriptionBDBuyer Name or DepartmentPER02 93NamePER03 365Communication Number QualifierCodeDescriptionTEBuyer’s Telephone NumberPER04 364Communication Number850 v.5010Created Date: June 13, 2014Associated Wholesale Grocers - Version 1.0Req.MTypeIDMin/Max2/2OXANID1/602/2XAN1/256Page 5 of 19
Segment:Position:Loop:Level:Usage:Max Use:Syntax Notes:SAC Service, Promotion, Allowance, or Charge Information1200SACHeaderOptional1*Data Element SummaryRef.Des.SAC01SAC02SAC05DataElement Name248Allowance or Charge ce, Promotion, Allowance, or Charge CodeCodeDescriptionA400Allowance Non-performanceD240FreightD250Freshness/Leaker AllowanceE170LabelingF340Pick/UpG740Service ChargeH400StopchargeH550SurchargeH560SwellH790Tax - Use TaxI170Trade Discount610Amount850 v.5010Created Date: June 13, 2014Associated Wholesale Grocers - Version 1.0Req. TypeMIDMin/Max1/1MID4/4M*N21/15Page 6 of 19
Segment:Position:Loop:Level:Usage:Max Use:Syntax Notes:DTM Date/Time Reference1500N/AHeaderMandatory*1*Data Element SummaryRef.Des.DTM01DTM02DataElement Name374Date/Time QualifierCodeDescription002Delivery Requested010Requested Ship373Date850 v.5010Created Date: June 13, 2014Associated Wholesale Grocers - Version 1.0Req. TypeMIDM*DTMin/Max3/38/8Page 7 of 19
Segment:Position:Loop:Level:Usage:Max Use:Syntax Notes:N9 Extended Reference Information2950N9HeaderOptional1Data Element SummaryRef.Des.N901N902DataElement Name128Reference Identification QualifierCodeDescriptionTOCType of Comment127Reference Identification850 v.5010Created Date: June 13, 2014Associated Wholesale Grocers - Version 1.0Req. TypeMIDM*ANMin/Max2/31/50Page 8 of 19
Segment:Position:Loop:Level:Usage:Max Use:Syntax Notes:MTX Text3000N9HeaderOptional 1Data Element SummaryRef.Des.MTX01MTX02DataElement Name363Note Reference CodeCodeDescriptionGENEntire Transaction Set1551Textual Data850 v.5010Created Date: June 13, 2014Associated Wholesale Grocers - Version 1.0Req. TypeM*IDM*ANMin/Max3/31/4096Page 9 of 19
Segment:Position:Loop:Level:Usage:Max Use:Syntax Notes:Notes:N1 Name3100N1HeaderMandatory*11.The code shown in the N104 segment will be AWG's DUNSnumber followed by a 4 digit suffix to represent the physicallocation of the ship to facility. If the ship to location is a store, thecode in N104 will be AWG's DUNS number followed by theAWG assigned store number. This suffix can be established inyour system as the unique identifier of the ship to location.Data Element SummaryRef.Des.N101N102N103N104DataElement Name98Entity Identifier CodeCodeDescriptionBTBill-to-PartySTShip ToVNVendor93Name66Identification Code Qualifier67Identification Code850 v.5010Created Date: June 13, 2014Associated Wholesale Grocers - Version 1.0Req. TypeMIDM*M*M*ANIDANMin/Max2/31/601/22/80Page 10 of 19
Segment:Position:Loop:Level:Usage:Max Use:Syntax Notes:FOB F.O.B. Related Instructions3700N1HeaderOptional1Data Element SummaryRef.Des.FOB01DataElement Name146Shipment Method of PaymentCodeDescriptionPBCustomer Pick-up/BackhaulPPPrepaid (by Seller)850 v.5010Created Date: June 13, 2014Associated Wholesale Grocers - Version 1.0Req. TypeMIDMin/Max2/2Page 11 of 19
Segment:Position:Loop:Level:Usage:Max Use:Syntax Notes:TD5 Carrier Details (Routing Sequence/Transit Time)3900N1HeaderOptional1*Data Element SummaryRef.Des.TD504DataElement Name91Transportation Method/Type CodeCodeDescriptionHCustomer PickupKBackhaulMMotor (Common Carrier)850 v.5010Created Date: June 13, 2014Associated Wholesale Grocers - Version 1.0Req. TypeM*IDMin/Max1/2Page 12 of 19
Segment:Position:Loop:Level:Usage:Max Use:Syntax Notes:Notes:PO1 Baseline Item Data0100PO1DetailMandatory11If either PO108 or PO109 is present, then the other is required.1The UK code is vendor specific and will only be sent wheninformed by AWG.Data Element t350380355212235PO107PO108234235PO109234850 v.5010NameReq. TypeAssigned IdentificationM*ANQuantityM*RUnit or Basis for Measurement CodeM*IDUnit PriceM*RProduct/Service ID QualifierM*IDCodeDescriptionITBuyer's Style NumberPIPurchaser's Item CodeUAU.P.C./EAN Case Code (2-5-5)UDU.P.C./EAN Consumer Package Code (2-5-5)UIU.P.C. Consumer Package Code (1-5-5)UKGTIN 14-digit Data StructureUPUCC - 12VNVendor's (Seller's) Item NumberProduct/Service IDM*ANProduct/Service ID QualifierXIDCodeDescriptionITBuyer's Style NumberPIPurchaser's Item CodeUAU.P.C./EAN Case Code (2-5-5)UDU.P.C./EAN Consumer Package Code (2-5-5)UIU.P.C. Consumer Package Code (1-5-5)UKGTIN 14-digit Data StructureUPUCC - 12VNVendor's (Seller's) Item NumberProduct/Service IDXANCreated Date: June 13, 2014Associated Wholesale Grocers - Version 1.0Min/Max1/201/152/21/172/21/482/21/48Page 13 of 19
Segment:Position:Loop:Level:Usage:Max Use:Syntax Notes:PID Product/Item Description0500PO1 / PIDDetailOptional1Data Element SummaryRef.Des.PID01PID05DataElement Name349Item Description TypeCodeDescriptionFFree-form352Description850 v.5010Created Date: June 13, 2014Associated Wholesale Grocers - Version 1.0Req. TypeMIDM*ANMin/Max1/11/80Page 14 of 19
Segment:Position:Loop:Level:Usage:Max Use:Syntax Notes:SAC Service, Promotion, Allowance, or Charge Information1300PO1/SACDetailOptional11.If either SAC06 or SAC07 is present, then the other is required.Data Element t Name248Allowance or Charge ce, Promotion, Allowance, or Charge CodeCodeDescriptionA400Allowance Non-performanceD240FreightD250Freshness/Leaker AllowanceE170LabelingF340Pick/UpG740Service ChargeH400StopchargeH550SurchargeH560SwellH790Tax - Use TaxI170Trade Discount378Allowance/Charge Percent Qualifier332Percent, Decimal Format118Rate850 v.5010Created Date: June 13, 2014Associated Wholesale Grocers - Version 1.0Req. TypeMIDMin/Max1/1M*ID4/4XXOIDRR1/11/61/9Page 15 of 19
Segment:Position:Loop:Level:Usage:Max Use:Syntax Notes:CTT Transaction Totals0100CTTSummaryMandatory*11.If either CTT03 or CTT04 is present, then the other is required.2.If either CTT05 or CTT06 is present, then the other is required.Data Element 4781355CTT05CTT06183355850 v.5010NameNumber of Line ItemsHash TotalWeightUnit or Basis for Measurement CodeCodeDescriptionLBPoundsVolumeUnit or Basis for Measurement CodeCodeDescriptionCFCubic FeetCreated Date: June 13, 2014Associated Wholesale Grocers - Version 1.0Req. e 16 of 19
Segment:Position:Loop:Level:Usage:Max Use:Syntax Notes:AMT Monetary Amount Information0200CTTSummaryMandatory*1Data Element SummaryRef.Des.AMT01AMT02DataElement Name522Amount Qualifier CodeCodeDescriptionTTTotal Transaction Amount782Monetary Amount850 v.5010Created Date: June 13, 2014Associated Wholesale Grocers - Version 1.0Req. TypeMIDMRMin/Max1/31/18Page 17 of 19
Segment:Position:Loop:Level:Usage:Max Use:Syntax Notes:SE Transaction Set Trailer0300N/ASummaryMandatory1Data Element SummaryRef.Des.SE01SE02DataElement Name96Number of Included Segments329Transaction Set Control Number850 v.5010Created Date: June 13, 2014Associated Wholesale Grocers - Version 1.0Req. TypeMN0MANMin/Max1/104/9Page 18 of 19
850 Purchase Order Sample DataISA*00**00**08*9272590000 *ZZ*XXXXXXXXX*140401*1050* *00501*111111111*0*P* D*Lee, 12N9*TOC**MSG FOLLOWSMTX*GEN*18 MONTHS DATING REQUIREDMTX*GEN*DON'T SHIP FED EX GRND CONWAYMTX*GEN*PRODUCT MUST SHIP ON PALLETSN1*ST*Sample Ship To*9*123456789FSKSN1*BT*Sample Bill To*9*123456789FSKSN1*VN*Sample .2**UA*001234567890*PI*123456PID*F****Sample 850 *151.2SE*20*0001GE*1*500000001IEA*1*111111111850 v.5010Created Date: June 13, 2014Associated Wholesale Grocers - Version 1.0Page 19 of 19
850 v.5010 Created Date: June 13, 2014 Page 2 of 19 Associated Wholesale Grocers - Version 1.0 Detail: Pos. Seg. Req. Loop No. ID Name Des. Max Use Repeat LOOP ID - PO1 100000 0100 PO1 Baseline Item Data M 1 LOOP ID - PID 1000 0500 PID Product/Item Description O 1 LOOP ID - SAC 25
