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. |