CC_VISA_TBL15

#	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_LEG_NUMBER	Number(2,0)	SMALLINT NOT NULL	Leg Number
6	VS_DEST_AIRPORT	Character(4)	VARCHAR2(4) NOT NULL	Destination/Airport Code
7	VS_CARRIER_CODE	Character(4)	VARCHAR2(4) NOT NULL	Carrier Code
8	VS_SERVICE_CLASS	Character(2)	VARCHAR2(2) NOT NULL	Service Class
9	VS_FARE_BASIS	Character(8)	VARCHAR2(8) NOT NULL	Fare Basis
10	CC_TRAVEL_DATE	Date(10)	DATE	Date of Travel
11	VS_STOPOVER_CODE	Character(1)	VARCHAR2(1) NOT NULL	Stopover Code 0=Stopover allowed (final dest) 1=Stopover not allowed
12	VS_COUPON_NO	Character(1)	VARCHAR2(1) NOT NULL	Coupon Number
13	VS_CARRIER_REF_NO	Character(6)	VARCHAR2(6) NOT NULL	Carrier Reference Number
14	VS_DEPARTURE_TIME	Character(4)	VARCHAR2(4) NOT NULL	Departure Time
15	VS_ARRIVAL_TIME	Character(4)	VARCHAR2(4) NOT NULL	Arrival Time
16	VS_ORIGINATION_CD	Character(4)	VARCHAR2(4) NOT NULL	Origination Airport/Railroad
17	VS_CONJ_TICKET_NO	Character(14)	VARCHAR2(14) NOT NULL	Conjunction Ticket Number
18	VS_MESSAGE_ID	Character(16)	VARCHAR2(16) NOT NULL	Message 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_DOMESTIC	Character(1)	VARCHAR2(1) NOT NULL	Domestice/International 0=1 Country 1=2 Country
27	ARRIVAL_DATE	Date(10)	DATE	Arrival Date
28	CC_DEPARTURETAX	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Departure Tax
29	VS_OPTIONAL_01	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 1
30	VS_OPTIONAL_02	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 2
31	VS_OPTIONAL_03	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 3
32	VS_OPTIONAL_04	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 4