FCST_EFT_DST (SQL View)	Index Back
EFT Destination Amount View pulls amounts (reverses sign) from Cash Flow Table for Destination Bank on EFT Transfers

FCST_EFT_DST

(SQL View)

EFT Destination Amount

View pulls amounts (reverses sign) from Cash Flow Table for Destination Bank on EFT Transfers

SELECT A.BUSINESS_UNIT , A.TR_SOURCE_ID , A.TR_SOURCE_CD , A.BNK_ID_NBR , A.BANK_ACCOUNT_NUM , D.SETID , D.BANK_CD , D.BANK_ACCT_KEY , B.AMOUNT , B.CURRENCY_CD , C.DRAWDOWN_FLG , B.PYMNT_METHOD , B.BUSINESS_DATE , B.ACCT_BUS_UNIT_GL FROM PS_TR_WR_DETAIL A , PS_CASH_FLOW_TR B , PS_TR_WR_HEADER C , PS_BNK_NON_KEYS_V2 D WHERE A.BUSINESS_UNIT = B.SOURCE_BUS_UNIT AND A.TR_SOURCE_ID = B.TR_SOURCE_ID AND A.TR_SOURCE_CD = B.TR_SOURCE_CD AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.TR_SOURCE_ID = C.TR_SOURCE_ID AND D.BNK_ID_NBR = A.BNK_ID_NBR AND D.BANK_ACCOUNT_NUM = A.BANK_ACCOUNT_NUM

# 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

4 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.

5 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.

6 SETID Character(5) VARCHAR2(5) NOT NULL SetID

7 TO_BANK_CD Character(5) VARCHAR2(5) NOT NULL To Bank Code for Bank Transfers on Destination Page of Transfer Template

8 TO_BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL To Bank Account on the Destination Page of Transfer Templates

9 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

11 DRAWDOWN_FLG Character(1) VARCHAR2(1) NOT NULL Drawdown Transfer Flag, either yes or no.
N=No
Y=Yes

12 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

13 BUSINESS_DATE Date(10) DATE Represents a date upon which business is conducted within a given company in a given country.

14 ACCT_BUS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL The general ledger business unit associated with a given bank/counterparty account.

#	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
4	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
5	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
6	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
7	TO_BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	To Bank Code for Bank Transfers on Destination Page of Transfer Template
8	TO_BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	To Bank Account on the Destination Page of Transfer Templates
9	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
10	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
11	DRAWDOWN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Drawdown Transfer Flag, either yes or no. N=No Y=Yes
12	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
13	BUSINESS_DATE	Date(10)	DATE	Represents a date upon which business is conducted within a given company in a given country.
14	ACCT_BUS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	The general ledger business unit associated with a given bank/counterparty account.