RF_SO_SRCH_VW (SQL View)	Index Back
Service Order Search View This is the Search View for the Service Order component.

RF_SO_SRCH_VW

(SQL View)

Service Order Search View

This is the Search View for the Service Order component.

SELECT A.BUSINESS_UNIT , A.SO_ID , B.BO_NAME , B.BO_NAME_AC , A.SITE_ID , E.BO_NAME , D.BO_NAME , D.BO_NAME_AC , A.SO_STATUS , A.SO_PRIORITY , A.SO_DATE , A.BO_ID_CUST , A.ROLE_TYPE_ID_CUST , A.BO_ID_CONTACT , A.ROLE_TYPE_ID_CNTCT , A.SYNCID , A.SYNCDTTM FROM PS_RF_SO_HDR A , PS_BO_NAME_PRIM_VW B , PS_BO_NAME_PRIM_VW D , PS_RF_SITE_P_NM_VW E WHERE A.BO_ID_CUST = B.BO_ID(+) AND A.BO_ID_CONTACT = D.BO_ID(+) AND A.BUSINESS_UNIT = E.SETCNTRLVALUE(+) AND A.SITE_ID = E.SITE_ID(+)

# 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 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

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

5 SITE_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

6 BO_NAME_3 Character(50) VARCHAR2(50) NOT NULL BO Name 3
Prompt Table: RF_SITE_NM_VW

7 BO_NAME_1 Character(50) VARCHAR2(50) NOT NULL BO Name 1

8 BO_NAME_CONTACT_AC Character(50) VARCHAR2(50) NOT NULL Alt-Char Contact Name

9 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

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

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

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.

17 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	BO_NAME	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
4	BO_NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
5	SITE_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
6	BO_NAME_3	Character(50)	VARCHAR2(50) NOT NULL	BO Name 3 Prompt Table: RF_SITE_NM_VW
7	BO_NAME_1	Character(50)	VARCHAR2(50) NOT NULL	BO Name 1
8	BO_NAME_CONTACT_AC	Character(50)	VARCHAR2(50) NOT NULL	Alt-Char Contact Name
9	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
10	SO_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	The priority of the service order. H=High L=Low N=Normal U=Urgent
11	SO_DATE	Date(10)	DATE	Stores the Service Order creation date.
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.
17	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time