INSTR_AH_LNG_VW (SQL View)	Index Back
Instrumnt Ad-hoc Language View Related Language View for INSTR_ADHOC_VW Ad-hoc / User Defined "Catch All" Fields, with INSTRUMENT_LINE named TRANSACTION_LINE (to allow copy into Deal Capture panels, and use as Related Display)

INSTR_AH_LNG_VW

(SQL View)

Instrumnt Ad-hoc Language View

Related Language View for INSTR_ADHOC_VW Ad-hoc / User Defined "Catch All" Fields, with INSTRUMENT_LINE named TRANSACTION_LINE (to allow copy into Deal Capture panels, and use as Related Display)

select setid ,instrument_type ,instrument_line ,trx_adhoc_id ,language_cd ,shortname from PS_INSTR_ADHOC_LNG

Related Language Record for INSTR_ADHOC_VW

Parent record: INSTR_DETAIL_TR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SP_SETID_NONVW

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

3 TRANSACTION_LINE Number(3,0) SMALLINT NOT NULL The separate and distinct base instrument type components of a given deal transaction.

4 TRX_ADHOC_ID Character(5) VARCHAR2(5) NOT NULL A unique key identifier that represents the use of free form attribute fields that may be associat

5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

6 SHORTNAME Character(15) VARCHAR2(15) NOT NULL Field Short Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
2	INSTRUMENT_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Instrument type
3	TRANSACTION_LINE	Number(3,0)	SMALLINT NOT NULL	The separate and distinct base instrument type components of a given deal transaction.
4	TRX_ADHOC_ID	Character(5)	VARCHAR2(5) NOT NULL	A unique key identifier that represents the use of free form attribute fields that may be associat
5	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
6	SHORTNAME	Character(15)	VARCHAR2(15) NOT NULL	Field Short Name