REQ_TYPEBO=Bill Only
BR=Bill and Replace
STD=Standard
Default Value: STD
PV_DISPLAY_LVLH=Header
L=Line
FIELDNAMEY/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: Y
PV_REQ_TYPE_HVW(SQL View) |
Index Back |
|---|
| SELECT REQ_TYPE , PV_DISPLAY_LVL , FIELDNAME , IS_REQUIRED , VISIBLE_FLAG FROM PS_PV_REQ_TYPE_FLD WHERE PV_DISPLAY_LVL = 'H' |
| # | 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 Default Value: STD |
| 2 | PV_DISPLAY_LVL |
Character(1) | VARCHAR2(1) NOT NULL |
Display Level
H=Header L=Line |
| 3 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 4 | IS_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL |
Required
Y/N Table Edit Default Value: N |
| 5 | VISIBLE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Visible
Y/N Table Edit Default Value: Y |