REQLNSRH_UPN_VW(SQL View) |
Index Back |
|---|---|
REQLNSRH_UPN_VWView created to search the upnid's on REQ line |
| SELECT A.BUSINESS_UNIT , A.REQ_ID , B.LINE_NBR , B.ITM_SETID , B.INV_ITEM_ID , B.DESCR254_MIXED , B.UNIT_OF_MEASURE , B.MFG_ID , B.MFG_ITM_ID , B.UPN_TYPE_CD , B.UPN_ID FROM PS_REQ_HDR A , PS_REQ_LINE B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.REQ_ID = B.REQ_ID AND B.UPN_ID <>' ' |
| # | 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 |
| 3 | LINE_NBR | Number(5,0) | INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
Default Value: 1 |
| 4 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
| 5 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: %EDIT_ITEM_ID |
| 6 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 7 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: %EDIT_UOM |
| 8 | MFG_ID | Character(50) | VARCHAR2(50) NOT NULL |
Manufacturer ID
Prompt Table: MANUFACTURER |
| 9 | MFG_ITM_ID | Character(50) | VARCHAR2(50) NOT NULL |
Manufacturer's Item ID
Prompt Table: %EDIT_MFGITM_ID |
| 10 | UPN_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL |
Universal Product Number Format Type
Prompt Table: %EDITTABLE39 |
| 11 | UPN_ID |
Character(20) | VARCHAR2(20) NOT NULL |
Universal Product Number
Prompt Table: %EDIT_FIELD |