CC_VISA_TAO27

#	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	VS_ITEM_SEQ_NBR	Number(5,0)	INTEGER NOT NULL	Item Sequence Number
8	CC_DAILY_RENTAL_R	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Daily Rental Rate
9	CC_INSURANCE_AMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Two decimal places are implied (ex 1234 = 12.34).
10	CC_TOWING_CHARGE	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Two decimal places are implied (ex 1234 = 12.34).
11	CC_EXTRA_MILE_A	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Two decimal places are implied (ex 1234 = 12.34).
12	CC_PHONECHARGE	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Telephone Charges
13	CC_OTHERCHARGE	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Other Charges
14	VS_OPTIONAL_01	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 1
15	VS_OPTIONAL_02	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 2
16	VS_OPTIONAL_03	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 3
17	VS_OPTIONAL_04	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 4
18	CRDMEM_ACCT_NBR	Character(44)	VARCHAR2(44) NOT NULL	Cardmember Number