Inventory Status Feed

Description

Inventory Status provides a snapshot of all merchant-owned sellable and non-sellable inventory in Radial's distribution centers.

There are both XML and flat file versions of this feed.

See Facility Inventory Status Feed for details on sending inventory status from the merchant to Radial.

Exchange Frequency

Daily

Timing:

2:00 AM EST

Sender/Receiver

From Radial to the merchant.

File Formats

XML

Flat file, fixed field length.

XML Schema

The XML version of the Inventory Status feed follows the schema: Inventory-Status.xsd.

Additional data element definitions are in the following flat file table.

XML Example

Flat File Name:

EOINSTSyyyymmddhhmmss.dat

Flat File Example

EOINSTS20170131020300.dat

Flat File Data Format

ID	Field	Description	Type	Length	Req.	Comments
1	Radial Store Number	Store number that is assigned by Radial to represent the JDA Store Number.	Character	5	Yes	This value can be found in the Launch Credentials document referred to as ‘JDA Store Number’
2	Partner Item Number	Partner’s item number for products in Radial Item Master.	Character	15	Yes	Same value sent in the item master as ClientItemId
3	Radial Item Number	Radial’s item number for products in Radial’s Item Master.	Character	9	Yes
4	Return On-Hand	The quantity in inventory for processing of customer returns.	Numeric	9,2	Yes	Does not contain a decimal point. It is an implied decimal. (e.g. Qty = 10 This will show as 000001000 Only used if returns are maintained in their own warehouse location. **1 Conditions apply
5	Sellable Quantity On-Hand	The quantity in inventory that has a sellable condition, is in the warehouse, and has not been shipped. Note: This amount does not take demand into account.	Numeric	9,2	Yes	Does not contain a decimal point. It is an implied decimal. (e.g. Qty = 10 This will show as 000001000) This does not include quantities that are received and pending put away.
6	Quantity Available	Quantity available = Sellable quantity on hand minus the quantity allocated to customer orders.	Numeric	9,2	Yes	Important: This field is for historical purposes only. * DO NOT USE *
7	Non-Sellable Quantity On-Hand	The quantity in inventory that is not in a sellable condition.	Numeric	9,2	Yes	Does not contain a decimal point. It is an implied decimal. (e.g. Qty = 10 This will show as 000001000) Typically used for damaged inventory or inventory to be returned to the Partner or vendor
8	Total Quantity On-Hand	The Total Inventory in the Radial Warehouse. (4+5+7+Pending Put away quantity)	Numeric	9,2	Yes	Does not contain a decimal point. It is an implied decimal. (e.g. Qty = 10 This will show as 000001000) Reflects total quantity including the quantities that are received and pending to be put away **2 Arriving at Pending put away value
9	Date/Time Stamp	Date and Time in which the file was generated. Format yyyy-mm-dd-hh.mm.ss	Character	19	Yes
10	Lot ID	The Lot ID associated with the product.	Character	20	No	If applicable, the lot id associated with the product.
11	Segment ID	The segment Id associated with this item.	Character	30	No	If applicable, the segment id associated with the item.

**1 Return On-Hand is not available for all Radial distribution centers.

**2 Pending Put Away could also be calaculated by subtracting the Non-SellableQuantity On-hand and the Sellable Quantity On-hand from the Total Quantity On-hand. (8-7-5).

Flat File Trailer Record

ID	Field Name	Field Description	Field Length	Req	Field Type	Comments
1	Record Identifier	Record Identifier	10	Yes	Character	Value: “TRAILER” (all caps)
2	# of total records	Total number of records in the file including Trailer	7,0	Yes	Numeric
3	Batch ID#	Batch Number	9,0	Yes	Numeric	sequential number