TR_WR_INTERM (SQL Table)	Index Back
TR Wire Intermediate Routing Treasury Wire Intermediate Bank Routing Table This record is a child of TR_WR_DETAIL. It contains the Intermediate Bank Routing Table of how to get funds from one bank to another if there is no direct route.

TR_WR_INTERM

(SQL Table)

TR Wire Intermediate Routing

Treasury Wire Intermediate Bank Routing Table This record is a child of TR_WR_DETAIL. It contains the Intermediate Bank Routing Table of how to get funds from one bank to another if there is no direct route.

Parent record: TR_WR_DETAIL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 TR_SOURCE_ID Character(12) VARCHAR2(12) NOT NULL An internal work field that represents a unique identifier for records depicting a given treasury po

3 TR_SOURCE_CD Character(1) VARCHAR2(1) NOT NULL Note: Changes to Translate Values must also be made to TRA_SOURCE_CD and SOURCE_TYPE. These 3 fields must be kept in sync. Values that are inactive are for use in TR Accounting only
B=BSP
D=Deals
E=Deal Fees
F=Facility Fees
H=Hedges
I=Interest
M=Deal: Estimated Maturity Accr
N=Netted Deal
O=Other
P=Investment Pools
R=EFT Fees
S=Securities
T=LC Fees
W=EFT Requests
X=Bank Transfers
Default Value: W

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

5 CASH_FLOW_LINE Number(15,0) DECIMAL(15) NOT NULL A sequential number that indicates the time order sequence of a given deal transaction's cash flows.
Default Value: 1

6 CASH_FLOW_LEG Number(1,0) SMALLINT NOT NULL A sequential number that indicates the relationship between a cash flow and its corresponding deal transaction leg
Default Value: 1

7 INTRMED_BANK_CD Character(5) VARCHAR2(5) NOT NULL The intermediary transit bank utilized for multibank settlements.
Prompt Table: BNK_CD_CORP_VW

8 INTRMED_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL The intermediary transit bank account utilized for multibank settlements.
Prompt Table: BNK_ACT_ICOR_VW

9 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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	TR_SOURCE_ID	Character(12)	VARCHAR2(12) NOT NULL	An internal work field that represents a unique identifier for records depicting a given treasury po
3	TR_SOURCE_CD	Character(1)	VARCHAR2(1) NOT NULL	Note: Changes to Translate Values must also be made to TRA_SOURCE_CD and SOURCE_TYPE. These 3 fields must be kept in sync. Values that are inactive are for use in TR Accounting only B=BSP D=Deals E=Deal Fees F=Facility Fees H=Hedges I=Interest M=Deal: Estimated Maturity Accr N=Netted Deal O=Other P=Investment Pools R=EFT Fees S=Securities T=LC Fees W=EFT Requests X=Bank Transfers Default Value: W
4	INTRMED_SEQ_NO	Number(3,0)	SMALLINT NOT NULL	A numeric value that sequentially identifiers the series of banks utilized for a given m
5	CASH_FLOW_LINE	Number(15,0)	DECIMAL(15) NOT NULL	A sequential number that indicates the time order sequence of a given deal transaction's cash flows. Default Value: 1
6	CASH_FLOW_LEG	Number(1,0)	SMALLINT NOT NULL	A sequential number that indicates the relationship between a cash flow and its corresponding deal transaction leg Default Value: 1
7	INTRMED_BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	The intermediary transit bank utilized for multibank settlements. Prompt Table: BNK_CD_CORP_VW
8	INTRMED_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	The intermediary transit bank account utilized for multibank settlements. Prompt Table: BNK_ACT_ICOR_VW
9	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
10	INTRMED_DFI_ID	Character(15)	VARCHAR2(15) NOT NULL	The intermediary bank DFI identifier.
11	INTRMED_PYMNT_MSG	Character(30)	VARCHAR2(30) NOT NULL	An internal work field that contains messaging associated with settlements subject to