ERP Internals/Data Tables/Customer/Customer Person

From Wikibooks, open books for an open world
Jump to navigation Jump to search

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

Used by: Accounts Receivable, Order Entry/Invoicing

Key: Customer Number, Customer Location Number, Person Number

Fields:

  • Customer Number
  • Customer Location 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
  • Marital Status
  • Birthday
  • Language
  • Notes