VAT_REV_AET(SQL Table) |
Index Back |
|---|---|
VAT_REV_AETState 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 |