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

VAT_ALGO_TMP2

(SQL Table)

VAT Algorithm temp table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EFFDT Date(10) DATE Effective Date

2 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

3 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.

4 VAT_EXCPTN_CERTIF Character(20) VARCHAR2(20) NOT NULL Specifies the VAT exception certificate number. This identifier serves as proof of customer's exemption from VAT.

5 VAT_EXCPTN_TYPE Character(1) VARCHAR2(1) NOT NULL A flag that specifies the reason for a VAT exemption for a customer. Suspension (S) and Exoneration (X) are examples of Exception Type.
N=None
S=Suspended
X=Exonerated

6 SETID Character(5) VARCHAR2(5) NOT NULL SetID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EFFDT	Date(10)	DATE	Effective Date
2	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
3	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.
4	VAT_EXCPTN_CERTIF	Character(20)	VARCHAR2(20) NOT NULL	Specifies the VAT exception certificate number. This identifier serves as proof of customer's exemption from VAT.
5	VAT_EXCPTN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	A flag that specifies the reason for a VAT exemption for a customer. Suspension (S) and Exoneration (X) are examples of Exception Type. N=None S=Suspended X=Exonerated
6	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID