TR_ONBEHALF_VW

(SQL View)
 Index Back

SELECT S.TREAS_MAST_SUB_BU , S.TREAS_MAST_SUB_ID , S.BUSINESS_UNIT , S.TREAS_HEADER_ID , S.COUNTERPARTY , S.INSTRUMENT_TYPE , S.TRANSACTION_DT , D.TRANSACTION_AMT FROM PS_TRX_HEADER_TR S , PS_TRX_DETAIL_TR D WHERE D.BUSINESS_UNIT = S.BUSINESS_UNIT AND D.TREAS_HEADER_ID = S.TREAS_HEADER_ID AND D.TRANSACTION_LINE = 1 AND (S.TREAS_MAST_SUB_BU = S.BUSINESS_UNIT OR S.TREAS_MAST_SUB_BU = ' ') AND (S.TREAS_MAST_SUB_ID = S.TREAS_HEADER_ID OR S.TREAS_MAST_SUB_ID = ' ') AND S.DEAL_STATUS = '03'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TREAS_MAST_SUB_BU Character(5) VARCHAR2(5) NOT NULL The business unit of the Treasury unit who controls a group of internal deals, soem of which may have different business units.
2 TREAS_MAST_SUB_ID Character(12) VARCHAR2(12) NOT NULL This field contains the first deal id in a series of deals that are related for interunit dealing, on behalf dealing, or deals between subsidiaries.
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_TRD_NONVW

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

Prompt Table: TRX_HEADER_TR

5 COUNTERPARTY Character(5) VARCHAR2(5) NOT NULL Represents a treasury dealing counterpart.

Prompt Table: BANK_TR_CPTY_VW

6 INSTRUMENT_TYPE Character(10) VARCHAR2(10) NOT NULL Instrument type

Prompt Table: %EDITTABLE

7 TRANSACTION_DT Date(10) DATE Transaction date (often used as trade date)
8 TRANSACTION_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL The nominal or actual deal transaction amount.