GetIdFromPk and GetPkFromId Functions now support tables where the Id column doesn't include the Table Name

The following functions have been enhanced:

finBL.Database.GetIdFromPk(tableName, pk, id)
finBL.Database.GetPkFromId(tableName, id, pk)

Previously, the both functions assumed that the Id field was the table name, with Id tagged to the end. For example, the AccountType Table would have an AccountTypeId field. For the most part, this is sufficient, however the following tables do not follow this naming convention:

• AccountTypePromotion
• Id column is PromotionId
• BankAccountService
• Id column is ServiceId
• BatchHeader
• Id column is BatchId
• WorkflowItem
• Id column is ItemId
• This column is optional, so may return empty values

These tables are now handled to return their respective Id / Pk columns (depending on which function has been called), as specified above.