CC_VISA_TAO14

#	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	CC_DEPARTURE_DATE	Date(10)	DATE	Departure Date
8	VS_TRV_AGENCY_CODE	Character(8)	VARCHAR2(8) NOT NULL	Travel Agency Code
9	VS_TRV_AGENCY_NAME	Character(26)	VARCHAR2(26) NOT NULL	Travel Agency Name
10	VS_TICKET_IND	Character(1)	VARCHAR2(1) NOT NULL	Ticket Indicator 0=No 1=Yes
11	VS_TICKET_NBR	Character(14)	VARCHAR2(14) NOT NULL	Visa Airline Ticket Number
12	VS_PASSENGER_NAME	Character(20)	VARCHAR2(20) NOT NULL	Passenger Name
13	VS_EXNG_TICKET_NO	Character(14)	VARCHAR2(14) NOT NULL	Exchange Ticket Number
14	CC_EXNG_TICKET_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Two decimal places are implied (ex 1234 = 12.34).
15	VS_INTERNET_IND	Character(1)	VARCHAR2(1) NOT NULL	Internet Indicator 0=No 1=Yes
16	CC_TOTAL_FARE_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Two decimal places are implied (ex 1234 = 12.34).
17	CC_TOTAL_FEE_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Two decimal places are implied (ex 1234 = 12.34).
18	CC_TOTAL_TAX_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Total Tax Amount
19	VS_MESSAGE_ID	Character(16)	VARCHAR2(16) NOT NULL	Message Identifier
20	VS_ENDORSEMENT	Character(20)	VARCHAR2(20) NOT NULL	Endorsement/Restrictions
21	VS_PURCH_ID	Character(50)	VARCHAR2(50) NOT NULL	Visa/Infospan Purchase ID
22	CC_SOURCE_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Two decimal places are implied (ex 1234 = 12.34).
23	TRANS_DT	Date(10)	DATE	Transaction Date
24	VS_MERCHANT_CAT_CD	Character(4)	VARCHAR2(4) NOT NULL	Merchant Category Code
25	VS_SUPPLIER_NAME	Character(26)	VARCHAR2(26) NOT NULL	Visa Supplier Name
26	VS_SUPPLIER_POSTAL	Character(14)	VARCHAR2(14) NOT NULL	Supplier Postal Code
27	VS_PROCESSOR_KEY	Character(52)	VARCHAR2(52) NOT NULL	Processor Addendum Key
28	VS_TRV_OBNBR	Character(13)	VARCHAR2(13) NOT NULL	Travel Obligation Number
29	TICKET_DT	Date(10)	DATE	Ticket Issue Date
30	VS_NUMBEROFLEGS	Number(2,0)	SMALLINT NOT NULL	Number of Legs
31	VS_ETICKET	Character(1)	VARCHAR2(1) NOT NULL	E-Ticket Indicator 0=Non-Elec 1=Elec
32	VS_OPTIONAL_01	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 1
33	VS_OPTIONAL_02	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 2
34	VS_OPTIONAL_03	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 3
35	VS_OPTIONAL_04	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 4
36	CRDMEM_ACCT_NBR	Character(44)	VARCHAR2(44) NOT NULL	Cardmember Number