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

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.