BUSINESS_UNITREQ_IDDefault Value: NEXT
LINE_NBR0=Not Required
1=Completed
2=Routed for Approval
Default Value: 0
PV_REQ_LINE_WS(SQL View) |
Index Back |
|---|---|
Req Line WorkScrollThis workscroll is being referenced on ePro Confirmation Page. |
| SELECT A.BUSINESS_UNIT , A.REQ_ID , A.LINE_NBR , %Substring(A.DESCR254_MIXED, 1, 30) , ' ' , ' ' , '0' FROM PS_REQ_LINE A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | REQ_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Requisition ID
Default Value: NEXT |
| 3 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 4 | ITEM_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Item Description |
| 5 | ALLOW_UPDATE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Allow Updates |
| 6 | DESCR25 | Character(25) | VARCHAR2(25) NOT NULL | Business Unit Descr |
| 7 | REQ_LINE_APPR | Character(1) | VARCHAR2(1) NOT NULL |
Invoice Line Approval Status
0=Not Required 1=Completed 2=Routed for Approval Default Value: 0 |