FIELD

The FIELD tag is used to define 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 to which the value of the selected ACL field is assigned.

type

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

  • C – Fields based on Character data types can be selected.

  • N – Fields based on Numeric data types can be selected.

  • D – Fields based on the Datetime data type can be selected.

  • L – Fields based on the Logical data type can be selected.

name

Specifies the name to associate with the field. The value is displayed in AX Web Client and AX Client 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 Web Client and AX Client 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 declaration with two fields defined. The first field definition accepts selections from both character and numeric field types, but omits the description. The second field definition accepts selections from the datetime field type, and includes a description of the field, or column, that the user should select from the ACL table.

//TABLE table_payments Payments Table
  Select a table that lists payments and includes a check number column.
//FIELD check_num CN Check Number
//FIELD payment_date D Payment Date
  Select the column that contains the check payment date.


(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback