VAT_ALGO_TMP1 (SQL Table)	Index Back
VAT Algorithm temp table VAT Algorithm temp table

VAT_ALGO_TMP1

(SQL 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 CUSTOMER_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID

4 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

5 ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Error Flag

6 COUNTRY_VAT_BILLTO Character(3) VARCHAR2(3) NOT NULL Specifies the country where an invoice is sent (for VAT processing only).

7 VAT_RGSTRN_BUYER Character(20) VARCHAR2(20) NOT NULL Specifies a customers VAT Registration ID for a particular country.

8 COUNTRY_VAT_TPRTNR Character(3) VARCHAR2(3) NOT NULL Trading Partner's VAT Registration Country. **** WARNING **** - This field has label ids of CUSTOMER, VENDOR, BANK. Do NOT delete these label ids. They are used to ensure the correct label is displayed on the common VAT subpages.

#	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	CUSTOMER_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
4	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
5	ERROR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Error Flag
6	COUNTRY_VAT_BILLTO	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country where an invoice is sent (for VAT processing only).
7	VAT_RGSTRN_BUYER	Character(20)	VARCHAR2(20) NOT NULL	Specifies a customers VAT Registration ID for a particular country.
8	COUNTRY_VAT_TPRTNR	Character(3)	VARCHAR2(3) NOT NULL	Trading Partner's VAT Registration Country. ** WARNING ** - This field has label ids of CUSTOMER, VENDOR, BANK. Do NOT delete these label ids. They are used to ensure the correct label is displayed on the common VAT subpages.