ERP Internals/Data Tables/Customer/Customer

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

This table contains one record for every customer.

Used by: Accounts Receivable, Order Entry/Invoicing

Key: Customer Number

Fields:

  • Customer Number (a unique identifier assigned by the user)
  • Type
  • Organization/Individual (individual must have exactly one person record)
  • Active (Yes/No)
  • Territory
  • Group (used to group national accounts together)
  • Name
  • Address 1
  • Address 2
  • City
  • State/Province
  • Country
  • Zip/Postal Code
  • Shipping Address (same fields as above billing address)
  • Telephone
  • 1-800 Number
  • FAX
  • E-mail
  • Website
  • Price List
  • Discount Percentage
  • Produce Statement (Yes/No)
  • Sales Representative Number
  • Credit Limit
  • Usual Terms
  • Usual FOB
  • Usual Ship Via
  • Usual Currency
  • Sales Representative ID
  • Backorders Allowed (Yes/No)
  • COD (Yes/No)
  • NAICS
  • Referred By
  • Preferred Invoice Delivery Mode
  • Language
  • Current Accounts Receivable Balance (a calculated field that the user cannot change)
  • YTD Sales (a calculated field that the user cannot change)
  • Customer Since (date)
  • Holdback Percentage
  • Holdback Days
  • GL Distribution Group (contains all the postable account numbers)
  • Notes