VAT_DF_VTP_TMP(SQL Table) |
Index Back |
|---|---|
VAT Treatment Default Temp |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
| 2 | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country to which the invoice contents were shipped (for VAT processing only). | |
| 3 | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country from which the invoice contents were shipped (for VAT processing only). | |
| 4 | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country where an invoice is sent (for VAT processing only). | |
| 5 | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country where an invoice is generated (for VAT processing only). | |
| 6 | VAT_TREATMENT | Character(4) | VARCHAR2(4) NOT NULL | VAT Treatment |
| 7 | VAT_RCRD_INPT_FLG | Character(1) | VARCHAR2(1) NOT NULL | A flag that indicates whether or not (Y or N) a business unit will pay the VAT and recover it later from the VAT tax authority. VAT input is usually associated with purchase transactions. |
| 8 | VAT_RCRD_OUTPT_FLG | Character(1) | VARCHAR2(1) NOT NULL | A flag that indicates whether or not (Y or N) VAT will be collected by the vendor on behalf of the government. VAT output is usually associated with sales transactions. |
| 9 | VAT_ERROR_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a VAT calculation error has been found. This field is maintained by the system.
N=No Error O=VAT Amount Calculation Error |
| 10 | IST_TXN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Intrastat Transaction Flag
N=No Y=Yes |
| 11 | DROP_SHIP_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Drop Ship
N=No Y=Yes |
| 12 | COUNTRY_VAT_SHIPTO | Character(3) | VARCHAR2(3) NOT NULL | Ship To VAT Rgstrn Country |