Import Fields: Vendors


This document describes the Customer data which can be imported into Big Business, along with a description of action taken if the data does not meet the required format.

Details:
Prior to importing information into Big Business, you need to prepare a tab delimited text file containing the necessary information. Each field to be imported must be separated by a tab, and each record must be separated by a return. This is easily done using a spread sheet.

Import Fields: Vendors (5158)






Prior to importing information into Big Business, you need to prepare a tab delimited text file containing the necessary information. Each field to be imported must be separated by a tab, and each record must be separated by a return. This is easily done using a spread sheet application.

Vendor Import (during Setup)

Info to Import Limitation on data Action if limitations not met

Vendor Listing Text up to 64 characters Remove characters beyond 64
Company Name Text up to 32 characters Remove characters beyond 32
Vendor Code Text up to 16 characters Remove characters beyond 16
Vendor Type Text up to 24 characters Remove characters beyond 24
Salutation Text up to 8 characters Remove characters beyond 8
First Name Text up to 16 characters Remove characters beyond 16
Last Name Text up to 16 characters Remove characters beyond 16
Title Text up to 24 characters Remove characters beyond 24
Phone # 1 (Work) Number up to 27 characters Remove characters beyond 27
Phone # 2 (Fax) Number up to 27 characters Remove characters beyond 27
Phone # 3 (Home) Number up to 27 characters Remove characters beyond 27
Phone # 4 (Mobile) Number up to 27 characters Remove characters beyond 27
Credit Limit Any number up to two Number rounded to two
decimal places decimal places
Terms Text up to 24 characters Remove characters beyond 24
ETA Days Any # between 1 and 32,767 Replace with zero

Payment Account Any Bank Account Remove entered
in the Account List Payment Account

Send 1099 “True, False, Yes, No, 1, 0” Replace with “No”
Tax ID# Text up to 16 characters Remove characters beyond 16

Payables Category Any Payables Category Replace with default
in the Account List Payables Category

Expense Category Any Category established Replace with default
in the Account List Expense Category

Balance Number up to two Number rounded to two
decimal places decimal places

Mailing Name Text up to 32 characters Remove characters beyond 32
Mailing Address 1 Text up to 32 characters Remove characters beyond 32
Mailing Address 2 Text up to 32 characters Remove characters beyond 32
Mailing City Text up to 16 characters Remove characters beyond 16
Mailing State Text up to 2 characters Remove characters beyond 2
Mailing Zip Number up to 9 characters Remove characters beyond 9
Mailing Country Text up to 16 characters Remove characters beyond 16
Payment Name Text up to 32 characters Remove characters beyond 32
Payment Address 1 Text up to 32 characters Remove characters beyond 32
Payment Address 2 Text up to 32 characters Remove characters beyond 32
Payment City Text up to 16 characters Remove characters beyond 16
Payment State Text up to 2 characters Remove characters beyond 2
Payment Zip Number up to 9 characters Remove characters beyond 9



Related:

  Chapter 11 System

Return to Help