STL_EFT_FRMT_VW

(SQL View)
 Index Back

EFT Format VW


SELECT CF.TR_SOURCE_CD ,CF.SOURCE_BUS_UNIT ,CF.TR_SOURCE_ID ,CF.BUSINESS_DATE ,CF.CASH_FLOW_LINE ,CF.CASH_FLOW_LEG ,CF.AMOUNT ,CF.CURRENCY_CD ,CF.BANK_SETID ,CF.BANK_CD_CUST ,CF.BANK_CD ,CF.BANK_ACCT_KEY ,CF.ACCT_BUS_UNIT_GL ,CF.PYMNT_METHOD ,CF.STL_THROUGH ,CF.PMTRUNINSTANCE ,CF.REPETITVE_TRNFR_CD ,CF.DRAWDOWN_FLG ,CF.PMT_FILE_ID ,B.FORMAT_ID ,C.CHUNK_CD FROM PS_STL_EFT_TRAN CF , PS_BANK_ACCT_MTHD B , PS_PMT_FORMAT_DEFN C WHERE CF.BANK_SETID=B.SETID AND CF.BANK_CD=B.BANK_CD AND CF.BANK_CD=B.BANK_CD_CPTY AND CF.BANK_ACCT_KEY=B.BANK_ACCT_KEY AND CF.PYMNT_METHOD=B.PYMNT_METHOD AND B.FORMAT_ID=C.FORMAT_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 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
2 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
3 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
4 BUSINESS_DATE Date(10) DATE Represents a date upon which business is conducted within a given company in a given country.
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.
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
7 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
9 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
10 BANK_CD_CUST Character(5) VARCHAR2(5) NOT NULL Represents the customer bank or counterparty in a relationship that pairs differing sets of b
11 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
12 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
13 ACCT_BUS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL The general ledger business unit associated with a given bank/counterparty account.
14 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
15 STL_THROUGH Character(2) VARCHAR2(2) NOT NULL Settle through
01=Financial Gateway
02=Pay Cycle
16 PMTRUNINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process ID
17 REPETITVE_TRNFR_CD Character(15) VARCHAR2(15) NOT NULL Repetitive Transfer Code assigned by customers Bank
18 DRAWDOWN_FLG Character(1) VARCHAR2(1) NOT NULL Drawdown Transfer Flag, either yes or no.
N=No
Y=Yes
19 PMT_FILE_ID Character(8) VARCHAR2(8) NOT NULL Payment File ID
20 FORMAT_ID Character(10) VARCHAR2(10) NOT NULL Format ID
21 CHUNK_CD Character(15) VARCHAR2(15) NOT NULL Grouping Rule