RF_SO_SRCH_VW2(SQL View) |
Index Back |
|---|---|
Service Order Search ViewThis is the Search View for the Service Order configurable search component. |
| SELECT A.BUSINESS_UNIT , A.SO_ID , B.BO_NAME_DISPLAY , B.BO_NAME_AC , A.SITE_ID , E.BO_NAME , D.BO_NAME_DISPLAY , 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 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_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 | 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_DISPLAY_1 | Character(80) | VARCHAR2(80) NOT NULL | This field represents the Display Name for a business object |
| 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 |