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