VAT_ALGO_TMP3

(SQL Table)
Index Back

VAT Algorithm temp table

VAT Algorithm temp table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COUNTRY_SHIP_TO Character(3) VARCHAR2(3) NOT NULL Specifies the country to which the invoice contents were shipped (for VAT processing only).

Prompt Table: COUNTRY_TBL

2 COUNTRY_SHIP_FROM Character(3) VARCHAR2(3) NOT NULL Specifies the country from which the invoice contents were shipped (for VAT processing only).
3 COUNTRY_VAT_BILLTO Character(3) VARCHAR2(3) NOT NULL Specifies the country where an invoice is sent (for VAT processing only).
4 DROP_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Drop Ship
N=No
Y=Yes
5 VAT_ENTITY Character(20) VARCHAR2(20) NOT NULL Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
6 COUNTRY_VAT_BILLFR Character(3) VARCHAR2(3) NOT NULL Specifies the country where an invoice is generated (for VAT processing only).
7 ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Error Flag
8 COUNTRY_VAT_RPTG Character(3) VARCHAR2(3) NOT NULL VAT Reporting Country
9 VAT_RPT_CNTRY_SRC Character(1) VARCHAR2(1) NOT NULL VAT Reporting Country Source
1=Ship From
2=Ship To
3=VAT Entity
4=Service Performed Country
5=Supplier Location Country
6=Buyer Location Country
7=Buyer VAT Registration Country