Appendix
B
Table:
Degree_Days
Columns
Name
Type
Size
Deg_Date
Date/Time
8
Deg_Day_num
Long
Integer
4
Daily_Deg_Num
Integer
2
Table:
Delivery
Cumns
Name
Type
Size
Acct_Num
Long
Integer
4
Name
Text
50
Tank_Id
Text
24
Serial_num
Text
20
date_filled
Date/Time
8
Last_Gallons
Long
Integer
4
Last_Percent_tank
Long
Integer
4
Last_Deg_Day_Fill
Long
Integer
4
Route_Id
Text
20
Ticket_num
Long
Integer
4
Table:
Lp_cust_db
Columns
Name
Type
Size
Acct_Num
Long
Integer
4
Name
Text
50
Address1
Text
40
Address2
Text
30
City
Text
25
State
Text
3
Zip
Text
10
Status
Text
50
Phone
Text
15
Num_Of_Tanks
Long
Integer
4
Route_Id
Text
20
Longitude
Double
8
Latitude
Double
8
Table:
Map_Review_List
Columns
Name
Type
Size
GeosetName
Text
50
LabelField
Text
50
zoom
:
Delete Query
16
centerx
Double
8
centery
Double
8
Character
Long
Integer
4
Color
Long
Integer
4
Font
Long
Integer
4
Table:
Route_id
Columns
Name
Type
Size
Route_Num
Text
20
Driver_name
Text
50
Table:
Scheduled_Delivery
Columns
Name
Type
Size
Acct_num
Long
Integer
4
Name
Text
50
Tank_Id
Text
24
Route_id
Text
20
Address
Text
35
City
Text
15
Capacity
Long
Integer
4
Date_last_paint
Date/Time
8
Base_Degree_days
Long
Integer
4
Last_fill_degree_days
Long
Integer
4
Next_fill_degree_days
Long
Integer
4
Driver
Text
20
Longitude
Double
8
Latitude
Double
8
Comment
Text
75
Sched_Date
Date/Time
8
Serial_Num
Text
20
Priority
Text
1
Phone
Text
15
Table:
Tank_Data
Columns
Name
Type
Size
ACCT_NUM
Long
Integer
4
NAME
Text
50
TANK_ID
Text
24
SERIAL_NUM
Text
20
CAPACITY
Integer
2
DATE_LAST_PAINT
Date/Time
8
BASE_DEGREE_DAYS
Long
Integer
4
LAST_FILL_DEGREE_DAYS
Long
Integer
4
NEXT_FILL_DEGREE_DAYS
Long
Integer
4
BURNFACTOR
Double
8
DATE_FILLED
Date/Time
8
LAST_PERCENT_TANK
Long
Integer
4
LAST_GALLONS
Long
Integer
4
LONGITUDE
Double
8
LATITUDE
Double
8
COMMENT
Text
75
ROUTE_ID
Text
20
DRIVER
Text
20
ADDRESS1
Text
40
ADDRESS2
Text
30
CITY
Text
25
STATE
Text
3
ZIP
Text
10
PHONE
Text
15
|
