CC_VISA_TAO21

#	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	VS_MESSAGE_ID	Character(16)	VARCHAR2(16) NOT NULL	Message Identifier
9	VS_COURIER	Character(26)	VARCHAR2(26) NOT NULL	Shipping/Courier Name
10	VS_TRACKINGNBR	Character(22)	VARCHAR2(22) NOT NULL	Tracking Number
11	PICKUP_DT	Date(10)	DATE	Pickup Date
12	VS_ORIGIN_POSTAL	Character(14)	VARCHAR2(14) NOT NULL	Original Postal Code
13	VS_ORIGIN_COUNTRY	Character(5)	VARCHAR2(5) NOT NULL	Original Country Code
14	VS_DEST_POSTAL	Character(14)	VARCHAR2(14) NOT NULL	Destination Postal Code
15	VS_DEST_COUNTRY	Character(5)	VARCHAR2(5) NOT NULL	Destination Country Code
16	VS_CUSTOMER_REFNO	Character(17)	VARCHAR2(17) NOT NULL	Customer Reference Number
17	VS_PACKAGE_CNT	Number(5,0)	INTEGER NOT NULL	Number of Packages
18	CC_NET_AMOUNT	Signed Number(14,2)	DECIMAL(12,2) NOT NULL	Net Amount
19	CC_TAX_AMOUNT	Signed Number(14,2)	DECIMAL(12,2) NOT NULL	Tax Amount
20	CC_DISCOUNTAMT	Signed Number(18,2)	DECIMAL(16,2) NOT NULL	Discount Amount
21	VS_SERVICE_DESCR	Character(24)	VARCHAR2(24) NOT NULL	Service Description
22	VS_UNITOFMEASURE	Character(3)	VARCHAR2(3) NOT NULL	Unit of Measure KGS=Kilograms LBS=Pounds
23	CC_WEIGHT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Weight
24	VS_ORIGIN_SENDER	Character(26)	VARCHAR2(26) NOT NULL	Origin Sender Name
25	VS_ORIGIN_ADDRESS	Character(20)	VARCHAR2(20) NOT NULL	Origin Address
26	VS_DEST_RECEIVER	Character(26)	VARCHAR2(26) NOT NULL	Destination Receiver Name
27	VS_DEST_ADDRESS	Character(20)	VARCHAR2(20) NOT NULL	Destination Address
28	VS_REIMBURSEATTR	Character(2)	VARCHAR2(2) NOT NULL	Reimbursement Attribute
29	VS_ORIGIN_STATE	Character(4)	VARCHAR2(4) NOT NULL	Origin State/Province
30	VS_DEST_STATE	Character(4)	VARCHAR2(4) NOT NULL	Destination State/Province
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