Task U4
PLANNUMBER
|
CUSTOMERNAME
|
CUSTOMERPHONE
|
DATEMADE
|
DATEORDERED
|
HOWTODELIVER
|
WHENTODELIVER
|
WHENDELIVERED
|
CUSTOMERADDRESS
|
CUSTOMERCITY
|
1
|
Diana Decorator
|
55510
|
2007-02-20 00:00:00.0
|
2007-02-20 00:00:00.0
|
home
|
2007-03-01 00:00:00.0
|
2007-03-01 00:00:00.0
|
Back Alley 6A3
|
Megapolis
|
2
|
Bill Buyer
|
55500
|
2007-03-01 00:00:00.0
|
null
|
null
|
null
|
null
|
Mainstreet 4C44
|
Megapolis
|
3
|
Pink Panther
|
null
|
2007-03-01 00:00:00.0
|
2007-03-01 00:00:00.0
|
store
|
2007-04-15 00:00:00.0
|
null
|
Park Lane IB2
|
Megapolis
|
4
|
Bruce Wayne
|
55513
|
2007-03-02 00:00:00.0
|
2007-03-05 00:00:00.0
|
home
|
2007-03-13 00:00:00.0
|
2007-03-15 00:00:00.0
|
Wide Alley 1
|
Megapolis
|
5
|
Bruce Wayne
|
55513
|
2007-03-06 00:00:00.0
|
2007-03-06 00:00:00.0
|
home
|
2007-03-13 00:00:00.0
|
2007-03-15 00:00:00.0
|
Wide Alley 1
|
Megapolis
|
6
|
Clark Kent
|
55555
|
2007-03-08 00:00:00.0
|
null
|
null
|
null
|
null
|
Narrow Street 1
|
Megapolis
|
7
|
Bunny Easter
|
55522
|
2007-03-08 00:00:00.0
|
2007-03-08 00:00:00.0
|
home
|
2007-03-20 00:00:00.0
|
null
|
Long Street 10
|
Megapolis
|
8
|
Donald Duck
|
313
|
2007-03-09 00:00:00.0
|
2007-03-09 00:00:00.0
|
home
|
2007-03-22 00:00:00.0
|
null
|
Home Alley 5
|
Duckburg
|
9
|
Daisy Duck
|
365
|
2007-03-10 00:00:00.0
|
2007-03-10 00:00:00.0
|
home
|
2007-03-22 00:00:00.0
|
null
|
Home Alley 20
|
Duckburg
|