INSTR_ACCTGTMPL(SQL Table) |
Index Back |
|---|---|
Instrument Acctg Event Type |
| # | 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 | INSTRUMENT_TYPE |
Character(10) | VARCHAR2(10) NOT NULL | Instrument type |
| 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
Y/N Table Edit Default Value: N |
| 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
Y/N Table Edit Default Value: N |