Radial Integration | 2016

DropShip Manager > Shipments Feed

Shipments Feed

Store Fulfillment/DropShip Manager to Retailer

Column Description

# Tag Req Max Len Occurs Type Nest Level Parent Tag Description SFS ISPU STS DS PO TYPE
1 <ShipmentUpdate> Yes 0 1 Node 0 None Root tag indicating the beginning of a shipment export document. Y Y Y Y Y A
2 <AccountID> No* 2 1 String 1 <ShipmentUpdate> Account code identifying the source of the data. *Provided only if multiple host sources are used. N N N N N NA
3 <OrderShipment> Yes 0 1 Node 1 <ShipmentUpdate> Tag indicating the beginning of a shipment. Y Y Y Y Y A
4 <ShipmentType> No 12 1 String 2 <OrderShipment> “Assignment” – For ISPU/STS orders, this transaction tag represents the order is pick confirmed/received and is ready for pick-up. “Confirmation” – For SFS orders, this transaction tag represents the order is shipped. "Shipment" – For SFS orders, this transaction tag represents the possession scan has been received from the carrier. For ISPU and STS orders, this transaction tag represents the order has been picked up by the customer. Y Y Y Y N A
5 <VendorInfo> Yes 0 1 Node 2 <OrderShipment>   Y Y Y Y Y A
6 <VendorNumber> Yes 10 1 String 3 <VendorInfo> Code representing the fulfillment location of the order. Y Y Y Y Y A
7 <VendorName> No 50 1 String 3 <VendorInfo> Vendor or Store Name Y Y Y Y Y A
8 <Address1> No 100 1 String 3 <VendorInfo> Vendor or Store address info specified in Store Fulfillment/DropShip Manager Y Y Y Y Y A
9 <Address2> No 50 1 String 3 <VendorInfo> Vendor or Store address info specified in Store Fulfillment/DropShip Manager Y Y Y Y Y A
10 <Street> No 100 1 String 3 <VendorInfo> Vendor or Store address info specified in Store Fulfillment/DropShip Manager Y Y Y Y Y A
11 <City> No 50 1 String 3 <VendorInfo> Vendor or Store address info specified in Store Fulfillment/DropShip Manager Y Y Y Y Y A
12 <State> No 2 1 String 3 <VendorInfo> Vendor or Store address info specified in Store Fulfillment/DropShip Manager Y Y Y Y Y A
13 <PostalCode> No 16 1 String 3 <VendorInfo> Vendor or Store address info specified in Store Fulfillment/DropShip Manager Y Y Y Y Y A
14 <CountryCode> No 8 1 String 3 <VendorInfo> Vendor or Store address info specified in Store Fulfillment/DropShip Manager Y Y Y Y Y A
15 <Country> No 50 1 String 3 <VendorInfo> Vendor or Store address info specified in Store Fulfillment/DropShip Manager Y Y Y Y Y A
16 </VendorInfo> Yes 0 1 Node 2 <OrderShipment>   Y Y Y Y Y A
17 <OrderNumber> Yes 20 1 String 2 <OrderShipment> The original OMS order number plus any suffix added in Store Fulfillment/DropShip Manager for split orders Y Y Y Y Y A
18 <HostOrderNumber> Yes 20 1 String 2 <OrderShipment> The original OMS order number. Y Y Y Y Y A
19 <OrderType> Yes 8 1 String 2 <OrderShipment> “DropShip” for Store Fulfillment or DropShip. "Stock" for StockPO. Y Y Y Y Y A
20 <Company> No 4 1 String 2 <OrderShipment> Code associating the order to a company. Y Y Y Y Y A
21 <Division> No 4 1 String 2 <OrderShipment> Code associating the order to a division within the company. Y Y Y Y Y A
22 <Department> No 4 1 String 2 <OrderShipment> Code associating the order to a department within the division. Y Y Y Y Y A
23 <CartonCount> No 10 1 Num 2 <OrderShipment> Number of cartons associated with this shipment. N N N N Y P
24 <ShipAllProducts> Yes 3 1 String 2 <OrderShipment> “Yes” or “No” indicating whether or not all products on the order are being shipped.Ignore this tag for Store Fulfillment as this flag represents only the portion of an order assigned to a single store. This would not represent the complete order if an order is split across stores. Y Y Y Y Y A
25 <CustomerPO> No 20 1 String 2 <OrderShipment> End customer purchase order number. Y Y Y Y Y A
26 <LotNumber> No 10 1 String 2 <OrderShipment> 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
27 <JobNumber> No 16 1 String 2 <OrderShipment> 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
28 <EntryOperator> No 30 1 String 2 <OrderShipment> Name of the entry operator who placed the order. May be used as a pass through field to store header-level data for printed or host update documents. Y Y Y Y Y A
29 <SourceCode> No 16 1 String 2 <OrderShipment> 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. Y Y Y Y Y A
30 <GroupNumber> No 9 1 Num 2 <OrderShipment> A number that uniquely identifies a shipment on an order. Y Y Y Y Y A
31 <ShipmentInfo> Yes 0 1+ Node 2 <OrderShipment> Node containing shipment information. Y Y Y Y Y A
32 <CommentInfo> No 0 1+ Node 3 <ShipmentInfo> Node containing Shipment Comment information. N N N Y Y D
33 <CommentType> No 1 1 String 4 <CommentInfo>   N N N Y Y D
34 <CommentText> No 80 1+ String 4 <CommentInfo>   N N N Y Y D
35 </CommentInfo> No 0 1 Node 3 <ShipmentInfo> End of node containing shipment information. N N N Y Y D
36 <TrackingNumber> No 30 1 String 3 <ShipmentInfo>   Y Y Y Y Y A
37 <TrackingNumber2> No 30 1 String 3 <ShipmentInfo> USPS Tracking# when using UPS SurePost (v45) Y Y Y Y Y A
38 <Freight> No 12 1 Num 3 <ShipmentInfo> Maximum 2 decimal places. Y Y Y Y Y A
39 <Weight> No 12 1 Num 3 <ShipmentInfo> Reserved for future use. Maximum 6 decimal places. Y Y Y Y Y A
40 <ShipmentDate> Yes 8 1 String 3 <ShipmentInfo> Shipment date (yyyyMMdd). Y Y Y Y Y A
41 <ShipmentTime> Yes 6 1 String 3 <ShipmentInfo> Shipment time (HHmmss). Y Y Y Y Y A
42 <ShipmentMethod> Yes 20 1 String 3 <ShipmentInfo> Code representing the method of shipment.Always “ISPU” for in-store pickup fulfillment. Y Y Y Y Y A
43 <ShipmentMethodDescription> Yes 35 1 String 3 <ShipmentInfo> Description of the method of shipment. Y Y Y Y Y A
44 <ShipmentReason> No 4 1 String 3 <ShipmentInfo> Reason code associated with the shipment. N N N Y Y D
45 <DestinationPostalCode> No 16 1 String 3 <ShipmentInfo>   Y Y Y Y Y A
46 <Alias> No 30 1 String 3 <ShipmentInfo> Shipment Alias; unique value created per order shipment. Y Y Y Y Y A
47 <ConsignmentCode> No 500 1 String 3 <ShipmentInfo> Consignment Code print data. Y Y Y Y Y A
48 <CarrierServiceName> No 500 1 String 3 <ShipmentInfo> Consignment Name print data. Y Y Y Y Y A
49 <CarrierCode> No 500 1 String 3 <ShipmentInfo> Code print data or Shipment carrier code. Y Y Y Y Y A
50 <CarrierName> No 500 1 String 3 <ShipmentInfo> Name print data. Y Y Y Y Y A
51 <CarrierServiceCode> No 500 1 String 3 <ShipmentInfo> Service Code print data. Y Y Y Y Y A
52 <TrackingUrl> No 500 1 String 3 <ShipmentInfo> URL print data. Y Y Y Y Y A
53 </ShipmentInfo> Yes 0 1+ Node 2 <OrderShipment> Tag indicating the end of the ShipmentInfo node. Y Y Y Y Y A
54 <InvoiceInfo> Yes 0 1 Node 2 <Invoice>   N N N Y Y D
55 <InvoiceNumber> Yes 10 1 String 3 <InvoiceInfo>   N N N Y Y D
56 <InvoiceDate> Yes 8 1 String 3 <InvoiceInfo> Invoice date (yyyyMMdd). N N N Y Y D
57 <InvoiceTime> Yes 6 1 String 3 <InvoiceInfo> Invoice time (HHmmss). N N N Y Y D
58 <InvoiceTotal> Yes 12 1 String 3 <InvoiceInfo> Maximum 2 decimal places. N N N Y Y D
59 <ProductTotal> Yes 12 1 String 3 <InvoiceInfo> Maximum 2 decimal places. N N N Y Y D
60 <Terms> No 20 1 String 3 <InvoiceInfo> Human readable terms on the purchase order. N N N Y Y D
61 <TermsDays> No 4 1 Num 3 <InvoiceInfo>   N N N Y Y D
62 <TermsPercent> No 6 1 Num 3 <InvoiceInfo> Maximum 2 decimal places. N N N Y Y D
63 <FreightAmount> No 12 1 Num 3 <InvoiceInfo> Maximum 2 decimal places. N N N Y Y D
64 <HandlingFee> No 12 1 Num 3 <InvoiceInfo> Maximum 2 decimal places. N N N Y Y D
65 <TaxAmount> No 12 1 Num 3 <InvoiceInfo> Maximum 2 decimal places. N N N Y Y D
66 <DutyAmount> No 12 1 Num 3 <InvoiceInfo> Maximum 2 decimal places. N N N Y Y D
67 <OtherCost> No 12 1 Num 3 <InvoiceInfo> Maximum 2 decimal places. N N N Y Y D
68 </InvoiceInfo> Yes 0 1 Node 2 <OrderShipment>   N N N Y Y D
69 <ProductInfo> No 0 1+ Node 2 <OrderShipment> Node containing product information for the shipment. Y Y Y Y Y A
70 <LineNumber> Yes 9 1 Num 3 <ProductInfo>   Y Y Y Y Y A
71 <SKU> Yes 30 1 String 3 <ProductInfo> Advertised SKU number. Y Y Y Y Y A
72 <VendorSKU> No 30 1 String 3 <ProductInfo> Vendor SKU number. Y Y Y Y Y A
73 <ExternalID> No 10 1 String 3 <ProductInfo> Internal host SKU identifier. Y Y Y Y Y A
74 <CoDivSKU> No 30 1 String 3 <ProductInfo> Alternate SKU number. Y Y Y Y Y A
75 <OfferSKU> No 30 1 String 3 <ProductInfo> Alternate SKU number. Y Y Y Y Y A
76 <UPCCode> No 14 1 Num 3 <ProductInfo> UPC, EAN, or GTIN. Y Y Y Y Y A
77 <OrderedQuantity> Yes 14 1 Num 3 <ProductInfo> Total line item order quantity.Maximum 6 decimal places.Ignore for Store Fulfillment as this quantity represents only the portion of an order assigned to a single store. This would not represent the total quantity if a line item is split across stores. Y Y Y Y Y A
78 <ShippedQuantity> Yes 14 1 Num 3 <ProductInfo> Depending on ShipmentType, picked or shipped/picked-up quantity for this line item.Maximum 6 decimal places. Y Y Y Y Y A
79 <UOM> No 4 1 String 3 <ProductInfo> Code representing the unit of measure. N N N Y Y D
80 <Factor> No 14 1 Num 3 <ProductInfo> UOM Factor.Maximum 4 decimal places. Y Y Y Y Y A
81 <LineCrossReference> No 10 1 Num 3 <ProductInfo> Cross-reference to the line item. Y Y Y Y Y A
82 <SerialInfo> No 0 1 Node 3 <ProductInfo> Tag indicating the beginning of line serial information. Y Y Y Y Y A
83 <SerialNumber> No 20 1+ String 4 <SerialInfo> Serial Number Captured at Shipping or Order/Pack Check. Y Y Y Y Y A
84 </SerialInfo> No 0 1 Node 3 <ProductInfo> Tag indicating the end of line serial information. Y Y Y Y Y A
85 <CustomInfo> No 0 1+ Node 3 <ProductInfo> Tag indicating the beginning of line customization information. N N N Y Y D
86 <Prompt> No 50 1 String 4 <CustomInfo> Prompt or description of the customization. N N N Y Y D
87 <CustomText> Yes 100 1 String 4 <CustomInfo> Customization value. N N N Y Y D
88 </CustomInfo> No 0 1+ Node 3 <ProductInfo> Tag indicating the end of line customization information. N N N Y Y D
89 <InvoicedQuantity> No 14 1 String 3 <ProductInfo> Maximum 4 decimal places. N N N Y Y D
90 <ExtendedCost> No 14 1 String 3 <ProductInfo> Maximum 4 decimal places. N N N Y Y D
91 <UnitCost> No 14 1 String 3 <ProductInfo> Maximum 4 decimal places. N N N Y Y D
92 <StandardFreight> No 14 1 String 3 <ProductInfo> Maximum 4 decimal places. N N N Y Y D
93 <ItemType> No 14 1 String 3 <ProductInfo> “G” = Group Header “S” = Service (Labor Cost) “I” = Insert Product Not provided for regular products. N N N Y Y D
94 </ProductInfo> Yes 0 1 Node 2 <OrderShipment> Tag indicating the end of the ProductInformation node. Y Y Y Y Y A
95 <CaseInfo> No 0   Node 2 <OrderShipment> Node containing case information for the shipment. N N N N Y P
96 <SSCCNumber> Yes 20   String 4 <CaseInfo> SSCC (carton) number. N N N N Y P
97 <ProductInfo> No 0   Node 3 <CaseInfo> Node containing product information for the shipment. N N N N Y P
98 <LineNumber> Yes 9   Num 4 <ProductInfo>   N N N N Y P
99 <SKU> Yes 30   String 4 <ProductInfo> Advertised SKU number. N N N N Y P
100 <VendorSKU> No 30   String 4 <ProductInfo> Vendor SKU number. N N N N Y P
101 <ExternalID> No 10   String 4 <ProductInfo> Internal host SKU identifier. N N N N Y P
102 <CoDivSKU> No 30   String 4 <ProductInfo> Alternate SKU number. N N N N Y P
103 <OfferSKU> No 30   String 4 <ProductInfo> Alternate SKU number. N N N N Y P
104 <UPCCode> No 14   Num 4 <ProductInfo> UPC or GTIN. N N N N Y P
105 <CaseQuantity> Yes 14   Num 4 <ProductInfo> Quantity shipped in the case. Maximum 4 decimal places. N N N N Y P
106 <UOM> No 4   String 4 <ProductInfo> Code representing the unit of measure. N N N N Y P
107 <Factor> No 14   Num 4 <ProductInfo> UOM Factor.Maximum 4 decimal places. N N N N Y P
108 <LineCrossReference> No 10   Num 4 <ProductInfo> Cross-reference to the line item. N N N N Y P
109 <SerialInfo> No 0   Node 4 <ProductInfo> Tag indicating the beginning of case serial information. N N N N Y P
110 <SerialNumber> No 20   String 5 <SerialInfo> Serial Number Captured at Shipping or Order/Pack Check. N N N N Y P
111 </SerialInfo> No 0   Node 4 <ProductInfo> Tag indicating the end of case serial information. N N N N Y P
112 </ProductInfo> Yes 0   Node 3 <CaseInfo> Tag indicating the end of the ProductInformation node. N N N N Y P
113 </CaseInfo> Yes 0   Node 2 <OrderShipment> Tag indicating the end of the CaseInformation node. N N N N Y P
114 </OrderShipment> Yes 0 1 Node 1 <ShipmentUpdate> Tag indicating the end of the OrderShipment node. Y Y Y Y Y A
115 </ShipmentUpdate > Yes 0 1 Node 0 None Tag indicating the end of the shipment export document. Y Y Y Y Y A

 

Copyright © 2017 Radial. All rights reserved.