FCST_EFT_SRC(SQL View) |
Index Back |
|---|---|
EFT Source AmountView pulls amounts from Cash Flow Table for Source Bank on EFT Transfers |
| SELECT A.BUSINESS_UNIT , A.TR_SOURCE_ID , A.TR_SOURCE_CD , B.BNK_ID_NBR , B.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 = B.BNK_ID_NBR AND D.BANK_ACCOUNT_NUM = B.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 | FROM_BNK_ID_NBR | Character(20) | VARCHAR2(20) NOT NULL | From Bank ID Number |
| 5 | FROM_BNK_ACCT_NUM | Character(35) | VARCHAR2(35) NOT NULL | From Bank Account # |
| 6 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 7 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 8 | 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 |
| 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. |