TRX_DEALACCT_VW

(SQL View)
Index Back

Treasury Deal Accouting Prompt

Is this used anywhere? ///

select business_unit, treas_header_id, transaction_dt from PS_TRX_HEADER_TR where deal_status in ('03','04')

# 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

2 TREAS_HEADER_ID Character(12) VARCHAR2(12) NOT NULL The unique key identifier for a given deal transaction.
3 TRANSACTION_DT Date(10) DATE Transaction date (often used as trade date)