CC_VISA_TAO08

#	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_MESSAGE_ID	Character(16)	VARCHAR2(16) NOT NULL	Message Identifier
8	CC_DISCOUNTAMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Discount Amount
9	CC_FREIGHT_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Freight Amount
10	CC_DUTY_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Duty Amount
11	VS_DEST_POSTAL	Character(14)	VARCHAR2(14) NOT NULL	Destination Postal Code
12	VS_SRC_POSTAL	Character(14)	VARCHAR2(14) NOT NULL	Source Postal Code
13	VS_DEST_COUNTRY	Character(5)	VARCHAR2(5) NOT NULL	Destination Country Code
14	VS_VAT_REF_NBR	Character(16)	VARCHAR2(16) NOT NULL	VAT Reference Number
15	CC_ORDER_DT	Date(10)	DATE	Order Date
16	CC_VAT_TAX_AMOUNT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Two decimal places are implied (ex 1234 = 12.34).
17	CC_VAT_TAX_RATE	Number(10,4)	DECIMAL(9,4) NOT NULL	Four decimal places are implied (ex 123456 = 12.3456).
18	VS_SERVICE_ID	Character(6)	VARCHAR2(6) NOT NULL	Service Identifier
19	VS_PURCH_ID	Character(50)	VARCHAR2(50) NOT NULL	Visa/Infospan Purchase ID
20	CC_SOURCE_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Two decimal places are implied (ex 1234 = 12.34).
21	TRANS_DT	Date(10)	DATE	Transaction Date
22	VS_MERCHANT_CAT_CD	Character(4)	VARCHAR2(4) NOT NULL	Merchant Category Code
23	VS_SUPPLIER_NAME	Character(26)	VARCHAR2(26) NOT NULL	Visa Supplier Name
24	VS_SUPPLIER_POSTAL	Character(14)	VARCHAR2(14) NOT NULL	Supplier Postal Code
25	VS_PROCESSOR_KEY	Character(52)	VARCHAR2(52) NOT NULL	Processor Addendum Key
26	VS_SRC_COUNTRY	Character(5)	VARCHAR2(5) NOT NULL	Source Country Code
27	VS_DEST_STATE	Character(4)	VARCHAR2(4) NOT NULL	Destination State/Province
28	VS_SRC_STATE	Character(4)	VARCHAR2(4) NOT NULL	Source State/Province
29	VS_SOURCE	Character(10)	VARCHAR2(10) NOT NULL	Source
30	VS_OPTIONAL_01	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 1
31	VS_OPTIONAL_02	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 2
32	VS_OPTIONAL_03	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 3
33	VS_OPTIONAL_04	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 4
34	CRDMEM_ACCT_NBR	Character(44)	VARCHAR2(44) NOT NULL	Cardmember Number