Bank Accounts by Address

Set up bank account information according to this example:

Field

Description

Record Type

Choose Supplier.

Bank Transit Number

Enter the sorting code (six digits without spaces or dashes).

Bank Account Number

Enter eight to ten digits without spaces or dashes.

Control Digit

Enter 00 (two zeros).

Description

Enter the name of the bank account.

Checking or Savings Account

Enter the type of account (optional).

Swift Code

This field is optional.

Reference/Roll Number

This field is required if the payment is made to a building society. All customers of a building society have the same sort code and account number. The value that is entered in the Reference/Roll Number field specifies which actual account is used.

This example shows how the values that are entered on the Set Up Bank Accounts By Address form populate the Bank Transit Master (F0030) and Bank Account/Supplier Number Worktable (F0030W) tables.

Field

Description

Record Type

Supplier

Bank Transit Number

601613

Bank Account Number

31926819

Control Digit

00

Description

Lloyds

Checking or Savings Account

Blank

SWIFT Code

Blank

Reference/Roll Number

Blank

The system populates the F0030 table like this:

AYBKTP

AYTNST

AYBNK

AYAN8

AYDL01

V

601613

31926819

22699

Lloyds

The system populates table F0030W like this:

AXAN8

AXBKTP

22699

V

Note: When you import bank account information directly into the F0030 table, you must also populate the F0030W table.