INSTR_ACTMPL_VW (SQL View)	Index Back
Instr Acctg Event copying view Used when a view over instr_acctgtmpl is needed, but without PeopleCode and with instrument_type and instrument_line renamed to instrmnt_~ so they don't get copied with CopyFields()

INSTR_ACTMPL_VW

(SQL View)

Instr Acctg Event copying view

Used when a view over instr_acctgtmpl is needed, but without PeopleCode and with instrument_type and instrument_line renamed to instrmnt_~ so they don't get copied with CopyFields()

select setid ,instrument_type ,instrument_line ,tra_actg_treatment ,acctg_event_type ,acctg_tmpl_id ,acctg_tmpl_id_leg2 ,do_accounting ,do_accounting_leg2 from PS_INSTR_ACCTGTMPL

Parent record: INSTR_DETAIL_TR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 INSTRMNT_SELECTION Character(10) VARCHAR2(10) NOT NULL Internal work record field that facilitates complex instrument processing.

3 INSTRUMENT_LINE Number(3,0) SMALLINT NOT NULL A sequential number that identifies each instrument base type defined within a given instrument.

4 TRA_ACTG_TREATMENT Character(2) VARCHAR2(2) NOT NULL Treasury Deal Accounting Treatment. Edit Translates on this field to alter the Accounting Treatments available. (Not quite a control table, but as good as it gets!)
01=Held to Maturity
02=Available for Sale
03=Trading
04=Other
05=Loans and Receivables

5 ACCTG_EVENT_TYPE Character(2) VARCHAR2(2) NOT NULL Accounting types for deal capture and hedging

6 ACCTG_TMPL_ID Character(15) VARCHAR2(15) NOT NULL A unique key identifier that represents a predefined accounting template, that is a set of rules used to generate debits and credits.
Prompt Table: TRA_DEAL_TPL_VW

7 ACCTG_TMPL_ID_LEG2 Character(15) VARCHAR2(15) NOT NULL An unique key identifier that represents a pro forma accounting template for the sec
Prompt Table: TRA_DEAL_TPL_VW

8 DO_ACCOUNTING Character(1) VARCHAR2(1) NOT NULL Allows the user to indicate that treasury accounting is to be generated for transaction events associated with a deal or hedge

9 DO_ACCOUNTING_LEG2 Character(1) VARCHAR2(1) NOT NULL Allows the user to indicate that treasury accounting is to be generated for the second le

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	INSTRMNT_SELECTION	Character(10)	VARCHAR2(10) NOT NULL	Internal work record field that facilitates complex instrument processing.
3	INSTRUMENT_LINE	Number(3,0)	SMALLINT NOT NULL	A sequential number that identifies each instrument base type defined within a given instrument.
4	TRA_ACTG_TREATMENT	Character(2)	VARCHAR2(2) NOT NULL	Treasury Deal Accounting Treatment. Edit Translates on this field to alter the Accounting Treatments available. (Not quite a control table, but as good as it gets!) 01=Held to Maturity 02=Available for Sale 03=Trading 04=Other 05=Loans and Receivables
5	ACCTG_EVENT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Accounting types for deal capture and hedging
6	ACCTG_TMPL_ID	Character(15)	VARCHAR2(15) NOT NULL	A unique key identifier that represents a predefined accounting template, that is a set of rules used to generate debits and credits. Prompt Table: TRA_DEAL_TPL_VW
7	ACCTG_TMPL_ID_LEG2	Character(15)	VARCHAR2(15) NOT NULL	An unique key identifier that represents a pro forma accounting template for the sec Prompt Table: TRA_DEAL_TPL_VW
8	DO_ACCOUNTING	Character(1)	VARCHAR2(1) NOT NULL	Allows the user to indicate that treasury accounting is to be generated for transaction events associated with a deal or hedge
9	DO_ACCOUNTING_LEG2	Character(1)	VARCHAR2(1) NOT NULL	Allows the user to indicate that treasury accounting is to be generated for the second le