CC_VISA_TBL02

#	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_NO_SHOW	Character(1)	VARCHAR2(1) NOT NULL	No Show Indicator 0=No 1=Yes
6	CC_DAILY_RENTAL_R	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Daily Rental Rate
7	CC_OTHERCHARGE	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Other Charges
8	CC_RENTAL_CO_DATE	Date(10)	DATE	Rental Check Out Date
9	CC_WEEKLY_RENTAL_R	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Two decimal places are implied (ex 1234 = 12.34).
10	CC_INSURANCE_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Two decimal places are implied (ex 1234 = 12.34).
11	CC_FUEL_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Two decimal places are implied (ex 1234 = 12.34).
12	VS_CAR_CLASS	Character(2)	VARCHAR2(2) NOT NULL	Class Code
13	CC_ONEWAY_DROPOFF	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Two decimal places are implied (ex 1234 = 12.34).
14	VS_RENTER_NAME	Character(40)	VARCHAR2(40) NOT NULL	Renter Name
15	CC_TOWING_CHARGE	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Two decimal places are implied (ex 1234 = 12.34).
16	CC_REGULAR_MILE_A	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Two decimal places are implied (ex 1234 = 12.34).
17	CC_EXTRA_MILE_A	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Two decimal places are implied (ex 1234 = 12.34).
18	CC_LATE_RETURN_A	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Two decimal places are implied (ex 1234 = 12.34).
19	VS_LOCATION_RETURN	Character(26)	VARCHAR2(26) NOT NULL	Location Return
20	CC_TOTAL_TAX_VAT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Two decimal places are implied (ex 1234 = 12.34).
21	CC_PHONECHARGE	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Telephone Charges
22	VS_CORP_ID	Character(16)	VARCHAR2(16) NOT NULL	Corporate Identification
23	CC_EXTRA_CHARGE_CD	Character(4)	VARCHAR2(4) NOT NULL	Extra Charge Code 0=None 1=Gas 2=Mileage 3=Late 4=Service 5=Parking
24	VS_DAYS_RENTED	Number(2,0)	SMALLINT NOT NULL	Days Rented
25	VS_MESSAGE_ID	Character(16)	VARCHAR2(16) NOT NULL	Message Identifier
26	VS_PURCH_ID	Character(50)	VARCHAR2(50) NOT NULL	Visa/Infospan Purchase ID
27	CC_SOURCE_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Two decimal places are implied (ex 1234 = 12.34).
28	TRANS_DT	Date(10)	DATE	Transaction Date
29	VS_MERCHANT_CAT_CD	Character(4)	VARCHAR2(4) NOT NULL	Merchant Category Code
30	VS_SUPPLIER_NAME	Character(26)	VARCHAR2(26) NOT NULL	Visa Supplier Name
31	VS_SUPPLIER_POSTAL	Character(14)	VARCHAR2(14) NOT NULL	Supplier Postal Code
32	VS_PROCESSOR_KEY	Character(52)	VARCHAR2(52) NOT NULL	Processor Addendum Key
33	VS_OPTIONAL_01	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 1
34	VS_OPTIONAL_02	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 2
35	VS_OPTIONAL_03	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 3
36	VS_OPTIONAL_04	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 4