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
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
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.
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.