VRBT_LN_VNDR_VW(SQL View) |
Index Back |
|---|---|
Supplier Rebate Line View |
| SELECT R.SETID , R.VRBT_ID , R.VRBT_LINE_NBR , R.VENDOR_SETID , R.VENDOR_ID , R.VRBT_BEGIN_DT , R.VNDR_LOC , R.DIRECT_SHIP_FLAG , R.VRBT_LINE_TYPE , R.ITM_SETID , R.CATEGORY_ID , I.INV_ITEM_ID FROM PS_VRBT_LN_VNDR R , PS_MASTER_ITEM_TBL I WHERE R.VRBT_LINE_TYPE = 'CAT' AND R.ITM_SETID = I.SETID AND R.CATEGORY_ID = I.CATEGORY_ID AND I.ITM_STATUS_CURRENT = '1' AND NOT EXISTS ( SELECT 'Y' FROM PS_VRBT_CAT_EXCPTN E WHERE E.SETID = R.SETID AND E.VRBT_ID = R.VRBT_ID AND E.VRBT_LINE_NBR = R.VRBT_LINE_NBR AND E.ITM_SETID = I.SETID AND E.INV_ITEM_ID = I.INV_ITEM_ID) |
| # | 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 | CATEGORY_ID |
Character(5) | VARCHAR2(5) NOT NULL | Category ID |
| 12 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |