Skip to main content
Solved

Information on address table

  • October 24, 2023
  • 2 replies
  • 50 views

Forum|alt.badge.img+11

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

Best answer by Jacques Cormier

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.

2 replies

Phil Seifert
Ultimate Hero (Employee)
Forum|alt.badge.img+24
  • Ultimate Hero (Employee)
  • October 24, 2023

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.


Jacques Cormier
Hero (Employee)
Forum|alt.badge.img+10
  • Hero (Employee)
  • Answer
  • October 24, 2023

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.