RF_STOR_LOC_RES (SQL Table)	Index Back
Storage Location Results Node Used on RMA to store the item balances returned from Inventory.

RF_STOR_LOC_RES

(SQL Table)

Storage Location Results Node

Used on RMA to store the item balances returned from Inventory.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL This field is used to hold the Storage Area associated with an Inventory item.

2 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL This field is used to hold the Storage Level 1 associated with an Inventory item.

3 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL This field is used to hold the Storage Level 2 associated with an Inventory item.

4 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL This field is used to hold the Storage Level 3 associated with an Inventory item.

5 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL This field is used to hold the Storage Level 4 associated with an Inventory item.

6 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity

7 QTY_RESERVED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Item quantity reserved base from Inventory.

8 QTY_AVAILABLE_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Inventory item quantity available.

9 PHYS_INV_NODE_FLAG Character(1) VARCHAR2(1) NOT NULL This field flags whether physical inventory nodes are present.
Default Value: N

10 RETURN_STATUS Character(10) VARCHAR2(10) NOT NULL Inventory item return status on an RMA.

11 MESSAGE_TEXT Character(100) VARCHAR2(100) NOT NULL Message Text This field refers to the Text for a particular Message Number in the Message Catalog.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	STORAGE_AREA	Character(5)	VARCHAR2(5) NOT NULL	This field is used to hold the Storage Area associated with an Inventory item.
2	STOR_LEVEL_1	Character(4)	VARCHAR2(4) NOT NULL	This field is used to hold the Storage Level 1 associated with an Inventory item.
3	STOR_LEVEL_2	Character(4)	VARCHAR2(4) NOT NULL	This field is used to hold the Storage Level 2 associated with an Inventory item.
4	STOR_LEVEL_3	Character(4)	VARCHAR2(4) NOT NULL	This field is used to hold the Storage Level 3 associated with an Inventory item.
5	STOR_LEVEL_4	Character(4)	VARCHAR2(4) NOT NULL	This field is used to hold the Storage Level 4 associated with an Inventory item.
6	QTY_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Base Quantity
7	QTY_RESERVED_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Item quantity reserved base from Inventory.
8	QTY_AVAILABLE_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Base Inventory item quantity available.
9	PHYS_INV_NODE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	This field flags whether physical inventory nodes are present. Default Value: N
10	RETURN_STATUS	Character(10)	VARCHAR2(10) NOT NULL	Inventory item return status on an RMA.
11	MESSAGE_TEXT	Character(100)	VARCHAR2(100) NOT NULL	Message Text This field refers to the Text for a particular Message Number in the Message Catalog.