ERP Internals/Data Tables/Supplier/Supplier

This table contains one record for every supplier.

Used by: Accounts Payable, Purchasing

Key: Supplier Number

Fields:
 * Supplier Number (a unique identifier assigned by the user)
 * Type
 * Organization/Individual (individual must have exactly one person record)
 * Active (Yes/No)
 * Group (used to group national accounts together)
 * Name
 * Address 1
 * Address 2
 * City
 * State/Province
 * Country
 * Zip/Postal Code
 * Telephone
 * FAX
 * E-mail
 * Website
 * Alternative Supplier Number
 * Tax ID
 * NAICS
 * 1099 Exempt (Y/N)
 * 1099 Number
 * Language
 * Usual Currency
 * Usual Terms
 * Usual FOB
 * Usual Ship Via
 * Bank Code
 * Duplicate Invoice Checking (Yes/No)
 * Credit Limit (this is the limit the supplier is imposing on the enterprise, used by Purchasing)
 * Hold (Yes/No) (If "yes", no transactions can be entered)
 * Holdback Percentage
 * Holdback Days
 * Current Accounts Payable Balance (a calculated field that the user cannot change)
 * YTD Volume (a calculated field that the user cannot change)
 * Supplier's Number for Us (this is the customer number that the supplier has assigned to us)
 * GL Distribution Group (contains all the postable account numbers)
 * Notes