CC_VISA_TAO31

#	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_CALLTONUMBER	Character(15)	VARCHAR2(15) NOT NULL	Call To Number
8	VS_CALLTOCITY	Character(14)	VARCHAR2(14) NOT NULL	Call To City
9	VS_CALLTOSTATE	Character(4)	VARCHAR2(4) NOT NULL	Call To State
10	VS_CALLTOCOUNTRY	Character(5)	VARCHAR2(5) NOT NULL	Call To Country
11	VS_CALLFROMNUMBER	Character(15)	VARCHAR2(15) NOT NULL	Call From Number
12	VS_CALLFROMCITY	Character(14)	VARCHAR2(14) NOT NULL	Call From City
13	VS_CALLFROMSTATE	Character(4)	VARCHAR2(4) NOT NULL	Call From State
14	VS_CALLFROMCOUNTRY	Character(5)	VARCHAR2(5) NOT NULL	Call From Country
15	VS_DURATION	Character(6)	VARCHAR2(6) NOT NULL	Format: HHMMSS
16	VS_CONNECTTIME	Character(6)	VARCHAR2(6) NOT NULL	Format: HHMMSS
17	VS_CALL_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Call Type
18	VS_RATEPERIOD	Character(6)	VARCHAR2(6) NOT NULL	Rate Period
19	CC_DISCOUNTAMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Discount Amount
20	CC_TOTAL_TAX_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Total Tax Amount
21	VS_OPTIONAL_01	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 1
22	VS_OPTIONAL_02	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 2
23	VS_OPTIONAL_03	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 3
24	VS_OPTIONAL_04	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 4
25	CRDMEM_ACCT_NBR	Character(44)	VARCHAR2(44) NOT NULL	Cardmember Number