RF_MAT_SRCH_VW (SQL View)	Index Back
Material Search View This is the Search record for the Material Orders component.

RF_MAT_SRCH_VW

(SQL View)

Material Search View

This is the Search record for the Material Orders component.

SELECT DISTINCT A.BUSINESS_UNIT , A.SO_ID , D.BO_NAME_DISPLAY , D.BO_NAME_AC , C.SO_STATUS , E.SOACTIVITY_STATUS , C.SO_PRIORITY , C.SO_DATE , A.SO_LINE , A.INV_ITEM_ID , A.REQ_ID , C.BO_ID_CUST , C.ROLE_TYPE_ID_CUST , C.BO_ID_CONTACT , C.ROLE_TYPE_ID_CNTCT , A.SYNCID FROM PS_RF_MATERIAL_DTL A , PS_RF_SO_HDR C , PS_RF_SO_LINE E , PS_BO_NAME_PRIM_VW D WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT AND C.SO_ID = A.SO_ID AND E.BUSINESS_UNIT = C.BUSINESS_UNIT AND E.SO_ID = C.SO_ID AND E.SO_LINE = A.SO_LINE AND D.BO_ID = C.BO_ID_CUST

# 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 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object

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

5 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

6 SOACTIVITY_STATUS Character(3) VARCHAR2(3) NOT NULL Service Order Activity (line) Status.
CAN=Canceled
CLO=Closed
COM=Completed
OAC=Accepted
OER=En Route
OHA=Hold Assignment
OHC=Hold Customer
OHP=Hold Part
OOS=On Site
OPA=Assigned
ORJ=Rejected

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

8 SO_DATE Date(10) DATE Stores the Service Order creation date.

9 SO_LINE Number(3,0) SMALLINT NOT NULL Stores the Service Order line number.
Prompt Table: RF_SO_LINE_VW4

10 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

11 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID

12 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.

13 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer

14 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.

15 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact

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

#	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	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object
4	BO_NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
5	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
6	SOACTIVITY_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Service Order Activity (line) Status. CAN=Canceled CLO=Closed COM=Completed OAC=Accepted OER=En Route OHA=Hold Assignment OHC=Hold Customer OHP=Hold Part OOS=On Site OPA=Assigned ORJ=Rejected
7	SO_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	The priority of the service order. H=High L=Low N=Normal U=Urgent
8	SO_DATE	Date(10)	DATE	Stores the Service Order creation date.
9	SO_LINE	Number(3,0)	SMALLINT NOT NULL	Stores the Service Order line number. Prompt Table: RF_SO_LINE_VW4
10	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
11	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
12	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
13	ROLE_TYPE_ID_CUST	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the customer
14	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
15	ROLE_TYPE_ID_CNTCT	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the contact
16	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.