RF_SOMYMAT_VW (SQL View)	Index Back
My SO Material View View for My Service Order Material entries (mobile data distribution)

RF_SOMYMAT_VW

(SQL View)

My SO Material View

View for My Service Order Material entries (mobile data distribution)

SELECT DISTINCT A.BUSINESS_UNIT , A.SO_ID , B.OPRID , D.BO_NAME_DISPLAY , D.BO_NAME_AC , C.SO_STATUS , C.SO_PRIORITY , E.MATERIAL_HDR , E.SHEET_ID , E.TIME_SHEET_ID , F.SYNCID , F.SYNCDTTM FROM PS_RF_SOLN_ASSIGN A , PSOPRALIAS B , PS_RF_SO_HDR C , PS_BO_NAME_PRIM_VW D , PS_RF_SO_LINE E , PS_RF_MATERIAL_HDR F WHERE A.PERSON_ID = B.PERSON_ID AND A.PERSON_ID <> ' ' AND B.OPRALIASTYPE = 'PER' AND C.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.SO_ID = A.SO_ID AND C.BO_ID_CUST = D.BO_ID AND A.SO_ID = E.SO_ID AND A.BUSINESS_UNIT = E.BUSINESS_UNIT AND F.MATERIAL_HDR = E.MATERIAL_HDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_RB.BUSINESS_UNIT
Prompt Table: SP_BU_RF_NONVW

2 SO_ID Character(10) VARCHAR2(10) NOT NULL Service Order ID
Prompt Table: RF_SO_HDR

3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

4 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object

5 BO_NAME_AC Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

6 SO_STATUS Character(1) VARCHAR2(1) NOT NULL This field is used to store the Service Order Header Status.
C=Complete
D=Closed
O=Open
X=Canceled

7 SO_PRIORITY Character(1) VARCHAR2(1) NOT NULL The priority of the service order.
H=High
L=Low
N=Normal
U=Urgent

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

9 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID

10 TIME_SHEET_ID Character(10) VARCHAR2(10) NOT NULL Time Sheet Unique Identifier (System Generated)

11 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.

12 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 Default Value: OPR_DEF_TBL_RB.BUSINESS_UNIT Prompt Table: SP_BU_RF_NONVW
2	SO_ID	Character(10)	VARCHAR2(10) NOT NULL	Service Order ID Prompt Table: RF_SO_HDR
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object
5	BO_NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
6	SO_STATUS	Character(1)	VARCHAR2(1) NOT NULL	This field is used to store the Service Order Header Status. C=Complete D=Closed O=Open X=Canceled
7	SO_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	The priority of the service order. H=High L=Low N=Normal U=Urgent
8	MATERIAL_HDR	Character(8)	VARCHAR2(8) NOT NULL	Header ID used when recording item usage on a service order.
9	SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Report ID
10	TIME_SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Time Sheet Unique Identifier (System Generated)
11	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.
12	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time