FIELD

The FIELD tag defines the requirements for fields that are mapped as part of a TABLE tag. The first FIELD tag must immediately follow a TABLE tag, and can be followed by additional FIELD tags entered on sequential lines.

Syntax

//FIELD id type name
  <description>
id

Specifies the variable that stores the field name selected by the user.

type

Specifies the types of fields that can be selected. Any type, or combination of types, from the following list can be selected:

  • C – Fields that use the Character data type can be selected.

  • N – Fields that use the Numeric data type can be selected.

  • D – Fields that use the Date, Datetime, or Time subtype of the Datetime data type can be selected.

  • L – Fields that use the Logical data type can be selected.

Any computed fields in a table can be selected regardless of the type specified.

name

Specifies the name to associate with the field. The value is displayed in AX Client, AX Web Client, and the Analysis App window when the user is prompted to select the field.

description

Optional. Descriptive text that specifies the purpose of the field. The description can be multiline, but it cannot skip lines. The value is displayed in AX Client, AX Web Client, and the Analysis App window when the user is prompted to select the field. The description can prompt the user to select the correct field. For example, “Select the field that includes the payment amount”. The description must be entered on the line below the associated FIELD tag.

Example

The following example shows a TABLE tag with two accompanying FIELD tags. The first field definition accepts selections from both character and numeric field types, but omits the description. The second field definition accepts selections from datetime field types, and includes a description of the field, or column, that the user should select from the ACL table.

//TABLE v_table_payments Payments Table
  Select a table that lists payments and includes a check number column.
//FIELD v_check_num CN Check Number Field
//FIELD v_payment_date D Payment Date Field
  Select the column that contains the check payment date.


(C) 2015 ACL Services Ltd. All Rights Reserved.