PV_RTV_FILTER(SQL Table) |
Index Back |
|---|---|
RTV Search Criteria8/30/07 - JK - Added Record Description. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PM_NONVW |
| 2 | RTV_ID | Character(10) | VARCHAR2(10) NOT NULL | Return To Vendor ID |
| 3 | BUYER_ID | Character(30) | VARCHAR2(30) NOT NULL |
Buyer
Prompt Table: BUYER_ACTIVE_VW |
| 4 | RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 5 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 6 | PV_RTV_FILTERBY | Character(3) | VARCHAR2(3) NOT NULL |
Show Status
A=All C=Closed O=Open S=Shipped X=Cancelled Default Value: A |
| 7 | PV_RTV_SORTBY | Character(3) | VARCHAR2(3) NOT NULL |
Sort By
ID=Receipt ID RTV=Return To Vendor (Supplier) ID VND=Supplier Default Value: RTV |