4 Creating Data Structures

This chapter contains the following topics:

4.1 Creating Business Function Data Structures

When you create a business function, you must attach a data structure. The data structure is used to pass data between an interactive or batch application and the business function. These data structures are created and modified using Oracle's JD Edwards Data Structure Design accessed from JD Edwards Object Management Workbench. Business function data structures contain data items defined in the data dictionary.

This section discusses how to create business function data structures.

4.1.1 Forms Used to Create a Data Structure

Form Name FormID Navigation Usage
Object Management Workbench W98220A In the Fast Path field of Solution Explorer, type OMW. Add and manage objects.
Add EnterpriseOne Object to the Project W98220C Select a project on OMW and click the Add button. Select a new object to add to a project.
Add Object W9861AF Select Data Structure on the Add Object form and click the OK button. Enter the name, description, and product code of a data structure. For a regular data structure, select Regular Data Structure.
Data Structure Design W9860A Complete the Add Object form and select Regular Data Structure, then click the OK button. Select the Design Tools tab, and then click the Data Structure Design button.

4.1.2 Creating Business Function Data Structures

Business function data structures are regular data structures used in creating business functions.

Access the Add Object form.

Object Name

Enter a unique name for the data structure. It needs to be unique within the entire JD Edwards EnterpriseOne system.

Product Code

Enter a user-defined code (98/SY) that identifies a system. Values include:

01

Address Book

03B

Accounts Receivable

04

Accounts Payable

09

General Accounting

11

Multicurrency

Product System Code

Enter a user-defined code (98/SY) that specifies the system number for reporting and jargon purposes.

Object Use

Enter a code that designates the use of the object. By default, data structure is 360.

See UDC 98/FU.

Regular Data Structure

Select this option if this is a business function data structure.

4.1.3 Selecting Data Items for Business Function Data Structures

Data items for business function data structures are data structures used in creating business functions.

To select data items for business function data structures:

  1. Click the Design Tools tab, and then click the Data Structure Design button.

  2. On the Dictionary Items tab, use the QBE line to locate the data dictionary items that you want to include in the business function data structure.

  3. To include data items in the data structure, drag them from the Dictionary Items tab to Structure Members.

    You can view detailed information about data items after they have been moved to Structure Members. Click the data item and select Data Dictionary Detail from the toolbar. The Data Item Specifications form appear.

  4. To remove data items from the data structure, select the data item in Structure Members and click the Delete button on the toolbar.

  5. Optionally, you can define data items as required and indicate the direction the data will flow.

    If the business function data structure will be used in a smart field, you must define the appropriate fields as required and set the direction arrows.

    Selecting an X in the required field indicates that the fields are optional. A check mark indicates that the fields are required.

  6. Optionally, you can add attachments to the data structure or to a data item in the data structure.

    Click Data Structure Attachments on the toolbar to add attachments to the data structure.

    Click a data item and then click Data Structure Item Attachments on the toolbar.

  7. Click XREF on the toolbar to launch the Cross Reference Facility from Data Structure Design.

    Use Cross Reference Facility when modifying existing data structures. Validate all references after the change.

  8. When the data structure is complete, click OK.

4.1.4 Creating a Type Definition

When the business function data structure is complete, and you are ready to use it in a C business function, you need to create a type definition. A type definition is a C code representation of a data structure definition. The type definition is stored in the clipboard so that you can easily paste it into the appropriate section of the .h file. This process is more efficient because you do not have to type the code into the .h file and, therefore, it minimizes errors.

Access the Data Structure Design form.

  1. Click the Design Tools tab.

  2. Click the Create a type definition button.

    You will see a message on the status bar that indicates that the type definition is stored in the clipboard. You can now paste it into the appropriate section of the .h file using the CTRL+ V key combination.

4.2 Creating Processing Option Data Structures

A processing option data structure is used to pass data to an interactive or batch application. Processing option data structures contain data items defined in the data dictionary. Processing option data structure is created through Processing Option Design Aid.

This section discusses how to create a processing options data structure.

4.2.1 Forms Used to Create a Processing Option Data Structure

Form Name FormID Navigation Usage
Object Management Workbench W98220A In the Fast Path field of Solution Explorer, type OMW. Add and manage objects.
Add EnterpriseOne Object to the Project W98220C Select a project on OMW and click the Add button. Select a new object to add to a project.
Add Object W9861AF Select Data Structure on the Add Object form and click the OK button. Enter the name, description, and product code of a data structure. For a processing option template, select Processing Option Template.
Processing Option Design W9860A Complete the Add Object form and select Processing Template, then click the OK button. Select the Design Tools tab, and then click the Start Processing Option Design Aid button.

4.2.2 Creating Processing Option Data Structures

Processing options are used to prompt for values that are then passed to the interactive or batch application and are used to determine the data to be presented.

Access the Add Object form.

Object Name

Enter a unique name for the data structure. It needs to be unique within the entire JD Edwards EnterpriseOne system.

Product Code

Enter a user-defined code (98/SY) that identifies a system. Values include:

01

Address Book

03B

Accounts Receivable

04

Accounts Payable

09

General Accounting

11

Multicurrency

Product System Code

Enter a user-defined code (98/SY) that specifies the system number for reporting and jargon purposes.

Object Use

Enter a code that designates the use of the object. The default value for data structure is 360.

See UDC 98/FU.

Processing Option Template

Select this option when creating processing option data structures.

4.2.3 Selecting Data Items for Processing Option Data Structures

Data items for processing option data structures are used to determine the data to be presented.

To select data items for processing option data structures:

  1. Click the Design Tools tab, and then click Start the Processing Option Design Aid.

  2. Right-click the processing option tab, <New Tab>, and select Current Tab Properties.

  3. In the Sort Name and Long Name fields, enter a name for the processing option tab according to the recommended naming conventions. Click OK.

  4. Optionally, click the letter A on the toolbar and click the processing option template.

    This option drops a Comment Text field on the processing option template. Double-click the field and highlight the text. Enter comments to explain the options.

  5. On the Data Dictionary Browser form, use the QBE line to locate the data items that you want to include on the processing option template.

    All of the data items included on a single tab should be related and the tab name should be descriptive. To add additional unrelated data items, you should create new tabs.

  6. To include data items in the processing option, drag them from the Data Dictionary Browser form to the processing option template.

  7. Optionally, double-click the data item description and enter descriptive text.

    This is necessary when you select a generic data item such as Everest Event Point 01 (EV01). This data item is used often when a single character value is expected, such as 1 or 2. You can change the text to read: Enter 1 to print a single column of labels, enter 2 to print two columns of labels.

    When you change the name of a data item on a processing option template, you should change the member name as well. Right-click the entry field of the data item. Select Properties. Using Hungarian Notation rules, change the member name. Leave the prefix that indicates the field type and modify the name to associate it with the description on the processing option template. Append an underline and the alias of the data item used for the field. For example, cLabels_EV01. Do not use spaces or special characters in the member name.

  8. To remove data items from the processing option, select the data item on the processing option template and click Cut Item on the toolbar.

  9. Optionally, right-click the processing option tab and select New Tab.

    In the Sort Name and Long Name fields, enter a name for the processing option tab according to the recommended naming conventions. Add related data items to this tab using the previous instructions.

  10. When all of the tabs and data items required have been added to the processing option template, select Test from the Edit menu.

    This option enables you to view the processing option template as it will appear to the user. If any of the data items are defined to include a visual assist, you will be able to access it from this test template.

  11. Save the processing option data structure.

    The processing option is now ready to be attached to an interactive or batch application. In the application, you must create event rules that define to the system how each processing option value should be processed.

4.3 Creating Media Object Data Structures

This section discusses how to create media object data structures.

4.3.1 Forms Used to Create Media Object Data Structures

Form Name FormID Navigation Usage
Object Management Workbench W98220A Enter OMW in the Fast Path field. View and manage objects in projects.
Add EnterpriseOne Object to the Project W98220C From JD Edwards Object Management Workbench, select a project, and click the Add button. Select the type of object to add to the project.
Add Object W9861AF On Add JD Edwards EnterpriseOne Object to the project, select Media Object Data Structure and click the OK button. Enter information about the media object data structure.
Data Structure Design W9860AL Complete the Add Object form and click the OK button. Select the Design Tools tab, and then click the Data Structure Design button to add data items into the data structure.

4.3.2 Creating Media Object Data Structures

Media Object data structures are data structures used to access media object table records.

Access the Add Object form.

Object Name

Enter a unique name for the data structure. It needs to be unique within the entire JD Edwards EnterpriseOne system.

Product Code

Enter a user-defined code (98/SY) that identifies a system. Values include:

01

Address Book

03B

Accounts Receivable

04

Accounts Payable

09

General Accounting

11

Multicurrency

Product System Code

Enter a user-defined code (98/SY) that specifies the system number for reporting and jargon purposes.

Object Use

Enter a code that designates the use of the object. The default value is "Undefined".

See UDC 98/FU.

4.3.3 Selecting Data Items for Media Object Data Structures

Media objects are attachments to records which are related to the record and are stored in the media object table.

To select data items for business function data structures:

  1. Click the Design Tools tab, and then click the Data Structure Design button.

  2. On the Dictionary Items tab, use the QBE line to locate the data dictionary items that you want to include in the media object data structure.

  3. To include data items in the data structure, drag them from the Dictionary Items tab to Structure Members.

    You can view detailed information about data items after they have been moved to Structure Members. Click the data item and select Data Dictionary Detail from the toolbar. The Data Item Specifications form appear.

  4. To remove data items from the data structure, select the data item in Structure Members and click the Delete button on the toolbar.

  5. Optionally, you can add attachments to the data structure or to a data item in the data structure.

    Click Data Structure Attachments on the toolbar to add attachments to the data structure.

    Click a data item and then click Data Structure Item Attachments on the toolbar.

  6. Click XREF on the toolbar to launch the Cross Reference Facility from Data Structure Design.

    Use Cross Reference Facility when modifying existing data structures. Validate all references after the change.

  7. When the data structure is complete, click OK.