TR_CM_FILTER_VW (SQL View)	Index Back
TRA Acctg Entry Summary View View of TRA_ACCTG_HDR and TRA_ACCTG_LINE for the Accounting Entry Summary Inquiry Panel.

TR_CM_FILTER_VW

(SQL View)

TRA Acctg Entry Summary View

View of TRA_ACCTG_HDR and TRA_ACCTG_LINE for the Accounting Entry Summary Inquiry Panel.

SELECT A.BUSINESS_UNIT , A.ACCOUNTING_ID , A.TRA_SOURCE_CD , A.EVENT_ID , A.ACCOUNTING_DT FROM PS_TRA_ACCTG_HDR A WHERE A.ACCTG_STATUS = 'P'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 ACCOUNTING_ID Character(10) VARCHAR2(10) NOT NULL Represents the unique alphanumeric identifier for treasury-specific accounting entries.

3 TRA_SOURCE_CD Character(1) VARCHAR2(1) NOT NULL Note: Changes to Translate Values must also be made to TR_SOURCE_CD and SOURCE_TYPE. These 3 fields must be kept in sync. Values that are inactive are for use in TR Cash Flows 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 EVENT_ID Character(20) VARCHAR2(20) NOT NULL The unique key identifier that enumerates Treasury accounting events. Accounting events are transaction events that have been created by the Treasury sources (deals, fees, bank transfers, EFTs, etc).

5 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	ACCOUNTING_ID	Character(10)	VARCHAR2(10) NOT NULL	Represents the unique alphanumeric identifier for treasury-specific accounting entries.
3	TRA_SOURCE_CD	Character(1)	VARCHAR2(1) NOT NULL	Note: Changes to Translate Values must also be made to TR_SOURCE_CD and SOURCE_TYPE. These 3 fields must be kept in sync. Values that are inactive are for use in TR Cash Flows 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	EVENT_ID	Character(20)	VARCHAR2(20) NOT NULL	The unique key identifier that enumerates Treasury accounting events. Accounting events are transaction events that have been created by the Treasury sources (deals, fees, bank transfers, EFTs, etc).
5	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple