[<< wikibooks] ERP Internals/Data Tables/Customer/Customer
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