TRA_TMPL_VAT_VW (SQL View)	Index Back
Treas. Acctg Templates Header 12/05/2001:CMH:Changed record SETCNTRLFLD='BUSINESS_UNIT' 01/20/2003:CMH:Modified for new VAT defaults

TRA_TMPL_VAT_VW

(SQL View)

Treas. Acctg Templates Header

12/05/2001:CMH:Changed record SETCNTRLFLD='BUSINESS_UNIT' 01/20/2003:CMH:Modified for new VAT defaults

SELECT A.SETID ,A.ACCTG_TMPL_ID ,A.DESCR60 FROM PS_TRA_TMPL_HDR A WHERE A.SOURCE_TYPE = 'F' AND A.ACCTG_TMPL_STATUS = 'A' AND EXISTS ( SELECT 'X' FROM PS_TRA_TMPL_DETL B WHERE B.SETID = A.SETID AND B.ACCTG_TMPL_ID = A.ACCTG_TMPL_ID AND B.VAT_TR_FLG = 'Y')

Related Language Record: TRA_TMPL_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
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