Legacy Tables…


Return to the Legacy Table index...
Table Details for: tblAR (Address Records)
Column Name Data Type Size Description User Comments
IDAR AutoNumber 232 Primary key of table tblAR.
Kind BYTE 28
Style BYTE 28 0=USA, 1=European
AddrName VARCHAR 255
AddrSort VARCHAR 255
Address1 VARCHAR 50
Address2 VARCHAR 50
City VARCHAR 50
State VARCHAR 50
ZipCode VARCHAR 50
Country VARCHAR 50
Latitude Double 264
Longitude Double 264
Phone1 VARCHAR 50
Phone2 VARCHAR 50
Email VARCHAR 255
HomePage VARCHAR 255
AddrNotes MEMO 1GB
List1 BYTE 28
List2 BYTE 28
List3 BYTE 28
List4 BYTE 28
List5 BYTE 28
List6 BYTE 28
Private BYTE 28
Tag1 BYTE 28
Used BYTE 28
Verified BYTE 28
FSResolved BYTE 28
VEResolved BYTE 28
Primary & Foreign Keys for table tblAR are highlighted.
BIT values can be 0 or 1
BYTE values can range from 0 to +255
Integer values can range from -32,768 to +32,767
Long (and AutoNumber) values can range from -2,147,483,648 to +2,147,483,647
Single (single-precision floating-point)
Double (double-precision floating-point)

Comments are closed.