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