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
- 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