TRA_TMP_HDR_VW (SQL View)	Index Back
Treas. Acctg Templates Treasury Accounting Templates Header View. This view will have only Active templates

TRA_TMP_HDR_VW

(SQL View)

Treas. Acctg Templates

Treasury Accounting Templates Header View. This view will have only Active templates

SELECT SETID , ACCTG_TMPL_ID , DESCR60 , APPL_JRNL_ID , SOURCE_TYPE , TRA_REVIEW_STATUS , ACCTG_TMPL_STATUS , LAST_MAINT_DTTM , LAST_MAINT_OPRID , DOC_TYPE FROM PS_TRA_TMPL_HDR WHERE ACCTG_TMPL_STATUS = 'A'

# 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 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description

4 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template
Prompt Table: JRNLGEN_APPL_ID

5 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

6 TRA_REVIEW_STATUS Character(1) VARCHAR2(1) NOT NULL Allows the user to indicate that an accounting entry for a given accounting template is subject to
Y/N Table Edit
Default Value: N

7 ACCTG_TMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Accounting Template Status - Active/Inactive
A=Active
I=Inactive
Default Value: A

8 LAST_MAINT_DTTM DateTime(26) TIMESTAMP A system generated value that reflects the date and time a transaction was last modified

9 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID

10 DOC_TYPE Character(8) VARCHAR2(8) NOT NULL Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
Prompt Table: DOC_TYPE_TBL

#	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	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
4	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template Prompt Table: JRNLGEN_APPL_ID
5	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
6	TRA_REVIEW_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Allows the user to indicate that an accounting entry for a given accounting template is subject to Y/N Table Edit Default Value: N
7	ACCTG_TMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Accounting Template Status - Active/Inactive A=Active I=Inactive Default Value: A
8	LAST_MAINT_DTTM	DateTime(26)	TIMESTAMP	A system generated value that reflects the date and time a transaction was last modified
9	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID
10	DOC_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code. Prompt Table: DOC_TYPE_TBL