Radial JDA-Based Order Management Help

Shipped Orders (POS)

Overview

The Shipped Orders (POS) feed provides the partner with shipped order information, returns and price adjustments. These include orders shipped from Radial, third-party, or partner warehouse. It also includes multi-channel fulfilled orders (SFS, STS, ISPU, dropship).

Feed Characteristics

Characteristics	Value
Exchange Frequency	Daily
Timing	TBD
Sender/Receiver	Radial sends to the client
File Name	StoreCode_POS_yyyymmddhhmmss.XML
File Format	XML

Feed Attributes

Header
ID	Field	Description	Type	Length	Req.	Comments
ID	Field	Description	Type	Length	Req.	Comments
1	Radial Store Code	Clients Store Number	String	10	Yes	Radial assigned store code
2	Invoice Type	Order Transaction Type	String	15	Yes	Values: SHIPMENT = Sales Order (including re-ships) RETURN = Return CREDIT_MEMO = Price Adjustment
3	Order Number	JDA - Order Number.	Integer	11,0	Yes
4	Order Sequence Number	JDA – Order Shipment Sequence	Integer	3,0	Yes	Shipping sequence number is a sequential number for each shipment on the order
5	Web Order Number	Web Store Order Number	String	30	No	Will be equal to the JDA order number for Phone-in orders.
6	VAT Invoice	VAT Invoice for EU Stores	String	30	No
7	Order Date/Time		String	29	Yes	UTC Format e.g. 2017-01-10T20:43:22.078Z
8	Ship Date/Time		String	29	Yes	UTC Format e.g. 2017-01-10T20:43:22.078Z
9	Fulfilment Location	Shipping warehouse
10	Order Retail Amount	Total gross merchandise amount	Float	15.2	Yes	Total order amount of order (not shipment)
11	Shipped Retail Amount	Shipped Merchandise Amt	Float	15.2	Yes
12	Order Freight Amount	Freight Amt (charged to guest) For multiple shipments, freight will be charged on first shipment.	Float	15.2	Yes
13	Order Tax Amount	Total Tax. For multiple shipments tax on freight will be charged on first shipment.	Float	15.2	Yes
14	Special Service Amount	Special Service Charge (gift wrap, monogramming)	Float	15.2	Yes	Some charges will be accounted for in this field and included in the tender amount but NOT included in the detail record.
15	Shipping Cost	Cost of shipping	Float	15.2	No
16	Freight Tax Rate	Tax Rate on the freight charges only	Float	5.5	Yes
17	Bill To Customer No	Bill to Customer Number	Integer	12,0	No
18	Bill To Email	Bill to Email Address	String	50	No
19	Bill To Cust	Bill to Customer Name	String	60	No
20	Bill To Addr1	Bill to Address	String	50	No
21	Bill To Addr2	Bill to Address	String	50	No
22	Bill To Addr3	Bill to Address	String	50	No
23	Bill To City	Bill to City	String	30	No
24	Bill To State	Bill to State	String	10	No
25	Bill To Postal Code	Bill to Zip/Postal Code	String	20	No
26	Bill-To Country	Bill to Country	String	20	No	ISO 3166-1-alpha-2 country codes are used
27	Bill To Phone	Bill to Phone	String	20	No
28	Loyalty Account Number	Loyalty number	String	25	No	This will contain the loyalty number if the Client is part of the Radial standard loyalty process
29	Future Use	Future Use	String	25	No
30	Order Channel	Based on Client requirements. Ex. EB2C=Web Order PHONE =Phone-In	String	20	Yes
31	Guest fulfill Store	Guest fulfill Store	String	4	No
32	Employee ID	Based on Client requirements	String	10	No
33	Catalog Source Code	Catalog Source	String	15	No
34	Catalog Customer ID	Catalog Customer Number	String	10	No
35	Assisting Store Number	AOS-Associate Ordering System’s location	Integer	10,0	No
36	Affiliate ID	Affiliates Ref ID	String	20	No
37	Original Invoice Number	Original Invoice Number	Integer	14,0	No	For Returns, Reships and Price Adjustments
38	Currency Code	Currency Code	String	3	No
39	Extended Attributes

Tender
ID	Field	Description	Type	Length	Req	Comments
1	Tender Type	Tender Type	String	5	Yes	Common: AM = American Express BL = Bill Me later BR – B2B no payment processing C1 = Personal Cheque DC = Discover Card GB = GBuy GS = Gift Certificate G3 = Gift Cert Appeasement Redemption G5 = Gift Cert Discount Redemption MC = MasterCard MO = Money Order PS = PetSmart Gift Card PY = PayPal RS = Re-ship S1 = SVS Credit Re-issue S2 = Credits for SVS cancellation UF = Uncollected Funds U1 = Underage Amount VC = Visa Card Note: “RS” tender type is for reshipment of product. The customer is not charged for reships. Not all tender types are available in all countries/currencies.
2	Tender Amount	Amount tendered for the shipment.	Float	15,2	Yes	Implied decimal point.
3	Acct_Number	Number/Code or Purchase Order associated with Tender	String	30	No	Masked value (typically first 4 and last 4 numbers) for credit cards.
4	Acct_Exp_Date	Account Expiration Date	Integer	4,0	No
5	PIN	Gift Card Personal Identification Number	Integer	6,0	No
6	Extended Attributes

Detail
ID	Field	Description	Type	Length	Req	Comments
1	Order Line Number	OMS - Order Line Number	Integer	4,0	Yes	Sequential order line number of the item shipped
2	Order Status	Order Line Status (S= Shipped)	String	3	Yes
3	Partner Item Number	Client’s Item Number	String	15	Yes
4	Radial Item Number	Radial Item Number	String	9	Yes
5	Order Quantity	Quantity Ordered	Integer	9,2	Yes	Implied decimal point
6	Shipped Quantity	Quantity Shipped	Integer	9,2	Yes	Implied decimal point
7	Regular Retail	Regular Price at Order Placement Time	Integer	15,2	Yes	This is the unit retail price from the webstore without discounts being applied Implied decimal point
8	Selling Retail	Transaction Retail Price. Price paid by customer	Integer	15,2	Yes	This is the extended price the customer paid, with all discounts applied. Implied decimal point
9	Selling Cost	Average Cost at Order Fulfilment Time	Integer	15,2	No	Implied decimal point
10	Selling Tax	Tax Amount on merchandise shipped	Integer	15,2	Yes	Implied decimal point
11	SKU Type	SKU Type	String	3	Yes	01 = Merchandise 30 = Gift Card
12	Ship Date	Ship Date	String	6	Yes	UTC Format e.g. 2017-01-10T20:43:22.078-05:00 (EST)
13	Carrier ID	Carrier Code (ex. UPS)	String	4	Yes
14	Carrier Mode	Carrier Mode (service level – e.g. ground)	String	6	No
15	Tracking Number	Package Tracking Number	String	22	No
16	Ship To Customer	Ship to Customer Name	String	60	No
17	Ship To Addr1	Ship to Address	String	35	No
18	Ship To Addr2	Ship to Address	String	35	No
19	Ship To Addr3	Ship to Address	String	35	No
20	Ship To City	Ship to City	String	30	No
21	Ship To State	Ship to State	String	2	No
22	Ship To Postal Code	Ship to Zip/Postal Code	String	10	No
23	Ship-To Country	Ship-To Country	String	20	No	ISO 3166-1-alpha-2 country codes are used
24	Ship-To Email	Ship To Email Address	String	40	No
25	Serial Number	Product Serial Number	String	20	No	Gift Card number (for purchased gift cards)
26	Original Order Number	Original Order number (for credits/returns)	Integer	11,0	No
27	Original Sequence Number	Original Order Ship Sequence	Integer	3,0	No	Shipping sequence number is a sequential number for each shipment on the order.
28	Reason Code	Customer Credit/Return Code	String	3	No	Common Radial Customer Reason Codes: ARDArrived Damaged ARLArrived Late CIDI Didn't Like CMDBuyers remorse CMMI Changed My Mind CWSSize Just Didn't Fit DAMDamaged DIQDisappointed in quality DLCDid not like colour DLSDid not like styling MISWrong item, size or colour MSII Received Incorrect Item MSSI Received Incorrect Size NADNot as pictured or described SHEShipping error TLGToo Large TSMToo Small
29	Inventory Condition	Inventory Condition – Sellable/Non-Sellable	String	5	No	For Returns only
30	Gift Wrap Amount	Gift Wrap Charge	Integer	15,2	No	Implied decimal point.
31	Gift Registry ID	Gift Registry Number	String	15	No
32	Gift Card ID	ID of gift card purchased.	String	19	No
33	Duty Amount	Duty Amount	Float	15,2	No
34	ISPU Store Id	ISPU StoreId	String	10	No
35	UPC	Product UPC	Integer	18,0	No
36	Discount Amount	Discount Amount	Float	15,2	No	Promo information from order message is used here
37	Promo Id	Promo Id	String	20	No
38	Promo Code	Promo Code	String	20	No
39	Discount Type	Promo Level	String	30	No	ORDER, ITEM, SHIPPING
40	Extended Attributes

Sample Feeds

Shipped Orders XML