Inventory Transactions Feed
Description
Inventory Transactions provides a detailed list of inventory activities for merchant-owned inventory within the Radial Distribution Center. Activities can include inventory receipts, adjustments, Return to Vendor (RTV) transactions and physical inventory transactions. Note: Sales and Return Transactions are not included but are reported to the Partner in the Shipped Order (POS) Feed.
There are both XML and flat file versions of this feed.
Exchange Frequency
Daily or multiple times per day.
Timing
Flexible -- schedule set to meet merchant needs, up to hourly.
Sender/Receiver
From Radial to merchant.
File Formats
XML
Flat file, fixed length
XML Schema
The XML version of the Inventory Transactions feed follows the schema: Inventory-Transactions.xsd.
Additional data element definitions are in the following flat file table.
XML Example
Flat File Name:
EOINTRNyyyymmddhhmmss.dat
Flat File Format
Flat file, fixed field length
Flat File Example
Flat File Data Format
|
ID |
Field |
Description |
Type |
Length |
Req. |
Partner 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 |
Transaction Type |
Identifies the type of Inventory transaction: 31 - Inventory Receipt 51 - Return to Vendor (RTV) 61 - Inventory Adjustment 71 - Physical Inventory 91 - Putaway
|
Character |
3 |
Yes |
Values: 31, 51, 61, 71, 91 |
|
5 |
Transaction Date |
Date of transaction YYMMDD |
Numeric |
6,0 |
Yes |
|
|
6 |
TransactionQuantity |
The transaction quantity in units |
Numeric |
9,2 |
Yes |
No decimal point is contained. It is an implied decimal. (For example, a quantity of 10 will show as 000001000) Quantity will be either positive or negative for types:
Quantity will always be positive for types:
|
|
7 |
TransactionReference 1 |
Identifies:
|
Character |
20 |
Yes |
Each transaction type will have a predefined prefix followed by the transaction number or reason code.
** The addition of ‘ADJ-‘ and ‘DMG-‘ for Physical inventory transactions is not available for all clients. Please reach out to Client Success team for more information . |
|
8 |
TransactionReference 2 |
Identifies additional customized information such as carton ID for receipts. For RTVs, this field would contain ‘ADJ’ when referring to sellable inventory or ‘DMG’ when referring to damaged inventory. |
Character |
25 |
No |
** The addition of ‘ADJ’ and ‘DMG’ is not available for all clients. Please reach out to Client Success team for more information . |
|
9 |
Transaction Retail |
Identifies the extended value based on the current retail price in Radial merchandise management system. |
Numeric |
9.2 |
No
|
No decimal point is contained. It is an implied decimal. For example, a price of $10.00 will show as 000001000 |
|
10 |
Transaction Cost |
Identifies the extended value based on the current cost in Radial merchandise management system. |
Numeric |
9.2 |
No |
No decimal point is contained. It is an implied decimal. For example, a cost of $10.00 will show as 000001000 |
|
11 |
Date/Time Stamp |
Date and Time in which the file was generated. Format yyyy-mm-dd-hh.mm.ss |
Character |
19 |
Yes |
|
|
12 |
Lot ID |
The Lot ID associated with the product. |
Character |
15 |
No |
If applicable, the lot ID associated with the product. |
|
13 |
Segment ID |
The segment ID associated with this item. |
Character |
30 |
No |
If applicable, the segment ID associated with the item. |
|
14 |
Order ID |
Order# for Return Order |
Character |
20 |
No |
Used when Returns are processed as Adjustment. |
|
15 |
Reason Code |
Return Reason |
Character |
5 |
No |
|
|
16 |
Line# |
PO/ASN Line# |
Character |
5 |
No |
|
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 |
Reason Codes
The following reason codes can be used in the Transaction Reference 1 field.
|
Reason Code |
Adjustment Code Description |
Intended Use |
|---|---|---|
|
CCR |
CCR - Customer Service request |
Customer return that was previously credited by customer service and flagged as in transit inventory that was credited to a customer but not yet received at the warehouse. |
|
DMG |
DMG - Damaged - Dest |
Product is damaged, is not sellable and may or may not be refurbished. |
|
EXP |
EXP - Expired / Out |
Disposal of any perishables that have passed expiration date |
|
GFT |
GFT - Gift Card SKU |
Used exclusively for Gift Card SKU Conversions. It is financially the same as the SKU adjustment code. |
|
IWN |
IWN - Intra-Warehous |
Merchandise movement out of Sellable to Unsellable and vice-versa |
|
IWT |
IWT - Inter-Warehous |
Merchandise movement out from one warehouse to another warehouse (i.e., Louisville to Shepherdsville) |
|
IWL |
IWL - Inter-Warehou |
Product is moved from one location to another. This is a In/Out transaction with no financial impact. - Rec against PO in one location, moved to another. |
|
KIT |
KIT - Kitting/Bundli |
Necessary adjustments as part of creating a kit out of several individual items or separating a kit |
|
LCR |
Legacy Customer Retu |
Bringing in a return that was originally fulfilled by another organization |
|
MSH |
MSH - Mis Shipped P |
Net zero transaction - Customer return to returns warehouse flagged as item that was ordered was not item received. |
|
MIT |
MIT - Merchandising |
Merchandising Trouble - Net zero transaction regarding trouble items received. |
|
OST |
OST - Over/Short Transfer |
Used to adjust inventory quantities during the transfer process when the quantity received is different from the quantity shipped. It is financially as the UP adjustment code |
|
PDD |
PDD - Partner Direct |
Partner specific/request |
|
PLF |
PLF - Pilferage - kn |
Adjust items that are suspected to have been taken - packaging found empty in location cycle count verifies missing item |
|
PHY |
PHY - Physical Inven |
Only used when a variance between physical and systemic inventory on hand is discovered during a physical inventory count |
|
PL |
PL - Planned Cycle C |
Any positive or negative adjustment made while cycle counting on a planned cycle count |
|
PHO |
PHO -Samples - Photo |
Photo taken out of inventory |
|
PHR |
PHR - Physical Inven |
Reconciliation when a physical inventory adjustment was completed based on a 3rd party's incorrect count |
|
RCV |
RCV - Receiving/Chec |
Receiving check in error |
|
RCN |
RCN - JDA Reconcil |
Adjustment code utilized to reconcile JDA and WMS |
|
RNP |
RNP - Receipt of Inv |
Receipt of Inventory with no PO |
|
RTV |
RTV - Return To Vendor |
Product that has been approved for return to the vendor and an actual RTV order isn't created |
|
SKU |
SKU - Sku Conversion |
When a SKU has been discontinued and assigned another |
|
UCR |
UCR - Unknown Credit |
Unknown customer return received at the warehouse - undetermined if credit issued. No shipper information, no label or no pack slip. |
|
UP |
UP -Unplanned Counts |
Any positive or negative unplanned adjustment made during resolution of troubled order process |
|
VAS |
VAS -Virtual SKU adj |
Adjust a virtual SKU examples: gift wrap, warranties, etc. |
|
SAM |
SAM - Samples - Non- |
Sample Product taken out of inventory |
|
CHA |
CHA - Charity Sale/G |
|
|
DMC |
DMC - Damages Custom |
|
|
LIQ |
LIQ - Liquidation |
Product that is taken out of stock for a liquidation sale |
|
OBQ |
OBQ - Out of Busi |
|
|
OLQ |
OLQ - GSI Vendor Liq |
|
|
REP |
REP - Replacement pa |
|
|
REF |
REF - Refurb Product |
|
|
TRS |
TRS - GSI Vend Trash |