TRX_DEALACCT_VW(SQL View) |
Index Back |
---|---|
Treasury Deal Accouting PromptIs 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) |