Some of these are self descriptive, others are user defined, but some are not clear.
For example, what are these used for?
1 UNIQUE_ID C 12 0 12 0 4371
2 CTIME C 6 0 6 0 4371
3 ETIME C 6 0 6 0 4371
4 MTIME C 6 0 6 0 81
Thank you,
Dave
==============
This was a very helpful site:
Field Length Analysis: BDS C:\ACT\DATABASE\BDS.DBF
Field Field Data Needed Extra Records
Number Name Type Len Dec Length Bytes Used
1 UNIQUE_ID C 12 0 12 0 4371
2 CTIME C 6 0 6 0 4371
3 ETIME C 6 0 6 0 4371
4 MTIME C 6 0 6 0 81
5 PUB_STATUS N 1 0 1 0 4371
6 USER C 12 0 12 0 4371
7 COMPANY C 50 0 50 0 4365
8 NAME C 50 0 39 11 2555
9 ADDR1 C 50 0 43 7 4000
10 ADDR2 C 30 0 30 0 1861
11 ADDR3 C 30 0 30 0 353
12 CITY C 30 0 24 6 4014
13 STATE C 20 0 14 6 4247
14 ZIP C 10 0 10 0 2536
15 COUNTRY C 25 0 13 12 10
16 IDSTATUS C 25 0 22 3 736
17 PHONE C 42 0 32 10 2897
18 FAX C 42 0 32 10 2
19 HOME_PHONE C 42 0 32 10 18
20 MOBILPHONE C 42 0 32 10 199
21 PAGER C 42 0 5 37 1
22 SALUTATION C 30 0 12 18 2538
23 LAST_MEET C 8 0 8 0 4
24 LAST_REACH C 8 0 8 0 186
25 LAST_ATMPT C 8 0 8 0 179
26 LTTR_DATE C 8 0 8 0 11
27 TITLE C 50 0 30 20 2346
28 ASSISTANT C 50 0 30 20 2012
29 LAST_RSLTS C 75 0 75 0 3114
30 REFER_BY C 30 0 30 0 1544
31 USER1 C 50 0 9 41 3449
32 USER2 C 50 0 29 21 2916
33 USER3 N 10 0 7 3 1008
34 USER4 C 50 0 19 31 3506
35 USER5 C 50 0 12 38 2881
36 USER6 C 50 0 50 0 2284
37 USER7 C 75 0 57 18 1536
38 USER8 C 75 0 30 45 90
39 USER9 C 75 0 75 0 893
40 USER10 C 50 0 23 27 292
41 USER11 C 50 0 50 0 395
42 USER12 C 50 0 20 30 492
43 USER13 C 50 0 50 0 135
44 USER14 C 50 0 50 0 556
45 USER15 C 50 0 50 0 302
46 ALTADDR1 C 50 0 25 25 28
47 ALTADDR2 C 30 0 30 0 1297
48 ALTCITY C 30 0 25 5 1142
49 ALTSTATE C 25 0 0 25 0
50 ALTZIP C 25 0 12 13 372
51 ALTCOUNTRY C 25 0 10 15 1
52 ALTPHONE C 42 0 8 34 1
53 NAME2 C 50 0 25 25 1065
54 TITLE2 C 50 0 26 24 32
55 PHONE2 C 42 0 32 10 13
56 NAME3 C 50 0 25 25 24
57 TITLE3 C 50 0 29 21 200
58 PHONE3 C 42 0 32 10 5
59 FNAME C 50 0 12 38 2537
60 LNAME C 50 0 17 33 2555
61 EXT C 8 0 3 5 500
62 FAX_EXT C 8 0 7 1 29
63 ALTEXT C 8 0 6 2 4
64 PHONE2_EXT N 19 5 4 15 2
65 PHONE3_EXT N 19 5 1 18 0
66 ASST_TITLE C 50 0 14 36 3
67 ASST_PHONE C 42 0 32 10 2
68 ASST_EXT C 8 0 8 0 1
69 DEPARTMENT C 50 0 10 40 1
70 SPOUSE C 50 0 6 44 1
71 CREATOR C 50 0 18 32 4362
72 OWNER C 50 0 15 35 4298
73 ALT1REACH C 8 0 8 0 1
74 ALT2REACH C 8 0 8 0 1
75 URL C 75 0 22 53 10
76 TICKERSYM C 12 0 9 3 1
77 CONT_TYPE N 1 0 1 0 11
78 USR1000 C 10 0 10 0 184
79 USR1001 C 10 0 8 2 184
80 USR1002 C 10 0 8 2 177
81 USR1003 C 20 0 12 8 1530
82 USR1004 C 10 0 10 0 4233
83 USR1005 C 50 0 7 43 1
84 USR1006 C 20 0 12 8 6
85 USR1007 C 75 0 7 68 1
86 USR1008 C 10 0 7 3 1
87 USR1009 C 75 0 7 68 1
88 USR1010 C 25 0 13 12 4
89 USR1011 C 10 0 7 3 1
90 USR1012 C 25 0 12 13 4
91 USR1013 C 10 0 7 3 1
92 USR1014 C 75 0 7 68 1
93 USR1015 C 10 0 0 10 0
94 USR1016 C 20 0 6 14 1
95 USR1017 C 50 0 34 16 953
96 USR1018 C 42 0 32 10 136
97 USR1019 C 50 0 27 23 6
98 USR1020 C 40 0 25 15 2
99 USR1021 C 25 0 7 18 1
100 USR1022 C 42 0 32 10 332
101 USR1023 C 50 0 25 25 1611
102 USR1024 C 40 0 25 15 1603
103 USR1025 C 25 0 0 25 0
104 USR1026 C 25 0 0 25 0
105 USR1027 C 25 0 0 25 0
106 USR1028 C 25 0 0 25 0
107 USR1029 C 25 0 0 25 0
108 USR1030 C 25 0 7 18 1
109 USR1031 C 25 0 7 18 1
110 USR1032 C 25 0 7 18 1
111 USR1033 C 25 0 7 18 1
112 USR1034 C 25 0 7 18 1
113 USR1035 C 75 0 7 68 1
114 USR1036 C 25 0 7 18 1
115 USR1037 C 25 0 7 18 1
116 USR1038 C 25 0 7 18 1
117 USR1039 C 25 0 7 18 1
118 USR1040 C 25 0 7 18 1
119 USR1041 C 25 0 7 18 1
120 USR1042 C 25 0 12 13 3
121 USR1043 C 25 0 0 25 0
122 USR1044 C 25 0 7 18 1
123 USR1045 C 75 0 7 68 1
124 USR1046 C 25 0 7 18 1
125 USR1047 C 25 0 7 18 1
126 USR1048 C 25 0 3 22 2
127 USR1049 C 20 0 20 0 3
128 USR1050 C 25 0 13 12 1324
129 USR1051 C 20 0 12 8 712
**TOTAL** 4271 2190 2081
For example, what are these used for?
1 UNIQUE_ID C 12 0 12 0 4371
2 CTIME C 6 0 6 0 4371
3 ETIME C 6 0 6 0 4371
4 MTIME C 6 0 6 0 81
Thank you,
Dave
==============
This was a very helpful site:
Field Length Analysis: BDS C:\ACT\DATABASE\BDS.DBF
Field Field Data Needed Extra Records
Number Name Type Len Dec Length Bytes Used
1 UNIQUE_ID C 12 0 12 0 4371
2 CTIME C 6 0 6 0 4371
3 ETIME C 6 0 6 0 4371
4 MTIME C 6 0 6 0 81
5 PUB_STATUS N 1 0 1 0 4371
6 USER C 12 0 12 0 4371
7 COMPANY C 50 0 50 0 4365
8 NAME C 50 0 39 11 2555
9 ADDR1 C 50 0 43 7 4000
10 ADDR2 C 30 0 30 0 1861
11 ADDR3 C 30 0 30 0 353
12 CITY C 30 0 24 6 4014
13 STATE C 20 0 14 6 4247
14 ZIP C 10 0 10 0 2536
15 COUNTRY C 25 0 13 12 10
16 IDSTATUS C 25 0 22 3 736
17 PHONE C 42 0 32 10 2897
18 FAX C 42 0 32 10 2
19 HOME_PHONE C 42 0 32 10 18
20 MOBILPHONE C 42 0 32 10 199
21 PAGER C 42 0 5 37 1
22 SALUTATION C 30 0 12 18 2538
23 LAST_MEET C 8 0 8 0 4
24 LAST_REACH C 8 0 8 0 186
25 LAST_ATMPT C 8 0 8 0 179
26 LTTR_DATE C 8 0 8 0 11
27 TITLE C 50 0 30 20 2346
28 ASSISTANT C 50 0 30 20 2012
29 LAST_RSLTS C 75 0 75 0 3114
30 REFER_BY C 30 0 30 0 1544
31 USER1 C 50 0 9 41 3449
32 USER2 C 50 0 29 21 2916
33 USER3 N 10 0 7 3 1008
34 USER4 C 50 0 19 31 3506
35 USER5 C 50 0 12 38 2881
36 USER6 C 50 0 50 0 2284
37 USER7 C 75 0 57 18 1536
38 USER8 C 75 0 30 45 90
39 USER9 C 75 0 75 0 893
40 USER10 C 50 0 23 27 292
41 USER11 C 50 0 50 0 395
42 USER12 C 50 0 20 30 492
43 USER13 C 50 0 50 0 135
44 USER14 C 50 0 50 0 556
45 USER15 C 50 0 50 0 302
46 ALTADDR1 C 50 0 25 25 28
47 ALTADDR2 C 30 0 30 0 1297
48 ALTCITY C 30 0 25 5 1142
49 ALTSTATE C 25 0 0 25 0
50 ALTZIP C 25 0 12 13 372
51 ALTCOUNTRY C 25 0 10 15 1
52 ALTPHONE C 42 0 8 34 1
53 NAME2 C 50 0 25 25 1065
54 TITLE2 C 50 0 26 24 32
55 PHONE2 C 42 0 32 10 13
56 NAME3 C 50 0 25 25 24
57 TITLE3 C 50 0 29 21 200
58 PHONE3 C 42 0 32 10 5
59 FNAME C 50 0 12 38 2537
60 LNAME C 50 0 17 33 2555
61 EXT C 8 0 3 5 500
62 FAX_EXT C 8 0 7 1 29
63 ALTEXT C 8 0 6 2 4
64 PHONE2_EXT N 19 5 4 15 2
65 PHONE3_EXT N 19 5 1 18 0
66 ASST_TITLE C 50 0 14 36 3
67 ASST_PHONE C 42 0 32 10 2
68 ASST_EXT C 8 0 8 0 1
69 DEPARTMENT C 50 0 10 40 1
70 SPOUSE C 50 0 6 44 1
71 CREATOR C 50 0 18 32 4362
72 OWNER C 50 0 15 35 4298
73 ALT1REACH C 8 0 8 0 1
74 ALT2REACH C 8 0 8 0 1
75 URL C 75 0 22 53 10
76 TICKERSYM C 12 0 9 3 1
77 CONT_TYPE N 1 0 1 0 11
78 USR1000 C 10 0 10 0 184
79 USR1001 C 10 0 8 2 184
80 USR1002 C 10 0 8 2 177
81 USR1003 C 20 0 12 8 1530
82 USR1004 C 10 0 10 0 4233
83 USR1005 C 50 0 7 43 1
84 USR1006 C 20 0 12 8 6
85 USR1007 C 75 0 7 68 1
86 USR1008 C 10 0 7 3 1
87 USR1009 C 75 0 7 68 1
88 USR1010 C 25 0 13 12 4
89 USR1011 C 10 0 7 3 1
90 USR1012 C 25 0 12 13 4
91 USR1013 C 10 0 7 3 1
92 USR1014 C 75 0 7 68 1
93 USR1015 C 10 0 0 10 0
94 USR1016 C 20 0 6 14 1
95 USR1017 C 50 0 34 16 953
96 USR1018 C 42 0 32 10 136
97 USR1019 C 50 0 27 23 6
98 USR1020 C 40 0 25 15 2
99 USR1021 C 25 0 7 18 1
100 USR1022 C 42 0 32 10 332
101 USR1023 C 50 0 25 25 1611
102 USR1024 C 40 0 25 15 1603
103 USR1025 C 25 0 0 25 0
104 USR1026 C 25 0 0 25 0
105 USR1027 C 25 0 0 25 0
106 USR1028 C 25 0 0 25 0
107 USR1029 C 25 0 0 25 0
108 USR1030 C 25 0 7 18 1
109 USR1031 C 25 0 7 18 1
110 USR1032 C 25 0 7 18 1
111 USR1033 C 25 0 7 18 1
112 USR1034 C 25 0 7 18 1
113 USR1035 C 75 0 7 68 1
114 USR1036 C 25 0 7 18 1
115 USR1037 C 25 0 7 18 1
116 USR1038 C 25 0 7 18 1
117 USR1039 C 25 0 7 18 1
118 USR1040 C 25 0 7 18 1
119 USR1041 C 25 0 7 18 1
120 USR1042 C 25 0 12 13 3
121 USR1043 C 25 0 0 25 0
122 USR1044 C 25 0 7 18 1
123 USR1045 C 75 0 7 68 1
124 USR1046 C 25 0 7 18 1
125 USR1047 C 25 0 7 18 1
126 USR1048 C 25 0 3 22 2
127 USR1049 C 20 0 20 0 3
128 USR1050 C 25 0 13 12 1324
129 USR1051 C 20 0 12 8 712
**TOTAL** 4271 2190 2081