PSRELATTRXDEL

index back

Relationship Transactions

Integration Broker Relationship Transactions

PeopleSoft Field Name Field Type Column Type Description
RELATIONSHIPID Character(30) VARCHAR2(30) NOT NULL Integration Broker Relationship ID (see PSRELATIONSHIP).
EFFDT Date(10) DATE NOT NULL Effective Date

Default: %date

SRCNODE Character(30) VARCHAR2(30) NOT NULL Integration Server Business Entity ID

Prompt Table: PSRELATNODEVW

SRCTRXTYPE Character(4) VARCHAR2(4) NOT NULL Integration Server Transaction Type
IA=Inbound Asynchronous
IS=Inbound Synchronous
OA=Outbound Asynchronous
OS=Outbound Synchronous

Default: IA

SRCRQSTMSGNAME Character(30) VARCHAR2(30) NOT NULL Integration Server Request Message Name

Prompt Table: PSRELATNTRXVW

SRCRQSTMSGVER Character(30) VARCHAR2(30) NOT NULL Integration Broker Source Request Message Version

Prompt Table: PSSRCMSGVERVW

TGTNODE Character(30) VARCHAR2(30) NOT NULL Integration Server Business Entity ID

Prompt Table: PSRELATNODEVW

TGTRQSTMSGNAME Character(30) VARCHAR2(30) NOT NULL Integration Server Request Message Name

Prompt Table: PSRELATNTRXVW

TGTRQSTMSGVER Character(30) VARCHAR2(30) NOT NULL Integration Broker Target Request Message Version

Prompt Table: PSTGTMSGVERVW

VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19