COUNTRY_VAT_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
2	VAT_RVRSE_CHG_FLG	Character(1)	VARCHAR2(1) NOT NULL	Domestic Reverse Charge Flag Y/N Table Edit Default Value: N
3	VAT_SUSPENSION_FLG	Character(1)	VARCHAR2(1) NOT NULL	Use VAT Suspension Y/N Table Edit Default Value: N
4	VAT_CNTRY_SUBD_FLG	Character(1)	VARCHAR2(1) NOT NULL	Track VAT by XXXXXXXXXXXXXXXXX Y/N Table Edit Default Value: N
5	VAT_RTRN_ID_TYPE	Character(1)	VARCHAR2(1) NOT NULL	VAT Return ID Type L=Local Tax ID V=VAT Registration ID Default Value: V
6	VAT_ESL_ID_TYPE	Character(1)	VARCHAR2(1) NOT NULL	EC Sales List ID Type L=Local N=None V=VAT Default Value: N
7	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
8	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time Default Value: %datetime
9	VAT_EXPRT_SVC_FLG	Character(1)	VARCHAR2(1) NOT NULL	VAT Exported Services Flag 0=Zero-Rate 1=Outside Default Value: 0
10	VAT_DEXPRT_SVC_FLG	Character(1)	VARCHAR2(1) NOT NULL	VAT Deemed Exported Services Flag: Treat Services Performed Domestically for a Foreign Buyer As: Deemed Export Domestic 0=Export 1=Domestic Default Value: 1
11	VAT_IMP_GOODS_FLG	Character(1)	VARCHAR2(1) NOT NULL	VAT Imported Goods Flag Record VAT on Imported Goods As: Zero-rated Input VAT Only Input and Output VAT 0=Input Only 1=Input/Output Default Value: 0
12	VAT_AUTHORITY	Character(30)	VARCHAR2(30) NOT NULL	VAT Authority Name
13	DESCR_SHORT	Character(15)	VARCHAR2(15) NOT NULL	Short Name