SO_LINEBUSINESS_UNITPrompt Table: SP_BU_PC_NONVW
SO_IDPrompt Table: SP_PROJ_NONVW
RS_SO_OPEN_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT B.SO_LINE , A.BUSINESS_UNIT , A.SO_ID , A.DESCR60 , A.CUST_ID , A.PROJECT_ID , B.PROJ_ROLE , B.QTY_INTEGER , B.START_DT , B.END_DT , A.ASSIGNED_TO FROM PS_RS_SO_HDR A , PS_RS_SO_LINE B , PS_RS_SO_STATUS C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SYSTEM_SOURCE = 'RS' AND A.SO_ID = B.SO_ID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.SO_ID = C.SO_ID AND C.LASTUPDDTTM = ( SELECT MAX(C1.LASTUPDDTTM) FROM PS_RS_SO_STATUS C1 WHERE C1.BUSINESS_UNIT = C.BUSINESS_UNIT AND C1.SO_ID = C.SO_ID) AND C.SO_STATUS NOT IN ('C','D','X') AND B.SO_LINE_STATUS = 'O' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SO_LINE |
Number(3,0) | SMALLINT NOT NULL | Line Number |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PC_NONVW |
| 3 | SO_ID |
Character(15) | VARCHAR2(15) NOT NULL | Service Order ID |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | CUST_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 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: SP_PROJ_NONVW |
| 7 | PROJ_ROLE | Character(15) | VARCHAR2(15) NOT NULL | Project Role |
| 8 | QTY_INTEGER | Number(11,0) | DECIMAL(11) NOT NULL | Quantity Rounded to 0 Decimals |
| 9 | START_DT | Date(10) | DATE | Start Date |
| 10 | END_DT | Date(10) | DATE | End Date |
| 11 | ASSIGNED_TO | Character(30) | VARCHAR2(30) NOT NULL | Assigned To |