Developer.walmart.com



XMLOrder Flow SpecificationOrder RequestOrder CancelOrder StatusTable of ContentsTable of Contents1Revision History2Interface Description3Functionality3Design Description3XML File Transfer Diagram3Interface Design and Implementation4System Requirements4Order Process Flow4Error Handling / Resend Process6Scheduling & Volume Analysis6General XML File Structure8Initial XML Declaration8XML Data Definition8Xpath Location8Optional/Required8Data Type8Data Length9WMIHEADER Element9FILETYPE Values10Order Request XML File11File Naming Convention11WMIORDERREQUEST Element11Line VASCODE Values16Shipping CARRIERMETHODCODE Values16Order Cancel XML File19File Naming Convention19WMIORDERCANCEL Element19Order Status XML File20File Naming Convention20WMIORDERSTATUS Element20?Interface DescriptionThis document describes the data format specification for the transfer of order-related information between and all suppliers, including Direct Ship Vendors.FunctionalityData files supported by these interfaces are as follows:?Order Request File – Contains customer order requests (Sent from to Supplier only).?Order Cancel File – Contains customer order cancellation requests (Sent from to Supplier only).?Order Status File – Contains customer order status updates (Sent from Supplier to only).Response files supported by these interfaces are as follows:?Confirmation File – Contains a file confirmation (Sent both directions between Supplier and ).??Error File – Contains a file error message (Sent both directions between Supplier and ).Design DescriptionEach file transfer is divided into three basic steps:1.The sender generates a data file and pushes it to the recipient’s server.?2.The recipient parses the received file and validates the file format and data consistency. ?3.If the file parses, then the recipient replies with a Confirmation File to the sender.? Otherwise reply with an Error File.?XML File Transfer DiagramThe following diagram illustrates the file transfer process between and a Supplier.Order Request FileOrder Cancel Order Status FileSupplierConfirmation FileError FileInterface Design and ImplementationSystem Requirements?Messages are sent between and the supplier as ASCII text files in XML format.? After a file is created, the file’s creator pushes it to the recipient.?Order Process FlowThese are the steps in the order process flow starting with a purchase on the web site:1)The process is initiated when a customer places an order on the web site and their credit card is authorized for the amount of the purchase.2)Once the credit card is successfully authorized, the customer order is split into multiple order requests, if necessary.? An order request will contain all the line items for a particular supplier (customer’s order may have multiple sources) at a particular shipping address (customer’s order may have multiple shipping addresses) using the same shipping method (customer’s order may have multiple shipping methods).? Each order request is included as an OR_ORDER element in the next scheduled Order Request File delivered to the appropriate supplier.3)When the Order Request File arrives at the supplier, they parse the file and validate the XML message against the v4.0 DTD.? If the message doesn't validate, then they send an Error File back to .? Otherwise, they send back a Confirmation File and continue processing.4)The supplier processes each OR_ORDER in the Order Request File and checks for data errors.? If an error is found, then they send an Error File back to and stop processing the bad order.? There are two exceptions to this error processing rule when an Order Status File is sent back instead:a)Unrecognized Item – If the order request line item isn’t recognized in the supplier’s system, then send back a line STATUSCODE of “LU”.b)Discontinued Item – If the order request line item refers to a discontinued (no longer available) item in the supplier’s system, then send back a line STATUSCODE of “LD”.5)Once an OR_ORDER is loaded into the supplier’s order processing system, they generate an Order Status File to acknowledge each order line.? This response may be different for each of two general cases:a)In Stock Items – If an item is available right away, then respond with a line STATUSCODE of "LI" for each line.? This message is due within four hours of receiving the Order Request File and indicates that the line will ship in one to two business days.b)On Demand Items – If the item is not available right away but will become available within a specified timeframe, then respond with a line STATUSCODE of “LH” to indicate that the line is “on hold” in the supplier’s system and will ship when available.? This acknowledgement may come in one of two ways:i)Supplier sends a line STATUSCODE of “LH” within four hours of receiving the Order Request File.ii)Supplier sends a line STATUSCODE of “LI” within four hours of receiving the Order Request File to satisfy the initial acknowledgement requirement.? Then a line STATUSCODE of “LH” is sent within one to two business days to put the line on hold.Note: takes note of the item availability at the time the order was placed as reported by each DSV in the Item Inventory File.? It’s expected that the line will not be on hold past the maximum availability time.? For more information, see this section of the DSV Inventory Interfaces Specification, v4.0.0.6)As the supplier picks items and packages them for shipment, they may receive a cancellation request or find out that all the items (per line) aren’t available to ship.? Here are the corresponding order line responses:a)Canceled Line – The supplier will cancel an order request line only after receiving a cancellation request from (via verbal request, automated e-mail message or Order Cancel File).? In this case send back a line STATUSCODE of "LC" and it will cancel all items in the line.b)Fully Backordered Line – If all items in a line are not available to ship, then send back a line STATUSCODE of "LB" and set the QUANTITY equal to the number of items ordered.? This transfers control back to the system and another order request will be generated when the items come back into stock.? The outstanding items will not remain live in the supplier's system. ?c)Partially Backordered Line (Not Applicable for Drop Ship Suppliers - only for owned item facilities) – If some items in a line are not available to ship, then send back a line STATUSCODE of "LB" and set the QUANTITY equal to the number of items not available.? Then send a package invoice message to reflect the number of items shipped (see below).? This transfers control back to the system for the outstanding items and another order request will be generated when the items come back into stock.? The outstanding items will not remain live in the supplier's system. ?Note: Backorders aren’t accepted for “Build to Order” DSV items with inventory availability code of “BO”.? For more information, see the Item Inventory File section of the DSV Inventory Interfaces Specification, v4.0.0.7)Once the items are available, the supplier packages them and ships according to the requested shipping method.? The package should have shipping label on the outside.? The supplier also sends back a package invoice message in the Order Status File that reflects the shipping details and an invoice to with the cost of goods and services.? Here are the possible package fulfillment cases:a)Electronic Delivery Item – If the line contains a “virtual” item that was downloaded over the Internet, then send back a package STATUSCODE of "PE".b)External Carrier Shipment – If all items were shipped via an external carrier (e.g. UPS, FedEx, Airborne, etc.), then send back an OS_PACKAGEINVOICE message for each unique tracking number and a package STATUSCODE of "PS".c)In-Store Delivery via Wal-Mart Fleet Carrier – If the items are to be picked up at a Wal-Mart store and are delivered via a Wal-Mart Fleet truck, then send back a package STATUSCODE of “PT” and a unique tracking number to indicate that the items are in transit.? Once the items arrive and are available for pickup, send a package STATUSCODE of “PA” with the same package ID and tracking number.8) keeps track of the items shipped.? If some order lines are backordered, then keeps the order alive and sends another order request once the items are back in stock.? The new request will not reference back to the original order request, but it will have the same customer order number.9) bills the customer’s card and pays each DSV (through the Wal-Mart accounts payable system) for items shipped.Error Handling / Resend ProcessWill use Error Files for messaging. ?There are two types of error response:1)The received file is incomplete or invalid against the v4.0 DTD.? In this case, the entire file is bad and it’s assumed that no data within the file was processed.? The sender will receive only the Error File (no Confirmation File) and will resend a valid file as soon as possible.2)The file contains a message with bad data.? In this case, only the message containing the error is rejected and all other messages in the file are processed.? For example, if the supplier processes an Order Request File containing 50 OR_ORDER messages and finds 2 messages that contain bad data, then the following will occur:?Supplier sends a Confirmation File because the file is complete and valid against the v4.0 DTD.?Supplier sends back an Error File with 2 FE_ERROR elements detailing the bad OR_ORDER messages.?Supplier processes the other 48 OR_ORDER messages.? resends the OR_ORDER messages in a subsequent file.Scheduling & Volume AnalysisExpected order volume is different for each supplier.? Estimates may be obtained from the Logistics and/or Merchandising Teams. ?Variations on the standard schedule (as described below) may be negotiated between each supplier and the Logistics Team.?Outbound messages are generated as follows:?Order Request and Order Cancel Files – A batch job queries database for order and cancel requests every X(will be defined by partner) minutes (24x7x365).? If requests are present and ready to be transmitted, then the job generates an XML message to the appropriate supplier and transmits right away.? If no requests are present for a particular supplier, then no messages are sent.?Confirmation and Error Files – One or both of these messages are generated as each inbound file is processed (if applicable).? The messages are placed in an outbound queue and transmitted right away.Inbound messages are processed as they are uploaded to the gateway server.? Each supplier is expected to send files as follows:?Initial Confirmation or Error Files – For each file transmitted to the supplier, a Confirmation or Error File response is expected within one hour of the transmission.? This acknowledges the receipt of the file and indicates whether the file passed file validation checks.?Processing Error Files – As the supplier processes each file, an Error File is generated if bad data is found.? This error message (if applicable) is expected within four hours of file transmission.?Order Request Line Status – If an order request is processed without format or data errors, then an Order Status File with an acknowledgement status of “LI” or “LH” is expected within four hours.? Alternatively, the supplier could send a non-fulfillment status of “LD”, “LU” or “LB” in the first four hours – or after the acknowledgement and before the package fulfillment message is expected (see below).?Order Request Line Cancellation Status – The Order Status response to an Order Cancel File is expected in the same timeframe as the package fulfillment response below.? This may be a line cancellation of “LC” or a package fulfillment message.?Order Request Package Fulfillment – The supplier sends an Order Status File with a package fulfillment status of “PS”, “PE” or “PT” as each package is sent.? The timing of these messages for each order request line is dependent on the item type and stated availability.General XML File StructureInitial XML DeclarationThe first line of the file defines the XML Standard version and the character encoding used in the file.? The format for this is as follows:<?xml version="1.0" encoding="UTF-8"?>XML Data DefinitionEach data element (and its component attributes and sub-elements) is described in this document with the following information.Xpath LocationThe location of the each element or attribute within the data element is defined based on Xpath notation. ??If the Xpath begins with a “/” character, then it’s absolute within the XML message (e.g. “/WMI/WMIHEADER/FH_TO@ID”). ??If the Xpath begins with any other character, then it’s relative to the specified reference node (e.g. “FH_TO@ID”, with a reference node of “/WMI/WMIHEADER”). ?For further information see . ?Optional/RequiredSpecifies whether each element or attribute is required to populate its parent element.?If optional, then the element or attribute may be populated with no data or may be omitted entirely.? Note that most optional data must be populated based on certain conditional business rules, so this must be taken into account when validating the file.?If required, then the element or attribute must exist and may not be empty.Data TypeSpecifies the type of data that’s contained in an element or attribute.?“STR” – A string value that can contain alphanumeric characters and punctuation.? This is parsed data, so any XML markup delimiters must be escaped with a character string as follows:oReplace greater than (>) with “&gt;”oReplace less than (<) with “&lt;”oReplace ampersand (&) with “&amp;”oReplace double-quote (”) with “&quot;”oReplace apostrophe (‘) with “&apos;”For more information, see ?“DEC” – A decimal value that contains only numeric data and a decimal point.? If the decimal is not present, it’s implied at the end.?“NUM” – Numeric data that can’t contain any alphabetic characters or punctuation.?“DTM” – A formatted date/time value that contains only numeric and punctuation characters.? It’s formatted as “MM/DD/CCYY.hh24.mi”, where “MM/DD/CCYY” is the date and “hh24.mi” is the 24-hour time (e.g. “12/11/2001.17.01”).?“FID” – A formatted File ID that contains only numeric and punctuation characters.? It is built from the file generation date and time, the WMFC vendor number and a six-digit random number (to guarantee uniqueness).? The format is:VVVVVVVVV.YYYYMMDD.HHMMSS.NNNNNNUsing the following notation:VVVVVVVVV is the Vendor ID assigned by (1 to 9 digits)YYYYMMDD is an eight-digit file creation date (GMT date)HHMMSS is a six-digit file creation time (24-hour GMT time)NNNNNN is a six-digit random number.?Note that these are the same fields used to generate an XML filename.? The filename and the File ID will use the same date, time and random number values.Data LengthSpecifies the maximum length of the data as follows:?“STR” – Number of character digits.? Note: When a character is escaped, the length of the data string expands.? The length of the data string may be up to 6 times the number of string characters (for a case with all double-quote characters).?“DEC” – Expressed as “N.D” notation, where “N” is the number of characters allowed to the left of the decimal and “D” is the number of digits to the right.? Note: Leading zeros are not required.?“NUM” – Number of numeric digits.?“DTM” – Number of characters in the formatted string.?“FID” – Number of characters in the formatted string.WMIHEADER ElementThe WMIHEADER element is the first element in any file.? It contains a unique file ID, the sender's name, the sender's vendor number and information for the contacting the sender. ?Xpath?OptTypeLengthDescription/WMI/WMIHEADER(Reference Node)R--File descriptor with the following attributes: FILEID, FILETYPE and VERSION.? Also contains one each of the following elements: FH_TO and FH_FROM@FILEIDRFID24 to 32Unique ID for this file.? See naming convention above.@FILETYPERSTR3File type code, see table below for values.@VERSIONRSTR5Version level of the XML format used.? The value is “4.0.0” for files using this specification.FH_TOR--Recipient information, containing the following attributes: ID and NAME.FH_TO@IDRNUM1 to 9Supplier number of the recipient.? The value is “2677” for files sent to .FH_TO@NAMERSTR1 to 30Text name of the recipient.? The value is "" for files sent to .FH_FROMR--Sender information, containing the following attributes: ID and NAME.? Also contains a FH_CONTACT element.FH_FROM@IDRNUM1 to 9Supplier number of the sender.? The value is “2677” for files from .FH_FROM@NAMERSTR1 to 30Text name of the sender.? The value is "" for files from .FH_FROM/FH_CONTACTR--Operations support contact information, with attributes NAME, EMAIL, PHONE and PHONEEXT.FH_FROM/FH_CONTACT@NAMERSTR1 to 30Name of the operations support contact.FH_FROM/FH_CONTACT@EMAILRSTR1 to 50Operations contact email addressFH_FROM/FH_CONTACT@PHONERNUM1 to 10Operations contact phone number (10-digit string containing no punctuation or spaces).FH_FROM/FH_CONTACT@PHONEEXTONUM1 to 5Operations contact phone extension (if applicable).FILETYPE ValuesCode ValueDescriptionFFCFile contains WMIFILECONFIRM data elementFFEFile contains WMIFILEERROR data elementFORFile contains WMIORDERREQUEST data element.FOCFile contains WMIORDERCANCEL data element.FOSFile contains WMIORDERSTATUS data element.Order Request XML File?The Order Request File contains detailed information required to fulfill customer order requests. ?File Naming ConventionThe file name contains the file type, creation date and time, the Supplier ID and a six-digit random number.? All filenames are case-sensitive. ?The naming convention is:WMI_Order_Req_VVVVVVVVV_YYYYMMDD_HHMMSS_NNNNNN.xmlUsing the following notation:?VVVVVVVVV is the Supplier ID assigned by (up to 9 digits)?YYYYMMDD is a formatted file creation date (GMT date)?HHMMSS is a formatted file creation time (24-hour GMT time)?NNNNNN is a six-digit random number to guarantee uniqueness.?Example: WMI_Order_Req_999999_20010718_163108_097981.xmlWMIORDERREQUEST ElementThe WMIORDERREQUEST element contains a group of order request messages.? Each order request message that tells the supplier to pack and ship items to a customer.If data if missing or invalid, then OR_ORDER elements can be individually rejected via an Error File (see error handling section above).?Xpath?OptTypeLengthDescription/WMI/WMIORDERREQUEST(Reference Node)R--Contains one or more OR_ORDER elements.OR_ORDERR--The order request, with attributes REQUESTNUMBER and ORDERNUMBER.? Contains one or more OR_ORDERLINE elements and one each of the following: OR_DATEPLACED, OR_SHIPPING, OR_BILLING, OR_RETURNS OR_LASTDELIVERYMSG, OR_MARKETINGMSG and OR_RETURNSMSG.OR_ORDER@REQUESTNUMBERRNUM1 to 13A unique reference number for each order request.OR_ORDER@ORDERNUMBERRNUM13Customer’s website order number.OR_ORDER/OR_DATEPLACEDR--Date the order was placed with attributes DAY, MONTH and YEAR.OR_ORDER/OR_DATEPLACED@DAYRNUM2Day of the month (01 to 31).OR_ORDER/OR_DATEPLACED@MONTHRNUM2Numeric month of the year (01 to 12).OR_ORDER/OR_DATEPLACED@YEARRNUM4Four-digit year (e.g. 2001).OR_ORDER/OR_SHIPTOSTORE@VENDORIDONUM1 to 10Internal vendor number assigned to . Required for Ship to Store Orders. Carrier Method 80,81,88OR_ORDER/OR_SHIPTOSTORE/OR_WPM@WPM_NUMONUM5Zero padded WPM facility identifierOR_ORDER/OR_SHIPTOSTORE/OR_WPM@GLN_NUMBERONUM13Zero Padded GLN NumberOR_ORDER/OR_SHIPTOSTORE/OR_WPM/OR_POSTAL@NAMEOSTR1 to 35Location name?OR_ORDER/OR_SHIPTOSTORE/OR_WPM/OR_POSTAL@ADDRESS1OSTR1 to 30Address line 1OR_ORDER/OR_SHIPTOSTORE/OR_WPM/OR_POSTAL@ADDRESS2OSTR1 to 30Address line 2OR_ORDER/OR_SHIPTOSTORE/OR_WPM/OR_POSTAL@ADDRESS3OSTR1 to 30Address line 3OR_ORDER/OR_SHIPTOSTORE/OR_WPM/OR_POSTAL@ADDRESS4OSTR1 to 30Address line 4OR_ORDER/OR_SHIPTOSTORE/OR_WPM/OR_POSTAL@CITYOSTR1 to 25City nameOR_ORDER/OR_SHIPTOSTORE/OR_WPM/OR_POSTAL@STATEOSTR2USPS state abbreviation.OR_ORDER/OR_SHIPTOSTORE/OR_WPM/OR_POSTAL@POSTALCODEOSTR5 or 9USPS zip codeOR_ORDER/OR_SHIPTOSTORE/OR_RDC@RDC_NUMONUM5Zero padded? RDC facility identifierOR_ORDER/OR_SHIPTOSTORE/OR_RDC@GLN_NUMBERONUM13Zero padded GLN NumberOR_ORDER/OR_SHIPTOSTORE/OR_RDC/OR_POSTAL@NAMEOSTR1 to 35Location name?OR_ORDER/OR_SHIPTOSTORE/OR_RDC/OR_POSTAL@ADDRESS1OSTR1 to 30Address line 1OR_ORDER/OR_SHIPTOSTORE/OR_RDC/OR_POSTAL@ADDRESS2OSTR1 to 30Address line 2OR_ORDER/OR_SHIPTOSTORE/OR_RDC/OR_POSTAL@ADDRESS3OSTR1 to 30Address line 3OR_ORDER/OR_SHIPTOSTORE/OR_RDC/OR_POSTAL@ADDRESS4OSTR1 to 30Address line 4OR_ORDER/OR_SHIPTOSTORE/OR_RDC/OR_POSTAL@CITYOSTR1 to 25City nameOR_ORDER/OR_SHIPTOSTORE/OR_RDC/OR_POSTAL@STATEOSTR2USPS state abbreviation.OR_ORDER/OR_SHIPTOSTORE/OR_RDC/OR_POSTAL@POSTALCODEOSTR5 or 9USPS zip codeOR_ORDER/OR_SHIPPINGR--Delivery information, with attributes METHODCODE, CARRIERMETHODCODE, STORENUMBER and TOGETHERCODE.? Contains one each of the following elements: OR_PHONE and OR_POSTAL.? Also may contain one each following elements: OR_DELIVERYDATE and OR_EMAIL.OR_ORDER/OR_SHIPPING@METHODCODERSTR2Code for requested shipping service requested for delivery.? Code values are as follows:?“MS” – Standard Delivery (Ground)?“MP – Priority Delivery (2-Day)?“MX” – Express Delivery (Overnight)?“MY” – Express Delivery with Saturday Delivery Option?“ME” – Electronic Delivery?“MI” – Delivery for In-Store Pickup?“MW” – Fulfillment from In-Store Inventory (NOT IN USE)?“MA” – S2S Express delivery?“MV” – Value Shipping (Ground)Note: Most suppliers use the “MS”, “MP” and “MX” codes and don’t need to support other codes unless specifically instructed.OR_ORDER/OR_SHIPPING@CARRIERMETHODCODEONUM4Populated if the supplier requires a specific carrier and method for each shipment.? See below for values.OR_ORDER/OR_SHIPPING@STORENUMBERONUM10A Wal-Mart store number, populated if METHODCODE is “MI”.OR_ORDER/OR_SHIPPING@TOGETHERCODERSTR2Codes used suppress split line shipments within a facility.? Code values are as follows:?“SC” – Hold items in each line and ship when complete?“SA” – Split items and deliver as they become availableNote: Most suppliers use the “SC” code and don’t need to support other codes unless specifically instructed.OR_ORDER/OR_SHIPPING/OR_PHONER--Phone number of the shipping contact, with attributes PRIMARY, PRIMARYEXT, SECOND and SECONDEXT.OR_ORDER/OR_SHIPPING/OR_PHONE@PRIMARYRNUM10Primary phone number (no punctuation or spaces)OR_ORDER/OR_SHIPPING/OR_PHONE@PRIMARYEXTONUM1 to 5Primary phone extensionOR_ORDER/OR_SHIPPING/OR_PHONE@SECONDONUM10Secondary phone number (no punctuation or spaces)OR_ORDER/OR_SHIPPING/OR_PHONE@SECONDEXTONUM1 to 5Secondary phone extensionOR_ORDER/OR_SHIPPING/OR_POSTALR--Delivery address, with attributes NAME, ADDRESS1, ADDRESS2, ADDRESS3, ADDRESS4, CITY, STATE, POSTALCODE and COUNTRY.OR_ORDER/OR_SHIPPING/OR_POSTAL@NAMERSTR1 to 35Full nameOR_ORDER/OR_SHIPPING/OR_PHONEO--Phone number of the billing contact, with attributes PRIMARY, PRIMARYEXT, SECOND and SECONDEXT.OR_ORDER/OR_SHIPPING/OR_PHONE@PRIMARYRNUM10Primary phone number (no punctuation or spaces)OR_ORDER/OR_SHIPPING/OR_PHONE@PRIMARYEXTONUM1 to 5Primary phone extensionOR_ORDER/OR_SHIPPING/OR_PHONE@SECONDONUM10Secondary phone number (no punctuation or spaces)OR_ORDER/OR_SHIPPING/OR_PHONE@SECONDEXTONUM1 to 5Secondary phone extensionOR_ORDER/OR_SHIPPING/OR_POSTAL@ADDRESS1RSTR1 to 30First address lineOR_ORDER/OR_SHIPPING/OR_POSTAL@ADDRESS2OSTR1 to 30Available for a second address lineOR_ORDER/OR_SHIPPING/OR_POSTAL@ADDRESS3OSTR1 to 30Available for a third address line (not currently used)OR_ORDER/OR_SHIPPING/OR_POSTAL@ADDRESS4OSTR1 to 30Available for a fourth address line (not currently used)OR_ORDER/OR_SHIPPING/OR_POSTAL@CITYRSTR1 to 25City nameOR_ORDER/OR_SHIPPING/OR_POSTAL@STATERSTR2USPS state abbreviation.OR_ORDER/OR_SHIPPING/OR_POSTAL@POSTALCODERNUM5 or 9USPS zip codeOR_ORDER/OR_SHIPPING/OR_POSTAL@COUNTRYRSTR3ISO ALPHA-3 country code.? For a list of codes, see the customer expects the order to be delivered, with attributes DAY, MONTH and YEAR. ?Note: Not all suppliers support this functionality.OR_ORDER/OR_SHIPPING/OR_DELIVERYDATE@DAYRNUM2Day of the month (01 to 31).OR_ORDER/OR_SHIPPING/OR_DELIVERYDATE@MONTHRNUM2Numeric month of the year (01 to 12).OR_ORDER/OR_SHIPPING/OR_DELIVERYDATE@YEARRNUM4Four-digit year (e.g. 2001).OR_ORDER/OR_SHIPPING/OR_EXPECTEDSHIPDATEO--Date the by which the order is expected to be shipped from fulfillment center/DC, with attributes DAY, MONTH and YEAR. ?Note: Not all suppliers support this functionality.OR_ORDER/OR_SHIPPING/OR_EXPECTEDSHIPDATE@DAYRNUM2Day of the month (01 to 31).OR_ORDER/OR_SHIPPING/OR_EXPECTEDSHIPDATE@MONTHRNUM2Numeric month of the year (01 to 12).OR_ORDER/OR_SHIPPING/OR_EXPECTEDSHIPDATE@YEARRNUM4Four-digit year (e.g. 2001).OR_ORDER/OR_SHIPPING/OR_ORDERPROCESSINGDATEO--Date on which the order to be processed at fulfillment center/DC, with attributes DAY, MONTH and YEAR. ?Note: Not all suppliers support this functionality.OR_ORDER/OR_SHIPPING/ OR_ORDERPROCESSINGDATE@DAYRNUM2Day of the month (01 to 31).OR_ORDER/OR_SHIPPING/ OR_ORDERPROCESSINGDATE@MONTHRNUM2Numeric month of the year (01 to 12).OR_ORDER/OR_SHIPPING/ OR_ORDERPROCESSINGDATE@YEARRNUM4Four-digit year (e.g. 2001).OR_ORDER/OR_SHIPPING/OR_EMAILOSTR1 to 75E-mail address of shipping contact.OR_ORDER/OR_BILLINGR--Contains OR_PRICE? attribute and each one of the following elementsOR_PAIMENT, OR_PHONE, OR_POSTAL?OR_ORDER/OR_BILLING@OR_PRICERDEC8.2Order price?OR_ORDER/OR_BILLING/OR_PAYMENT@METHODRSTR1 to 20Description of payment method (e.g. “VISA-1234”).? Note: For gift orders, this is replaced by non-descriptive text.OR_ORDER/OR_BILLING/OR_PHONEO--Phone number of the billing contact, with attributes PRIMARY, PRIMARYEXT, SECOND and SECONDEXT.OR_ORDER/OR_BILLING/OR_PHONE@PRIMARYRNUM10Primary phone number (no punctuation or spaces)OR_ORDER/OR_BILLING/OR_PHONE@PRIMARYEXTONUM1 to 5Primary phone extensionOR_ORDER/OR_BILLING/OR_PHONE@SECONDONUM10Secondary phone number (no punctuation or spaces)OR_ORDER/OR_BILLING/OR_PHONE@SECONDEXTONUM1 to 5Secondary phone extensionOR_ORDER/OR_BILLING/OR_POSTALR--Postal billing address, with attributes NAME, ADDRESS1, ADDRESS2, ADDRESS3, ADDRESS4, CITY, STATE, POSTALCODE and COUNTRY.OR_ORDER/OR_BILLING/OR_POSTAL@NAMERSTR1 to 35Full nameOR_ORDER/OR_BILLING/OR_POSTAL@ADDRESS1RSTR1 to 30First address lineOR_ORDER/OR_BILLING/OR_POSTAL@ADDRESS2OSTR1 to 30Available for a second address lineOR_ORDER/OR_BILLING/OR_POSTAL@ADDRESS3OSTR1 to 30Available for a third address line (not currently used)OR_ORDER/OR_BILLING/OR_POSTAL@ADDRESS4OSTR1 to 30Available for a fourth address line (not currently used)OR_ORDER/OR_BILLING/OR_POSTAL@CITYRSTR1 to 25City nameOR_ORDER/OR_BILLING/OR_POSTAL@STATERSTR2USPS state abbreviation.OR_ORDER/OR_BILLING/OR_POSTAL@POSTALCODERNUM5 or 9USPS zip codeOR_ORDER/OR_BILLING/OR_POSTAL@COUNTRYRSTR3ISO ALPHA-3 country code.? For a list of codes, see to 75E-mail address of billing contact.OR_ORDER/OR_RETURNSR--Returns-related info, with attributes TCNUMBER and METHODCODE.? May contain one OR_POSTAL and/or one OR_PERMIT element depending on the METHODCODE value.OR_ORDER/OR_RETURNS@TCNUMBERRNUM1 to 25Unique TC Number for this order request, used for in-store returns.See below for? details on generationOR_ORDER/OR_RETURNS@METHODCODERSTR2Code to specify direct returns method.? Valid code values are as follows:? “RC” – Returns Center (not pre-paid)?“RP” – Returns Center with Pre-Paid Permit?“RS” – Returns Direct to Supplier (not pre-paid)Note: All suppliers use the “RX” code and don’t need to support other codes unless specifically instructed.OR_ORDER/OR_RETURNS/OR_POSTALO--Returns center postal address, with attributes NAME, ADDRESS1, ADDRESS2, ADDRESS3, ADDRESS4, CITY, STATE, POSTALCODE and COUNTRY.? Only used if METHODCODE is RC, RP or RS.OR_ORDER/OR_RETURNS/OR_POSTAL@NAMERSTR1 to 35Full nameOR_ORDER/OR_RETURNS/OR_POSTAL@ADDRESS1RSTR1 to 30First address lineOR_ORDER/OR_RETURNS/OR_POSTAL@ADDRESS2OSTR1 to 30Available for a second address lineOR_ORDER/OR_RETURNS/OR_POSTAL@ADDRESS3OSTR1 to 30Available for a third address line (not currently used)OR_ORDER/OR_RETURNS/OR_POSTAL@ADDRESS4OSTR1 to 30Available for a fourth address line (not currently used)OR_ORDER/OR_RETURNS/OR_POSTAL@CITYRSTR1 to 25City nameOR_ORDER/OR_RETURNS/OR_POSTAL@STATERSTR2USPS state abbreviation.OR_ORDER/OR_RETURNS/OR_POSTAL@POSTALCODERNUM5 or 9USPS zip codeOR_ORDER/OR_RETURNS/OR_POSTAL@COUNTRYRSTR3ISO ALPHA-3 country code.? For a list of codes, see permit info, with attributes NUMBER, CITY, STATE and POSTALCODE.? Only required if METHODCODE is RP.OR_ORDER/OR_RETURNS/OR_PERMIT@NUMBERRSTR1 to 20USPS permit number for returnsOR_ORDER/OR_RETURNS/OR_PERMIT@CITYRSTR1 to 20City nameOR_ORDER/OR_RETURNS/OR_PERMIT@STATERSTR2USPS state abbreviation.OR_ORDER/OR_RETURNS/OR_PERMIT@POSTALCODERNUM5 or 9USPS zip codeOR_ORDER/OR_ORDERLINER--Line info, with attributes LINENUMBER and LINEPRICE.? Contains one each of the following elements: OR_ITEM, OR_PRICE, OR_COST.? May also contain multiple OR_VAS and/or OR_DYNAMICDATA elements if they apply.OR_ORDER/OR_ORDERLINE@LINENUMBERRNUM1 to 3Line number unique to this order request. ?OR_ORDER/OR_ORDERLINE@LINEPRICERDEC8.2Total retail price for all items in this line including value-added services and adjustments.? Note: Only for validating the price totals in this line.? For gift orders this field is filled with a single “0” (zero) character.OR_ORDER/OR_ORDERLINE/OR_ITEMR--Item identification info with the following attributes: ITEMNUMBER, UPC, SKU and DESCRIPTION.Note: ITEM information is not necessarily unique to a single OR_ORDERLINE element in an OR_ORDER.OR_ORDER/OR_ORDERLINE/OR_ITEM@ITEMNUMBERRNUM1 to item numberOR_ORDER/OR_ORDERLINE/OR_ITEM@UPCRNUM13Wal-Mart UPC (13 digits with no check digit)OR_ORDER/OR_ORDERLINE/OR_ITEM@SKURSTR1 to 20Supplier item SKUOR_ORDER/OR_ORDERLINE/OR_ITEM@DESCRIPTIONRSTR1 to 60Short description of the ordered item. ?For gift orders, this description is replaced by non-descriptive text.OR_ORDER/OR_ORDERLINE/OR_ITEM@QUANTITYRNUM1 to 4Quantity orderedOR_ORDER/OR_ORDERLINE/OR_PRICER--Item prices, with attributes RETAIL, TAX and SHIPPING.? May contain multiple OR_VASPRICE and/or OR_ADJUSTMENT elements.Note: This price information reflects the customer’s cost and is used to calculate pricing.? For gift orders, these fields are filled with a single “0” (zero) character.OR_ORDER/OR_ORDERLINE/OR_PRICE@RETAILRDEC8.2Retail price for each item in this line. ?OR_ORDER/OR_ORDERLINE/OR_PRICE@TAXRDEC8.2Tax price for each item in this line.OR_ORDER/OR_ORDERLINE/OR_PRICE@SHIPPINGRDEC8.2Shipping price for each item in this line.OR_ORDER/OR_ORDERLINE/OR_PRICE/OR_VASPRICEO--Value-Added Service charge, with DESCRIPTION and AMOUNT attributes.Note: These elements are never present in gift orders.OR_ORDER/OR_ORDERLINE/OR_PRICE/OR_VASPRICE@DESCRIPTIONRSTR1 to 50Short description of value-added service.OR_ORDER/OR_ORDERLINE/OR_PRICE/OR_VASPRICE@AMOUNTRDEC8.2Value-added service price for each item in this line.OR_ORDER/OR_ORDERLINE/OR_PRICE/OR_ADJUSTMENTO--Negative price adjustment, with DESCRIPTION and AMOUNT attributes.Note: These elements are never present in gift orders.OR_ORDER/OR_ORDERLINE/OR_PRICE/OR_ADJUSTMENT@DESCRIPTIONRSTR1 to 50Short description of adjustmentOR_ORDER/OR_ORDERLINE/OR_PRICE/OR_ADJUSTMENT@AMOUNTRDEC8.2Adjustment price (promotion or customer service credit) for each item in this line.? The value will be positive.OR_ORDER/OR_ORDERLINE/OR_COSTR--Assumed item cost, with attribute AMOUNT.OR_ORDER/OR_ORDERLINE/OR_COST@AMOUNTRDEC8.2Cost to for each item in this lineOR_ORDER/OR_ORDERLINE/OR_VASO--Value-Added Service with attributes SEQUENCE and VASCODE.? Also contains one or more OR_VASDATA element.? The VAS data defined for each VAS code is described in the table below.OR_ORDER/OR_ORDERLINE/OR_VAS@SEQUENCERNUM1 to 2Sequence number unique to this value-added service request.? Starts with 1 and increments for each VAS. ?OR_ORDER/OR_ORDERLINE/OR_VAS@VASCODERSTR3Code identifies the value-added service.? Valid code values are listed below.OR_ORDER/OR_ORDERLINE/OR_VAS/OR_VASDATAR--VAS data, with attributes NAME and VALUE.? Data is described with the VASCODE values below.OR_ORDER/OR_ORDERLINE/OR_VAS/OR_VASDATA@NAMERSTR1 to 10Name of VAS data elementOR_ORDER/OR_ORDERLINE/OR_VAS/OR_VASDATA@VALUERSTR1 to 50Value of VAS data elementNote: If any of these data elements are intentionally blank, then they’ll have a single “0” (zero) character.OR_ORDER/OR_ORDERLINE/OR_DYNAMICDATAO--Dynamic data with attributes NAME and VALUE.? Data is described with the VASCODE values below.OR_ORDER/OR_ORDERLINE/OR_DYNAMICDATA@NAMERSTR1 to 50The name of the dynamic data element.OR_ORDER/OR_ORDERLINE/OR_DYNAMICDATA@VALUERSTR1 to 1000The value of the dynamic data element.OR_ORDER/OR_LASTDELIVERYMSGR--A delivery message with attributes LINE1, LINE2, LINE3 and LINE4. ?OR_ORDER/OR_LASTDELIVERYMSG@LINE1RSTR1 to 100First line of messageOR_ORDER/OR_LASTDELIVERYMSG@LINE2RSTR1 to 100Second line of messageOR_ORDER/OR_LASTDELIVERYMSG@LINE3RSTR1 to 100Third line of messageOR_ORDER/OR_LASTDELIVERYMSG@LINE4RSTR1 to 100Fourth line of messageOR_ORDER/OR_MARKETINGMSGR--A marketing message with attributes LINE1, LINE2, LINE3 and LINE4.OR_ORDER/OR_MARKETINGMSG@LINE1RSTR1 to 100First line of messageOR_ORDER/OR_MARKETINGMSG@LINE2RSTR1 to 100Second line of messageOR_ORDER/OR_MARKETINGMSG@LINE3RSTR1 to 100Third line of messageOR_ORDER/OR_MARKETINGMSG@LINE4RSTR1 to 100Fourth line of messageOR_ORDER/OR_RETURNSMSGR--A returns message with attributes LINE1, LINE2, LINE3 and LINE4.OR_ORDER/OR_RETURNSMSG@LINE1RSTR1 to 50First line of messageOR_ORDER/OR_RETURNSMSG@LINE2RSTR1 to 50Second line of messageOR_ORDER/OR_RETURNSMSG@LINE3RSTR1 to 50Third line of messageOR_ORDER/OR_RETURNSMSG@LINE4RSTR1 to 50Fourth line of messageLine VASCODE ValuesCodeDescriptionVASDATA NameVASDATA ValueVGTGift TagTOGift Tag “To” Message (30 characters max)FROMGift “From” Message (30 characters max)VGMGift MessageLINE11st line of gift message (30 characters max)?LINE22nd line of gift message (30 characters max)LINE33rd line of gift message (30 characters max)LINE44th line of gift message (30 characters max)VGWGift WrapUPCUPC of gift wrap requested (13-digit numeric)VCDCustoms Declaration?CDFLAGCharacter value 'Y'VPRPuerto Rico Customs DeclarationPRCDFLAGCharacter value 'Y'VOIOuter Invoice on cartonINVOICECharacter value 'Y'VSRSignature on deliverySODCharacter value 'Y'Shipping CARRIERMETHODCODE ValuesShipping CARRIERMETHODCODE ValuesThe applicable carrier method codes from the below list will be provided before the start of testingExisting CodesCarrier/Method DescriptionNotes01USPS Parcel Post02UPS Ground03Clark Transport LTL04Yellow Freight System LTL05USPS Express Mail?06USPS 4th Intra07USPS 4th Inter08USPS 4th Dest09UPS 2nd Day Air?Same as 13 – This is the preferred code value10USPS First Class Mail11Spee-Dee12Silver Star13UPS 2nd Day Air?Same as 9 – Included for backward compatibility14Consolidated Freightways LTL15J. B. Hunt Transport Services LTL16UPS Next Day Air?17Common Carrier LTL18Roadway Express LTL19FedEx Express Saver (3 Day Service)20FedEx Ground21FedEx Priority Overnight?Same as 23 – This is the preferred code22FedEx 2 Day23FedEx Priority Overnight?Same as 21 – Included for backward compatibility24FedEx Standard Overnight25American Freightways LTL?26UPS Next Day Air Saver?27UPS 2nd Day Air A.M.?Same as 28 – This is the preferred code28UPS 2nd Day Air A.M.Same as 27 – Included for backward compatibility29UPS 3 Day Select30USPS Priority Mail31USPS Priority Mail32Old Dominion Freight Line LTL33Airborne Next Afternoon?34Airborne Ground Delivery35Airborne Overnight Air Express?36Airborne@Home37Airborne 2nd Day Service38UPS Ground39Overnight Transportation LTL40The Connection Company LTL41ABF Freight Systems LTL42Bekins LTL43Pilot Freight LTL44FedEx Priority Overnight w/ Saturday Delivery45UPS Next Day Air Saver w/ Saturday Delivery46SmartMail Ground Delivery47USPS Media Mail48USPS Bound Printed Matter49Bekins Economy50Bekins Premium51Eagle Global Logistics - Priority Service52Eagle Global Logistics - Next Day Service53Eagle Global Logistics - Second Day Service54Eagle Global Logistics - Three Day Service55Eagle Global Logistics – Economy56Eagle Global Logistics - White Glove57Exel Direct/CDN Overnight58Exel Direct/CDN 2 Day59Exel Direct/CDN Economy60Exel Direct/CDN White Glove61UPS Ground (CTN, GA)62UPS Ground (Parsippany, NJ)63UPS Ground (Chicago, IL)64UPS Ground (Vernon, CA)65FedEx SmartPost – BMC66FedEx SmartPost – DDU67FedEx Home Delivery6869UPS Mail Innovations BPM70UPS Mail Innovations71APX72Sun Delivery, Inc73APX-DDU74APX-BMC757677787980Ship to Store Direct DTS?81In-Store delivery via WPM & RDC82Seko Worldwide83DHL@home84DHL@home(expedited)85DHL Second Day Service86DHL Next Afternoon87FTD Florist88Ship to Store Direct. Expedited891 Hour Burn on Demand90Ship to store DTS Freight91In-Store Delivery via RDC (bypass WPM)92S2S DHL Sort939495Inventory from Wal-Mart Store96Wal-Mart Fleet for In-Store Pickup97Direct to Store 2 Day98Electronic Delivery99Photo In-Store Pickup100DHL Overnight Air Express101DHL Overnight w/SatTC number CalculationsTC number is calculated in OMS (Order management System) and encrypted using ISD-provided code.?? Unencrypted, it's?comprised of:?Store Number - 4 digitsTerminal ID -3 digitsTransaction ID 4 digitsAmount in cents - 7 digitsYear?of sale - 2 digitsDay of year - 3 digits?For , store# is 2677Transaction ID is 4 last digits of PO number,?Terminal# is next 2 digits of PO number?Example:TCNUMBER="46708052813539595453"Store# - 2677PO# (last 6 digits) 675342Amount - $97.88Date of sale - 3/12/06Order Cancel XML File?The Order Cancel File contains customer requests to cancel a specific order request line.? If it’s possible to cancel the line (i.e. the order hasn't been shipped yet), then return a line STATUSCODE of “LC” in the next Order Status File.? If the order line can't be stopped, then send back the shipping information as usual.Note: The supplier should only cancel the requested lines.? For example, if an order request contains four lines and the supplier receives cancel requests for lines 1, 3 and 4, then line 2 should ship as requested.? The request is for all items in the line.Note: The customer is aware that there’s no guarantee their line can be canceled.? However, we expect that the supplier will make a reasonable attempt to stop the shipment.File Naming ConventionThe file name contains the file type, creation date and time, the Supplier ID and a six-digit random number.? All filenames are case-sensitive. ?The naming convention is:WMI_Order_Cancel_VVVVVVVVV_YYYYMMDD_HHMMSS_NNNNNN.xmlUsing the following notation:?VVVVVVVVV is the Supplier ID assigned by (up to 9 digits)?YYYYMMDD is a formatted file creation date (GMT date)?HHMMSS is a formatted file creation time (24-hour GMT time)?NNNNNN is a six-digit random number to guarantee uniqueness.?Example: WMI_Order_Cancel_999999_20010418_163108_097981.xmlWMIORDERCANCEL ElementThe WMIORDERCANCEL element contains a group of order cancel messages.? Each order cancel request message tells the supplier to cancel a specific order request line, if possible.?If data if missing or invalid, then OC_LINECANCEL elements can be individually rejected via a WMIFILEERROR file (see error handling section above).Xpath?OptTypeLengthDescription/WMI/WMIORDERCANCEL(Reference Node)R--Contains at least one OC_LINECANCELOC_LINECANCELR--Cancel request, with attributes REQUESTNUMBER and LINENUMBEROC_LINECANCEL@REQUESTNUMBERRNUM1 to 13OR_ORDER@REQUESTNUMBER attribute of the original order request message.OC_LINECANCEL@LINENUMBERRNUM1 to 3OR_ORDER/OR_ORDERLINE@LINENUMBER attribute from the original order request message.Order Status XML FileThe Order Status File contains status updates for order request lines.? There are two types of status updates:?OS_LINESTATUS messages are for cases when an order request line has not been fulfilled.? The status may acknowledge the receipt of the line for future fulfillment or indicate that the line can’t be fulfilled for a specified reason.?OS_PACKAGEINVOICE messages indicate that items were sent to the customer.? Within this message, there is an OS_PACKAGE element to identify the package, an OS_SHIPDATE element to indicate when the package was sent and an OS_INVOICE element to indicate what is contained in the package and how much it cost.An Order Status File may contain only OS_PACKAGEINVOICE elements, only OS_LINESTATUS elements or a combination of both element types.File Naming ConventionThe file name contains the file type, creation date and time, the Supplier ID and a six-digit random number.? All filenames are case-sensitive. ?The naming convention is:WMI_Order_Status_VVVVVVVVV_YYYYMMDD_HHMMSS_NNNNNN.xmlUsing the following notation:?VVVVVVVVV is the Supplier ID assigned by (up to 9 digits)?YYYYMMDD is a formatted file creation date (GMT date)?HHMMSS is a formatted file creation time (24-hour GMT time)?NNNNNN is a six-digit random number to guarantee uniqueness.?Example: WMI_Order_Status_999999_20040718_163108_097981.xmlWMIORDERSTATUS ElementThe WMIORDERSTATUS element contains a group of order status messages.? Each order status message from the supplier contains a status update for a specific set of order request lines.If data if missing or invalid, then OS_LINESTATUS or OS_PACKAGEINVOICE elements can be individually rejected via an Error File (see error handling section above).Xpath?OptTypeLengthDescription/WMI/WMIORDERSTATUS(Reference Node)R--Contains one or more OS_LINESTATUS and/or OS_PACKAGEINVOICE elementsOS_LINESTATUSO--Line update, with attributes REQUESTNUMBER, LINENUMBER, STATUSCODE and QUANTITY. ?OS_LINESTATUS@REQUESTNUMBERRNUM1 to 13OR_ORDER@REQUESTNUMBER attribute of the original order request message.OS_LINESTATUS@LINENUMBERRNUM1 to 3OR_ORDER/OR_ORDERLINE@LINENUMBER attribute from the original order request message.OS_LINESTATUS@STATUSCODERSTR2Line status code.? Code values are as follows:??“LI” – An “initial” line acknowledgement that indicates the order request was loaded and will be fulfilled in the standard time window of 24 to 48 hours.?“LH” – A “hold” line acknowledgement that indicates the order request was loaded and will be fulfilled outside of the standard time window. ??“LD” – The line SKU is recognized and has been discontinued, so this line can’t be fulfilled.?“LU” – The line SKU is not recognized, so this line can’t be fulfilled.?“LB” – The line SKU is not in stock and can’t be fulfilled at this time, so the supplier has canceled this line.?“LC” – The line has been canceled by an Order Cancel message, so it will not be fulfilled.?“LW” – The line should be able to cancel until? receive the status from the distributor that it is not possible to cancel any more.OS_LINESTATUS@QUANTITYONUM1 to 4Number of items reflected by this status.? Only required for backorder notification (STATUSCODE = “LB”) and line Wave (STATUSCODE = “LW”), because all other statuses are assumed to reflect the full ordered quantity.OS_PACKAGEINVOICEO--Shipping notification, with attributes REQUESTNUMBER and STATUSCODE.? Contains one each of the following elements: OS_ PACKAGE and OS_SHIPDATE.? Also contains an OS_INVOICE element if the STATUSCODE is “PS”, “PT” or “PE”.OS_PACKAGEINVOICE@REQUESTNUMBERRNUM1 to 13OR_ORDER@REQUESTNUMBER attribute of the original order request message.OS_PACKAGEINVOICE@STATUSCODERSTR2Package status code.? Valid code values are as follows:?“PS” – A package was shipped to the customer via a carrier outside of the Wal-Mart distribution system.? Also used if items were delivered to the customer out of in-store inventory.OS_PACKAGEINVOICE/OS_PACKAGER--Physical package info, with attributes PACKAGEID, CARRIERMETHODCODE, TRACKINGNUMBER and WEIGHT.OS_PACKAGEINVOICE/OS_PACKAGE@PACKAGEIDRSTR1 to 25Number (assigned by the supplier) to uniquely identify this package within the REQUESTNUMBER.OS_PACKAGEINVOICE/OS_PACKAGE@CARRIERMETHODCODERNUM4The code of the shipping carrier and method used.? Valid codes are defined are part of the Order Request File definition.Note: In some cases this may be different than the value from the OR_SHIPPING@CARRIERMETHODCODE attribute in the original order request message.OS_PACKAGEINVOICE/OS_PACKAGE@TRACKINGNUMBERRSTR1 to 25Number used by the carrier to identify this package.? If tracking is not available for this carrier (e.g. USPS First-Class Mail, Electronic Delivery, etc.), then use a single pound (#) character. This is a unique number for each packageOS_PACKAGEINVOICE/OS_PACKAGE@ASNNUMBEROSTR1-20DSV Assigned unique SSCC18 Bar code for each Ship –to-Store Order package , See below details on generationOS_PACKAGEINVOICE/OS_PACKAGE@PALLET_ASNNUMBEROSTR1-20DSV Assigned SSCC18 Bar code for? shipping pallet for Backhaul Ship -to-Store order, See below details on generationOS_PACKAGEINVOICE/OS_PACKAGE@BOL_NUMBEROSTR1-20VICS Bill of Lading Number assigned to the shipmentOS_PACKAGEINVOICE/OS_PACKAGE@WEIGHTRDEC5.2Package weight in Pounds (rounded to 2 decimal points).OS_PACKAGEINVOICE/OS_SHIPDATER--Date the package was shipped, with the following attributes: DAY, MONTH and YEAR.OS_PACKAGEINVOICE/OS_SHIPDATE@DAYRNUM2Day of the month (01 to 31).OS_PACKAGEINVOICE/OS_SHIPDATE@MONTHRNUM2Numeric month of the year (01 to 12).OS_PACKAGEINVOICE/OS_SHIPDATE@YEARRNUM4Four-digit year (e.g. 2001).OS_PACKAGEINVOICE/OS_SHIPDATE@HOURONUM2Numeric hour of the day in HH24 format (00 to 23).OS_PACKAGEINVOICE/OS_SHIPDATE@MINUTEONUM2Numeric minute of the hour (00 to 59).OS_PACKAGEINVOICE/OS_SHIPDATE@TIMEZONEOCHAR2Time Zone valuesNorthAmerica / EuropeET = Eastern TimeCT = Central TimeMT = Mountain TimePT = Pacific TimeED = Eastern Daylight TimeCD = Central Daylight TimeMD = Mountain Daylight TimePD = Pacific Daylight TimeGM = Greenwich Mean Time (GMT England)OS_PACKAGEINVOICE/OS_INVOICEC--Package contents and cost to .? Contains one OS_SHIPPING element and one or more OS_LINECOST elements.It is mandatory for statuses PS,PE, PTOS_PACKAGEINVOICE/OS_INVOICE/OS_SHIPPINGR--Package shipping cost, with attributes SUPPLIERSHIPPING and THIRDPARTYSHIPPING.OS_PACKAGEINVOICE/OS_INVOICE/OS_SHIPPING@SUPPLIERSHIPPINGRDEC8.2Package cost of shipping paid by the supplier.? To be re-paid through accounts-payable process.OS_PACKAGEINVOICE/OS_INVOICE/OS_SHIPPING@THIRDPARTYSHIPPINGRDEC8.2Package cost of shipping by a 3rd party.? Billed to by the 3rd party.OS_PACKAGEINVOICE/OS_INVOICE/OS_LINECOSTR--Quantity and cost of shipped line, with attributes LINENUMBER, QUANTITY, HANDLING and ITEMCOST.? May also contain multiple OS_VAS elements.OS_PACKAGEINVOICE/OS_INVOICE/OS_LINECOST@LINENUMBERRNUM1 to 3OR_ORDER/OR_ORDERLINE@LINENUMBER attribute from the original order request message.OS_PACKAGEINVOICE/OS_INVOICE/OS_LINECOST@QUANTITYRNUM1 to 4Quantity of items shippedOS_PACKAGEINVOICE/OS_INVOICE/OS_LINECOST@ITEMCOSTODEC8.2Unit item cost from the supplier.? Optional if the vendor uses an Order Invoice File to send costs.OS_PACKAGEINVOICE/OS_INVOICE/OS_LINECOST@HANDLINGODEC8.2Unit cost for supplier handling for each item shipped.? Optional if the vendor uses an Order Invoice File to send costs.OS_PACKAGEINVOICE/OS_INVOICE/OS_LINECOST@STORENUMBERONUM1 to 5Store number , for line to be shipped from, optional needed only or? owned inventoryOS_PACKAGEINVOICE/OS_INVOICE/OS_LINECOST/OS_VASO--One element for every value-added service applied to this line, with attributes VASCODE and COST.? Optional if there were no VAS codes in the order request line.OS_PACKAGEINVOICE/OS_INVOICE/OS_LINECOST/OS_VAS@VASCODERSTR3VAS code values are defined in VASCODE section of the Order Request File definition.OS_PACKAGEINVOICE/OS_INVOICE/OS_LINECOST/OS_VAS@COSTODEC8.2Cost of value-added service for each item shipped.? Optional if the vendor uses an Order Invoice File to send costs.ASN(SSCC18 barcode) number format rule of creation:1.Walmart generated ASN number, the 20-digit ASN number is composed of the following:??3 digit leading zeros (example: 000)?7 digit distributor id (example UPS: 593830, if the distributor id is more than 7 digit then we divide it by 1000 and pad leading zeros)?9 digit sequence with a leading zero (example: 032000314)?1 digit check sum which is calculated using MOD 10 algorithm.2.Distributor generated ASN number; we only have IML at this time.???The first 10-digit of the ASN is 0000511873.???The next 10-digit is composed of their warehouse id (2-digit), followed by sequence number, and a check sum digit. ................
................

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

Google Online Preview   Download