OPRIDPrompt Table: OPRID_VW
A=Approved
C=Closed
H=Hold
O=Open
X=Cancelled
Default Value: O
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
VRBT_MANAGER_VW(SQL View) |
Index Back |
|---|---|
Rebate Manager Authority View |
| SELECT r.oprid , o.OPRDEFNDESC , r.vrbt_status , r.vrbt_entry_auth , r.vrbt_approve_auth , r.vrbt_onhold_auth , r.vrbt_cancel_auth , r.vrbt_close_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 Default Value: O |
| 4 | VRBT_ENTRY_AUTH | Character(1) | VARCHAR2(1) NOT NULL |
Authority to Add/Update Vendor Rebates
Y/N Table Edit Default Value: N |
| 5 | VRBT_APPROVE_AUTH | Character(1) | VARCHAR2(1) NOT NULL | Authority to Approve Vendor Rebate |
| 6 | VRBT_ONHOLD_AUTH | Character(1) | VARCHAR2(1) NOT NULL | Authority to put a Vendor Rebate On Hold |
| 7 | VRBT_CANCEL_AUTH | Character(1) | VARCHAR2(1) NOT NULL | Authority to Cancel Vendor Rebate |
| 8 | VRBT_CLOSE_AUTH | Character(1) | VARCHAR2(1) NOT NULL | Authority to Close Vendor Rebate |
| 9 | VRBT_UNRESTRICT_FL | Character(1) | VARCHAR2(1) NOT NULL |
Unrestricted Rebate Manager
Y/N Table Edit Default Value: N |