VRBT_USER1_VW

(SQL View)
 Index Back

Rebate Unrestricted Flag Users

Rebate Unrestricted Flag Users

SELECT H.SETID , H.VRBT_ID , H.REBATE_MGR FROM PS_VRBT_HDR H WHERE H.VRBT_STATUS = 'A' AND EXISTS ( SELECT 'X' FROM PS_OPR_DEF_TBL_PM O WHERE VRBT_UNRESTRICT_FL = 'Y')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 VRBT_ID Character(25) VARCHAR2(25) NOT NULL Vendor Rebate ID

Prompt Table: VRBT_HDR

3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).