1

Vendor#

Character

10

2

Name

Character

40

3

Attention

Character

40

4

Address

Character

30

5

City

Character

15

6

State

Character

 2

7

Zip

Character

10

8

Shortname

Character

10

9

Phone

Character

12

Format this field with dashes. For example, 999-999-9999.

10

Fax

Character

12

Format this field with dashes. For example, 999-999-9999.

11

G/L Acct#

Character

15

Format this number with dashes. For example, xxxx-xxx-xxx. Equates to an Expense Code.

12

Acct desc

Character

15

13

1099?

Character

1

Y = Yes
N = No

14

Vend.Code

Character

1

C = Corporation
S = Sole Proprietorship

15

Category

Character

1

Sets Category
P = Permanent, T = Temporary, O=One Time

16

Tax ID#

Character

12

Tax ID. Uses location of dash to determine Business Type.
999-99-9999=S (Sole Proprietorship);
otherwise C (Corporation).

17

LastActivty

Date

Use the format MM/DD/YY.

18

YTD Purch

Numeric

12

2 - Not used by the import process.

19

YTD Pay

Numeric

12

2 - Not used by the import process.

20

Discount %

Numeric

7

3

21

Disc Days

Numeric

3

22

Due Days

Numeric

3

23

Priority

Character

1

24

Hold Code

Character

1

Blank = None
H = Hold (looks up hold codes and uses first one). If none exists, it adds one "On Hold" and assigns it.
C = Sets Closed = Y, sets Hold = N.

25

Approved

Character

1

A=Y (Approved)
Any other value=N

26

Group Type

Character

Vendor Group Type

NOTES:

1. The system groups fields 26 and 27 together to create the Vendor Group.

2. When importing or exporting using a .BCL file, Width is 1 character.

Example: When V is entered for Group Type, then Vendor Groups start with V.

27

Group Code

Character

5

Vendor Group Code

The system groups fields 26 and 27 together to create the Vendor Group.

Example: When V is entered for Group Type (field 26), then the Vendor Group created with Group Code starts with V.

28

Class Code

Character

5

PO Class Code

If completed, the import creates another Vendor Group.

29

Unapproved

Character

1

X = Unapproved
Blank = Approved

30

Last Vend #

Character

10

The number is the vendor number previous to renumbering.

31

Liab Required?

Character

1

Y = Yes, liability insurance is required.
N = No, liability insurance is not required.

32

Liab Expire Date

Date

8

The date liability expires. Use the format MM/DD/YY.

33

Work Comp Required?

Character

1

Y = Yes, workers comp insurance is required
N = No, workers comp insurance is not required.

34

Work Comp Expire Date

Date

8

Use the format MM/DD/YY for the date workers comp expires.

35

W-9 on file

Character

1

Y = Yes
N = No

36

Name #2

Character

40

The physical location

37

Addr1 #2

Character

40

38

Addr2 #2

Character

30

39

City #2

Character

15

40

State #2

Character

2

41

Zip #2

Character

10

42

Contact_1

Character

30

43

Contact_2

Character

30

44

Phone_1

Character

12

Format this field with dashes. For example, 999-999-9999.

45

Phone_2

Character

12

Format this field with dashes. For example, 999-999-9999.

46

Ext_1

Character

4

47

Ext_2

Character

4

48

Customer #

Character

20

49

Notes

Character

40

50

Allocation#

Character

10

The default allocation table number.

51

Add date

Date

8

Use the format MM/DD/YY.

52

PO

Character

1

Y=Yes
N=No

53

Tax Rate

Character

10

Not Used

54

Terms

Character

30

Not Used

55

Addr On Invoice Required

Character

1

For temporary vendors to require invoice address.

56

Liab Insurance Carrier

Character

50

Name of Liability Insurance Carrier.

57

Liab Policy Number

Character

20

Liability Insurance Policy Number.

58

Work Comp

Character

50

Name of Workers Compensation Carrier

59

WorkCompPolicyNumber

Character

20

Workers Compensation Policy Number

60

Print Lien Waiver

Character

1

Y/N

61

Retainage Rate

Numeric

12

2 decimal places

62

Credit Limit

Numeric

12

2 decimal places

63

Last Invoice Amount

Numeric

12

2 decimal places

64

Last Invoice Date

Date

8

Use mm/dd/yy

65

Last InvoiceID

Character

20

Invoice ID of Last Invoice

66

Last Payment Amount

Numeric

12

2 decimal places

67

Last Payment Date

Date

8

Use mm/dd/yy

68

Last PayamentID

Character

20

Number of last check

69

SuppressPrintAdvice

Character

1

Y/N

70

PreNote

Numeric

1

Number of Prenotes to send.

71

ApprovedBy

Character

10

AP User Code for Approved By.

72

InvoiceType

Character

10

AP User Code for Invoice Type.

73

Location

Character

10

AP User Code for Location

74

Priority

Character

10

AP User Code for Priority

75

VendorType

Character

10

AP User Code for Vendor Type.

76

DirectDepositAdvice

Character

1

Y/N

77

RoutingNumber

Character

9

Bank Routing Number

78

AccountNumber

Character

17

Bank Account Number

79

EmailAddress

Character

256

Email address for Direct Deposit Notification.

80

BankName

Character

50

Name of Bank

81

AccountType

Character

1

C = Checking Account
S = Savings Account

82

AmountType

Character

1

A = Amount
P = Percentage
R = Remaining

83

Value

Numeric

12

2 decimal places. Relates to Amount Type of Amount and Percent.

84

SeqNo

Numeric

1

Processing sequence for multiple accounts.

1

Vendor#

Character

10

2

Name

Character

40

3

Attention

Character

40

4

Address

Character

30

5

City

Character

15

6

State

Character

 2

7

Zip

Character

10

8

Shortname

Character

10

9

Phone

Character

12

Format this field with dashes. For example, 999-999-9999.

10

Fax

Character

12

Format this field with dashes. For example, 999-999-9999.

11

G/L Acct#

Character

15

Format this number with dashes. For example, xxxx-xxx-xxx. Equates to an Expense Code.

12

Acct desc

Character

15

13

1099?

Character

1

Y = Yes
N = No

14

Vend.Code

Character

1

C = Corporation
S = Sole Proprietorship

15

Category

Character

1

Sets Category
P = Permanent, T = Temporary, O=One Time

16

Tax ID#

Character

12

Tax ID. Uses location of dash to determine Business Type.
999-99-9999=S (Sole Proprietorship);
otherwise C (Corporation).

17

LastActivty

Date

Use the format MM/DD/YY.

18

YTD Purch

Numeric

12

2 - Not used by the import process.

19

YTD Pay

Numeric

12

2 - Not used by the import process.

20

Discount %

Numeric

7

3

21

Disc Days

Numeric

3

22

Due Days

Numeric

3

23

Priority

Character

1

24

Hold Code

Character

1

Blank = None
H = Hold (looks up hold codes and uses first one). If none exists, it adds one "On Hold" and assigns it.
C = Sets Closed = Y, sets Hold = N.

25

Approved

Character

1

A=Y (Approved)
Any other value=N

26

Group Type

Character

Vendor Group Type

NOTES:

1. The system groups fields 26 and 27 together to create the Vendor Group.

2. When importing or exporting using a .BCL file, Width is 1 character.

Example: When V is entered for Group Type, then Vendor Groups start with V.

27

Group Code

Character

5

Vendor Group Code

The system groups fields 26 and 27 together to create the Vendor Group.

Example: When V is entered for Group Type (field 26), then the Vendor Group created with Group Code starts with V.

28

Class Code

Character

5

PO Class Code

If completed, the import creates another Vendor Group.

29

Unapproved

Character

1

X = Unapproved
Blank = Approved

30

Last Vend #

Character

10

The number is the vendor number previous to renumbering.

31

Liab Required?

Character

1

Y = Yes, liability insurance is required.
N = No, liability insurance is not required.

32

Liab Expire Date

Date

8

The date liability expires. Use the format MM/DD/YY.

33

Work Comp Required?

Character

1

Y = Yes, workers comp insurance is required
N = No, workers comp insurance is not required.

34

Work Comp Expire Date

Date

8

Use the format MM/DD/YY for the date workers comp expires.

35

W-9 on file

Character

1

Y = Yes
N = No

36

Name #2

Character

40

The physical location

37

Addr1 #2

Character

40

38

Addr2 #2

Character

30

39

City #2

Character

15

40

State #2

Character

2

41

Zip #2

Character

10

42

Contact_1

Character

30

43

Contact_2

Character

30

44

Phone_1

Character

12

Format this field with dashes. For example, 999-999-9999.

45

Phone_2

Character

12

Format this field with dashes. For example, 999-999-9999.

46

Ext_1

Character

4

47

Ext_2

Character

4

48

Customer #

Character

20

49

Notes

Character

40

50

Allocation#

Character

10

The default allocation table number.

51

Add date

Date

8

Use the format MM/DD/YY.

52

PO

Character

1

Y=Yes
N=No

53

Tax Rate

Character

10

Not Used

54

Terms

Character

30

Not Used