CC_VISA_TAO07

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	VS_LOADTRANSCODE	Character(1)	VARCHAR2(1) NOT NULL	Load Transaction Code 1=Add transaction 2=Delete transaction 3=Update matching transaction 4=Update if existed or add
3	VS_ACCT_NBR	Character(19)	VARCHAR2(19) NOT NULL	Account Number
4	POST_DT	Date(10)	DATE	The Date a transaction was Posted.
5	VS_CCTRANS_NBR	Character(24)	VARCHAR2(24) NOT NULL	Transaction Number
6	VS_CCSEQ_NBR	Number(10,0)	DECIMAL(10) NOT NULL	Visa Sequence Number
7	VS_ITEM_SEQ_NBR	Number(5,0)	INTEGER NOT NULL	Item Sequence Number
8	VS_MESSAGE_ID	Character(16)	VARCHAR2(16) NOT NULL	Message Identifier
9	VS_ITEM_COMM_CODE	Character(16)	VARCHAR2(16) NOT NULL	Item Commodity Code
10	VS_ITEM_DESCR	Character(26)	VARCHAR2(26) NOT NULL	Item Description
11	CC_QUANTITY	Signed Number(18,4)	DECIMAL(16,4) NOT NULL	Four decimal places are implied (ex 123456 = 12.3456).
12	CC_UNIT_COST	Signed Number(18,4)	DECIMAL(16,4) NOT NULL	Four decimal places are implied (ex 123456 = 12.3456).
13	VS_UNIT_MEASURE	Character(12)	VARCHAR2(12) NOT NULL	Unit of Measure
14	CC_VAT_TAX_AMOUNT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Two decimal places are implied (ex 1234 = 12.34).
15	VS_TYPE_SUPPLY	Number(6,0)	INTEGER NOT NULL	Type Supply
16	VS_LAST_ITEM	Character(1)	VARCHAR2(1) NOT NULL	Last Item Indicator 0=Not last 1=Last
17	CC_VAT_TAX_RATE	Number(10,4)	DECIMAL(9,4) NOT NULL	Four decimal places are implied (ex 123456 = 12.3456).
18	CC_ITEM_DISCOUNT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Item Discount Amount
19	CC_ITEM_TOTAL_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Item Total Amount
20	VS_ITEM_PROD_CODE	Character(12)	VARCHAR2(12) NOT NULL	Item Product Code
21	VS_SERVICE_ID	Character(6)	VARCHAR2(6) NOT NULL	Service Identifier
22	VS_PURCH_ID	Character(50)	VARCHAR2(50) NOT NULL	Visa/Infospan Purchase ID
23	CC_SOURCE_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Two decimal places are implied (ex 1234 = 12.34).
24	TRANS_DT	Date(10)	DATE	Transaction Date
25	VS_MERCHANT_CAT_CD	Character(4)	VARCHAR2(4) NOT NULL	Merchant Category Code
26	VS_SUPPLIER_NAME	Character(26)	VARCHAR2(26) NOT NULL	Visa Supplier Name
27	VS_SUPPLIER_POSTAL	Character(14)	VARCHAR2(14) NOT NULL	Supplier Postal Code
28	VS_PROCESSOR_KEY	Character(52)	VARCHAR2(52) NOT NULL	Processor Addendum Key
29	VS_ITEMTAXCHARGED	Character(1)	VARCHAR2(1) NOT NULL	Line Item Sales Tax Charged 0=Not taxed 1=Taxed
30	VS_ITEMLEVELUSAGE	Character(2)	VARCHAR2(2) NOT NULL	Item Level Usage Code
31	VS_ITEMSOURCE	Character(10)	VARCHAR2(10) NOT NULL	Line Item Source
32	VS_OPTIONAL_01	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 1
33	VS_OPTIONAL_02	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 2
34	VS_OPTIONAL_03	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 3
35	VS_OPTIONAL_04	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 4
36	PRICE_PO	Signed Number(17,5)	DECIMAL(15,5) NOT NULL	Purchase Order Price
37	UNIT_PRICE	Signed Number(17,5)	DECIMAL(15,5) NOT NULL	Unit Price
38	QTY_PO	Number(16,4)	DECIMAL(15,4) NOT NULL	Purchase Order Quantity
39	VAT_ENTRD_TAX_PCT	Signed Number(9,4)	DECIMAL(7,4) NOT NULL	Specifies the tax percentage that corresponds to the VAT code. If more than one VAT authority is linked to a VAT code this will represent an aggregate percentage.
40	PHYSICAL_NATURE	Character(1)	VARCHAR2(1) NOT NULL	Physical Nature G=Goods S=Services Default Value: G
41	CRDMEM_ACCT_NBR	Character(44)	VARCHAR2(44) NOT NULL	Cardmember Number