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