Radial JDA-Based Order Management Help

RELATED TOPICS

Inventory Transaction

Overview

Inventory Transactions provide a detailed list of inventory activities for client-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 Client in the Shipped Order (POS) Feed.

Feed Characteristics

Characteristic Description
Exchange Frequency Daily
Timing Determined with client
Sender/Receiver To client from Radial
File Name

StoreCode_INVTRN_yyyymmddhhmmss.XML
File Format XML
Receipt Acknowledgement -Standard Receipt Acknowledgement TBD; File Name: INVTNRECACK_yyyymmddhhmmss.XML

Feed Attributes

ID

Field

Description

Type

Length

Req.

Comments

1

StoreCode

Store number that is assigned by Radial to represent the Client’s web store

String

10

Yes

Radial assigned store code

2

ClientItemId

Client’s item number for product’s in Radial Item Master.

String

15

Yes

 

4

TransactionType

Identifies the type of Inventory transaction: 

31 -  Inventory Receipt

51 -  Return to Vendor (RTV)

61 -  Inventory Adjustment

71 -  Physical Inventory

 

String

3

Yes

 

Configured Field

Type: A – Allowed Values

Values: 31, 51, 61, 71

5

TransactionDate

Date of transaction

String

10

Yes

ISO Format: YYYY-MM-DD

6

TransactionQuantity

The transaction quantity in units

Float

9,2

Yes

 

9

TransactionRetail

Identifies the extended value based on the current retail price in Radial merchandise management system.

Float

9.2

No

 

 

10

TransactionCost

Identifies the extended value based on the current cost in Radial merchandise management system.

Float

9.2

No

 

 

DetailExtendeAttributes

Transaction Reference 1

String

30

 

Identifies:

  • the Purchase Order or Advance Shipping Number for Inventory Receipts (type 31)
  • the Radial RTV number (type 51)
  • Reason code for inventory adjustments and physical inventory (types 61 and 71)

Additional extended attributes can be defined as necessary.

Feed Samples

Inventory Transaction XML