VAT_DF_VCS_TMP (SQL Table)	Index Back
VAT Code Defaulting Temp Table

VAT_DF_VCS_TMP

(SQL Table)

VAT Code Defaulting Temp Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

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

3 STATE Character(6) VARCHAR2(6) NOT NULL State

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

5 PROD_SETID Character(5) VARCHAR2(5) NOT NULL Product SetID

6 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

7 EFFDT Date(10) DATE Effective Date

8 CUSTOMER_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID

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

10 VAT_APPLICABLE Character(1) VARCHAR2(1) NOT NULL VAT Applicable
E=Exempt
O=Outside of Scope of VAT
T=Taxable

11 TAX_CD_VAT Character(8) VARCHAR2(8) NOT NULL Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
3	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
4	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
5	PROD_SETID	Character(5)	VARCHAR2(5) NOT NULL	Product SetID
6	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
7	EFFDT	Date(10)	DATE	Effective Date
8	CUSTOMER_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
9	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.
10	VAT_APPLICABLE	Character(1)	VARCHAR2(1) NOT NULL	VAT Applicable E=Exempt O=Outside of Scope of VAT T=Taxable
11	TAX_CD_VAT	Character(8)	VARCHAR2(8) NOT NULL	Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.