TRX_HEADER_VW2

(SQL View)
Index Back

Treasury Header View

Treasury Header View that lists Treasury Header ID, Master ID and Previous ID by Unit.

SELECT business_unit , treas_master_id , treas_header_id , treas_previous_id , deal_status , transaction_dt FROM PS_TRX_HEADER_TR

# 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_MASTER_ID Character(12) VARCHAR2(12) NOT NULL Master ID for a given deal header.
3 TREAS_HEADER_ID Character(12) VARCHAR2(12) NOT NULL The unique key identifier for a given deal transaction.

Prompt Table: TRX_HEADER_TR

4 TREAS_PREVIOUS_ID Character(12) VARCHAR2(12) NOT NULL Previous ID for a given deal header for Partial Sell/Buy back.
5 DEAL_STATUS Character(2) VARCHAR2(2) NOT NULL Represents the specific state or point in the life cycle of a deal transaction.
01=Under Negotiation
02=Sample
03=Open
04=Matured
05=Deactivated
06=Rejected
07=Sold / Bought back
08=Forecasted
09=Partially Sold/Bought Back
6 TRANSACTION_DT Date(10) DATE Transaction date (often used as trade date)