Smart Field Templates

JD Edwards EnterpriseOne includes predefined Smart Field templates. Smart Field templates group smart fields that use the same data selection criteria so that you can include them collectively in a Report Director template. For example, the S09001 - Financial Reporting smart field template contains all of the smart fields for financial reporting. Through the Oracle's JD Edwards EnterpriseOne Smart Field Templates (P91420) application, you can add new smart field templates or modify existing smart field templates to meet your reporting needs. You can access the JD Edwards EnterpriseOne Smart Field Template application from both the Microsoft Windows client and the web client.

You must add smart fields to a smart field template before they can be used in reports. Then you must attach the smart field template to a Report Director template. When you use the Report Director template to create a report, the smart fields in the attached smart field template appear in the Available Smart Fields list on the Select Columns form of the Director. From this form, you can select any of the available smart fields to include in the report.

When you select a smart field to include in the section layout, you are typically prompted for data selection values. Data selection fields are defined within the smart field template. These fields appear on the Smart Field Data Selection form of the Director.

Custom smart field template names should begin with SFT. The next two characters should be one of the product codes that is reserved for clients (55–59), and the next characters should reflect the system that uses the smart field template, as recommended for JD Edwards EnterpriseOne objects.

When you define a smart field template, you can select multiple smart fields to include in the template as long as they all use the same data selection. When defining data selection, you must select from fields that reside in the business view that is associated with the smart fields. Only five data items can be included in the smart field data selection criteria.

You can define a data selection field as requiring a range of values, but the field must be counted as two items. A range of values takes up two lines on the Smart Field Data Selection form in RDA. For example, if you include business unit as a data selection item, you might want the report developer to be able to include a range of values. This option presents two fields on the Smart Field Data Selection form in the Director, one for the beginning business unit value and one for the ending business unit value.