VAT_DF_VTP_TMP

(SQL Table)
Index Back

VAT Treatment Default Temp

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 COUNTRY_SHIP_TO Character(3) VARCHAR2(3) NOT NULL Specifies the country to which the invoice contents were shipped (for VAT processing only).
3 COUNTRY_SHIP_FROM Character(3) VARCHAR2(3) NOT NULL Specifies the country from which the invoice contents were shipped (for VAT processing only).
4 COUNTRY_VAT_BILLTO Character(3) VARCHAR2(3) NOT NULL Specifies the country where an invoice is sent (for VAT processing only).
5 COUNTRY_VAT_BILLFR 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