PYMNT_UFFEC_CON (SQL View)	Index Back
EDI Manager Pymt Bank Contact Payments view for internal bank contac tperson used for outbound payment file created through EDI manager PAYMENT map ID.

PYMNT_UFFEC_CON

(SQL View)

EDI Manager Pymt Bank Contact

Payments view for internal bank contac tperson 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, B.NAME, B.PHONE from PS_PYMNT_UFFEC_STG A, PS_TR_CONTACT_TBL B, PS_BANK_ACCT_CNTCT C where C.SETID = A.BANK_SETID and C.BANK_CD = A.BANK_CD and C.BANK_ACCT_KEY = A.BANK_ACCT_KEY and C.SETID = B.SETID and C.CONTACT_ID = B.CONTACT_ID and B.CONTACT_TYPE = 'I'

# 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 NAME Character(50) VARCHAR2(50) NOT NULL Name

8 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone

#	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	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
8	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone