VAT_APPLICABILITYE=Exempt
N=Not Applicable
O=Outside of Scope of VAT
S=Suspended
T=Taxable
V=VAT Only
X=Exonerated
LANGUAGE_CDTRV_VAT_APPL_LG(SQL View) |
Index Back |
|---|---|
Treasury VAT RL dropdown list |
| SELECT %Substring(A.FIELDVALUE,1,1) ,C.LANGUAGE_CD ,C.XLATSHORTNAME ,C.XLATLONGNAME FROM PSXLATITEM A , PSXLATITEMLANG C 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' AND A.FIELDNAME = C.FIELDNAME AND A.FIELDVALUE = C.FIELDVALUE AND A.EFFDT = C.EFFDT |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | XLATSHORTNAME | Character(10) | VARCHAR2(10) NOT NULL | Translate Value Short Name |
| 4 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |