This chapter contains the following topics:
You use supplemental data to track and store information that is not included in the standard master tables in JD Edwards EnterpriseOne software.
Using supplemental data, you define categories and further define information that you want to track for each category. Assume that you want to track the delivery methods for your customers. Delivery method is not a field in any of the master tables. Using supplemental data, you could define a category called Delivery Methods and then define the different delivery methods that you use.
JD Edwards EnterpriseOne software provides one supplemental database for each of these systems:
JD Edwards EnterpriseOne Address Book
JD Edwards EnterpriseOne General Accounting
JD Edwards EnterpriseOne Job Cost
JD Edwards EnterpriseOne Fixed Assets
JD Edwards EnterpriseOne Human Capital Management
JD Edwards EnterpriseOne Payroll
JD Edwards EnterpriseOne Equipment/Plant Management
JD Edwards EnterpriseOne Work Orders
JD Edwards EnterpriseOne Inventory Management
You can set up databases in addition to those provided by JD Edwards EnterpriseOne software. For each supplemental database, you can create one or more data types to organize your information. After you set up your database and data types, you can enter and use supplemental data.
Information for supplemental database codes is stored in these tables:
Supplemental Database Setup (F00090)
Supplemental Database Data Types (F00091)
Supplemental Data (F00092)
The type of information that you want to track determines the format in which you display supplemental data. These formats are available:
Assume that you work for a construction company and the company wants to use supplemental data to track the progress of each job (or business unit). Specifically, your company wants to track this information for each job:
Legal description
General remarks
Ground conditions
Precipitation
Wind conditions
Daily job logs
Incident log
This example illustrates the information that you want to track for business unit 5001:
Figure 19-1 Supplemental data for business unit 5001
You must set up data types for the legal description, general remarks, ground conditions, and so on.
Legal description. This data type contains a legal description of the job site.
General remarks. This data type describes the delays related to the ground conditions.
The data types for legal description and general remarks contain free-form text and, therefore, use the narrative format.
You also set up data types for:
Ground conditions
Precipitation
Wind conditions
Daily job logs
Incident log
These data types use the code format, which enables you to customize the entry form on which you enter data. With the code format, you can track additional information such as categories, dates, and amounts.
To track detailed information for ground conditions for a job, you set up these categories:
Dry
Mud
Frost greater than 20 inches