The following is useful information for more advanced uses of AnyOrder. It describes the structure of the Contact database. This is the database which is used in association with the Customer Database and includes contact information for the customers.
Fields data for Contact.dbf. This is a file which is related to the customer number in Cust_Num. It's a contact manager for each customer.
Contact.dbf
Purpose: Contacts associated with the customer database
Relation: Related to Customer Database by the field Cust_no
|
|
|
|
|
|
|
|
|
|
|
|
Field
|
Field Name
|
Type
|
Length
|
Dec
|
Description
|
1
|
CUST_NO
|
NUMERIC
|
10
|
|
Customer Number
|
2
|
FNM1
|
CHARACTER
|
18
|
|
First name
|
3
|
LNM1
|
CHARACTER
|
25
|
|
Last name
|
4
|
DEPT1
|
CHARACTER
|
25
|
|
Department
|
5
|
PHONE1
|
CHARACTER
|
20
|
|
Phone
|
6
|
EXT1
|
CHARACTER
|
14
|
|
Phone Extension
|
7
|
MENU1
|
CHARACTER
|
14
|
|
Phone menu numbers
|
8
|
ACCOUNT1
|
CHARACTER
|
18
|
|
Phone menu account numbers
|
9
|
FAX1
|
CHARACTER
|
20
|
|
Fax Number
|
10
|
PAGER1
|
CHARACTER
|
20
|
|
Page Number
|
11
|
CELL1
|
CHARACTER
|
20
|
|
Cell Number
|
12
|
EMAIL1
|
CHARACTER
|
35
|
|
Email Address
|
13
|
WEBSITE1
|
CHARACTER
|
40
|
|
Website URL
|
14
|
COMMENT1
|
MEMO
|
10
|
|
Memo field used for user's comments on this individual
|
-----
|
------------------------------------
|
--------------
|
--------
|
-----
|
|
|
TOTAL
|
|
290
|
|
|
|