Show/Hide All
Enter the name of the user-defined table (UDT) to add. You can enter up to 23 characters. When a table name is entered, all characters are automatically converted to uppercase, spaces are converted to underscores (_), and the table name is prepended with GL_UDT_.
GL_UDT_PROJECTS
Enter a description for the UDT. You can enter up to 40 characters. This field is available only if a name has been entered in the Table Name field. When a table description is entered, the characters are automatically converted to lowercase with initial capitalization, and the description is prepended with the two-letter module code and appended with (UDT).
G/L Projects
Enter the field name for the key into the UDT. You can enter up to 20 characters. This field is available only if a name has been entered in the Table Name field. When a key field name is entered, all characters are automatically converted to uppercase, spaces are converted to underscores, and the key field name is prepended with UDF_ and appended with _CODE.
The following examples show how the key field name can reflect the kind of data the UDT is based on:
Enter....
If....
UDF_PROJECT_CODE
The table is based on project codes.
Enter a description for the key field. You can enter up to 40 characters. This field is available only if a name has been entered in the Table Name field. When a key field description is entered, the characters are automatically converted to lowercase with initial capitalization, and the description is appended with the word Code.
Project Code
Enter the length of the key for the UDT. The key field length must be at least 2 but no more than 96 characters long.
Enter....
If....
10
The table is based on 10-digit project codes.
