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