• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part: VI Appendixes > The tblClients table

The tblClients table

This table stores pertinent information about each client, such as the company name, contact name, and phone numbers.

Table A.1. The tblClients table.
Field NameTypeSize (Bytes)
ClientIDNumber (Long)4
CompanyNameText50
AddressText255
CityText30
StateProvinceText20
PostalCodeText20
CountryText20
ContactFirstNameText30
ContactLastNameText50
ContactTitleText50
OfficePhoneText30
FaxText30
CellularText30
HomeText30
EMailAddressText30
ReferredByText30
AssociatedWithText30
IntroDateDate/Time8
DefaultRateCurrency8
NotesMemo(Varies)
HomePageHyperlink 



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint