CC_VISA_TBL18

#	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_PRODUCT_SEQ_NO	Number(2,0)	SMALLINT NOT NULL	Product Sequence Number
6	VS_PRODUCTCODE	Character(2)	VARCHAR2(2) NOT NULL	Product Code 30=Motor Oil 31=Oil Change 32=Engine Service 33=Transmission Service 34=Brake Service 35=Unassigned Repair Value 39=Miscellaneous Repairs 40=Tires, Batteries, Accessories 41=Tires 42=Batteries 43=Automotive Accessories 44=Automotive Glass 45=Car Wash 46=Unassigned Automotive Services 47=Unassigned Automotive Services 48=Unassigned Automotive Services 49=Unassigned Automotive Services 70=Cigarettes/Tobacco 78=Health/Beauty Aid 79=Miscellaneous Grocery 80=Soda 81=Beer/Wine 82=Milk/Juice 90=Miscellaneous
7	VS_MESSAGE_ID	Character(16)	VARCHAR2(16) NOT NULL	Message Identifier
8	VS_PURCH_ID	Character(50)	VARCHAR2(50) NOT NULL	Visa/Infospan Purchase ID
9	CC_SOURCE_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Two decimal places are implied (ex 1234 = 12.34).
10	TRANS_DT	Date(10)	DATE	Transaction Date
11	VS_MERCHANT_CAT_CD	Character(4)	VARCHAR2(4) NOT NULL	Merchant Category Code
12	VS_SUPPLIER_NAME	Character(26)	VARCHAR2(26) NOT NULL	Visa Supplier Name
13	VS_SUPPLIER_POSTAL	Character(14)	VARCHAR2(14) NOT NULL	Supplier Postal Code
14	VS_PROCESSOR_KEY	Character(52)	VARCHAR2(52) NOT NULL	Processor Addendum Key
15	VS_OPTIONAL_01	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 1
16	VS_OPTIONAL_02	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 2
17	VS_OPTIONAL_03	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 3
18	VS_OPTIONAL_04	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 4