SETIDPrompt Table: SP_SETID_NONVW
VRBT_IDPrompt Table:
VENDOR_PO_VW
Set Control Field: VENDOR_SETID
VRBT_HDR_VW(SQL View) |
Index Back |
|---|---|
Supplier Rebates in Approved SSupplier Rebate Agreements in Approved Status used in the PO Components (VRBT Search ) |
| SELECT H.SETID ,H.VRBT_ID ,H.VENDOR_SETID ,H.VENDOR_ID , N.VENDOR_NAME_SHORT , H.VRBT_REFERENCE , H.DESCR ,H.VRBT_BEGIN_DT ,H.VRBT_EXPIRE_DT FROM PS_VRBT_HDR H , PS_VENDOR N WHERE H.VRBT_STATUS = 'A' AND H.VENDOR_SETID = N.SETID AND H.VENDOR_ID = N.VENDOR_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 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
Prompt Table:
VENDOR_PO_VW
|
| 5 | VENDOR_NAME_SHORT | Character(14) | VARCHAR2(14) NOT NULL | Short Vendor Name |
| 6 | VRBT_REFERENCE | Character(30) | VARCHAR2(30) NOT NULL | Vendor Rebate Reference |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | VRBT_BEGIN_DT | Date(10) | DATE NOT NULL | Vendor Rebate Agreement Begin Date |
| 9 | VRBT_EXPIRE_DT | Date(10) | DATE | Vendor Rebate Agreement Expire Date |