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

VAT_DF_VCP_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 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID

5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

6 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID

7 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

8 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

9 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

10 GRP_AP_ID Character(10) VARCHAR2(10) NOT NULL Control Group ID

11 ORIGIN_SETID Character(5) VARCHAR2(5) NOT NULL SetID

12 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin

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

14 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	ITM_SETID	Character(5)	VARCHAR2(5) NOT NULL	Item SetID
5	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
6	CATEGORY_ID	Character(5)	VARCHAR2(5) NOT NULL	Category ID
7	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
8	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
9	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
10	GRP_AP_ID	Character(10)	VARCHAR2(10) NOT NULL	Control Group ID
11	ORIGIN_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
12	ORIGIN	Character(3)	VARCHAR2(3) NOT NULL	Origin
13	VAT_APPLICABLE	Character(1)	VARCHAR2(1) NOT NULL	VAT Applicable E=Exempt O=Outside of Scope of VAT T=Taxable
14	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.