SETIDVENDOR_IDVNDR_LOCPROPNAMEPV_TPO_SUPP_VW(SQL View) |
Index Back |
|---|---|
Direct Connect Node ViewICE Res.# 862698 |
| SELECT C.SETID , C.VENDOR_ID , C.VNDR_LOC , A.MSGNODENAME , B.PV_NV_NAME , B.PV_NV_VALUE , A.DESCR , C.PV_TPO_NODE , D.ROUTINGDEFNNAME FROM PSMSGNODEDEFN A , PS_PV_MS_SUPP_NV B , PS_PV_MS_SUPPLIER C ,PSIBRTNGDEFN D WHERE A.MSGNODENAME=C.PV_TPO_NODE AND B.SETID=C.SETID AND B.PV_MS_SUP_TYPE=C.PV_MS_SUP_TYPE AND B.VENDOR_ID=C.VENDOR_ID AND B.VNDR_LOC=C.VNDR_LOC AND A.MSGNODENAME = D.RECEIVERNODENAME AND D.EFF_STATUS = 'A' AND A.ACTIVE_NODE='1' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 3 | VNDR_LOC |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 4 | MSGNODENAME | Character(30) | VARCHAR2(30) NOT NULL | Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN). |
| 5 | PROPNAME |
Character(30) | VARCHAR2(30) NOT NULL | Property Name |
| 6 | PROPVALUE | Character(254) | VARCHAR2(254) NOT NULL | Value |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | PV_TPO_NODE | Character(30) | VARCHAR2(30) NOT NULL | Transparent Punchout Node |
| 9 | ROUTINGDEFNNAME | Character(30) | VARCHAR2(30) NOT NULL | Routing Name |