BUSINESS_UNITSO_IDSOLUTION_IDRF_SO_SOLVE_VW(SQL View) |
Index Back |
|---|---|
Service Order Resolution ViewThis is a Resolution View for Service Order. |
| SELECT A.BUSINESS_UNIT , A.SO_ID , B.SOLUTION_ID , A.RC_DESCRLONG , A.PRODUCT_ID , A.SERVICE_ID FROM PS_RF_SO_HDR A , PS_RF_RESOLUTION B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SO_ID = B.SO_ID AND B.SOLUTION_ID > 0 |
| # | 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 | SOLUTION_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Solution ID |
| 4 | RC_DESCRLONG | Long Character | CLOB | Long description used in CallCenter for Problem, Solution... |
| 5 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 6 | SERVICE_ID | Character(20) | VARCHAR2(20) NOT NULL | Service ID |