Radial Integration | 2016

DropShip Manager > Order Feed

Order Feed

Retailer to Store Fulfillment/DropShip Manager

Column Description

# Tag Req Max Len Occurs Type Nest Level Parent Tag P E Description SFS ISPU STS DS PO TYPE
1 <ImportOrders> Yes 0 1/Doc Node 0 None Root tag indicating the beginning of an order import document. Y Y Y Y Y A
2 <AccountID> No* 2 1 String 1 <ImportOrders> N N **NO LONGER IN USE** Account code identifying the source of the data. Used only if multiple host sources are used. N N N N N NA
3 <Action> No 10 1 String 1 <ImportOrders> N N "SendOrders" or "SendMods" N N N Y Y D
4 <OrderInfo> Yes 0 1/Order Node 1 <ImportOrders> Tag indicating the beginning of an order. Y Y Y Y Y A
5 <OrderNumber> Yes 16/20 1 String 2 <OrderInfo> Y Y Customer Order # DropShip max length is 20. Store Fulfillment max length is 16. Y Y Y Y Y A
6 <HeaderInfo> Yes 0 1 Node 2 <OrderInfo> Tag indicating the beginning of header-level order information. Y Y Y Y Y A
7 <OrderType> Yes 8 1 String 3 <HeaderInfo> N N “DropShip” for Store Fulfillment or DropShip. "Stock" for StockPO. Y Y Y Y Y A
8 <VendorCode> Yes 10 1 String 3 <HeaderInfo> Y Y Code indicating the vendor account. Always “DEFAULT” for ship-from-store. Always “ISPU” for in-store pickup. Always receiving Store ID for ship-to-store. See AllocVendorCode for passing the designated store for in-store pickup orders. Y Y Y Y Y A
9 <OrderDate> Yes 25 1 String 3 <HeaderInfo> Y Y Order Entry Date and time with time zone off set. (i.e., 2013-11-14T15:15:52-05:00). Y Y Y Y Y A
10 <ExpShipDate> No 8 1 String 3 <HeaderInfo> Y Y Expected shipment date (yyyyMMdd). N N N Y Y D
11 <RequiredDate> No 8 1 String 3 <HeaderInfo> Y Y Required delivery date (yyyyMMdd). Y N N Y Y A
12 <CancelDate> No 8 1 Date 3 <HeaderInfo> Y Y "Cancel if not shipped by" date (yyyyMMdd). N N N Y Y D
13 <Terms> No 20 1 String 3 <HeaderInfo> Y Y Human readable terms. N N N Y Y D
14 <TermsDays> No 4 1 Num 3 <HeaderInfo> Y Y Terms days. N N N Y Y D
15 <TermsType> No 1 1 String 3 <HeaderInfo> Y Y Terms type. N N N Y Y D
16 <TermsPercent> No 6 1 Dec 3 <HeaderInfo> Y Y Terms percent.Maximum 2 decimal places. N N N Y Y D
17 <ShipMethCode> Yes 20 1 String 3 <HeaderInfo> Y Y Code representing the shipping method.Always “ISPU” for in-store pickup fulfillment.Always "STS" for ship-to-store fulfillment. Y Y Y Y Y A
18 <ShipMethod> No 35 1 String 3 <HeaderInfo> Y Y Ship Method Description. Y N N Y Y A
19 <ShipmentReason> No 4 1 String 3 <HeaderInfo> Y* Y Reason code associated with the shipment. N N N Y Y D
20 <SourceCode> No 16   String 3 <HeaderInfo> Y Y Offer or Catalog Code of the order. May be used as a pass through field to store header-level data for printed documents or host updates. N N N Y Y D
21 <CustomerPO> No 20 1 String 3 <HeaderInfo> Y Y End customer purchase order number. N N N Y Y D
22 <PH> No 12 1 Num 3 <HeaderInfo> Y Y Postage and handling charged to the end-customer for this portion of the order. Maximum 2 decimal places. Y Y Y Y Y A
23 <Tax> No 12 1 Num 3 <HeaderInfo> Y Y Tax charged to the end-customer for this portion of the order. Maximum 2 decimal places. Y Y Y Y Y A
24 <LotNumber> No 10 1 String 3 <HeaderInfo> Y Y Number or code representing the order processing picking lot of the order. May be used as a pass through field to store header-level data for printed documents or host updates. Y Y Y Y Y A
25 <JobNumber> No 16 1 String 3 <HeaderInfo> Y N Number or code representing the processing job that processed the order. May be used as a pass through field to store header-level data for printed documents or host updates. Y Y Y Y Y A
26 <CompanyCode> No 4 1 String 3 <HeaderInfo> Y Y Code associating the order to a company. Y Y Y Y Y A
27 <DivisionCode> No 4 1 String 3 <HeaderInfo> Y Y Code associating the order to a division within the company. Y Y Y Y Y A
28 <DeptCode> No 4 1 String 3 <HeaderInfo> Y Y Code associating the order to a department within the division. Y Y Y Y Y A
29 <EntryOperator> No 30 1 String 3 <HeaderInfo> Y Y DS: Name of the entry operator who placed the order. SF: Used for storing the customer facing order number. Y Y Y Y Y A
30 <ReasonCode> No 4 1 String 3 <HeaderInfo> Y Y Code representing why the order was placed. May be used as a pass through field to store any header-level data. N N N Y Y D
31 <Alias> No 30 1+ String 3 <HeaderInfo> N N Secondary/cross-reference order number. Y Y Y Y Y A
32 <InvoiceType> No 1 1 String 3 <HeaderInfo> N Y   N N N Y Y D
33 <BeginningStatus> No* 2 1 Num 3 <HeaderInfo> N N Default – nothing passed uses vendor’s default order flow. “00” = Printing “08” = Staging "09" = Vendor Acknowledge *Must use "08" for STS orders. N N Y Y Y A
34 <PriceCountryCode> No 8 1 String 3 <HeaderInfo> N N Country code to be used for prices. Y Y Y Y Y A
35 <CostCountryCode> No 8 1 String 3 <HeaderInfo> N N Country code to be used for costs. N N N Y Y D
36 <QtyCountryCode> No 8 1 String 3 <HeaderInfo> N N Country code to be used for quantity number formatting. Y Y Y Y Y A
37 <PackCountryCode> No 8 1 String 3 <HeaderInfo> N N Country code to be used for pack slip formatting. Y Y Y Y Y A
38 <WebOrderNumber> No* 40 1 String 3 <HeaderInfo> Y N Web order number against which inventory was reserved for an in-store pickup order. This is the same number passed to the ReserveInventory function of the Inventory Web Service by the web store at customer checkout. N Y N N N S
39 <AllocVendorCode> No* 10 1 String 3 <HeaderInfo> N N Required for ISPU.The designated store identifier for an in-store pickup order. N Y N N N S
40 <PackSlipData> No Large 1 Text 3 <HeaderInfo>     User-defined data available for inclusion on the packing slip. Y Y Y Y Y A
41 <StartPickDate> No 8 1 String 3 <HeaderInfo> N N Date by which picking should begin based on SLA (yyyyMMdd) for in-store pickup fulfillment. N Y N N N S
42 <StartPickTime> No 6 1 String 3 <HeaderInfo> N N Time by which picking should begin based on SLA (HHmmss) for in-store pickup fulfillment. N Y N N N S
43 <PickConfirmDate> No 8 1 String 3 <HeaderInfo> N N Date by which picking should be complete based on SLA (yyyyMMdd) for in-store pickup fulfillment. N Y N N N S
44 <PickConfirmTime> No 6 1 String 3 <HeaderInfo> N N Time by which picking should be complete based on SLA (HHmmss) for in-store pickup fulfillment. N Y N N N S
45 <PickupDate> No 8 1 String 3 <HeaderInfo> N N Date by which the order should be picked up by the customer (yyyyMMdd) for in-store pickup fulfillment. N Y Y N N S
46 <PickupTime> No 6 1 String 3 <HeaderInfo> N N Time by which the order should be picked up by the customer (HHmmss) for in-store pickup fulfillment. N Y Y N N S
47 <EventID> No 10 1 String 3 <HeaderInfo> N N For In Store Pick Up Orders always send "ISPU". N Y Y N N S
48 <CoDivDept> No 12 1 String 3 <HeaderInfo> Y Y Company, Division and Department for the order Y Y Y Y Y A
49 <ContactInfo> Yes 0 1+ Node 3 <HeaderInfo> Tag indicating the beginning of order contact information. Y Y Y Y Y A
50 <ContactType> Yes 7 1 String 4 <ContactInfo> N N “BillTo” (required), or “ShipTo”, or “Buyer”,or “OrderTo”. ShipTo address for in-store pickup orders must be the recipient / fulfilling store address. Y Y Y Y Y A
51 <ContactID> No 12 1 String 4 <ContactInfo> Y Y Number or string uniquely identifying the BillTo or ShipTo address. Should always be passed Blank. N N N N N NA
52 <CompanyName> Yes* 100 1 String 4 <ContactInfo> Y Y Not required if <FirstName> or <LastName> is provided. Y Y Y Y Y A
53 <TitleInfo> No 0 1+ Node 4 <ContactInfo> Tag indicating the beginning of contact title information. Y Y Y Y Y A
54 <TitleType> Yes 6 1 String 5 <TitleInfo> N N “Prefix” or “Suffix” Y Y Y Y Y A
55 <TitleCode> Yes 2 1 String 5 <TitleInfo> N N Code identifying the title. Y Y Y Y Y A
56 <Title> Yes 16 1 String 5 <TitleInfo> Y N   Y Y Y Y Y A
57 </TitleInfo> No 0 1 Node 4 <ContactInfo> Tag indicating the end of contact title information. Y Y Y Y Y A
58 <FirstName> Yes* 50 1 String 4 <ContactInfo> Y Y Not required if <LastName> or <CompanyName> is provided. Y Y Y Y Y A
59 <MiddleInitial> No 1 1 String 4 <ContactInfo> Y Y   Y Y Y Y Y A
60 <LastName> Yes* 50 1 String 4 <ContactInfo> Y Y Not required if <FirstName> or <CompanyName> is provided. Y Y Y Y Y A
61 <PhoneNumber1> No* 16 1 Num 4 <ContactInfo> Y Y Some shipping carriers require Ship To phone number. Y Y Y Y Y A
62 <PhoneNumber2> No* 16 1 Num 4 <ContactInfo> N Y Some shipping carriers require Ship To phone number. Y Y Y Y Y A
63 <PhoneNumber3> No* 16 1 Num 4 <ContactInfo> N Y Some shipping carriers require Ship To phone number. Y Y Y Y Y A
64 <EmailAddress> No 200 1 String 4 <ContactInfo> Y Y   Y Y Y Y Y A
65 <AddressInfo> Yes 0 1 Node 4 <ContactInfo> Tag indicating the beginning of contact address information. Y Y Y Y Y A
66 <Street> Yes 100 1 String 5 <AddressInfo> Y Y   Y Y Y Y Y A
67 <Address1> No 100 1 String 5 <AddressInfo> Y Y Additional address information (e.g. PO Box or apartment number). Y Y Y Y Y A
68 <Address2> No 50 1 String 5 <AddressInfo> Y Y Additional address information (e.g. PO Box, or apartment number). Y Y Y Y Y A
69 <City> Yes 50 1 String 5 <AddressInfo> Y Y   Y Y Y Y Y A
70 <State> Yes* 2 1 String 5 <AddressInfo> Y Y Required for addresses with States or Provinces Y Y Y Y Y A
71 <PostalCode> Yes* 16 1 String 5 <AddressInfo> Y Y Required for carrier integration within USA/Canada. Y Y Y Y Y A
72 <CountryCode> Yes* 8 1 String 5 <AddressInfo> Y Y Required to format contact address and phone numbers. Y Y Y Y Y A
73 <Country> No 30 1 String 5 <AddressInfo> Y Y   Y Y Y Y Y A
74 <AddressType> No 11 1 String 5 <AddressInfo> Y Y “Residential” or “Commercial” Y Y Y Y Y A
75 <GiftRecipient> No 3 1 String 5 <AddressInfo> N N “Yes” or “No” Y Y Y Y Y A
76 </AddressInfo> Yes 0 1 Node 4 <ContactInfo> Tag indicating the end of contact address information. Y Y Y Y Y A
77 </ContactInfo> Yes 0 1+ Node 3 <HeaderInfo> Tag indicating the end of order contact information. Y Y Y Y Y A
78 <CommentInfo> No 0 1+ Node 3 <HeaderInfo> Tag indicating the beginning of order comment information. Y Y Y Y Y A
79 <CommentType> No 1 1 String 4 <CommentInfo> N Y Default - Online comments to vendor. Packing Slip Comments: X – Gift Comments 0 – Shipping Label Comments 1 – Special Handling Instructions 2 – Guarantee/Warranty Comments 3–9 – User Defined Packing Slip Comments Y Y Y Y Y A
80 <CommentText> Yes unlimited 1+ String 4 <CommentInfo> Y Y Remove unwanted line feed characters. Y Y Y Y Y A
81 </CommentInfo> No 0 1+ Node 3 <HeaderInfo>   Y Y Y Y Y A
82 <CreditCardInfo> No 0 1+ Node 3 <HeaderInfo>   N N N Y Y D
83 <Type> No 2 1 String 4 <CreditCardInfo> Y Y Code identifying the type of the credit card (e.g. VI = Visa, MC = Mastercard). N N N Y Y D
84 <Description> No 100 1 String 4 <CreditCardInfo> N Y Description of the credit card. N N N Y Y D
85 <Number> Yes 20 1 String 4 <CreditCardInfo> Y Y Credit card number. N N N Y Y D
86 <ExpirationDate> No 4 1 String 4 <CreditCardInfo> Y Y Credit card expiration date (MMYY). N N N Y Y D
87 <ID> No 4 1 String 4 <CreditCardInfo> Y Y Credit Card ID (CCID) or Card Security Code (CSC). N N N Y Y D
88 <AuthCode> No 10 1 String 4 <CreditCardInfo> N Y   N N N Y Y D
89 </CreditCardInfo> No 0 1 Node 3 <HeaderInfo>   N N N Y Y D
90 <ShipmentInfo> No 0 1+ Node 3 <HeaderInfo> Package added to the order that is being imported N N Y N N S
91 <ShipmentMethod> No 20 1 String 4 <ShipmentInfo> N N Ship Method for the package N N Y N N S
92 <TrackingNumber> No 30 1 String 4 <ShipmentInfo> N N Tracking number for the package N N Y N N S
93 <Carrier> No 4 1 String 4 <ShipmentInfo> N N Carrier code for the package N N Y N N S
94 <TrackingUrl> No 100 1 String 4 <ShipmentInfo> N N Tracking so the package tracking can be viewed N N Y N N S
95 </ShipmentInfo> No 0 1 Node 3 <HeaderInfo>   N N Y N N S
96 </HeaderInfo> Yes 0 1 Node 2 <OrderInfo> Tag indicating the end of header-level order information. Y Y Y Y Y A
97 <LineItemInfo> Yes 0 1+ Node 2 <OrderInfo> Tag indicating the beginning of detail-level order information. Y Y Y Y Y A
98 <LineNumber> Yes 9 1 Num 3 <LineItemInfo> Y Y   Y Y Y Y Y A
99 <SKU> Yes 30 1 String 3 <LineItemInfo> Y Y Advertised SKU number. Y Y Y Y Y A
100 <ExternalID> No 10 1 Num 3 <LineItemInfo> N N Internal host SKU identifier. Y Y Y Y Y A
101 <CoDivSKU> No 30 1 String 3 <LineItemInfo> Y* Y* Alternate SKU number. N N N Y Y D
102 <OfferSKU> No 30 1 String 3 <LineItemInfo> Y* Y* Alternate SKU number. N N N Y Y D
103 <VendorSKU> No 30 1 String 3 <LineItemInfo> Y Y Vendor SKU number. N N N Y Y D
104 <Description> No 100 1 String 3 <LineItemInfo> Y Y Advertised SKU description. N N N Y Y D
105 <VendorDesc> No 100 1 String 3 <LineItemInfo> Y Y Vendor SKU Description. N N N Y Y D
106 <UPCCode> No 14 1 Num 3 <LineItemInfo> N Y Valid values are: 8 digits (EAN/UCC-8) 12 digits (UPC/UCC-12) 13 digits (EAN/UCC-13) 14 digits (GTIN/UCC-14) N N N Y Y D
107 <LineCrossRef> No 10 1 Num 3 <LineItemInfo> N N Cross-reference to the line item. N N N Y Y D
108 <Quantity > Yes 14 1 Num 3 <LineItemInfo> Y Y Maximum 4 decimal places. Y Y Y Y Y A
109 <ShippedQuantity> No 14 1 Num 3 <LineItemInfo> Y Y Maximum 4 decimal places. N N N Y Y D
110 <CancelledQuantity > No 14 1 Num 3 <LineItemInfo> Y Y Maximum 4 decimal places. N N N Y Y D
111 <WarehouseQuantity> No 14 1 Num 3 <LineItemInfo> N N Maximum 4 decimal places. Used for Order Redirect: If warehouse can ship complete then must equal quantity ordered. If warehouse cannot ship complete then must be zero. Y N N N N S
112 <ExtendedCost> Yes* 14 1 Num 3 <LineItemInfo> Y Y Maximum 4 decimal places. Not required if <UnitCost> is provided. N N N Y Y D
113 <UnitCost> Yes* 14 1 Num 3 <LineItemInfo> Y Y Maximum 4 decimal places. Not required if <ExtendedCost> is provided. N N N Y Y D
114 <ExtendedPrice> No 14 1 Num 3 <LineItemInfo> Y Y Maximum 4 decimal places. N N N Y Y D
115 <UnitPrice> No 14 1 Num 3 <LineItemInfo> Y Y Maximum 4 decimal places. Y Y Y Y Y A
116 <UnitWeight> No 12 1 Num 3 <LineItemInfo> Y Y Maximum 6 decimal places. N N N Y Y D
117 <DryIceWeight> No 12 1 Num 3 <LineItemInfo> Y N Maximum 6 decimal places. N N N Y Y D
118 <Freight> No 14 1 Num 3 <LineItemInfo> N N Maximum 4 decimal places. N N N Y Y D
119 <Handling> No 14 1 Num 3 <LineItemInfo> N N Maximum 4 decimal places. N N N Y Y D
120 <LabelCount> No 12 1 Num 2 <LineItemInfo> N N Number of product labels per item. N N N N Y P
121 <CaseQuantity> No 14 1 Num 3 <LineItemInfo> N N Number of units per case.Maximum 4 decimal places. N N N N Y P
122 <LeadDays> No 4 1 Num 3 <LineItemInfo> N N Vendor’s lead days for the item. N N N Y Y D
123 <SerialNoReq> No 8 1 String 3 <LineItemInfo> N N “Yes”, “No”, or “Optional”. Y Y N Y Y A
124 <ShipAloneQty> No 14 1 Num 3 <LineItemInfo> N N Quantity of the product to include in a single shipment when assigning shipments during order import. Maximum 4 decimal places. N N N Y Y D
125 <ItemType> No 1 1 String 3 <LineItemInfo> Y Y “G” = Group Header “S” = Service (Labor Cost) “I” = Insert Product Not provided for regular products. N N N Y Y D
126 <ItemStatus> No 8 1 String 3 <LineItemInfo> N N “C” – Line item is cancelled. N N N Y Y D
127 <AssociatedLine> No 9 1 Num 3 <LineItemInfo> N N Line to which this line is associated. N N N Y Y D
128 <ExpShipDate> No 8 1 String 3 <LineItemInfo> Y Y Line-level expected shipment date (yyyyMMdd). N N N Y Y D
129 <RequiredDate> No 8 1 String 3 <LineItemInfo> Y Y Line-level required delivery date (yyyyMMdd). N N N Y Y D
130 <UOM> No 4 1 String 3 <LineItemInfo> Y Y Unit of measure (e.g. “EACH”, “DOZN”). N N N Y Y D
131 <Factor> No 14 1 Num 3 <LineItemInfo> Y Y Number of units received for each unit ordered.Maximum 4 decimal places. N N N Y Y D
132 <EncodeData> No 50 1 String 3 <LineItemInfo> Y* N Additional product data that can be included on printed documents and encoded within barcodes. N N N Y Y D
133 <Shared> No 3 1 String 3 <LineItemInfo> N N Always “Yes” for Store Fulfillment. "No" if DropShip or StockPO. N N N Y Y D
134 <StyleInfo> No 0 1 Node 3 <LineItemInfo> Tag indicating the beginning of line style information.Required if passing style information. N N N Y Y D
135 <Name> Yes 20 1 String 4 <StyleInfo> Y Y Internal host Style identifier. N N N Y Y D
136 <Description> Yes 100 1 String 4 <StyleInfo> Y Y Style description. N N N Y Y D
137 <StyleLevel> Yes 0 1 Node 4 <StyleInfo> Tag indicating the beginning of line style level information. N N N Y Y D
138 <Number> No 2 1 Num 5 <StyleLevel> N N “1” – “4”, indicating the style level N N N Y Y D
139 <Name> Yes 20 1 String 5 <StyleLevel> N Y Level style name (ex: Size, Color, etc.) N N N Y Y D
140 <SKU> Yes 10 1 String 5 <StyleLevel> Y Y Level style value (ex: XS, S, M, L, XL) N N N Y Y D
141 <Description> Yes 20 1 String 5 <StyleLevel> N Y Description of style values (ex: Extra Small, etc.) N N N Y Y D
142 <Sort> No 8 1 Num 5 <StyleLevel> N Y Level style sort (for sorting of levels on screen) N N N Y Y D
143 </StyleLevel> Yes 0 1 Node 4 <StyleInfo> Tag indicating the end of line style level information. N N N Y Y D
144 </StyleInfo> No 0 1 Node 3 <LineItemInfo> Tag indicating the end of line style information. N N N Y Y D
145 <HostDescriptionInfo> No 0 1+ Node 3 <LineItemInfo> Tag indicating the beginning of secondary language host description information. N N N Y Y D
146 <LanguageCode> Yes 10 1 String 4 <HostDescriptionInfo> N N Language code of the description (ex. En, Fr) N N N Y Y D
147 <Description> Yes 100 1 String 4 <HostDescriptionInfo> Y Y Product description text. N N N Y Y D
148 </HostDescriptionInfo> No 0 1+ Node 3 <LineItemInfo> Tag indicating the end of secondary language host description information. N N N Y Y D
149 <VendorDescriptionInfo> No 0 1+ Node 3 <LineItemInfo> Tag indicating the beginning of secondary language vendor description information. N N N Y Y D
150 <LanguageCode> Yes 10 1 String 4 <VendorDescriptionInfo> N N Language code of the secondary description (ex. En, Fr) N N N Y Y D
151 <Description> Yes 100 1 String 4 <VendorDescriptionInfo> Y Y Product description text. N N N Y Y D
152 </VendorDescriptionInfo> No 0 1+ Node 3 <LineItemInfo> Tag indicating the end of secondary language vendor description information. N N N Y Y D
153 <CommentInfo> No 0 1 Node 3 <LineItemInfo> Tag indicating the beginning of line comment information. Y Y Y Y Y A
154 <CommentType> No 1 1 String 4 <CommentInfo> N Y Default – Item level online comments to vendor. Packing Slip Comments: X – Gift Comments 0 – 9 Upsell Comments Y Y Y Y Y A
155 <CommentText> Yes 80 1+ String 4 <CommentInfo> Y Y   Y Y Y Y Y A
156 </CommentInfo> No 0 1 Node 3 <LineItemInfo> Tag indicating the end of line comment information. Y Y Y Y Y A
157 <CustomInfo> No 0 1+ Node 3 <LineItemInfo> Tag indicating the beginning of line customization information. Y Y Y Y Y A
158 <Prompt> Yes 50 1 String 4 <CustomInfo> Y Y Prompt or description of the customization. Y Y Y Y Y A
159 <CustomText> Yes 100 1 String 4 <CustomInfo> Y Y Customization value. Y Y Y Y Y A
160 <Sequence> No 10 1 Num 4 <CustomInfo> N N Sort order. Y Y Y Y Y A
161 </CustomInfo> No 0 1+ Node 3 <LineItemInfo> Tag indicating the end of line customization information. Y Y Y Y Y A
162 </LineItemInfo> Yes 0 1+ Node 2 <OrderInfo> Tag indicating the end of detail-level order information Y Y Y Y Y A
163 </OrderInfo> Yes 0 1/Order Node 1 <ImportOrders> Tag indicating the end of an order. Y Y Y Y Y A
164 </ImportOrders> Yes 0 1/Doc Node 0 None Tag indicating the end of an order import document. Y Y Y Y Y A

 

Copyright © 2017 Radial. All rights reserved.