BUSINESS_UNIT_PORTV_IDRTV_HDR_INV_VW2(SQL View) |
Index Back |
|---|---|
RTV View of INV TransRTV Header view of INV related transactions. |
| SELECT A.BUSINESS_UNIT , A.RTV_ID , A.BUYER_ID , A.VENDOR_SETID , A.VENDOR_ID , A.CARRIER_ID FROM PS_RTV_HDR A WHERE A.RTV_STATUS = 'O' AND EXISTS ( SELECT 'X' FROM PS_RTV_LN B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.RTV_ID = B.RTV_ID AND B.INV_FLG = 'Y' AND B.RTV_INV_OPTION IN ('1', '2') AND B.RTV_INV_STAT <> '9' AND B.DISPOSITION_TYPE = '0') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_PO |
Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 2 | RTV_ID |
Character(10) | VARCHAR2(10) NOT NULL | Return To Vendor ID |
| 3 | BUYER_ID | Character(30) | VARCHAR2(30) NOT NULL | Buyer |
| 4 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 5 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 6 | CARRIER_ID | Character(10) | VARCHAR2(10) NOT NULL | Carrier ID |