Case Management formula

To localize the Case Management formula you must modify the select statement that gets address data from the database. The default code is shown below, along with modified code for different regional settings.

Default formula (US)

colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.AddressKey" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.StreetNumber" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.StreetNumberSortAs" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.FullStreetNumber" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.PreDirection.Code" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.StreetSubDesignation" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.StreetName" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.Suffix.Code" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.PostDirection.Code" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.City" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.State" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.ZIP" ) )

Canada

colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.AddressKey" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.StreetNumber" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.StreetNoSortAs" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.FullStreetNumber" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.PreDirection.Code" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.StreetSubDesignation" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.StreetName" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.StreetSuffix.Code" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.PostDirection.Code" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.City" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.Province" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.PostalCode" ) )

UK

colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.AddressKey" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.HouseNumber" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.HouseNoSortAs" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.FullStreetNumber" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.SubUnitHouseName" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.StreetName" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.Town" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.County" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.PostCode" ) )

Australia

colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.AddressKey" ))
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.HouseNumber" ))
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.HouseNumberSortAs" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.FullStreetNumber" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.Flat" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.StreetName" ))
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.StreetType.Code" ))
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.Suburb" ))
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.State" ))
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.PostalCode" ))

New Zealand

colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.AddressKey" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.HouseNumber" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.HouseNumberSortAs" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.FullStreetNumber" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.Flat" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.StreetName" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.StreetType.Code" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.Suburb" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.State" ) )
colSelect.Add( new IDOperativeByCommonID( sProductFamily, sTableName + ".Address.PostalCode" ) )