Solved

Information on address table

  • 24 October 2023
  • 2 replies
  • 42 views

Userlevel 4
Badge +10

Hi in address table there is an address_2 and address_3 fields could you tell us for what they are used ?

Thanks by advance

Rgds

Christophe

icon

Best answer by Jacques Cormier 24 October 2023, 16:52

View original

2 replies

Userlevel 7
Badge +21

Hi Christophe,

For the standard application, they are not used in any of the processes or standard reports.

These are old column holdovers from the early service alliance days.

Userlevel 5
Badge +10

Christophe,

These address record fields are ‘vestigial’ from the early days of Alliance.  I think that since version 8, address 1 contains all the 3 values separated by a special character.  Also compatibility with new international standards for mapping software.  They can be used as extra fields for data, but Alliance does not use them.  Someone more technical may correct my post.

Reply