GLRCN_TRA_BAX

(SQL View)

SELECT B.BUSINESS_UNIT , B.BAX_TRANSFER_ID , B.TRANSFER_TYPE ,B.AMOUNT ,B.CURRENCY_CD ,B.TRANSACTION_DT , C.APPROVAL_FLG_TR ,C.PYMNT_METHOD ,C.PYMNT_SELCT_STATUS ,E.TR_SOURCE_CD , E.ACCTG_EVENT_TYPE ,E.TRA_PROCESS_STATUS FROM PS_BAX_HEADER_TR B , PS_CASH_FLOW_TR C , PS_TRA_EVENT_CAL E WHERE C.TR_SOURCE_CD = E.TR_SOURCE_CD AND C.SOURCE_BUS_UNIT = E.BUSINESS_UNIT AND C.TR_SOURCE_ID = E.EVENT_ID AND C.BUSINESS_DATE = E.EVENT_DT AND CASH_FLOW_LEG = E.TRANSACTION_LEG AND C.BANK_CD = C.BANK_CD_CUST AND b.business_unit = C.SOURCE_BUS_UNIT AND B.BAX_TRANSFER_ID = C.TR_SOURCE_ID AND B.TRANSACTION_DT = C.BUSINESS_DATE AND C.PYMNT_SELCT_STATUS <> 'P'

# 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 BAX_TRANSFER_ID Character(12) VARCHAR2(12) NOT NULL An unique key identifier that represents a bank transfer transaction.
Prompt Table: BAX_HEADER_TR

3 TRANSFER_TYPE Character(2) VARCHAR2(2) NOT NULL Transfer Type
00=Internal Transfer
01=External Transfer

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

5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

6 TRANSACTION_DT Date(10) DATE NOT NULL Transaction date (often used as trade date)
Default Value: %DATE

7 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

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 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

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

#	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	BAX_TRANSFER_ID	Character(12)	VARCHAR2(12) NOT NULL	An unique key identifier that represents a bank transfer transaction. Prompt Table: BAX_HEADER_TR
3	TRANSFER_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Transfer Type 00=Internal Transfer 01=External Transfer
4	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
5	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
6	TRANSACTION_DT	Date(10)	DATE NOT NULL	Transaction date (often used as trade date) Default Value: %DATE
7	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
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	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
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