WB0TRA
public text v1 · immutableStructure for table: S:\DATA\MEMBER.DBF
Number of data records: 9
Date of last update: 10/24/05
Memo file block size: 64
Code Page: 1252
Field Field Name Type Width Dec Index Collate Nulls
1 MEMBERID Integer 4 Asc Machine No
2 LOCATIONID Integer 4 Asc Machine No
3 LOCNBR Integer 4 Asc Machine No
4 MEMBNBR Character 12 Asc Machine No
5 LNAME Character 30 Asc Machine No
6 FNAME Character 20 Asc Machine No
7 NAMEUPDT DateTime 8 No
8 ADDRESS1 Character 50 No
9 ADDRESS2 Character 50 No
10 CITY Character 30 No
11 STATE Character 2 No
12 ZIP Character 10 No
13 HOLDMAIL Logical 1 No
14 NOMAIL Logical 1 No
15 ADDRUPDT DateTime 8 No
16 EMAILADDR Character 50 No
17 BADEMAIL Logical 1 No
18 EMAILOPTIN Logical 1 No
19 EMAILUPDT DateTime 8 No
20 HPHONE Character 10 Asc Machine No
21 CELLPHONE Character 10 Asc Machine No
22 CELLCARR Character 20 No
23 TXTMSOPTIN Logical 1 No
24 BIRTHMO Numeric 2 No
25 BIRTHYEAR Numeric 4 No
26 SEX Character 1 No
27 SALESRANK Integer 4 No
28 SENDCARD Logical 1 No
29 CARDSENT Date 8 No
30 WELCSENT Date 8 No
31 MEMBSINCE Date 8 No
32 FIRSTVISIT Date 8 No
33 LASTVISIT Date 8 No
34 CURRENT Logical 1 No
35 CURRUPDT DateTime 8 No
36 TERMINATED Logical 1 No
37 TERMUPDT DateTime 8 No
38 INCOMPLETE Logical 1 No
39 SEED Logical 1 No
40 ENRLBONUS Logical 1 No
41 NOPOINTS Logical 1 No
42 POINTBAL Integer 4 No
43 NOTES Memo 4 No
44 ADDED DateTime 8 No
45 UPDATED DateTime 8 No
46 UPDTREAS Character 8 No
** Total ** 442
Structural CDX file: S:\DATA\MEMBER.CDX
Index tag: LOCATIONID Key: LOCATIONID
Index tag: FNAME Key: FNAME
Index tag: LNAME Key: LNAME
Index tag: LOCNBR Key: LOCNBR
Index tag: MEMBNBR Key: MEMBNBR
Index tag: MEMBERID Key: MEMBERID
Index tag: CELLPHONE Key: CELLPHONE
Index tag: HPHONE Key: HPHONE
Index tag: ULNAME Key: UPPER( LNAME )
Index tag: UEMAIL Key: UPPER( EMAILADDR )
Memo file: S:\DATA\MEMBER.FPT