COUNTRYL=Local Tax ID
V=VAT Registration ID
L=Local
N=None
V=VAT
ORDENT_VTCNT_VW(SQL View) |
Index Back |
|---|---|
Order VAT Country Vw |
| SELECT CVT.COUNTRY , CT.DESCR , CVT.VAT_SUSPENSION_FLG , CVT.VAT_CNTRY_SUBD_FLG , CVT.VAT_RTRN_ID_TYPE , CVT.VAT_ESL_ID_TYPE FROM PS_COUNTRY_VAT_TBL CVT , PS_COUNTRY_TBL CT WHERE CT.COUNTRY = CVT.COUNTRY |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Country |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | VAT_SUSPENSION_FLG | Character(1) | VARCHAR2(1) NOT NULL | Use VAT Suspension |
| 4 | VAT_CNTRY_SUBD_FLG | Character(1) | VARCHAR2(1) NOT NULL | Track VAT by XXXXXXXXXXXXXXXXX |
| 5 | VAT_RTRN_ID_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
VAT Return ID Type
L=Local Tax ID V=VAT Registration ID |
| 6 | VAT_ESL_ID_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
EC Sales List ID Type
L=Local N=None V=VAT |