SPA_WORDER_VW(SQL View) |
Index Back |
|---|---|
SP WO Roster View |
| SELECT A.BUSINESS_UNIT , A.WORK_ORDER_ID , A.SP_REQ_ID , A.LINE_NBR , A.PROJECT_ID , A.VENDOR_ID , A.WO_CONID , A.PO_ID FROM PS_SPF_WORDERREC A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PM_NONVW |
| 2 | WORK_ORDER_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Work Order ID
Default Value: NEXT |
| 3 | SP_REQ_ID | Character(10) | VARCHAR2(10) NOT NULL |
Service Request ID
Prompt Table:
SPF_WO_REQ_D_VW
|
| 4 | LINE_NBR | Number(5,0) | INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
Prompt Table: SPF_WO_LINE_VW |
| 5 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: PROJECT |
| 6 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: SPM_BU_SNW_VW |
| 7 | WO_CONID | Character(15) | VARCHAR2(15) NOT NULL |
Service Provider's ID assigned on work order
Prompt Table: SPF_CNDIDATE_VW |
| 8 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |