ACADDRESS

Activity Address

This file contains address information from AC10.5 (Location). It includes the actual address, an address code for the address, a contact for the address, and telephone and E-mail information for the contact. You can assign address codes to activities and activity groups in AC10.2 (Location Assignment).

REFERENCED BY
AC50.1 AC500 ACBD.2


UPDATED BY
AC10.4

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ADD-ADDRESS-CODE
Element: Address Code
Alpha 9
Required key. This field contains the address code. The address code is defined in AC10.4 (Location).
AC10.4
ADD-ADDR1
Element: Address 1
Alpha 30 (Lower Case)
This is the first line of address information.
AC10.4
ADD-ADDR2
Element: Address 2
Alpha 30 (Lower Case)
This is the second line of address information.
AC10.4
ADD-ADDR3
Element: Address 3
Alpha 30 (Lower Case)
This is the third line of address information.
AC10.4
ADD-ADDR4
Element: Address 4
Alpha 30 (Lower Case)
This is the fourth line of address information.
AC10.4
ADD-ADDR5
Element: Address 5
Alpha 18 (Lower Case)
This is the fifth line of address information. In the United States, define the city.
AC10.4
ADD-STATE-PROV
Element: State or Province
Alpha 2
This is the state or province.
AC10.4
ADD-POSTAL-CODE
Element: Postal Code
Alpha 10 (Lower Case)
This is the postal code or zip code.
AC10.4
ADD-COUNTY
Element: County
Alpha 25 (Lower Case)
This is the county for the address.
AC10.4
ADD-COUNTRY
Element: Country
Alpha 30 (Lower Case)
This is the country of the address or a place to record additional information such as an attention name.
AC10.4
ADD-ADDR-CONTACT
Element: Addr Contact
Alpha 30 (Lower Case)
This is the name of the main contact.
AC10.4
ADD-PHONE-COUNTRY
Element: Telephone Country
Alpha 6
This is the prefix of the telephone number for the main contact. For example, the country or city telephone code.
AC10.4
ADD-PHONE
Element: Phone
Alpha 15
This is the telephone number.
AC10.4
ADD-PHONE-EXT
Element: Telephone Extension
Alpha 5
This is the telephone extension for the main contact.
AC10.4
ADD-TELEX-NUMBER
Element: Telex Number
Alpha 15
This is the telex number for the main contact.
AC10.4
ADD-E-MAIL-ADDR
Element: Email Address
Alpha 60
This is the E-mail address for the main contact.
AC10.4


ACADDRESS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ADDSET1 ADDRESS-CODE
AC10.2 AC10.4
AC50.1 AC500
ACBD.2


ACADDRESS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acaddrbod ACADDRBOD Not Required, Delete Cascades
Valid When YAC- =ADD-
ADD-ADDRESS-CODE->YAC-ADDRESS-CODE


File created: Thu Jun 09 02:02:44 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.