Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ACT! Field Names - what are their functions?

Status
Not open for further replies.

dydavid

MIS
Dec 27, 1999
120
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top