GLRCN_TRA_EFT

(SQL View)
Index Back

SELECT A.BUSINESS_UNIT , A.TR_SOURCE_ID ,C.TR_SOURCE_CD ,C.BUSINESS_DATE ,C.SEQ_NBR ,C.AMOUNT ,C.CURRENCY_CD ,C.PYMNT_METHOD ,C.PYMNT_SELCT_STATUS ,C.APPROVAL_FLG_TR ,E.ACCTG_EVENT_TYPE ,E.TRA_PROCESS_STATUS FROM ps_TR_WR_HEADER A , PS_CASH_FLOW_TR C , PS_TRA_EVENT_CAL E WHERE C.SOURCE_BUS_UNIT = E.BUSINESS_UNIT AND C.TR_SOURCE_CD = E.TR_SOURCE_CD AND C.TR_SOURCE_ID = E.EVENT_ID AND C.BUSINESS_DATE = E.EVENT_DT AND C.SEQ_NBR = E.SEQ_NBR AND A.BUSINESS_UNIT=C.SOURCE_BUS_UNIT AND A.TR_SOURCE_ID = C.TR_SOURCE_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_GL_NONVW

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

Prompt Table: TR_WR_HEADER

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 BUSINESS_DATE Date(10) DATE Represents a date upon which business is conducted within a given company in a given country.
5 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
6 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

8 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: STL_PYMT_MTHD_V

9 PYMNT_SELCT_STATUS Character(1) VARCHAR2(1) NOT NULL Payment Selection Status
C=Closed
D=Negative Voucher Sum
E=Externally Paid
F=Federal Sanctions Error
I=In Process - EFT
N=Not Selected for Payment
O=Financial Sanctions Review
P=Paid
R=Requested for Payment
S=Settlement Payment
V=Convert Error
X=Canceled
Y=Prepaid

Default Value: X

10 APPROVAL_FLG_TR Character(1) VARCHAR2(1) NOT NULL An internal work field that indicates that a given treasury transaction has been approved by
A=Approved
D=Denied
N=None Required
P=Pending Approval

Default Value: N

11 ACCTG_EVENT_TYPE Character(2) VARCHAR2(2) NOT NULL Accounting types for deal capture and hedging
12 TRA_PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL The processing status for a given accounting entry build.
A=Accruing
D=Deactivated
E=Error
I=In Process
N=Not Processed
P=Processed
T=Temporary Hold