This appendix contains the following topics:
The Address Book system uses tables to store both address book and batch processing information.
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. Also, the stored information includes the fields that need to be protected for data privacy. |
| 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. Also, the stored information includes the fields that need to be protected for data privacy. |
| 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. Also, the stored information includes the fields that need to be protected for data privacy. |
| 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. |
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. |