VRBT_LIST_VW

(SQL View)
 Index Back

Supplier Rebate ID Search

Supplier Rebate ID Search Results View used only in Supplier Rebate Look-up/Custom Search Page.

SELECT A.SETID , A.VRBT_ID , A.VENDOR_SETID , A.VENDOR_ID , B.VENDOR_NAME_SHORT , A.MSTR_CNTRCT_ID , A.ALLOW_OPEN_ITEM , A.ORDER_BY_DESCR , A.VRBT_REFERENCE , A.VRBT_CORP_FLG , A.DIRECT_SHIP_FLAG , A.VRBT_STATUS , A.DESCR , A.VRBT_BEGIN_DT , A.VRBT_EXPIRE_DT , 'N' FROM PS_VRBT_HDR A , PS_VENDOR B WHERE A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 VRBT_ID Character(25) VARCHAR2(25) NOT NULL Vendor Rebate ID
3 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
5 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
6 MSTR_CNTRCT_ID Character(10) VARCHAR2(10) NOT NULL Master Contract ID
7 ALLOW_OPEN_ITEM Character(1) VARCHAR2(1) NOT NULL Allow Open Item Reference
N=No
Y=Yes

Y/N Table Edit

8 ORDER_BY_DESCR Character(1) VARCHAR2(1) NOT NULL Allow Order by Description

Y/N Table Edit

9 VRBT_REFERENCE Character(30) VARCHAR2(30) NOT NULL Vendor Rebate Reference
10 VRBT_CORP_FLG Character(1) VARCHAR2(1) NOT NULL Vendor Rebate Agreement Corporate Flag
11 DIRECT_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Include Direct Shipments Direct Shipments Only Exclude Direct Shipments
1=Include Direct Shipments
2=Direct Shipments Only
3=Exclude Direct Shipments
12 VRBT_STATUS Character(2) VARCHAR2(2) NOT NULL Vendor Rebate Status
A=Approved
C=Closed
H=Hold
O=Open
X=Cancelled
13 DESCR Character(30) VARCHAR2(30) NOT NULL Description
14 VRBT_BEGIN_DT Date(10) DATE Vendor Rebate Agreement Begin Date
15 VRBT_EXPIRE_DT Date(10) DATE Vendor Rebate Agreement Expire Date
16 SELECT_FLAG Character(1) VARCHAR2(1) NOT NULL Selection Flag
N=No
Y=Yes