## Appendix: Tables Used by the Address Book System

The Address Book system uses tables to store both address book and batch processing information.

### Address Book Tables

This table lists the tables used by the Address Book system:

Table | Description
Address Book Master (F0101) | Stores names, address numbers, search types, and address book category code information for an individual or company that is assigned an address book number.
Address Book - Who's Who (F0111) | Stores names, address book information, and who's who category code information for individuals who are associated with a particular address book number.
Related Person (F01112) | Stores names, personal information, and related- person category code information for individuals who are related to a who's who entry.
Address Book - Phone Numbers (F0115) | Stores area codes, phone numbers, and types of phones.
Electronic Address (F01151) | Stores E-mail and uniform resource locator (URL) addresses associated with a who's who entry.
Address by Date (F0116) | Stores addresses, address lines, postal codes, and effective dates for address book numbers.
Postal Codes (F0117) | Stores the city, state, county, country, and optionally, a second postal code, bulk mailing center and carrier route for postal codes that you enter.
Alternate Address (F01161) | Stores addresses, address lines, postal codes, and effective dates for who's who and contact entries.
Address Organization Structure Master (F0150) | Stores parent numbers, child numbers, address numbers, and structure types.
Enhanced Parent Child (F01501) | Stores parent numbers and who's who child numbers.
Country Constants Master File (F0070) | Stores country-specific address-book formats for international mailing labels.
AB Word Search Master (F01815) | Stores words that are referenced when you search for a name.
Supplemental Database - Core (F01090) Supplemental Database - Code (F01092) Supplemental Database - Narrative (F01093) | Stores user-defined information, such as textual and statistical information.
Address Book Master Audit Log (F0101A) | Stores a record of changes to existing address book records and new address book records that have been entered.
Address Book Data Permissions List Definitions (F01138) | Stores the permission list definitions to be used for Address Book Data Privacy. The stored information includes the fields that should be protected for data privacy.
Postal Code Address (F0118) | Stores the address associated with a specific postal code.
Activity Master (F01301) | Stores the activities and tasks that are part of the Foundation Calendar module.
Activity Master Work Table (F01301W) | Stores the activities and task records including the recurrence records that are generated when a user inquires on an activity.
Activity-Deleted IDs for Sync (F01302) | Stores the records that are deleted in disconnected mode.
Calendar Master (F01311) | Stores the calendar record and related properties for all calendars created in the Foundation Calendar module.
Recurrence Master (F01321) | Stores the recurrence patterns for activities and tasks.
Recurrence Exclusion (F01331) | Stores the exclusions for recurrences that are set up for an activity or task.
Action Plan (F01401) | Stores the grouping of activity templates (that is, pseudo activities) that can later be used to create real activities.
Action Plan Activity (F01411) | Stores the activity templates that are available to be associated with action plans.
Contacts Subscription Table (F011901) | Stores the contacts for which a user has requested synchronization between the JD Edwards EnterpriseOne server and the Personal Information Manager.
Supplier Master (F0401) | Stores supplier specific information.
Customer Master (F03012) | Stores customer specific information.

### Address Book Tables for Batch Processing

This table lists the tables used by the Address Book system for batch processing:

Table | Description
Address Book - Interoperability (F0101Z2) | Stores records that originate from an outside (third-party) source until they become JD Edwards EnterpriseOne address book records.
Customer Master LOB-Batch Table (F03012Z1) | Stores records that originate from an outside (third-party) source until they become JD Edwards EnterpriseOne customer master records.
Supplier Master - Batch Upload (F0401Z1) | Stores records that originate from an outside (third-party) source until they become JD Edwards EnterpriseOne supplier master records.
Batch Who's Who Information (F0111Z1) | Stores who's who (contact) records that originate from an outside source until they become JD Edwards EnterpriseOne who's who entries.
Batch - Related Person (F01112Z1) | Stores related person records that originate from an outside source until they become JD Edwards EnterpriseOne related person entries for a who's who entry.
Phones-Interoperability (F0115Z1) | Stores phone numbers information for contacts.
Batch - Electronic Address (F01151Z1) | Stores E-mail and URL records that originate from an outside source until they become JD Edwards EnterpriseOne electronic address records.
Batch - Alternative Address (F01161Z1) | Stores alternative address records that originate from an outside source until they become JD Edwards EnterpriseOne alternative address records.

See Also

Adding Address Book Records