Common address joins
| Reports using Address 1 | Name.ADDRESS\_NUM\_1= Name\_Address.ADDRESS\_NUM |
| Reports using Address 2 | Name.ADDRESS\_NUM\_2= Name\_Address.ADDRESS\_NUM |
| Reports using Address 3 | Name.ADDRESS\_NUM\_3= Name\_Address.ADDRESS\_NUM |
| Reports using Preferred Bill Address | Name.BILL\_ADDRESS\_NUM= Name\_Address.ADDRESS\_NUM |
| Reports using Preferred Mail Address | Name.MAIL\_ADDRESS\_NUM= Name\_Address.ADDRESS\_NUM |
| Other Alternate Addresses | *For example*, if you have more than three purposes: Name.ID=Name\_Address.ID where PURPOSE=' ' (List purpose in between single quotes.) |
Updated 3 months ago
Did this page help you?