RF_ITEM_RESULTS (SQL Table)	Index Back
Item Results This record contains UOM and quantity information about an item.

RF_ITEM_RESULTS

(SQL Table)

Item Results

This record contains UOM and quantity information about an item.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

2 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

3 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Used to store the unit of measure for an item.

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

5 QTY_ONHAND Signed Number(17,4) DECIMAL(15,4) NOT NULL Item quantity on-hand from Inventory.

6 QTY_RESERVED Signed Number(17,4) DECIMAL(15,4) NOT NULL Item quantity reserved from Inventory.

7 QTY_OWNED Signed Number(17,4) DECIMAL(15,4) NOT NULL Item quantity owned returned from Inventory.

8 BU_NODE_FLAG Character(1) VARCHAR2(1) NOT NULL Flag to indicate whether Business Unit Segment is being sent as part of the Item Balance Inquiry to SCM
Default Value: N

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

10 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	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
3	UNIT_MEASURE_STD	Character(3)	VARCHAR2(3) NOT NULL	Used to store the unit of measure for an item.
4	QTY_AVAILABLE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Inventory item quantity available.
5	QTY_ONHAND	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Item quantity on-hand from Inventory.
6	QTY_RESERVED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Item quantity reserved from Inventory.
7	QTY_OWNED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Item quantity owned returned from Inventory.
8	BU_NODE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Flag to indicate whether Business Unit Segment is being sent as part of the Item Balance Inquiry to SCM Default Value: N
9	RETURN_STATUS	Character(10)	VARCHAR2(10) NOT NULL	Inventory item return status on an RMA.
10	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.