Developer.walmart.com



850Purchase Order?Functional Group=POThis Draft Standard for Trial Use contains the format and establishes the data contents of the Purchase Order Transaction Set (850) for use within the context of an Electronic Data Interchange (EDI) environment. The transaction set can be used to provide for customary and established business and industry practice relative to the placement of purchase orders for goods and services. This transaction set should not be used to convey purchase order changes or purchase order acknowledgment information.Heading:PosIdSegment NameReqMax UseRepeatNotesUsage010STTransaction Set HeaderM1??Must use020BEGBeginning Segment for Purchase OrderM1??Must use050REFReference IdentificationO>1??Must use090CTPPricing InformationO>1??Must use110CSHSales RequirementsO5??Must use150DTMDate/Time ReferenceO10??Must use?LOOP ID - N9????1000????295N9Reference IdentificationO1??Must use300MSGMessage TextO1000??Must use????????????LOOP ID - N1????200????310N1NameO1??Must use330N3Address InformationO2??Must use340N4Geographic LocationO>1??Must use350REFReference IdentificationO12??Dependent360PERAdministrative Communications ContactO>1??Dependent390TD5Carrier Details (Routing Sequence/Transit Time)O12??Dependent???????????Detail:PosIdSegment NameReqMax UseRepeatNotesUsage?LOOP ID - PO1????100000????010PO1Baseline Item DataM1?Must use?LOOP ID - PID????1000????050PIDProduct/Item DescriptionO1??Must use????????????LOOP ID - SAC????25????130SACService, Promotion, Allowance, or Charge InformationO1??Must use????????????LOOP ID - N9????1000????330N9Reference IdentificationO1??Dependent340MSGMessage TextO1000??Dependent???????????Summary:PosIdSegment NameReqMax UseRepeatNotesUsage?LOOP ID - CTT????1????010CTTTransaction TotalsO1?N3/010Must use030SETransaction Set TrailerM1??Must useNotes:3/010The number of line items (CTT01) is the accumulation of the number of PO1 segments.STTransaction Set HeaderPos: 010Max: 1Heading - MandatoryLoop: N/AElements: 2Usage Option:Must useTo indicate the start of a transaction set and to assign a control numberElement Summary:?RefIdElement NameReqTypeMin/MaxST01143Transaction Set Identifier CodeMID3/3?CodeName?850Purchase OrderRefIdElement NameReqTypeMin/MaxST02329Transaction Set Control NumberMAN4/9BEGBeginning Segment for Purchase OrderPos: 020Max: 1Heading - MandatoryLoop: N/AElements: 4Usage Option:Must useTo indicate the beginning of the Purchase Order Transaction Set and transmit identifying numbers and datesElement Summary:?RefIdElement NameReqTypeMin/MaxBEG01353Transaction Set Purpose CodeMID2/2?CodeName?00OriginalRefIdElement NameReqTypeMin/MaxBEG0292Purchase Order Type CodeMID2/2?CodeName?DSDropshipRefIdElement NameReqTypeMin/MaxBEG03324Purchase Order NumberMAN1/22BEG05373DateUsage NotesDate this Purchase Order was created.MDT8/8REFReference IdentificationPos: 050Max: >1Heading - OptionalLoop: N/AElements: 2Usage Option:Must useTo specify identifying informationElement Summary:?RefIdElement NameReqTypeMin/MaxREF01128Reference Identification QualifierMID2/3?CodeName?COCustomer Order NumberRefIdElement NameReqTypeMin/MaxREF02127Reference IdentificationXAN1/30Segment NotesContains the customer's order number (13-digit numeric).? Note: This number may not be unique across all Purchase Orders.REFReference IdentificationPos: 050Max: >1Heading - OptionalLoop: N/AElements: 2Usage Option:Must use (only for Site to Store Orders)To specify identifying informationElement Summary:?RefIdElement NameReqTypeMin/MaxREF01128Reference Identification QualifierMID2/3?CodeName?STWalmart Store NumberRefIdElement NameReqTypeMin/MaxREF02127Reference IdentificationXAN1/30Segment NotesContains the Wal-mart Store Number for ship to store ordersREFReference IdentificationPos: 050Max: >1Heading - OptionalLoop: N/AElements: 2Usage Option:Must useTo specify identifying informationElement Summary:?RefIdElement NameReqTypeMin/MaxREF01128Reference Identification QualifierMID2/3?CodeName?IAInternal Vendor NumberRefIdElement NameReqTypeMin/MaxREF02127Reference IdentificationXAN1/30Segment NotesWalmart Assigned Internal Vendor Number. This is not to be used even though always send in the order file.REFReference IdentificationPos: 050Max: >1Heading - OptionalLoop: N/AElements: 2Usage Option:OptionalTo specify identifying informationElement Summary:?RefIdElement NameReqTypeMin/MaxREF01128Reference Identification QualifierMID2/3?CodeName?VRFacility Id NumberRefIdElement NameReqTypeMin/MaxREF02127Reference IdentificationXAN1/30Segment Assigned Facility id Number. This segment will be send only if the vendor has multiple ship points or Facilities. REF-02 has the Facility Number from where the order is to be shipped.CTPPricing InformationPos: 090Max: >1Heading - OptionalLoop: N/AElements: 4Usage Option:Must useTo specify pricing informationElement Summary:?RefIdElement NameReqTypeMin/MaxCTP01687Class of Trade CodeMID2/2?CodeName?RSResaleRefIdElement NameReqTypeMin/MaxCTP03212Unit PriceUsage NotesTotal retail price for this Purchase Order, including all lines, charges and adjustments.? Note: For gift orders this value is zero.MR1/17CTP04380QuantityUsage NotesAlways 1 unit quantity.MR1/15CTP05C001Composite Unit of MeasureOTComp355Unit or Basis for Measurement CodeMID2/2?CodeName?EAEachSegment NotesContains the total retail amount of this Purchase Order.? It may be used to validate the data consistency of this message.CSHSales RequirementsPos: 110Max: 5Heading - OptionalLoop: N/AElements: 1Usage Option:Must useTo specify general conditions or requirements of the saleElement Summary:?RefIdElement NameReqTypeMin/MaxCSH01563Sales Requirement CodeOID1/2?CodeName?P2Ship As Soon As Possible?SCShip CompleteSegment NotesContains a code used to suppress split-shipments within a facility.DTMDate/Time ReferencePos: 150Max: 10Heading - OptionalLoop: N/AElements: 2Usage Option:Must useTo specify pertinent dates and timesElement Summary:?RefIdElement NameReqTypeMin/MaxDTM01374Date/Time QualifierMID3/3?CodeName?002Delivery Requested?806010009Customer OrderExpected ship dateOrder Processing DateRefIdElement NameReqTypeMin/MaxDTM02373DateXDT8/8Segment NotesThere is always a DTM segment containing the date the order was placed (DTM01 = "806").? There may be a DTM segment containing a date on which the customer has requested the item be delivered (DTM01 = "002").? This option is not supported by all suppliers.DTM01= “010” is for expected ship date and is optionalDTM01= “009” is for? Order Processing date(OPD) and is optionalN9Reference IdentificationPos: 295Max: 1Heading - OptionalLoop: N9Elements: 2Usage Option:Must useTo transmit identifying information as specified by the Reference Identification QualifierElement Summary:?RefIdElement NameReqTypeMin/MaxN901128Reference Identification QualifierMID2/3?CodeName?ZZMutually DefinedRefIdElement NameReqTypeMin/MaxN902127Reference IdentificationXAN1/30?CodeName?RETURNSMSGReturns Message?MARKETINGMSGMarketing Message?LASTDELIVERYMSGLast Delivery MessageSegment NotesThe N9 segments with N9-01=ZZ are always send in the order file. This is not to be used. Presently the N9-02 always contains the above mentioned values.?MSGMessage TextPos: 300Max: 1000Heading - OptionalLoop: N9Elements: 3Usage Option:Must useTo provide a free-form format that allows the transmission of text informationElement Summary:?RefIdElement NameReqTypeMin/MaxMSG01933Free-Form Message TextMAN1/264MSG02934Printer Carriage Control CodeXID2/2?CodeName?AAAdvance The Specified Number of Lines Before PrintRefIdElement NameReqTypeMin/MaxMSG031470NumberUsage NotesMessage line number (1 to 4).ON01/9Segment NotesThe MSG segments with MSG-02=AA are always send in the order file. This is not to be used?Each message may have four lines and contain up to 100 characters of data per line.N1NamePos: 310Max: 1Heading - OptionalLoop: N1Elements: 2Usage Option:Must useTo identify a party by type of organization, name, and codeElement Summary:?RefIdElement NameReqTypeMin/MaxN10198Entity Identifier CodeMID2/3?CodeName?BTBill-to-Party?RTReturned to?STShip ToFDPhysical AddressRefIdElement NameReqTypeMin/MaxN10293NameXAN1/60Segment NotesThis loop contains three addresses related to this Purchase Order, and this segment (N101) defines the type of data to follow.The N1 loop when N101=ST (Ship to) address is always send in the 850.?The N1 loop when N101=BT (Bill To) address is optionalFD is used to specify the physical address of a Walmart? facility for the case of orders using ship code 81 and 91 (Wal-Mart transportation ) . In that case the optional N103/N104 elements are populated to provide the Walmart ID number for the facility N102 will be populated with ‘RDC’ or ‘WPM’ for this case.N3Address InformationPos: 330Max: 2Heading - OptionalLoop: N1Elements: 2Usage Option:Must useTo specify the location of the named partyElement Summary:?RefIdElement NameReqTypeMin/MaxN301166Address InformationMAN1/55N302166Address InformationOAN1/55N4Geographic LocationPos: 340Max: >1Heading - OptionalLoop: N1Elements: 4Usage Option:Must useTo specify the geographic place of the named partyElement Summary:?RefIdElement NameReqTypeMin/MaxN40119City NameOAN2/30N402156State or Province CodeOID2/2N403116Postal CodeOID3/15N40426Country CodeUsage NotesISA ALPHA-3 Country Code.? For a list of codes, see QualifierX1?ID 1/2Usage Notes?Used only for Integrated Shipping (backhaul). Value ‘GL’N406310Location IdentifierO1?AN 1/30Usage Notes?Used only for Integrated Shipping (backhaul). Value GLN (Global Location Number) of facilityREFReference IdentificationPos: 350Max: 12Heading - OptionalLoop: N1Elements: 3Usage Option:DependentTo specify identifying informationElement Summary:?RefIdElement NameReqTypeMin/MaxREF01128Reference Identification QualifierMID2/3?CodeName?4NSpecial Payment Reference Number?ODOriginal Return Request Reference Number?PNPermit Number?PHCProcess Handling CodeRefIdElement NameReqTypeMin/MaxREF02127Reference IdentificationUsage NotesREF01 = "4N": Description of billing payment method.? For gift orders, this is replaced by non-descriptive text.REF01 = "OD": Returns TC Number?REF01 = "PN": Returns Permit Number.? Additional data is populated in REF04.REF01 = "PHC": Returns Method Code of "RC" (Not pre-paid), "RP" (pre-paid) or "RS" (return to vendor).XAN1/30REF04C040Reference IdentifierUsage NotesOnly used if REF01 = "PN"OComp128Reference Identification QualifierMID2/3?CodeName?ZZMutually DefinedRefIdElement NameReqTypeMin/Max127Reference IdentificationUsage NotesReturns Permit CityMAN1/30128Reference Identification QualifierXID2/3?CodeName?ZZMutually DefinedRefIdElement NameReqTypeMin/Max127Reference IdentificationUsage NotesReturns Permit StateXAN1/30128Reference Identification QualifierXID2/3?CodeName?ZZMutually DefinedRefIdElement NameReqTypeMin/Max127Reference IdentificationUsage NotesReturns Permit Zip CodeXAN1/30Segment NotesSegments mandatory with REF01 = "4N" and “OD” for N101 = "ST".Segments mandatory with REF01 = "PN" and "PHC" for N101 = "RT".PERAdministrative Communications ContactPos: 360Max: >1Heading - OptionalLoop: N1Elements: 6Usage Option:DependentTo identify a person or office to whom administrative communications should be directedElement Summary:?RefIdElement NameReqTypeMin/MaxPER01366Contact Function CodeMID2/2?CodeName?BIBill Inquiry Contact?REReceiving ContactRefIdElement NameReqTypeMin/MaxPER0293NameOAN1/60PER03365Communication Number QualifierXID2/2?CodeName?TETelephoneRefIdElement NameReqTypeMin/MaxPER04364Communication NumberUsage NotesTelephone number as 10-digit string with no punctuation.XAN1/80PER05365Communication Number QualifierXID2/2?CodeName?EMElectronic MailRefIdElement NameReqTypeMin/MaxPER06364Communication NumberXAN1/80Segment NotesSegment mandatory with PER01 = "BI" for N101 = "BT".Segment mandatory with PER01 = "RE" for N101 = "ST".TD5Carrier Details (Routing Sequence/Transit Time)Pos: 390Max: 12Heading - OptionalLoop: N1Elements: 6Usage Option:DependentTo specify the carrier and sequence of routing and provide transit time informationElement Summary:?RefIdElement NameReqTypeMin/MaxTD501133Routing Sequence CodeOID1/2?CodeName?OOrigin Carrier (Air, Motor, or Ocean)RefIdElement NameReqTypeMin/MaxTD50266Identification Code QualifierXID1/2?CodeName?93Code assigned by the organization originating the transaction setRefIdElement NameReqTypeMin/MaxTD50367Identification CodeUsage NotesA carrier method code as defined by .? Carrier method up to 4 digits numeric.The value of this element determines whether this is a site-to-home or site-to-store order.Carrier codes for site-to-store orders are – 77,78,79,80, 88, 90, 92 and 97 (highlighted in blue in the list below).XAN2/80?CodeName?01USPS 3rd Class?02UPS Ground?03Clark Transport?04Yellow Freight System?05USPS Express Mail?07USPS 4th Inter?08UPS Basic??09UPS Second day Air?10USPS First Class?12Silver Star?13UPS Second Day Ground?14Consolidation?16UPS Next Day Air?17Common Carrier?19FedEx Express Saver (3 Day Service)?20FedEx Ground?21FedEx Priority Overnight?22FedEx Two Day?23FedEx Priority Overnight (duplicate or 21)?24FedEx Standard Overnight (PM Delivery)?26UPS Next Day Air Saver?29UPS 3 Day Select?30USPS Priority Mail?31USPS Priority Mail?32OLD Dominion Freight Line LTL?33Newgistics?34Airborne Ground Delivery?35Airborne Express?36Airborne?37Airborne 2-DAY?38UPS Ground?41ABF Freight System?42Bekins?43Pilot Freight Basic Delivery?44FedEx Priority Overnight w/Saturday Delivery?45UPS Next Day Air Saver (Saturday Delivery)?46SmartMail?47USPS Media Mail?48USPS Bound Printed Matter50Bekins Premium51USA Truck52Contract Freighers, Inc?53Crete Carrier?54Eagle Global Logistics - Three Day Service?55Eagle Global Logistics - Economy?56US Xpress?57Heartland Express58Dart Transit61UPS Ground (CTN, GA)62UPS Ground (Parsippany, NJ)63UPS Ground (Chicago, IL)64UPS Ground (Vernon, CA)65FedEx SmartPost - BMC66FedEx SmartPost - DDU67FedEx Home Delivery68Streamlite69UPS Mail Innovations BPM70UPS Mail Innovations71USPS72Sun Delivery, Inc73APX-DDU76APX-BMCFedEx Standard Overnight - S2S77Direct to Store FedEx Priority Overnight78Direct to Store FedEx Two Day79Direct to Store FedEx, Ground80Direct to Store UPS, Ground81In-Store delivery through WPM RDC82Seko Worldwide83DHL@home84DHL@home(expedited)85DHL 2nd Day86DHL Next Day 03:00pm87FTD Florist88Direct to Store UPS Next Day Air891 Hour Burn on Demand90Direct to Store – Freight91In-Store delivery through Bypass WPM92Direct to Store via UPS Ground Sort (Jewelry & Media)95Fulfilled with Inventory from a Wal-Mart Store96UPS Next Day Air Saver - S2S97Direct to Store UPS, second Day Air98Downloads99In-Store Pickup100DHL Next Day 12:00pm101DHL Next Day w/SatNote : A list of actual applicable codes will be provided separately based on the item assortmentRefIdElement NameReqTypeMin/MaxTD507309Location QualifierUsage NotesIf the customer chose in-store pickup, then TD507 and TD508 are required to specify the store number.? All suppliers do not support this delivery method.OID1/2?CodeName?ISIn StoreRefIdElement NameReqTypeMin/MaxTD508310Location IdentifierUsage NotesWal-Mart Store Number if TD507 = "IS".XAN1/30TD512284Service Level CodeUsage NotesCode indicating the service level chosen by the customer for this order. ?XID2/2?CodeName?NDNext Day Air?SESecond Day?SGStandard Ground?ZZDFMutually DefinedValue shippingPO1Baseline Item DataPos: 010Max: 1Detail - MandatoryLoop: PO1Elements: 11Usage Option:Must useTo specify basic and most frequently used line item dataElement Summary:?RefIdElement NameReqTypeMin/MaxPO101350Assigned IdentificationUsage NotesUnique identifier for this Purchase Order Line.? This number is necessary when responding with a status update or shipping notification.OAN1/20PO102330Quantity OrderedXR1/15PO103355Unit or Basis for Measurement CodeOID2/2?CodeName?EAEachRefIdElement NameReqTypeMin/MaxPO104212Unit PriceUsage NotesThe cost to for each unit, according to the latest information provided by the supplier.XR1/17PO105639Basis of Unit Price CodeOID2/2?CodeName?QEQuoted Price per EachRefIdElement NameReqTypeMin/MaxPO106235Product/Service ID QualifierXID2/2?CodeName?BPBuyer's Part NumberRefIdElement NameReqTypeMin/MaxPO107234Product/Service IDUsage item SKU.XAN1/48PO108235Product/Service ID QualifierXID2/2?CodeName?UPU.P.C. Consumer Package Code (1-5-5-1)RefIdElement NameReqTypeMin/MaxPO109234Product/Service IDUsage NotesWal-Mart Item UPCXAN1/48PO110235Product/Service ID QualifierXID2/2?CodeName?VPVendor's (Seller's) Part NumberRefIdElement NameReqTypeMin/MaxPO111234Product/Service IDUsage NotesSupplier's item SKU.XAN1/48PIDProduct/Item DescriptionPos: 050Max: 1Detail - OptionalLoop: PIDElements: 2Usage Option:Must useTo describe a product or process in coded or free-form formatElement Summary:?RefIdElement NameReqTypeMin/MaxPID01349Item Description TypeMID1/1?CodeName?FFree-formRefIdElement NameReqTypeMin/MaxPID05352DescriptionUsage NotesItem description.XAN1/80SACService, Promotion, Allowance, or Charge InformationPos: 130Max: 1Detail - OptionalLoop: SACElements: 5Usage Option:Must useTo request or identify a service, promotion, allowance, or charge; to specify the amount or percentage for the service, promotion, allowance, or chargeElement Summary:?RefIdElement NameReqTypeMin/MaxSAC01248Allowance or Charge IndicatorMID1/1?CodeName?NNo Allowance or ChargeRefIdElement NameReqTypeMin/MaxSAC021300Service, Promotion, Allowance, or Charge CodeXID4/4?CodeName?D340Goods and Services Charge?G830Shipping and Handling?H000Special Allowance?H151Special Services?H850TaxRefIdElement NameReqTypeMin/MaxSAC08118RateUsage NotesRetail price per unit.? Note: For gift orders this value is zero.OR1/9SAC12331Allowance or Charge Method of Handling CodeOID2/2?CodeName?15Information OnlyRefIdElement NameReqTypeMin/MaxSAC15352DescriptionUsage NotesA free-text description is supplied if SAC02 is "H000" or "H151".XAN1/80Segment NotesSAC02 = "D340": Charge to the customer for each item - always present.SAC02 = "G830": Charge to the customer for shipping and handling - always present.SAC02 = "H850": Charge to the customer for sales tax - always present.The below segments are not always present in the 850.SAC02 = "H000": Allowance to the customer for customer service adjustment or promotion - present only if non-zero.SAC02 = "H151": Charge to the customer for value-added service - present only if non-zero.N9Reference IdentificationPos: 330Max: 1Detail - OptionalLoop: N9Elements: 4Usage Option:DependentTo transmit identifying information as specified by the Reference Identification QualifierElement Summary:?RefIdElement NameReqTypeMin/MaxN901128Reference Identification QualifierMID2/3?CodeName?QYService Performed Code?S2Data SourceRefIdElement NameReqTypeMin/MaxN902127Reference IdentificationUsage NotesIf N901 = "QY", then this is a value-added service code as defined by .XAN1/30?CodeName?VGMGift Message (Four Lines)?VGTGift Tag (To/From)?VGWVSRGift WrappingSignature on DeliveryRefIdElement NameReqTypeMin/MaxN903369Free-form DescriptionUsage NotesIf N901 = "S2", then this is the name of a dynamic data element.XAN1/45N907C040Reference IdentifierUsage NotesIf N901 = "QY", then this contains a unique sequence number for each value-added service request.OComp128Reference Identification QualifierMID2/3?CodeName?55Sequence NumberRefIdElement NameReqTypeMin/Max127Reference IdentificationMAN1/30Segment NotesThese segments contain value-added services that the customer has requested (N901 = "QY") or dynamic-data elements for item configuration (N901 = "S2").? The N9 segments with N901=QY will be send when the order is a Gift order with Gift message, Gift wrapping or Gift Tag.MSGMessage TextPos: 340Max: 1000Detail - OptionalLoop: N9Elements: 1Usage Option:DependentTo provide a free-form format that allows the transmission of text informationElement Summary:?RefIdElement NameReqTypeMin/MaxMSG01933Free-Form Message TextMAN1/264Segment NotesIf N901 = "QY", then there is one MSG element for each value-added service data element.? MSG01 will contain a name/value pair separated by a "|" character (e.g. "LINE1|Hi Mom").?There will 4 MSG segments containing 4 lines of text when N9-02=VGM.When N9-02=VSR ,MSG-01 =SOD|Y? for signature on deliveryIf N901 = "S2", then there are MSG segments containing the dynamic-data value corresponding to the N903 dynamic-data name.? The data will be split into 264 character blocks, so there may be one or many MSG segments depending on the length of the data.CTTTransaction TotalsPos: 010Max: 1Summary - OptionalLoop: CTTElements: 1Usage Option:Must useTo transmit a hash total for a specific element in the transaction setElement Summary:?RefIdElement NameReqTypeMin/MaxCTT01354Number of Line Items (Count of PO1 segments)MN01/6SETransaction Set TrailerPos: 030Max: 1Summary - MandatoryLoop: N/AElements: 2Usage Option:Must useTo indicate the end of the transaction set and provide the count of the transmitted segments (including the beginning (ST) and ending (SE) segments)Element Summary:?RefIdElement NameReqTypeMin/MaxSE0196Number of Included SegmentsMN01/10SE02329Transaction Set Control NumberMAN4/9 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download