PO_CCVATCLC_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	CREDIT_CARD_VENDOR	Character(5)	VARCHAR2(5) NOT NULL	Corporate Card Vendor
4	CRDMEM_ACCT_NBR	Character(44)	VARCHAR2(44) NOT NULL	Cardmember Number
5	TRANS_NBR	Character(24)	VARCHAR2(24) NOT NULL	Transaction Number
6	SEQUENCENO	Number(10,0)	DECIMAL(10) NOT NULL	Sequence Number
7	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
8	CHARTFIELD_PR1	Character(18)	VARCHAR2(18) NOT NULL	Chartfield Priority 1
9	CHARTFIELD_PR2	Character(18)	VARCHAR2(18) NOT NULL	Chartfield Priority 2
10	PRODUCT_FAMILY	Character(1)	VARCHAR2(1) NOT NULL	Product Family
11	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
12	PRCS_OPTION_ID	Character(5)	VARCHAR2(5) NOT NULL	Processing Option ID
13	TEMP_FLD	Character(1)	VARCHAR2(1) NOT NULL	Temporary Field for App Engine
14	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
15	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
16	ITM_SETID	Character(5)	VARCHAR2(5) NOT NULL	Item SetID
17	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
18	PO_DT	Date(10)	DATE	Date
19	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
20	VAT_SETID	Character(5)	VARCHAR2(5) NOT NULL	VAT SetID
21	VAT_USE_ID	Character(6)	VARCHAR2(6) NOT NULL	VAT Use Type
22	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.
23	SETID_APORT	Character(5)	VARCHAR2(5) NOT NULL	SetID
24	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location
25	VAT_DFLT_WRK	Character(2)	VARCHAR2(2) NOT NULL	VAT Defaulting Work
26	RETURN_CD	Character(1)	VARCHAR2(1) NOT NULL	Return Code 0=Return OK 1=Return error
27	CC_TRANS_ID	Number(18,0)	DECIMAL(18) NOT NULL	Used for the SABRE/BTS Data Feed/Import. Unique number generated by SABRE BTS. Links rows to the Outbound Trip Data Table.
28	VAT_CALC_TXN_ID	Character(22)	VARCHAR2(22) NOT NULL	VAT Calculation Transaction ID