VAT_REV_AET

(SQL Table)
Index Back

VAT_REV_AET

State Record added for VAT Reverse Chage Defaulting.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 VAT_SUBJ_RVRSE_CHG Character(1) VARCHAR2(1) NOT NULL Domestic Reverse Charge
N=No
Y=Yes
3 VAT_RVRSE_CHG_FLG Character(1) VARCHAR2(1) NOT NULL Domestic Reverse Charge Flag
4 VAT_TREATMENT Character(4) VARCHAR2(4) NOT NULL VAT Treatment
5 COUNTRY_SHIP_TO Character(3) VARCHAR2(3) NOT NULL Specifies the country to which the invoice contents were shipped (for VAT processing only).
6 COUNTRY_SHIP_FROM Character(3) VARCHAR2(3) NOT NULL Specifies the country from which the invoice contents were shipped (for VAT processing only).
7 COUNTRY_VAT_BILLTO Character(3) VARCHAR2(3) NOT NULL Specifies the country where an invoice is sent (for VAT processing only).
8 COUNTRY_VAT_BILLFR Character(3) VARCHAR2(3) NOT NULL Specifies the country where an invoice is generated (for VAT processing only).
9 DROP_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Drop Ship
N=No
Y=Yes
10 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
11 TAX_CD_VAT_RVC Character(8) VARCHAR2(8) NOT NULL Reverse Charge VAT Code
12 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services
13 COUNTRY_VAT_SHIPTO Character(3) VARCHAR2(3) NOT NULL Ship To VAT Rgstrn Country