PMT_INTRM_STG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PMT_MSG_ID	Character(15)	VARCHAR2(15) NOT NULL	Payment Message ID
2	PMT_SEQ_NUM	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
3	INTRMED_SEQ_NO	Number(3,0)	SMALLINT NOT NULL	A numeric value that sequentially identifiers the series of banks utilized for a given m
4	STL_ROUTING_METHOD	Character(2)	VARCHAR2(2) NOT NULL	The routing approach assigned to a given bank/counterparty and account for settlement purposes. 01=DFI ID 02=Bank Account
5	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 Prompt Table: BNK_RCN_MTHD_VW
6	INTRM_DFI_ID_QUAL	Character(2)	VARCHAR2(2) NOT NULL	A banking industry convention identifier utilized to drive data validation for a given bank/counterparty. 01=Transit Number 02=Swift ID 03=CHIPS Participant ID 04=Canadian Bank Branch/Institute 05=CHIPS Universal ID ZZ=Mutually Defined
7	INTRMED_DFI_ID	Character(15)	VARCHAR2(15) NOT NULL	The intermediary bank DFI identifier.
8	INTRMED_PYMNT_MSG	Character(30)	VARCHAR2(30) NOT NULL	An internal work field that contains messaging associated with settlements subject to
9	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
10	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
11	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
12	FROM_BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	From Bank ID Number
13	FROM_BNK_ACCT_NUM	Character(35)	VARCHAR2(35) NOT NULL	From Bank Account #
14	FROM_DFI_ID_NUM	Character(12)	VARCHAR2(12) NOT NULL	A banking industry convention identifier utilized to drive electronic settlements processing for a given bank/coun
15	FROM_DFI_ID_QUAL	Character(2)	VARCHAR2(2) NOT NULL	A banking industry convention identifier utilized to drive data validation for a given bank/counterparty. 01=Transit Number 02=Swift ID 03=CHIPS Participant ID 04=Canadian Bank Branch/Institute 05=CHIPS Universal ID ZZ=Mutually Defined