Creating Data Dictionary Items

From the Tools menu in JD Edwards Solution Explorer, select Object Management Workbench (OMW).

1. Select the project in which you want to add a new data dictionary item and click Add.

2. On the Add EnterpriseOne Object to the Project form, select Data Item and click OK.

3. On the Data Dictionary Item Type form, click No.

   This is a regular data dictionary item, not a glossary data item.

4. On the Data Item Specifications form, enter the name of the data item in the Data Item field.

5. In the Alias field, enter a unique alphanumeric identifier.

6. In the Glossary Group field, enter D to indicate a primary data element.

7. In the Description field, enter a brief description of the data item.

8. In the Product Code field, enter a product code.

   Codes in the 55–59 range are reserved for clients.

9. In the Product Code Reporting field, enter a product code that represents the system associated with this data item.

10. In the Data Type field, use the visual assist to select a value that indicates the type of data to be entered (for example, character, string, numeric).

11. In the Size field, enter the field size of the data item.

    This field is enabled based on the data type you selected.

12. In the File Decimals field, enter the number of stored positions to the right of the decimal place.

    This field is enabled only if the data type is defined as numeric.

13. In the Class field, use the visual assist to select a class that defines the attributes and characteristics of the data item (for example, CURRENCY).

    This field is only informational; it is not required.

14. In the Display Decimals field, enter the number of decimals that you want to appear.

    This field is enabled only if the data type is defined as numeric.

15. In the Control Type field, enter the type of control that is associated with the data item (for example, check box, push button, generic edit, and so on).

    The generic edit option is typically used when creating data items specifically for batch applications.

16. Leave the Item Occurrences field cleared.

    The value entered in this field causes a number of identical data items to be created based on the template defined by the active data item properties. For example, if data item RDATEST is added with Item Occurrences set to 2, the system creates two copies of the data item, RDATEST1 and RDATEST2.

17. In the Row Description field, enter the data item description as it should appear in group sections.

18. In the Column Title fields, enter the data item description as it should appear in columnar sections.

    Split lengthy descriptions into two lines. Enter short descriptions in the top line.

19. Select the Item Glossary tab, enter a description of all of the valid values for this prompt, and click OK.

    The item glossary appears on the Smart Field Parameters form in the Director.

    For example, for a quarterly data item prompt you might enter:

    Enter 1 to display totals for the first quarter.

    Enter 2 to display totals for the second quarter.

    Enter 3 to display totals for the third quarter.

    Enter 4 to display totals for the fourth quarter.