PYMNT_UFFEC_IN1 (SQL View)	Index Back
EDI Manager Pymt Intrmd Bank Payments view for DFI ID type intermediate bank information used for outbound payment file created through EDI manager PAYMENT map ID.

PYMNT_UFFEC_IN1

(SQL View)

EDI Manager Pymt Intrmd Bank

Payments view for DFI ID type intermediate bank information used for outbound payment file created through EDI manager PAYMENT map ID.

select A.PAY_CYCLE, A.PAY_CYCLE_SEQ_NUM, A.BANK_SETID, A.BANK_CD, A.BANK_ACCT_KEY, A.PYMNT_METHOD, C.INTRMED_PYMNT_MSG, C.INTRMED_DFI_ID, C.INTRMED_SEQ_NO from PS_PAYMENT_TBL A, PS_PYCYCL_DATA B, PS_BANK_ACCT_INTRM C where A.PAY_CYCLE = B.PAY_CYCLE and A.PAY_CYCLE_SEQ_NUM = B.PAY_CYCLE_SEQ_NUM and A.BANK_SETID = B.BANK_SETID and A.BANK_CD = B.BANK_CD and A.BANK_ACCT_KEY = B.BANK_ACCT_KEY and A.PYMNT_ID = B.PYMNT_ID and B.REMIT_BANK_SETID = C.SETID and B.REMIT_BANK_CD = C.BANK_CD and B.REMIT_BNK_ACCT_KEY = C.BANK_ACCT_KEY and A.PYMNT_METHOD = C.PYMNT_METHOD and C.INTRMED_DFI_ID <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL Pay Cycle

2 PAY_CYCLE_SEQ_NUM Number(6,0) INTEGER NOT NULL Pay Cycle Sequence Number

3 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.

4 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

5 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank

6 PYMNT_METHOD Character(3) VARCHAR2(3) NOT NULL Payment Method
ACH=Automated Clearing House
BEF=Draft - Customer EFT
BOO=Draft - Customer Initiated
CHK=System Check
D=Deposit
DD=Direct Debit
DFT=Draft - Supplier Initiated
DRA=Draft
EFT=Electronic Funds Transfer
GE=Giro - EFT
GM=Giro - Manual
LC=Letter of Credit
MAN=Manual Check
TRW=Treasury Wire
WIR=Wire Transfer

7 INTRMED_PYMNT_MSG Character(30) VARCHAR2(30) NOT NULL An internal work field that contains messaging associated with settlements subject to

8 INTRMED_DFI_ID Character(15) VARCHAR2(15) NOT NULL The intermediary bank DFI identifier.

9 INTRMED_SEQ_NO Number(3,0) SMALLINT NOT NULL A numeric value that sequentially identifiers the series of banks utilized for a given m

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PAY_CYCLE	Character(6)	VARCHAR2(6) NOT NULL	Pay Cycle
2	PAY_CYCLE_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Pay Cycle Sequence Number
3	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
4	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
5	BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	A user defined unique identifier that facilitates the identification of a given account with a given bank
6	PYMNT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Payment Method ACH=Automated Clearing House BEF=Draft - Customer EFT BOO=Draft - Customer Initiated CHK=System Check D=Deposit DD=Direct Debit DFT=Draft - Supplier Initiated DRA=Draft EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check TRW=Treasury Wire WIR=Wire Transfer
7	INTRMED_PYMNT_MSG	Character(30)	VARCHAR2(30) NOT NULL	An internal work field that contains messaging associated with settlements subject to
8	INTRMED_DFI_ID	Character(15)	VARCHAR2(15) NOT NULL	The intermediary bank DFI identifier.
9	INTRMED_SEQ_NO	Number(3,0)	SMALLINT NOT NULL	A numeric value that sequentially identifiers the series of banks utilized for a given m