REQ_TYPEBO=Bill Only
BR=Bill and Replace
STD=Standard
PV_REQ_TYPE_VW(SQL View) |
Index Back |
|---|
| SELECT x.fieldvalue , x.xlatlongname FROM PSXLATITEM X WHERE X.FIELDNAME = 'REQ_TYPE' AND %EffdtCheck(PSXLATITEM XX, X, %CurrentDateIn) AND X.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REQ_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Requisition Type
BO=Bill Only BR=Bill and Replace STD=Standard |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |