[interchange-cvs] interchange - heins modified 5 files

interchange-core@icdevgroup.org interchange-core@icdevgroup.org
Mon Oct 14 09:36:00 2002


User:      heins
Date:      2002-10-14 13:35:57 GMT
Modified:  dist/foundation/html index.html
Modified:  dist/foundation/pages/query check_orders.html
Modified:  dist/foundation/products transactions.txt
Modified:  dist/foundation/templates/sampledata/reports/products
Modified:           transactions.txt
Modified:  dist/foundation/templates/sampledata/tools/products
Modified:           transactions.txt
Log:
* Fix splash page so links are legible -- that white-on-white color scheme
  was a bit hard to read.

* Add "tracking_number" field to transactions.

* Change query/check_orders to:

	-- Not export transactions every time user queried order.

	-- Read tracking_number field and use that instead of status
	   for doing tracking number queries.

	-- Allow TRACKING_NUMBER_QUERY variable setting to formulate
	   query for tracking numbers.

* Any assistance with making HTML for those pages better would be
  appreciated...

Revision  Changes    Path
2.4       +7 -7      interchange/dist/foundation/html/index.html


rev 2.4, prev_rev 2.3
Index: index.html
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
RCS file: /var/cvs/interchange/dist/foundation/html/index.html,v
retrieving revision 2.3
retrieving revision 2.4
diff -u -r2.3 -r2.4
--- index.html	13 Sep 2002 20:46:17 -0000	2.3
+++ index.html	14 Oct 2002 13:35:56 -0000	2.4
@@ -41,18 +41,18 @@
     <big><b>__MVC_COMPANY__</b></big>
   </td>
 </tr>
-<tr class=3D"categorybar">
+<tr class=3D"contentbar1">
   <td align=3Dcenter colspan=3D2>
     <table cellpadding=3D5 width=3D"100%" align=3Dcenter>
-    <tr class=3D"categorybar">
+    <tr class=3D"contentbar1">
       <td colspan=3D2>&nbsp;</td>
     </tr>
-    <tr class=3D"categorybar">
-      <td class=3D"categorybar" width=3D"50%" align=3D"center">
-        <A class=3D"categorybar" HREF=3D"__MVC_CGIURL__/index.html">Custom=
er Entrance</A>
+    <tr class=3D"contentbar1">
+      <td class=3D"contentbar1" width=3D"50%" align=3D"center">
+        <A HREF=3D"__MVC_CGIURL__/index.html">Customer Entrance</A>
       </td>
-      <td class=3D"categorybar" width=3D"50%" align=3D"center">
-        <A class=3D"categorybar" HREF=3D"__MVC_CGIURL__/admin/index.html">=
Admin Interface</A>
+      <td class=3D"contentbar1" width=3D"50%" align=3D"center">
+        <A HREF=3D"__MVC_CGIURL__/admin/index.html">Admin Interface</A>
       </td>
     </tr>
     <tr class=3D"categorybar">



2.1       +44 -15    interchange/dist/foundation/pages/query/check_orders.h=
tml


rev 2.1, prev_rev 2.0
Index: check_orders.html
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
RCS file: /var/cvs/interchange/dist/foundation/pages/query/check_orders.htm=
l,v
retrieving revision 2.0
retrieving revision 2.1
diff -u -r2.0 -r2.1
--- check_orders.html	18 Jul 2001 02:21:25 -0000	2.0
+++ check_orders.html	14 Oct 2002 13:35:56 -0000	2.1
@@ -26,9 +26,22 @@
=20
 <!-- BEGIN CONTENT -->
=20
-[query st=3Ddb arrayref=3Dorders
+[tmp ugly_dbm][/tmp]
+
+[calc]
+        return if $Config->{Database}{transactions}{Class} =3D~ /DBI/;
+        $Scratch->{ugly_dbm} =3D 1;
+        return;
+[/calc]
+
+[if scratch ugly_dbm]
+    [index table=3Dtransactions export-only=3D1]
+    [index table=3Dorderline export-only=3D1]
+[/if]
+
+[query arrayref=3Dorders
 	sql=3D"SELECT
-		code,status,nitems,subtotal,shipping,handling,total_cost,payment_method,=
order_date
+		code,status,tracking_number,nitems,subtotal,shipping,handling,total_cost=
,payment_method,order_date
 		FROM transactions
 		WHERE username =3D '[data base=3Dsession field=3Dusername filter=3Dsql]'
 		ORDER by code
@@ -81,7 +94,7 @@
=20
 	my %hash;
=20
-	my @fields =3D qw/order_number status nitems subtotal shipping
+	my @fields =3D qw/order_number status tracking_number nitems subtotal shi=
pping
 			handling total_cost payment_method order_date/;
=20=09=09=09
 	my $row;
@@ -97,20 +110,39 @@
 			href =3D> 'query/order_detail',
 			arg =3D> $hash{order_number},
 		});
-		if($hash{status} =3D~ /\d/) {
-			my @ids =3D grep /\S/, split /\s+/, $hash{status};
-			$hash{status} =3D '';
-			for(@ids) {
-				$hash{status} .=3D <<EOF;
-<A HREF=3D"http://wwwapps.ups.com/etracking/tracking.cgi?InquiryNumber1=3D=
$_&TypeOfInquiryNumber=3DT">UPS $_</A>
-EOF
-			}
+
+		my $status =3D errmsg($hash{status});
+		my $tracking;
+
+		if($hash{tracking_number}) {
+			$tracking =3D $hash{tracking_number};
 		}
-		else {
+		elsif($hash{status} =3D~ /\d/) {
+			$status =3D errmsg('shipped');
+			$tracking =3D $hash{status};
+		}
+
+		if($status) {
 				$hash{status} =3D <<EOF;
 <A HREF=3D"$hash{detail_url}">$hash{status}</A>
 EOF
 		}
+=09=09
+		if($tracking) {
+Debug("found tracking $tracking");
+			my @ids =3D grep /\S/, split /\s+/, $tracking;
+			my $tpl =3D $Variable->{TRACKING_NUMBER_QUERY} || <<EOF;
+<A HREF=3D"http://wwwapps.ups.com/etracking/tracking.cgi?InquiryNumber1=3D=
{TRACKING_NUMBER}&TypeOfInquiryNumber=3DT">UPS {TRACKING_NUMBER}</A>
+EOF
+=09=09=09
+			for(@ids) {
+Debug("found id $_");
+				my $val =3D $tpl;
+				$val =3D~ s/{TRACKING_NUMBER}/$_/g;
+				$hash{status} .=3D $val;
+			}
+		}
+
 		for(qw/subtotal shipping total_cost/) {
 			$hash{$_} =3D $Tag->currency ({ body=3D> $hash{$_} });
 		}
@@ -130,9 +162,6 @@
 [/mvasp]
=20
 <BR CLEAR=3DALL>
-
-[seti export][tag export transactions transactions.txt][/tag][/seti]
-[seti export][tag export orderline orderline.txt][/tag][/seti]
=20
 <!-- END CONTENT -->
=20



2.1       +1 -1      interchange/dist/foundation/products/transactions.txt


rev 2.1, prev_rev 2.0
Index: transactions.txt
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
RCS file: /var/cvs/interchange/dist/foundation/products/transactions.txt,v
retrieving revision 2.0
retrieving revision 2.1
diff -u -r2.0 -r2.1
--- transactions.txt	18 Jul 2001 02:21:27 -0000	2.0
+++ transactions.txt	14 Oct 2002 13:35:57 -0000	2.1
@@ -1 +1 @@
-code	store_id	order_number	session__MVC_FIELDMUNGE__	username	shipmode	nit=
ems	subtotal	shipping	handling	salestax	total_cost	fname	lname	company	addr=
ess1	address2	city	state	zip	country	phone_day	phone_night	fax	email	b_fnam=
e	b_lname	b_company	b_address1	b_address2	b_city	b_state	b_zip	b_country	b_=
phone	order_date	order_ymd	order_wday	payment_method	po_number	payment_mode=
	avs	order_id	update_date	status	affiliate	campaign	parent	archived	deleted=
	complete	comments	currency_locale
+code	store_id	order_number	session__MVC_FIELDMUNGE__	username	shipmode	nit=
ems	subtotal	shipping	handling	salestax	total_cost	fname	lname	company	addr=
ess1	address2	city	state	zip	country	phone_day	phone_night	fax	email	b_fnam=
e	b_lname	b_company	b_address1	b_address2	b_city	b_state	b_zip	b_country	b_=
phone	order_date	order_ymd	order_wday	payment_method	po_number	payment_mode=
	avs	order_id	update_date	status	tracking_number	affiliate	campaign	parent	=
archived	deleted	complete	comments	currency_locale



2.1       +1 -1      interchange/dist/foundation/templates/sampledata/repor=
ts/products/transactions.txt


rev 2.1, prev_rev 2.0
Index: transactions.txt
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
RCS file: /var/cvs/interchange/dist/foundation/templates/sampledata/reports=
/products/transactions.txt,v
retrieving revision 2.0
retrieving revision 2.1
diff -u -r2.0 -r2.1
--- transactions.txt	18 Jul 2001 02:21:42 -0000	2.0
+++ transactions.txt	14 Oct 2002 13:35:57 -0000	2.1
@@ -1 +1 @@
-code	store_id	order_number	session__MVC_FIELDMUNGE__	username	shipmode	nit=
ems	subtotal	shipping	handling	salestax	total_cost	fname	lname	company	addr=
ess1	address2	city	state	zip	country	phone_day	phone_night	fax	email	b_fnam=
e	b_lname	b_company	b_address1	b_address2	b_city	b_state	b_zip	b_country	b_=
phone	order_date	order_ymd	order_wday	payment_method	po_number	payment_mode=
	avs	order_id	update_date	status	affiliate	campaign	parent	archived	deleted=
	complete	comments	currency_locale
+code	store_id	order_number	session__MVC_FIELDMUNGE__	username	shipmode	nit=
ems	subtotal	shipping	handling	salestax	total_cost	fname	lname	company	addr=
ess1	address2	city	state	zip	country	phone_day	phone_night	fax	email	b_fnam=
e	b_lname	b_company	b_address1	b_address2	b_city	b_state	b_zip	b_country	b_=
phone	order_date	order_ymd	order_wday	payment_method	po_number	payment_mode=
	avs	order_id	update_date	status	tracking_number	affiliate	campaign	parent	=
archived	deleted	complete	comments	currency_locale



2.3       +16 -16    interchange/dist/foundation/templates/sampledata/tools=
/products/transactions.txt


rev 2.3, prev_rev 2.2
Index: transactions.txt
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
RCS file: /var/cvs/interchange/dist/foundation/templates/sampledata/tools/p=
roducts/transactions.txt,v
retrieving revision 2.2
retrieving revision 2.3
diff -u -r2.2 -r2.3
--- transactions.txt	16 Aug 2002 21:44:54 -0000	2.2
+++ transactions.txt	14 Oct 2002 13:35:57 -0000	2.3
@@ -1,16 +1,16 @@
-code	store_id	order_number	session__MVC_FIELDMUNGE__	username	shipmode	nit=
ems	subtotal	shipping	handling	salestax	total_cost	fname	lname	company	addr=
ess1	address2	city	state	zip	country	phone_day	phone_night	fax	email	b_fnam=
e	b_lname	b_company	b_address1	b_address2	b_city	b_state	b_zip	b_country	b_=
phone	order_date	order_ymd	order_wday	payment_method	po_number	avs	order_id=
	update_date	status	affiliate	campaign	parent	archived	deleted	complete	com=
ments	currency_locale
-00001		00001	AhGiHXgR	T00001	upsg (UPS Ground)	1	19.99	5.73	0	0	25.72	Uebe=
r	Mensch		16 Hauptstrasse		Portland	OR	97201	US	503-555-1212			devnull@icde=
vgroup.net											20001006 11:35:39	20001006	5	Credit Card (visa)				__M=
VC_SQLUDATE__	shipped				1	0	0=09
-00002		00002	AhGiHXgR	ckirk	upsg (UPS Ground)	27	641.73	15.06	0	41.71	698.=
5	Charles	Kirk	Auto Exchange Express	123 Exchange Dr.		Seattle	WA	34987	US	=
360-111-1234	360-111-1244		kirk@icdevgroup.net											20001006 11:37:01	=
20001006	5	Credit Card (visa)				__MVC_SQLUDATE__	backorder						0=09
-00003		00003	AhGiHXgR	jking	upsg (UPS Ground)	150	1948.5	61.01	0	116.91	21=
26.42	John	King	Car Parts, Inc.	123 Auto Blvd.		Miami	FL	39807	US	305-111-1=
234	305-111-1239		king@icdevgroup.net											20001006 11:39:36	20001006	=
5	Credit Card (visa)				__MVC_SQLUDATE__	shipped				1	0	0=09
-00004		00004	AhGiHXgR	ladams	upsg (UPS Ground)	27	257.89	11.13	0	15.47	284=
49	Louis	Adams	Electronics Inc.	123 California Street		Los Angeles	CA	7890=
2	US	714-111-1234	714-111-1235		adams@icdevgroup.net											20001006 11:=
40:39	20001006	5	Credit Card (visa)				__MVC_SQLUDATE__	credit						0=09
-00005		00005	AhGiHXgR	lriley	upsg (UPS Ground)	17	164.83	6.9		6.59	178.32	=
Larry	Riley	Computerz Inc.	123 Monitor Rd.		New York	NY	46890	US	518-111-12=
34	518-111-1242		riley@icdevgroup.net											20001006 11:42:01	20001006	=
5	Credit Card (visa)				__MVC_SQLUDATE__	partial	hardhat=09=09=09=09=09=09
-00006		00006	AhGiHXgR	T00002	upsr (UPS Next Day)	1	29.99	0	0	0	29.99	Bobby=
	Bodega	Computerz Inc.	9500 W. Covina		Valdez	AK	99686	US	907-111-1234			mi=
lton@icdevgroup.net											20001006 11:44:34	20001006	5	Credit Card (vis=
a)				__MVC_SQLUDATE__	pending				0	0	0=09
-00007		00007	AhGiHXgR	mcarter	upsg (UPS Ground)	2	89.98	9.84	0	4.50	104.32=
	Michele	Carter	Spare Parts, Inc.	123 Parts Ctr Blvd.		Annapolis	MD	32498	U=
S	301-111-1234	703-111-1241		carter@icdevgroup.net											20001006 12:07=
:52	20001006	5	Credit Card (visa)				__MVC_SQLUDATE__	shipped				1	0	0=09
-00008		00008	AhGiHXgR	mkeller	upsg (UPS Ground)	3	53.97	5.17	0	0	59.14	Mic=
hael	Keller	InfoMed, Inc.	123 Oak St.		Portland	OR	45098	US	541-111-1234	54=
1-111-1240		keller@icdevgroup.net											20001006 12:08:36	20001006	5	Cr=
edit Card (visa)				__MVC_SQLUDATE__	pending				0	0	0=09
-00009		00009	AhGiHXgR	mmichaels	upsg (UPS Ground)	100	100	0	0	6.3	106.3	Mi=
chael	Michaels	Medical Supplies Co.	123 South Street		Austin	TX	30987	US	51=
2-111-9876	512-111-1237		michael@icdevgroup.net											20001006 12:09:48=
	20001006	5	Credit Card (visa)				__MVC_SQLUDATE__	shipped				0	0	0=09
-00010		00010	AhGiHXgR	tlucas	upsg (UPS Ground)	5	57.95	6.43	0	2.90	67.28	T=
homas	Lucas	Construct Buildings Inc.	123 Building Dr.		Phoenix	AZ	56987	US	=
520-111-1234	520-111-1245		lucas@icdevgroup.net											20001006 12:10:47=
	20001006	5	Credit Card (visa)				__MVC_SQLUDATE__	canceled						0=09
-00011		00011	AhGiHXgR	jrollins	upsg (UPS Ground)	1	44.99	6.87	0	1.57	53.43=
	Joseph	Rollins	Expert Repair, Inc.	123 Area Rd.		Richmond	VA	22398	US	804-=
111-1234	804-111-1243		Rollins@icdevgroup.net											20001006 12:11:34	2=
0001006	5	Credit Card (visa)				__MVC_SQLUDATE__	pending				0	0	0=09
-00012		00012	AhGiHXgR	ssmith	upsg (UPS Ground)	1	18.99	5.61			24.6	Steve	S=
mith	Pharm Supplies, Inc.	456 Hopkins Ave		Washington	DC	20090	US	202-111-8=
763	202-111-1238		smith@icdevgroup.net											20001006 12:12:13	20001006=
	5	Credit Card (visa)				__MVC_SQLUDATE__	shipped				1=09=09=09
-00013		00013	AhGiHXgR	mmichaels	upsg (UPS Ground)	1	14.99	5.35		0.94	21.28=
	Michael	Michaels	Medical Supplies Co.	123 South Street		Austin	TX	30987	US=
	512-111-9876	512-111-1237		michael@icdevgroup.net											20001006 12:12=
:55	20001006	5	Credit Card (visa)				__MVC_SQLUDATE__	shipped	consolidated	=
		1=09=09=09
-00014		00014	9bmBpw9j	T00003	upsg (UPS Ground)	3	59.97	6.4	0	0	66.37	James=
	Kelos		1414 Woodruff Ave.		Idaho Falls	ID	83401	US	(208) 524- 7202			devnu=
ll@icdevgroup.net											20001006 12:20:25	20001006	5	Credit Card (visa)=
				__MVC_SQLUDATE__	pending				0	0	0=09
-00015		00015	e69CSkSu	ladams	upsg (UPS Ground)	4	54.96	6.23	0	3.30	64.49	L=
ouis	Adams	Electronics Inc.	123 California Street		Los Angeles	CA	78902	US	=
714-111-1234	714-111-1235		adams@icdevgroup.net											20001006 12:46:50=
	20001006	5	Credit Card (visa)				__MVC_SQLUDATE__	pending				0	0	0=09
+code	store_id	order_number	session__MVC_FIELDMUNGE__	username	shipmode	nit=
ems	subtotal	shipping	handling	salestax	total_cost	fname	lname	company	addr=
ess1	address2	city	state	zip	country	phone_day	phone_night	fax	email	b_fnam=
e	b_lname	b_company	b_address1	b_address2	b_city	b_state	b_zip	b_country	b_=
phone	order_date	order_ymd	order_wday	payment_method	po_number	avs	order_id=
	update_date	status	tracking_number	affiliate	campaign	parent	archived	dele=
ted	complete	comments	currency_locale
+00001		00001	AhGiHXgR	T00001	upsg (UPS Ground)	1	19.99	5.73	0	0	25.72	Uebe=
r	Mensch		16 Hauptstrasse		Portland	OR	97201	US	503-555-1212			devnull@icde=
vgroup.net											20001006 11:35:39	20001006	5	Credit Card (visa)				__M=
VC_SQLUDATE__	shipped					1	0	0
+00002		00002	AhGiHXgR	ckirk	upsg (UPS Ground)	27	641.73	15.06	0	41.71	698.=
5	Charles	Kirk	Auto Exchange Express	123 Exchange Dr.		Seattle	WA	34987	US	=
360-111-1234	360-111-1244		kirk@icdevgroup.net											20001006 11:37:01	=
20001006	5	Credit Card (visa)				__MVC_SQLUDATE__	backorder							0
+00003		00003	AhGiHXgR	jking	upsg (UPS Ground)	150	1948.5	61.01	0	116.91	21=
26.42	John	King	Car Parts, Inc.	123 Auto Blvd.		Miami	FL	39807	US	305-111-1=
234	305-111-1239		king@icdevgroup.net											20001006 11:39:36	20001006	=
5	Credit Card (visa)				__MVC_SQLUDATE__	shipped					1	0	0
+00004		00004	AhGiHXgR	ladams	upsg (UPS Ground)	27	257.89	11.13	0	15.47	284=
49	Louis	Adams	Electronics Inc.	123 California Street		Los Angeles	CA	7890=
2	US	714-111-1234	714-111-1235		adams@icdevgroup.net											20001006 11:=
40:39	20001006	5	Credit Card (visa)				__MVC_SQLUDATE__	credit							0
+00005		00005	AhGiHXgR	lriley	upsg (UPS Ground)	17	164.83	6.9		6.59	178.32	=
Larry	Riley	Computerz Inc.	123 Monitor Rd.		New York	NY	46890	US	518-111-12=
34	518-111-1242		riley@icdevgroup.net											20001006 11:42:01	20001006	=
5	Credit Card (visa)				__MVC_SQLUDATE__	partial		hardhat
+00006		00006	AhGiHXgR	T00002	upsr (UPS Next Day)	1	29.99	0	0	0	29.99	Bobby=
	Bodega	Computerz Inc.	9500 W. Covina		Valdez	AK	99686	US	907-111-1234			mi=
lton@icdevgroup.net											20001006 11:44:34	20001006	5	Credit Card (vis=
a)				__MVC_SQLUDATE__	pending					0	0	0
+00007		00007	AhGiHXgR	mcarter	upsg (UPS Ground)	2	89.98	9.84	0	4.50	104.32=
	Michele	Carter	Spare Parts, Inc.	123 Parts Ctr Blvd.		Annapolis	MD	32498	U=
S	301-111-1234	703-111-1241		carter@icdevgroup.net											20001006 12:07=
:52	20001006	5	Credit Card (visa)				__MVC_SQLUDATE__	shipped					1	0	0
+00008		00008	AhGiHXgR	mkeller	upsg (UPS Ground)	3	53.97	5.17	0	0	59.14	Mic=
hael	Keller	InfoMed, Inc.	123 Oak St.		Portland	OR	45098	US	541-111-1234	54=
1-111-1240		keller@icdevgroup.net											20001006 12:08:36	20001006	5	Cr=
edit Card (visa)				__MVC_SQLUDATE__	pending					0	0	0
+00009		00009	AhGiHXgR	mmichaels	upsg (UPS Ground)	100	100	0	0	6.3	106.3	Mi=
chael	Michaels	Medical Supplies Co.	123 South Street		Austin	TX	30987	US	51=
2-111-9876	512-111-1237		michael@icdevgroup.net											20001006 12:09:48=
	20001006	5	Credit Card (visa)				__MVC_SQLUDATE__	shipped					0	0	0
+00010		00010	AhGiHXgR	tlucas	upsg (UPS Ground)	5	57.95	6.43	0	2.90	67.28	T=
homas	Lucas	Construct Buildings Inc.	123 Building Dr.		Phoenix	AZ	56987	US	=
520-111-1234	520-111-1245		lucas@icdevgroup.net											20001006 12:10:47=
	20001006	5	Credit Card (visa)				__MVC_SQLUDATE__	canceled							0
+00011		00011	AhGiHXgR	jrollins	upsg (UPS Ground)	1	44.99	6.87	0	1.57	53.43=
	Joseph	Rollins	Expert Repair, Inc.	123 Area Rd.		Richmond	VA	22398	US	804-=
111-1234	804-111-1243		Rollins@icdevgroup.net											20001006 12:11:34	2=
0001006	5	Credit Card (visa)				__MVC_SQLUDATE__	pending					0	0	0
+00012		00012	AhGiHXgR	ssmith	upsg (UPS Ground)	1	18.99	5.61			24.6	Steve	S=
mith	Pharm Supplies, Inc.	456 Hopkins Ave		Washington	DC	20090	US	202-111-8=
763	202-111-1238		smith@icdevgroup.net											20001006 12:12:13	20001006=
	5	Credit Card (visa)				__MVC_SQLUDATE__	shipped					1
+00013		00013	AhGiHXgR	mmichaels	upsg (UPS Ground)	1	14.99	5.35		0.94	21.28=
	Michael	Michaels	Medical Supplies Co.	123 South Street		Austin	TX	30987	US=
	512-111-9876	512-111-1237		michael@icdevgroup.net											20001006 12:12=
:55	20001006	5	Credit Card (visa)				__MVC_SQLUDATE__	shipped		consolidated=
			1
+00014		00014	9bmBpw9j	T00003	upsg (UPS Ground)	3	59.97	6.4	0	0	66.37	James=
	Kelos		1414 Woodruff Ave.		Idaho Falls	ID	83401	US	(208) 524- 7202			devnu=
ll@icdevgroup.net											20001006 12:20:25	20001006	5	Credit Card (visa)=
				__MVC_SQLUDATE__	pending					0	0	0
+00015		00015	e69CSkSu	ladams	upsg (UPS Ground)	4	54.96	6.23	0	3.30	64.49	L=
ouis	Adams	Electronics Inc.	123 California Street		Los Angeles	CA	78902	US	=
714-111-1234	714-111-1235		adams@icdevgroup.net											20001006 12:46:50=
	20001006	5	Credit Card (visa)				__MVC_SQLUDATE__	pending					0	0	0