CC_VISA_TAO26

#	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	CHARGE_DT	Date(10)	DATE	Date of Charge
8	VS_ITEM_SEQ_NBR	Number(5,0)	INTEGER NOT NULL	Item Sequence Number
9	CC_ROOM_RATE	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Room Rate
10	CC_DISCOUNT_RATE	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Discount Rate
11	CC_FOODDRINKCHARGE	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Food/Beverage Charges
12	CC_FOLIOCASHADV	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Folio Cash Advances
13	CC_VALETPARKCHARGE	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Valet Parking Charges
14	CC_MINIBARCHARGE	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Mini Bar Charges
15	CC_LAUNDRYCHARGE	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Laundry Charges
16	CC_PHONECHARGE	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Telephone Charges
17	CC_GIFTSHOPCHARGE	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Gift Shop Purchases
18	CC_MOVIECHARGE	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Movie Charges
19	CC_BUSCENTERCHARGE	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Business Center Charges
20	CC_HLTHCLUBCHARGE	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Health Club Charges
21	CC_ROOM_TAX1	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Room Tax 1 Amount
22	CC_ROOM_TAX2	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Room Tax 2 Amount
23	CC_ROOM_TAX3	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Room Tax 3 Amount
24	CC_ROOM_TAX4	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Room Tax 4 Amount
25	CC_OTHERCHARGE	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Other Charges
26	VS_OTHERCHARGEDESC	Character(20)	VARCHAR2(20) NOT NULL	Description of Other Charge
27	VS_OTHERCHARGECODE	Character(5)	VARCHAR2(5) NOT NULL	Other Charge Code
28	VS_MESSAGE_ID	Character(16)	VARCHAR2(16) NOT NULL	Message Identifier
29	VS_PURCH_ID	Character(50)	VARCHAR2(50) NOT NULL	Visa/Infospan Purchase ID
30	VS_PROCESSOR_KEY	Character(52)	VARCHAR2(52) NOT NULL	Processor Addendum Key
31	VS_OPTIONAL_01	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 1
32	VS_OPTIONAL_02	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 2
33	VS_OPTIONAL_03	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 3
34	VS_OPTIONAL_04	Character(26)	VARCHAR2(26) NOT NULL	Optional Field 4
35	CRDMEM_ACCT_NBR	Character(44)	VARCHAR2(44) NOT NULL	Cardmember Number