VAT_FLD_VW1_RLR (SQL View)	Index Back
VAT Report Criteria Flds - RLR

VAT_FLD_VW1_RLR

(SQL View)

VAT Report Criteria Flds - RLR

SELECT b.FIELDNAME , c.LANGUAGE_CD , c.LONGNAME , c.SHORTNAME FROM PSDBFLDLABL b , PSDBFLDLABLLANG c WHERE b.FIELDNAME IN ('TAX_CD_VAT','VAT_TXN_TYPE_CD', 'VAT_DST_ACCT_TYPE') AND b.DEFAULT_LABEL = 1 AND c.FIELDNAME = b.FIELDNAME AND c.LABEL_ID = b.LABEL_ID

Related Language Record for VAT_RPT_FLD_VW1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name

4 SHORTNAME Character(15) VARCHAR2(15) NOT NULL Field Short Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	LONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Long Name
4	SHORTNAME	Character(15)	VARCHAR2(15) NOT NULL	Field Short Name