RF_SO_MAT_TMP (SQL Table)	Index Back
Material Work Temp Table This is a temp table to temporarily store the Material Usage data from the Used, Removed and Not Used tables so that it can be displayed on the Service Order

RF_SO_MAT_TMP

(SQL Table)

Material Work Temp Table

This is a temp table to temporarily store the Material Usage data from the Used, Removed and Not Used tables so that it can be displayed on the Service Order

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 SO_ID Character(10) VARCHAR2(10) NOT NULL Service Order ID

3 SO_LINE Number(3,0) SMALLINT NOT NULL Stores the Service Order line number.

4 MATERIAL_HDR Character(8) VARCHAR2(8) NOT NULL Header ID used when recording item usage on a service order.

5 MATERIAL_LINE Number(5,0) INTEGER NOT NULL Material Line number when recording item usage on a service order.

6 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
Prompt Table: MASTER_ITM_VW3

7 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number

8 USAGE_ACTION Character(4) VARCHAR2(4) NOT NULL This field displays the actions the use can select for Material Usage on the Service Order.
1=Used
2=Removed
3=Not Used

9 USAGE_ACTION_MBL Character(4) VARCHAR2(4) NOT NULL This field displays the actions the user can select for Material Usage on the Mobile Service Order.
1=Used
2=Removed

10 ORDERED_QTY Number(16,4) DECIMAL(15,4) NOT NULL Item quantity ordered when recording item usage on a service order.

11 QTY_SERLOT Number(16,4) DECIMAL(15,4) NOT NULL Quantity entered on Manage Material when recording new item or item removal usage.

12 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the Serial ID of an item or installed product

13 LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID

14 BILLABLE_FLAG Character(1) VARCHAR2(1) NOT NULL This is used to determine of the item under consideration is billable or not.
N=No
Y=Yes
Y/N Table Edit

15 FAILURE_CD Character(10) VARCHAR2(10) NOT NULL Code used to specify the nature of the failure - user defined.
Prompt Table: RF_FAILURE_CD

16 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
Prompt Table: RF_SOLN_ASS_VW

17 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

18 LINE_NBR Number(5,0) INTEGER NOT NULL This field represents the integer Order Line Number.

19 INTERUNIT_ID Character(10) VARCHAR2(10) NOT NULL This field is used to store the interunit id associated with material that was ordered.

20 INTERUNIT_LINE Number(5,0) INTEGER NOT NULL InterUnit Order Line

21 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

22 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	SO_ID	Character(10)	VARCHAR2(10) NOT NULL	Service Order ID
3	SO_LINE	Number(3,0)	SMALLINT NOT NULL	Stores the Service Order line number.
4	MATERIAL_HDR	Character(8)	VARCHAR2(8) NOT NULL	Header ID used when recording item usage on a service order.
5	MATERIAL_LINE	Number(5,0)	INTEGER NOT NULL	Material Line number when recording item usage on a service order.
6	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: MASTER_ITM_VW3
7	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
8	USAGE_ACTION	Character(4)	VARCHAR2(4) NOT NULL	This field displays the actions the use can select for Material Usage on the Service Order. 1=Used 2=Removed 3=Not Used
9	USAGE_ACTION_MBL	Character(4)	VARCHAR2(4) NOT NULL	This field displays the actions the user can select for Material Usage on the Mobile Service Order. 1=Used 2=Removed
10	ORDERED_QTY	Number(16,4)	DECIMAL(15,4) NOT NULL	Item quantity ordered when recording item usage on a service order.
11	QTY_SERLOT	Number(16,4)	DECIMAL(15,4) NOT NULL	Quantity entered on Manage Material when recording new item or item removal usage.
12	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to represent the Serial ID of an item or installed product
13	LOT_ID	Character(15)	VARCHAR2(15) NOT NULL	Lot ID
14	BILLABLE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	This is used to determine of the item under consideration is billable or not. N=No Y=Yes Y/N Table Edit
15	FAILURE_CD	Character(10)	VARCHAR2(10) NOT NULL	Code used to specify the nature of the failure - user defined. Prompt Table: RF_FAILURE_CD
16	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID Prompt Table: RF_SOLN_ASS_VW
17	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
18	LINE_NBR	Number(5,0)	INTEGER NOT NULL	This field represents the integer Order Line Number.
19	INTERUNIT_ID	Character(10)	VARCHAR2(10) NOT NULL	This field is used to store the interunit id associated with material that was ordered.
20	INTERUNIT_LINE	Number(5,0)	INTEGER NOT NULL	InterUnit Order Line
21	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
22	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time