RF_BU_RESULTS (SQL Table)	Index Back
Business Unit Results Node Stores the results from the Inventory item balance request.

RF_BU_RESULTS

(SQL Table)

Business Unit Results Node

Stores the results from the Inventory item balance request.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

2 STOR_LOC_NODE_FLAG Character(1) VARCHAR2(1) NOT NULL Flag indicating that storage location nodes are present.
Default Value: N

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

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 STAGED_DATE_FLAG Character(1) VARCHAR2(1) NOT NULL Flag indicating whether or not the staged date control is on.
N=Staged Date Tracking OFF
Y=Staged Date Tracking ON

9 NON_OWN_FLAG Character(1) VARCHAR2(1) NOT NULL 07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o

10 INVENTORY_ITEM Character(1) VARCHAR2(1) NOT NULL Inventory Item

11 CONSIGNED_FLAG Character(1) VARCHAR2(1) NOT NULL Indicates if the item is consigned.

12 INCL_QUAR_AVAIL Character(1) VARCHAR2(1) NOT NULL Used by the Inventory item balance request to indicate if any quantity that is 'non-open in Avail' should be included.

13 INCL_WIP_QTY_FLG Character(1) VARCHAR2(1) NOT NULL Used by the Inventory item balance request to indicate if any quantity in WIP (work in process) should be included.

14 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	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
2	STOR_LOC_NODE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Flag indicating that storage location nodes are present. Default Value: N
3	RETURN_STATUS	Character(10)	VARCHAR2(10) NOT NULL	Inventory item return status on an RMA.
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	STAGED_DATE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Flag indicating whether or not the staged date control is on. N=Staged Date Tracking OFF Y=Staged Date Tracking ON
9	NON_OWN_FLAG	Character(1)	VARCHAR2(1) NOT NULL	07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o
10	INVENTORY_ITEM	Character(1)	VARCHAR2(1) NOT NULL	Inventory Item
11	CONSIGNED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Indicates if the item is consigned.
12	INCL_QUAR_AVAIL	Character(1)	VARCHAR2(1) NOT NULL	Used by the Inventory item balance request to indicate if any quantity that is 'non-open in Avail' should be included.
13	INCL_WIP_QTY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Used by the Inventory item balance request to indicate if any quantity in WIP (work in process) should be included.
14	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.