RF_STORLOC_TMP (SQL Table)	Index Back
Temp Worker Storage Locations This record stores the Worker's Storage Locations temporarily for use on the Manage Material page. This function is used primarily for FieldService to track the Field Engineer's truck stock.

RF_STORLOC_TMP

(SQL Table)

Temp Worker Storage Locations

This record stores the Worker's Storage Locations temporarily for use on the Manage Material page. This function is used primarily for FieldService to track the Field Engineer's truck stock.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
Prompt Table: RB_WORKER

2 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
Prompt Table: SP_BU_FS_NONVW

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

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

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

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

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

8 BUSINESS_UNIT_IN_2 Character(5) VARCHAR2(5) NOT NULL This field is used to hold the Inventory Business Unit associated with a FieldService technican's defective truck inventory.

9 STORAGE_AREA_2 Character(5) VARCHAR2(5) NOT NULL This field is used to hold the Storage Area associated with a FieldService technican's defective truck inventory.

10 STOR_LEVEL_1_2 Character(4) VARCHAR2(4) NOT NULL This field is used to hold the Storage Level 1 associated with a FieldService technican's defective truck inventory.

11 STOR_LEVEL_2_2 Character(4) VARCHAR2(4) NOT NULL This field is used to hold the Storage Level 2 associated with a FieldService technican's defective truck inventory.

12 STOR_LEVEL_3_2 Character(4) VARCHAR2(4) NOT NULL This field is used to hold the Storage Level 3 associated with a FieldService technican's defective truck inventory.

13 STOR_LEVEL_4_2 Character(4) VARCHAR2(4) NOT NULL This field is used to hold the Storage Level 4 associated with a FieldService technican's defective truck inventory.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID Prompt Table: RB_WORKER
2	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit Prompt Table: SP_BU_FS_NONVW
3	STORAGE_AREA	Character(5)	VARCHAR2(5) NOT NULL	This field is used to hold the Storage Area associated with an Inventory item.
4	STOR_LEVEL_1	Character(4)	VARCHAR2(4) NOT NULL	This field is used to hold the Storage Level 1 associated with an Inventory item.
5	STOR_LEVEL_2	Character(4)	VARCHAR2(4) NOT NULL	This field is used to hold the Storage Level 2 associated with an Inventory item.
6	STOR_LEVEL_3	Character(4)	VARCHAR2(4) NOT NULL	This field is used to hold the Storage Level 3 associated with an Inventory item.
7	STOR_LEVEL_4	Character(4)	VARCHAR2(4) NOT NULL	This field is used to hold the Storage Level 4 associated with an Inventory item.
8	BUSINESS_UNIT_IN_2	Character(5)	VARCHAR2(5) NOT NULL	This field is used to hold the Inventory Business Unit associated with a FieldService technican's defective truck inventory.
9	STORAGE_AREA_2	Character(5)	VARCHAR2(5) NOT NULL	This field is used to hold the Storage Area associated with a FieldService technican's defective truck inventory.
10	STOR_LEVEL_1_2	Character(4)	VARCHAR2(4) NOT NULL	This field is used to hold the Storage Level 1 associated with a FieldService technican's defective truck inventory.
11	STOR_LEVEL_2_2	Character(4)	VARCHAR2(4) NOT NULL	This field is used to hold the Storage Level 2 associated with a FieldService technican's defective truck inventory.
12	STOR_LEVEL_3_2	Character(4)	VARCHAR2(4) NOT NULL	This field is used to hold the Storage Level 3 associated with a FieldService technican's defective truck inventory.
13	STOR_LEVEL_4_2	Character(4)	VARCHAR2(4) NOT NULL	This field is used to hold the Storage Level 4 associated with a FieldService technican's defective truck inventory.