Structure 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