TR_INT_INTDT_VW (SQL View)	Index Back
Interest Dates for a Deal View over TRX_INTEREST_TR to get a list of interest dates

TR_INT_INTDT_VW

(SQL View)

Interest Dates for a Deal

View over TRX_INTEREST_TR to get a list of interest dates

SELECT I.BUSINESS_UNIT ,I.TREAS_HEADER_ID ,I.TRANSACTION_LINE ,I.INTEREST_DT FROM PS_TRX_INTEREST_TR I WHERE TRX_PAYMENT_TYPE = 'I'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 TREAS_HEADER_ID Character(12) VARCHAR2(12) NOT NULL The unique key identifier for a given deal transaction.

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

4 INTEREST_DT Date(10) DATE The business date for an interest period in a deal transaction.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	TREAS_HEADER_ID	Character(12)	VARCHAR2(12) NOT NULL	The unique key identifier for a given deal transaction.
3	TRANSACTION_LINE	Number(3,0)	SMALLINT NOT NULL	The separate and distinct base instrument type components of a given deal transaction.
4	INTEREST_DT	Date(10)	DATE	The business date for an interest period in a deal transaction.