TR_INTREST_D_VW

(SQL View)
Index Back

View over deals with reset

list of physical and notional deals that have a floating rate type

SELECT DISTINCT D.BUSINESS_UNIT , D.TREAS_HEADER_ID , H.DESCR150_MIXED FROM PS_TRX_HEADER_TR H , PS_TRX_DETAIL_TR D WHERE H.BUSINESS_UNIT = D.BUSINESS_UNIT AND H.TREAS_HEADER_ID = D.TREAS_HEADER_ID AND D.INSTRMNT_BASE_TYPE IN ('01','02')

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

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

Prompt Table: TR_INTREST_DEAL

3 DESCR150_MIXED Character(150) VARCHAR2(150) NOT NULL Description