TR_MTM_BATCH_H (SQL View)	Index Back
MTM BAtch Proc.Treasury Header Treasury Deals header view for MTM Batch processing

TR_MTM_BATCH_H

(SQL View)

MTM BAtch Proc.Treasury Header

Treasury Deals header view for MTM Batch processing

SELECT a.BUSINESS_UNIT, a.INSTRUMENT_TYPE, a.COUNTERPARTY, a.treasury_portfolio from PS_TRX_HEADER_TR a

# 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_GL_NONVW

2 INSTRUMENT_TYPE Character(10) VARCHAR2(10) NOT NULL Instrument type
Prompt Table: INSTR_INST_H_VW

3 COUNTERPARTY Character(5) VARCHAR2(5) NOT NULL Represents a treasury dealing counterpart.
Prompt Table: BANK_TR_CPTY_VW

4 TREASURY_PORTFOLIO Character(15) VARCHAR2(15) NOT NULL A unique key identifier for a position portfolio that may be associated with a given deal transaction.

#	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_GL_NONVW
2	INSTRUMENT_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Instrument type Prompt Table: INSTR_INST_H_VW
3	COUNTERPARTY	Character(5)	VARCHAR2(5) NOT NULL	Represents a treasury dealing counterpart. Prompt Table: BANK_TR_CPTY_VW
4	TREASURY_PORTFOLIO	Character(15)	VARCHAR2(15) NOT NULL	A unique key identifier for a position portfolio that may be associated with a given deal transaction.