UPG_PO_VAT1_T

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
4	PO_DT	Date(10)	DATE	Date
5	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
6	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
7	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
8	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
9	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer
10	BILL_LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Billing Location
11	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.
12	SHIPTO_SETID	Character(5)	VARCHAR2(5) NOT NULL	ShipTo SetID
13	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location
14	PHYSICAL_NATURE	Character(1)	VARCHAR2(1) NOT NULL	Physical Nature G=Goods S=Services Default Value: G
15	VAT_SVC_PERFRM_FLG	Character(1)	VARCHAR2(1) NOT NULL	Where VAT Services Physically Performed Flag 1=Ship To Location 2=Ship From Location 3=Buyer's Location 4=Supplier's Location Default Value: 1
16	COUNTRY_LOC_BUYER	Character(3)	VARCHAR2(3) NOT NULL	Buyer's Location Country - May be either the VAT Entity or the Trading Partner
17	STATE_LOC_BUYER	Character(6)	VARCHAR2(6) NOT NULL	Buyer's Location State - May be either the VAT Entity or the Trading Partner
18	COUNTRY_LOC_SELLER	Character(3)	VARCHAR2(3) NOT NULL	Seller's Location Country - May be either the VAT Entity or the Trading Partner
19	STATE_LOC_SELLER	Character(6)	VARCHAR2(6) NOT NULL	Seller's Location State - May be either the VAT Entity or the Trading Partner
20	COUNTRY_VAT_PERFRM	Character(3)	VARCHAR2(3) NOT NULL	Country Where Service Physically Performed
21	STATE_VAT_PERFRM	Character(6)	VARCHAR2(6) NOT NULL	State Where Service Physically Performed
22	COUNTRY_SHIP_FROM	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country from which the invoice contents were shipped (for VAT processing only).
23	STATE_SHIP_FROM	Character(6)	VARCHAR2(6) NOT NULL	Ship From State
24	COUNTRY_SHIP_TO	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country to which the invoice contents were shipped (for VAT processing only).
25	STATE_SHIP_TO	Character(6)	VARCHAR2(6) NOT NULL	Ship To State