Radial JDA-Based Order Management Help

Orders to Fulfill (OTF)

Overview

The Orders to Fulfill feed transmits information on orders that Radial has processed successfully and are ready to be fulfilled (Pick, Pack & Ship) by the fulfiller.

Feed Characteristics

Characteristic	Description
Exchange Frequency	Multiple times a day, seven days a week
Sender/Receiver	To the TPF/Partner from Radial
File Name	StoreCode_OTF_yyyymmddhhmmss.XML
File Format	XML

Feed Attributes

ID	Field	Description	Type	Length	Req	Comments
	Header
1	Radial Store Code	Store number that is assigned by Radial to represent the Client’s web store	String	10	Yes	Radial assigned store code
2	Radial Fulfillment Location	Number assigned by Radial to TPF fulfillment location	Integer	5	Yes
3	External Warehouse Id	TPF Warehouse Id	String	10	Yes
4	Fulfilment Channel		String	10	Yes	WMS
5	Order Type	Type of Order	String	10	Yes	WEB PHONE
6	OMS Order Id	Radial Order Invoice Number	Integer	14	Yes	This number is a concatenation of the order number and the shipping sequence and is typically included on the pack slip to the customer. For example: For Order Number 12345678901, shipping sequence 1 the value would be :12345678901001.
7	Customer Order Id	Webstore Order id	String	30	Yes	Webstore order id
8	Split Order Indicator	Split Order	String	1	No	Indicates if order is split. Y = Partial Order N = Complete Order
9	Order Entry Date Time	Date Customer placed the Order	String		Yes	UTC Time
10	Invoice Date Time	Date Invoice Created in OMS	String		Yes	UTC Time
11	Expedited Order Indicator	Expedited Order	String	1	Yes	Y/N
12	Delivery Instructions	Delivery Instruction	String	256	No
13	Locale	Locale	String	5	Yes

	Billing Address
14	Customer Id	Webstore customer id	String	30	Yes	If webstore customer id is not available, then OMS customer id is used.
15	Full Name	Bill To Full Name	String	60	Yes
16	Salutation	Bill To Salutation	String	10	No
17	First Name	Bill To First Name	String	30	Yes
18	Last Name	Bill To Last Name	String	30	Yes
19	Email Address	Bill To E Mail Address	String	50	No
20	Company Name	Bill To Company Name	String	35	No
21	Address Line1	Bill To Customer Address 1	String	50	Yes
22	Address Line2	Bill To Customer Address 2	String	50	No
23	Address Line3	Bill To Customer Address3	String	50	No
24	City	Bill To City	String	30	Yes
25	State or Province	Bill To State/Province	String	10	No
26	Country Code	Bill To Zip/Postal Code	String	10	Yes
27	Postal Code	Bill to Phone Number	String	20	Yes
28	Full telephone Number	Bill to Phone Number	String	20	No

	Shipping Address
29	Customer Id	Shipping Customer Id	String	30	No	If webstore customer id is not available, then OMS customer id is used.
30	Full Name	Ship to Full Name	String	60	Yes
31	Salutation	Ship to Salutation	String	10	No
32	First Name	Ship to First Name	String	30	Yes
33	Last Name	Ship to Last Name	String	30	Yes
34	Email Address	Ship to E Mail Address	String	50	No
35	Company Name	Ship to Company Name	String	35	No
36	Address Line1	Ship to Customer Address 1	String	50	Yes
37	Address Line2	Ship to Customer Address 2	String	50	No
38	Address Line3	Ship to Customer Address3	String	50	No
39	City	Ship to City	String	30	Yes
40	State or Province	Ship to State/Province	String	10	No
42	Country Code	Ship to Zip/Postal Code	String	10	Yes
42	Postal Code	Ship to Phone Number	String	20	Yes
43	Full telephone Number	Ship to Phone Number	String	20	No

	Carrier
44	Carrier Id	Carrier Code	String	4	Yes	These values are determined with partner during Discovery Phase.
45	Carrier Service Level	Carrier Mode	String	6	Yes	These valuesare determined with partner during Discovery Phase.

46	Amount					Order totals
46	Amount Type	Type of charge	String	50	Yes	TotalInvoiceAmount, TotalRetailAmount, TotalFreightAmount, TotalGiftWrapAmount, TotalCustomizationAmount, TotalTaxAmount, TotalTaxOnFreight
47	Amount	Order Amounts	Float	13,2	Yes
48	Currency Code	Transaction Currency Code	String	3	Yes

	Payment
49	Payment Reference	Payment information such as Credit card type and last 4 digits.	String	20	Yes	Value: Tender Name + Blank + Last4digit of Credit Card# No Payment information for Reships
	Payment Extended Attributes				No	Used for additional payment level custom attributes.
50	Name	Name	String	30
51	Description	Description	String	100
52	Value	Value	String	100


	Header Extended Attributes				No	Used for additional header level custom attributes.
67	Name	Name	String	30
68	Description	Description	String	100
69	Value	Value	String	100

	Order Detail
70	Line Number	Order Line number assigned by Radial	Integer	4	Yes

	Item
71	Item Id	Client Item Id	String	15	Yes
72	UPC Number	UPC	Integer	18	No	Provided if available.

	Item Attributes
73	Item Description	Item description	String	120	Yes
74	Size	Size Description	String	40	No
75	Color	Color Description	String	40	No
76	Order Quantity	Quantity Ordered by the Customer	Integer	7	Yes
77	Unit Price	Unit Price	Float	13,2	Yes
78	Currency Code	Transaction Currency Code	String	3	Yes

	Line Amount
79	Line Amount Type	Type of Line Charge	String	50	Yes	LineTotalAmount, LineRetailAmount LineDiscountAmount, LineCustomizationAmount, LineGiftWrapAmount
80	Amount	Amount	Float	13,2	Yes
81	Currency Code	Transaction Currency Code	String	3	Yes

	Tax
82	Tax Type	Type	String	20	Yes	CountryFederal, State, County, City, SecondaryCity
83	Tax Authority	Authority	String	6	Yes
84	Tax Code	Code	String	6	Yes
85	Tax Rate	Rate	Float	6.5	Yes
86	Tax Exemption	Exemption	String	1	No	Y or N
87	Tax Amount	Amount	Float	13,2	Yes

	Customization
88	Custom Item Id	Client Item Id	String	15	No	Gift Wrap Item or any custom item .
89	Sequence	Sequence	Integer	2	Yes
90	Custom Type		String	1	Yes	List included
91	Instruction		String	254	No	Customization instruction
92	Content		String	254	No	Gift message, pack slip message

	Detail Extended Attributes				No
93	Name	Name	String	30
94	Description	Description	String	100
95	Value	Value	String	100

Valid Order Comment Types

Comment Type	Description
C	Customization Comment
E	Embroidery/Embossing data for 210
F	Finance Department Comment
G	Gift Wrap Text
I	Internal Comment
L	Line Message Comment
O	Special Order
P	DO NOT USE!!! Personal Comment
S	Shipping Comment
V	Invoice Comments
1	Internet Line Item Shipping Comment
H	Header Pack slip Message
T	General Header Comment

Sample Feed

Orders to Fulfill XML