PRCR_DS_WO_VW(SQL View) |
Index Back |
|---|---|
Work Order Record View |
| SELECT A.BUSINESS_UNIT , A.WORK_ORDER_ID , A.CURRENCY_CD , A.DEPTID , ' ' , A.LINE_NBR , A.LINKEDWORDER , A.POAMOUNT , A.PROJECT_ID , A.ROW_CREATE_USER , A.SP_REQ_ID , A.SP_ROUTE_TO , A.SP_WO_TYPE , A.START_DATE , A.WO_CLIID , A.WO_CONID , A.WO_STATUS FROM PS_SPF_WORDERREC A WHERE SUB_LINE = 'N' OR SUB_LINE = ' ' |
| # | 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_FS.BUSINESS_UNIT Prompt Table: SP_BU_SP_NONVW |
| 2 | WORK_ORDER_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Work Order ID
Prompt Table: SPF_WORDER_VW1 |
| 3 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 4 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 5 | INVAPPROVER | Character(30) | VARCHAR2(30) NOT NULL | Invoice Approver |
| 6 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 7 | LINKEDWORDER | Character(15) | VARCHAR2(15) NOT NULL | Linked Work Order |
| 8 | POAMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Purchase Order / Work Order Amount |
| 9 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 10 | ROW_CREATE_USER | Character(30) | VARCHAR2(30) NOT NULL | Row Added By |
| 11 | SP_REQ_ID | Character(10) | VARCHAR2(10) NOT NULL | Service Request ID |
| 12 | SP_ROUTE_TO | Character(30) | VARCHAR2(30) NOT NULL | WorkOrder Approver Person. |
| 13 | SP_WO_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
WorkOrder Type classified as original, extension, reassign wo
E=Extension O=Original P=Replacement R=Reassign Work Order |
| 14 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 15 | WO_CLIID | Character(30) | VARCHAR2(30) NOT NULL | Requester |
| 16 | WO_CONID | Character(15) | VARCHAR2(15) NOT NULL | Service Provider's ID assigned on work order |
| 17 | WO_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Work Order Status
A=Approved C=Closed D=Denied F=Finalize L=Released N=Canceled O=Open P=Pending Terminate S=Submitted T=Terminated |