TR_INTREST_D_VW(SQL View) |
Index Back |
---|---|
View over deals with resetlist 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 |