TRV_VAT_APPL_VW (SQL View)	Index Back
Treasury VAT dropdown list

TRV_VAT_APPL_VW

(SQL View)

Treasury VAT dropdown list

SELECT %Substring(A.FIELDVALUE,1,1) ,A.XLATSHORTNAME ,A.XLATLONGNAME FROM PSXLATITEM A WHERE A.FIELDNAME='VAT_APPLICABILITY' AND A.FIELDVALUE<>'S' AND A.FIELDVALUE<>'V' AND A.EFFDT=( SELECT MAX(EFFDT) FROM PSXLATITEM WHERE FIELDNAME=A.FIELDNAME AND FIELDVALUE=A.FIELDVALUE AND EFFDT<=%CurrentDateIn) AND A.EFF_STATUS='A'

Related Language Record: TRV_VAT_APPL_LG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 VAT_APPLICABILITY Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible.
E=Exempt
N=Not Applicable
O=Outside of Scope of VAT
S=Suspended
T=Taxable
V=VAT Only
X=Exonerated

2 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name

3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	VAT_APPLICABILITY	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible. E=Exempt N=Not Applicable O=Outside of Scope of VAT S=Suspended T=Taxable V=VAT Only X=Exonerated
2	XLATSHORTNAME	Character(10)	VARCHAR2(10) NOT NULL	Translate Value Short Name
3	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name