SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
ACCTG_TMPL_IDPrompt Table: TRA_TMPL_HDR
SOURCE_TYPEB=BSP
D=Deals
F=Fees
H=Hedge Accounting
I=Interest
P=Investment Pools
W=EFT Requests
TRA_TMPL_HDR_VW(SQL View) |
Index Back |
|---|---|
TR Acctg Template Header ViewView over Treasury Accounting Template Header. |
| SELECT SETID , ACCTG_TMPL_ID , SOURCE_TYPE FROM PS_TRA_TMPL_HDR |
| # | 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 | 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_TMPL_HDR |
| 3 | SOURCE_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Categorizes Treasury Accounting Templates according to the type of transaction they process (badly named field). Keep this field in sync with TR_SOURCE_CD and TRA_SOURCE_CD.
01/11/99 - CMH - Removed 'A' from XLAT, will use 'W' for TR Wires
11/20/99 - MC - Added 'H' for Hedge Accounting
06/29/00 - RV - Changed 'F' to Fees. Fees now cover Deal Fees, LC
Fees, Facility Fees, etc.
09/08/00 - RV - Changed Treasury Wires to EFT Requests.
07/15/04 - SD - Added 'P' for Investment Pools
B=BSP D=Deals F=Fees H=Hedge Accounting I=Interest P=Investment Pools W=EFT Requests |