OPRIDPrompt Table: OPRID_VW
A=Approved
C=Closed
H=Hold
O=Open
X=Cancelled
Y/N Table Edit
Y/N Table Edit
VRBT_ADDAUTH_VW(SQL View) |
Index Back |
|---|---|
RebateAgreement Entry Auth VwRebate Agreement Entry Authority User View (Used as REBATE_MGR prompt on VRBT_HDR) |
| SELECT r.oprid , o.OPRDEFNDESC , r.vrbt_status , r.vrbt_entry_auth , r.vrbt_unrestrict_fl FROM PS_OPR_DEF_TBL_PM r , PSOPRDEFN o WHERE r.oprid = o.oprid AND (r.vrbt_entry_auth ='Y' OR r.vrbt_unrestrict_fl = 'Y') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW |
| 2 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |
| 3 | VRBT_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Vendor Rebate Status
A=Approved C=Closed H=Hold O=Open X=Cancelled |
| 4 | VRBT_ENTRY_AUTH | Character(1) | VARCHAR2(1) NOT NULL |
Authority to Add/Update Vendor Rebates
Y/N Table Edit |
| 5 | VRBT_UNRESTRICT_FL | Character(1) | VARCHAR2(1) NOT NULL |
Unrestricted Rebate Manager
Y/N Table Edit |