Where is the Banks Data Held?¶

The banks are held in the [dbo].[Banks] table and is identified as IsBank = 1
1: [dbo].[Contacts] table contains this information.\ - Link from [dbo].[Banks].[ContactID] to [dbo].[Contacts].[ID]\ - The required fileld is: CompanyName\ - Mailmerge Field: BankContactCompanyName
2: [dbo].[Contacts] table contains this information.\ - Link from [dbo].[Banks].[ContactID] to [dbo].[Contacts].[ID]\ - The required fields are: Address1, Address2, Address3, Address4, Address5, Address6, Address7, Address8, PCD\ - Mailmerge Field: BankContactAddress1, BankContactAddress2, BankContactAddress3, BankContactAddress4, BankContactAddress5, BankContactAddress6,\ BankContactAddress7, BankContactAddress8, BankContactPCD
3: [dbo].[BankCategory] table contains this information.\ - Link from [dbo].[Banks].[BankCategoryID] to [dbo].[BankCategory].[ID]\ - The required fileld is: Description\ - Mailmerge Field: NOT AVAILABLE
4: [dbo].[Contacts] table contains this information.\ - Link from [dbo].[Banks].[ContactID] to [dbo].[Contacts].[ID]\ - The required filelds are: Title, FirstName, LastName, PhoneHome, PhoneWork, AdditionalDetails, Email, Fax\ - Mailmerge Field: BankContactTitle, BankContactFirstName, BankContactLastName, BankContactPhoneHome, BankContactPhoneWork, BankContactAdditionalDetails,\ BankContactEmail, BankContactFax
5: [dbo].[Banks] table contains this information.\ - The required fileld is: FsaDetails\ - Mailmerge Field: BankDetailsFsaDetails