CC_VISA_TBL31

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CRDMEM_ACCT_NBR	Character(44)	VARCHAR2(44) NOT NULL	Cardmember Number
2	POST_DT	Date(10)	DATE	The Date a transaction was Posted.
3	VS_CCTRANS_NBR	Character(24)	VARCHAR2(24) NOT NULL	Transaction Number
4	VS_CCSEQ_NBR	Number(10,0)	DECIMAL(10) NOT NULL	Visa Sequence Number
5	VS_CALLTONUMBER	Character(15)	VARCHAR2(15) NOT NULL	Call To Number
6	VS_CALLTOCITY	Character(14)	VARCHAR2(14) NOT NULL	Call To City
7	VS_CALLTOSTATE	Character(4)	VARCHAR2(4) NOT NULL	Call To State
8	VS_CALLTOCOUNTRY	Character(5)	VARCHAR2(5) NOT NULL	Call To Country
9	VS_CALLFROMNUMBER	Character(15)	VARCHAR2(15) NOT NULL	Call From Number
10	VS_CALLFROMCITY	Character(14)	VARCHAR2(14) NOT NULL	Call From City
11	VS_CALLFROMSTATE	Character(4)	VARCHAR2(4) NOT NULL	Call From State
12	VS_CALLFROMCOUNTRY	Character(5)	VARCHAR2(5) NOT NULL	Call From Country
13	VS_DURATION	Character(6)	VARCHAR2(6) NOT NULL	Format: HHMMSS
14	VS_CONNECTTIME	Character(6)	VARCHAR2(6) NOT NULL	Format: HHMMSS
15	VS_CALL_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Call Type
16	VS_RATEPERIOD	Character(6)	VARCHAR2(6) NOT NULL	Rate Period
17	CC_DISCOUNTAMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Discount Amount
18	CC_TOTAL_TAX_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Total Tax Amount
19	VS_OPTIONAL_01	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 1
20	VS_OPTIONAL_02	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 2
21	VS_OPTIONAL_03	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 3
22	VS_OPTIONAL_04	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 4