VRBT_LN_VNDR

(SQL View)
 Index Back

Supplier Rebate Line View


SELECT A.SETID , A.VRBT_ID , B.VRBT_LINE_NBR , A.VENDOR_SETID , A.VENDOR_ID , A.VRBT_BEGIN_DT , A.VNDR_LOC , A.DIRECT_SHIP_FLAG , B.VRBT_LINE_TYPE , B.ITM_SETID , B.INV_ITEM_ID , B.CATEGORY_ID FROM PS_VRBT_HDR A , PS_VRBT_LINE B WHERE A.SETID = B.SETID AND A.VRBT_ID = B.VRBT_ID AND A.VRBT_STATUS = 'A' AND B.CATEGORY_ID <> ' ' AND B.STATUS = 'A'

# 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

2 VRBT_ID Character(25) VARCHAR2(25) NOT NULL Vendor Rebate ID
3 VRBT_LINE_NBR Number(5,0) INTEGER NOT NULL Vendor Rebate Elligible Line Number
4 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
5 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
6 VRBT_BEGIN_DT Date(10) DATE Vendor Rebate Agreement Begin Date
7 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
8 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
9 VRBT_LINE_TYPE Character(4) VARCHAR2(4) NOT NULL Rebate Line Type: Category or Item
CAT=Category
ITEM=Item
10 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
11 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
12 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID