Jump to content

ERP Internals/Data Tables/Contact/Contact Person

From Wikibooks, open books for an open world

This table contains one record for every person at every contact.

Used by: Contacts

Key: Contact Number, Person Number

Fields:

  • Contact Number
  • Person Number (a unique identifier assigned by the user)
  • Last Name
  • First Name
  • Informal Name
  • Job Title
  • Department
  • Title (Mr/Ms/Mrs/etc.)
  • Address 1
  • Address 2
  • City
  • State/Province
  • Country
  • Zip/Postal Code
  • Business Telephone
  • Telephone Extension
  • Home Telephone
  • FAX
  • Mobile
  • Pager
  • E-mail
  • Language
  • Gender
  • Marital Status
  • Birthdate
  • Notes