Vendors may be imported as follows (refer to the vendor section of this document for full details):
|
Field Name |
Size |
Mandatory |
Comments |
|
Vendor Number |
10 |
Y |
The vendor number. If this number is not currently a K212 Finance vendor, the vendor will be added. If the vendor number already exists, it will be updated. |
|
Vendor Name |
50 |
Y |
The vendor name. |
|
Address 1 |
50 |
Y |
The first vendor address line. |
|
Address 2 |
50 |
|
the second vendor address line. |
|
City |
50 |
|
The vendor's city |
|
Country |
50 |
|
The vendor's country |
|
Province/State |
50 |
|
The vendor's province or state. |
|
Postal/Zip Code |
7 |
|
The vendor's postal code or zip code |
|
Zip Code Ext. |
4 |
|
The four character zip code extension |
|
Pay To Vendor # |
10 |
|
If payment is to be made to a different vendor, enter the pay-to vendor number here. This must be a valid K212 Finance pay-to vendor |
|
Accounting Phone |
10 |
|
The phone number for the vendor's accounting contact |
|
Accounting Phone Ext. |
5 |
|
The extension number for the vendor's accounting contact |
|
Accounting Fax |
10 |
Conditional |
The fax number for the vendor's accounting contact - mandatory field if Preferred Payment Notification is Fax |
|
Forex Code |
3 |
|
The foreign exchange code. This will be validated against the Current Subscriptions settings |
|
Vendor Security Code |
2 |
Y |
The security code to be applied to this vendor. This will govern who may view or order from this vendor |
|
Vendor Type Code |
2 |
Y |
The vendor type code |
|
HST Number |
50 |
|
The vendor's HST registration number |
|
Accounting Contact |
50 |
|
The vendor's accounting contact |
|
Accounting Email |
50 |
Conditional |
The email address for the vendor's accounting contact - mandatory field if Preferred Payment Notification is email |
|
Website |
50 |
|
The vendor's web site |
|
Preferred Payment Notification |
10 |
Y |
Options are HardCopy, Email or Fax -- if the vendor is an EFT vendor this will govern how payment notifications will be generated by default |
|
Work Management Type Flag |
1 |
|
If integrating with a third-party work management system, enter Y if this vendor is significant to the work management system |
|
Employee ID |
9 |
|
If using the employee integration while integrating with K212 HR / Payroll and adding an employee as a vendor, enter the employee number here. The vendor type code must be the same as that specified in Settings --> Integration --> Payroll --> Vendor Type for Internal Employee |
|
EFT Payment Flag |
1 |
|
Enter a Y in this column to make this vendor an EFT vendor -- payments will be generated via eft rather than cheque as long as eft is activated for this vendor |
|
Bank Number |
20 |
Conditional |
The vendor's bank number - mandatory if EFT vendor |
|
Bank Transit Number |
20 |
Conditional |
The vendor's transit number - mandatory if EFT vendor |
|
Bank Account Number |
20 |
Conditional |
The vendor's bank account number - mandatory if EFT vendor |
|
Preferred PO Delivery Method |
10 |
Y |
Options are HardCopy, Email or Fax -- this will govern how purchase orders will be delivered by default |
|
Quote Only Flag |
1 |
|
Not applicable |
|
Purchasing Contact |
500 |
|
The name of the vendor's purchasing contact |
|
Purchasing Phone |
10 |
|
The phone number of the vendor's purchasing contact |
|
Purchasing Phone Ext. |
5 |
|
The extension of the vendor's purchasing contact |
|
Purchasing Fax |
10 |
|
The fax of the vendor's purchasing contact - mandatory if Preferred PO Delivery Method is Fax |
|
Purchasing Email |
50 |
|
The email of the vendor's purchasing contact - mandatory if Preferred PO Delivery Method is Email |
|
Payment Terms |
10 |
|
The vendors payment terms -- number of days for payment |
|
Discount Rate |
10 |
|
The discount rate offered by the vendor if payment is made according to the terms (above) |
|
F.O.B. |
50 |
|
The FOB conditions for the vendor |
|
Shipping Instructions |
500 |
|
The shipping instructions for this vendor |
|
Commodity Codes |
30 |
|
Not applicable |
|
Purchasing Comments |
500 |
|
Comments |
|
Purchasing Instructions |
500 |
|
Any special instructions that may apply to this vendor |
|
Internal Notes |
500 |
|
Notes entered here will display any time the vendor is accessed (shopping cart, purchase order, invoice, etc) |
|
User Defined Field 1 |
500 |
|
The user defined fields may be used for anything the board may determine is beneficial |
|
User Defined Field 2 |
500 |
|
The user defined fields may be used for anything the board may determine is beneficial |
|
User Defined Field 3 |
500 |
|
The user defined fields may be used for anything the board may determine is beneficial |
|
User Defined Field 4 |
500 |
|
The user defined fields may be used for anything the board may determine is beneficial |
|
User Defined Field 5 |
500 |
|
The user defined fields may be used for anything the board may determine is beneficial |