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