RF_MATREMSER_VW (SQL View)	Index Back
Removed Material View This is a view on the used material table to be used for populating the material usage grid on the service order.

RF_MATREMSER_VW

(SQL View)

Removed Material View

This is a view on the used material table to be used for populating the material usage grid on the service order.

SELECT BUSINESS_UNIT , SO_ID , SO_LINE , MATERIAL_HDR , MATERIAL_LINE , REMOVED_ITEM_ID , SEQNO , QTY_SERLOT , SERIAL_ID , LOT_ID , FAILURE_CD , BILLABLE_FLAG , USAGE_ACTION , PERSON_ID FROM PS_RF_MATREMSER

# 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 QTY_SERLOT Number(16,4) DECIMAL(15,4) NOT NULL Quantity entered on Manage Material when recording new item or item removal usage.

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

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

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

12 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

13 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

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

#	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	QTY_SERLOT	Number(16,4)	DECIMAL(15,4) NOT NULL	Quantity entered on Manage Material when recording new item or item removal usage.
9	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to represent the Serial ID of an item or installed product
10	LOT_ID	Character(15)	VARCHAR2(15) NOT NULL	Lot ID
11	FAILURE_CD	Character(10)	VARCHAR2(10) NOT NULL	Code used to specify the nature of the failure - user defined. Prompt Table: RF_FAILURE_CD
12	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
13	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
14	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID Prompt Table: RF_SOLN_ASS_VW