TRX_ROLL_VW

(SQL View)
Index Back

View linking rolled deals


SELECT BUSINESS_UNIT ,TREAS_BACK_ROLL_ID ,TREAS_HEADER_ID FROM PS_TRX_HEADER_TR WHERE TREAS_BACK_ROLL_ID <> ' '

# 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_BACK_ROLL_ID Character(12) VARCHAR2(12) NOT NULL This fields contains the first deal id in a series of deals that are related for deal rolling forward.
3 TREAS_HEADER_ID Character(12) VARCHAR2(12) NOT NULL The unique key identifier for a given deal transaction.

Default Value: NEXT

Prompt Table: TRX_HEADER_TR