EBICS_TGNODE_VW

(SQL View)
 Index Back

SELECT node.msgnodename AS ebics_tgnode , node.descr , rtng.routingdefnname , rtng.sendernodename , node.node_type , node.localnode FROM PSIBRTNGDEFN rtng , psmsgnodedefn node WHERE rtng.ib_operationname='EBICS_SERVICE_OPR' AND node.msgnodename = rtng.receivernodename AND node.active_node='1' AND rtng.eff_status = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EBICS_TGNODE Character(30) VARCHAR2(30) NOT NULL Target Node
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 ROUTINGDEFNNAME Character(30) VARCHAR2(30) NOT NULL Routing Name
4 SENDERNODENAME Character(30) VARCHAR2(30) NOT NULL Sender Node Name

Prompt Table: PSMSGNODEDEFN

5 NODE_TYPE Character(4) VARCHAR2(4) NOT NULL Node Type
EX=External
ICT=Pre-PeopleTools 8.4
PIA=PeopleSoft

Default Value: PIA

6 LOCALNODE Number(1,0) SMALLINT NOT NULL Indicates if a Message Node is the local message node

Default Value: 0