Radial JDA-Based Order Management Help

RELATED TOPICS

Order Status

Overview

The Order Status feed provides hourly batch reports on orders that had a status change. The Order Status feed is optional, and can be implemented for clients who want visibility into the status of orders as they proceed through processing in the Radial Order Management System.

The Order Status feed is an outbound feed, sent hourly from Radial to the client. Data in the feed is incremental, including only the orders that had a change in the Order Status field since the previous report. If an order status changes more than once during the hour, the feed includes all status changes, with a separate timestamp for each order status event.

Order Status Feed Event

  • New
  • Backorders
  • Cancels
  • Allocated
  • Shipped
  • Price Adjustments
  • Returns

Feed Characteristics

Characteristics Value
Exchange Frequency Hourly
Timing TBD
Sender/Receiver To the eCommerce site provider from Radial
File Name

StoreCode_ALCORDST_yyyymmddhhmmss.XML

StoreCode_BCKORDST_yyyymmddhhmmss.XML

StoreCode_CANORDST_ yyyymmddhhmmss.XML

StoreCode_NEWORDST_ yyyymmddhhmmss.XML

StoreCode_RTNORDST_ yyyymmddhhmmss.XML

StoreCode_SHPORDST_ yyyymmddhhmmss.XML

StoreCode_PRCADJST_ yyyymmddhhmmss.XML

File Format XML
Receipt Acknowledgement – Standard Receipt Acknowledgement TBD; File Name: ORDSTSRECACK_yyyymmddhhmmss.XML

Feed Attributes

ID

Field Name

Description

Type

Length

Req.

Comments

1

Radial Store Code

Radial Store Code

 

String

10

Y

 

2

Record Type

Refer to Matrix

Char

20

Y

New                       

Allocated               

Shipped                 

Cancelled              

Backordered         

Return                    

PriceAdjustment 

3

OMS Order Number

OMS Order Number

 

Integer

11, 0

Y

 

4

Line Number

JDA line number

 

Integer

4,0

Y

 

5

Web Order Number

Webstore order

String

30

Y

 

6

Original OMS Order Id

OMS Order Id

Integer

11,0

Y

Original order number for RT, PA, RS

7

Partner Line number

Web line Number

 

Integer

3,0

Y

 

9

Warehouse

Inventory Location

 

Integer

5,0

Y

 

10

Customer Name

First & Last Name

String

50

Y

 

11

Order Date Time

Order Entry Date

 

String

 

Y

UTC

12

Activity Date Time

Line Status Date

 

String

 

Y

UTC

13

Reason Code

Return Reason Code

 

Char

3

N

Cancels, returns, price adjustments

14

Quantity

Quantity Ordered

 

Quantity Back Order

 

Quantity Allocated

 

Quantity Shipped To Date

 

Integer

 

Y

Ship, Cancel, Return, Reship, allocated, backordered qty

15

Partner Item Id

Partner Item number

  

 

String

15

Y

 

16

Ship Date Time

Line Status Date

 

String

 

Y

UTC

Shipped, returned, price adjustments

17

Ship Via

Carrier code

String

20

N

 

18

Ship Method

Carrier mode

String

20

N

 

19

Tracking Number

Shipping Tracking Number

String

30

N

Shipped only

20

HFR Tracking Number

HFR Tracking

String

50

N

 

21

UPC

 

 

 

N

 

Notes:

 

Sample Feeds

New Orders Status XML

Shipped Orders Status XML

Canceled Orders Status XML

Returned Orders Status XML