CC_VISA_TAO99

#	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_REFERENCETYPE	Character(2)	VARCHAR2(2) NOT NULL	Reference Type 1=Airline 2=Airport 3=Commodity Code 4=Country 5=Currency 6=Fleet Product 7=MCC 8=State/Province Code
4	VS_KEYFIELD	Character(10)	VARCHAR2(10) NOT NULL	Key Field
5	VS_DESCR01	Character(50)	VARCHAR2(50) NOT NULL	Description 1
6	VS_DESCR02	Character(50)	VARCHAR2(50) NOT NULL	Description 2
7	VS_DESCR03	Character(50)	VARCHAR2(50) NOT NULL	Description 3
8	VS_DESCR04	Character(50)	VARCHAR2(50) NOT NULL	Description 4
9	VS_DESCR05	Character(50)	VARCHAR2(50) NOT NULL	Description 5
10	VS_DESCR06	Character(50)	VARCHAR2(50) NOT NULL	Description 6
11	VS_DESCR07	Character(50)	VARCHAR2(50) NOT NULL	Description 7
12	VS_DESCR08	Character(50)	VARCHAR2(50) NOT NULL	Description 8
13	VS_DESCR09	Character(50)	VARCHAR2(50) NOT NULL	Description 9
14	VS_DESCR10	Character(50)	VARCHAR2(50) NOT NULL	Description 10
15	VS_DESCR11	Character(50)	VARCHAR2(50) NOT NULL	Description 11
16	VS_DESCR12	Character(50)	VARCHAR2(50) NOT NULL	Description 12
17	VS_DESCR13	Character(50)	VARCHAR2(50) NOT NULL	Description 13
18	VS_DESCR14	Character(50)	VARCHAR2(50) NOT NULL	Description 14
19	VS_DESCR15	Character(50)	VARCHAR2(50) NOT NULL	Description 15
20	VS_INACTIVEFLAG	Character(1)	VARCHAR2(1) NOT NULL	Inactive Flag 0=Still active code 1=Code inactive
21	VS_REFERENCENBR	Character(24)	VARCHAR2(24) NOT NULL	Effective Date