TRV_VAT_TXN_VW (SQL View)	Index Back
Distinct TR VAT Transactions View over TRV_VAT_TRAN of distinct key structures.

TRV_VAT_TXN_VW

(SQL View)

Distinct TR VAT Transactions

View over TRV_VAT_TRAN of distinct key structures.

SELECT DISTINCT BUSINESS_UNIT ,TR_SOURCE_CD ,EVENT_ID ,TRANSACTION_DT ,TRANSACTION_LINE ,SEQ_NBR ,TRANSACTION_LEG ,ACCTG_EVENT_TYPE ,BANK_ACCOUNT_NUM ,TRAN_REF_ID FROM PS_TRV_VAT_TRAN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 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

3 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).

4 TRANSACTION_DT Date(10) DATE Transaction date (often used as trade date)

5 TRANSACTION_LINE Number(3,0) SMALLINT NOT NULL The separate and distinct base instrument type components of a given deal transaction.

6 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

7 TRANSACTION_LEG Number(1,0) SMALLINT NOT NULL The separate and distinct business positions of a given deal transaction line.
1=Pay Leg
2=Receive Leg

8 ACCTG_EVENT_TYPE Character(2) VARCHAR2(2) NOT NULL Accounting types for deal capture and hedging

9 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.

10 TRAN_REF_ID Character(20) VARCHAR2(20) NOT NULL Represents the unique transaction identifier in bank reconciliation processing.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	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
3	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).
4	TRANSACTION_DT	Date(10)	DATE	Transaction date (often used as trade date)
5	TRANSACTION_LINE	Number(3,0)	SMALLINT NOT NULL	The separate and distinct base instrument type components of a given deal transaction.
6	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
7	TRANSACTION_LEG	Number(1,0)	SMALLINT NOT NULL	The separate and distinct business positions of a given deal transaction line. 1=Pay Leg 2=Receive Leg
8	ACCTG_EVENT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Accounting types for deal capture and hedging
9	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
10	TRAN_REF_ID	Character(20)	VARCHAR2(20) NOT NULL	Represents the unique transaction identifier in bank reconciliation processing.