Create a User-Defined Table (UDT)

 

Expand/Collapse all Show/Hide All

Expand/Collapse item  Overview

You can customize your system by creating customized UDT. When you create user-defined fields (UDFs), you can validate them against the UDT file. You can also use UDT fields as data sources for other UDFs.

This procedure applies only to some modules.

 

To create a user-defined table (UDT)

  1. Select Custom Office Main menu > User-Defined Field and Table Maintenance.

  2. Select the module and click the Add a User-Defined Table button.

  3. In the Add User-Defined Table window, in the Table Name field, enter the name of the UDT. For more information, see Add User-Defined Table - Fields.

  4. The Description field is automatically populated with the entry in the Table Name field. Change the description of the UDT if necessary.

  5. In the Key Field Name field, enter the name of the field that is used as the key into the table. The Description field is automatically populated with the entry in the Key Field Name field. Change the description of the key field if necessary.

  6. In the Key Field Length field, enter the length of the field that is used as the key into the UDT. Click OK.

The UDT is created. After you click OK, the User-Defined Fields window appears. You can use this window to add fields to the UDT. For more information, see Create a User-Defined Field (UDF). Once you have defined all the fields for the UDT, you can maintain the data in the UDT using User-Defined Table Maintenance. For more information, see Maintain User-Defined Table (UDT) Data. You can also change the order of fields in the UDT grid, and add the UDT to the Desktop. For more information, see Set UDT Grid Order Entry and Add UDT to Desktop.

Expand or collapse item  Example - Creating a UDT to maintain project code information.

In the following example, a UDT was created for company ABX to store information about General Ledger projects, including project codes, project descriptions, and project supervisors. All General Ledger projects for company ABX have a 10-character project code.

The following information was entered in the Add User-Defined Table window:

Field

Entry

Table Name

GL_UDT_PROJECTS

Description

GL Projects (UDT)

Key Field Name

UDF_PROJECT_CODE

Key Field Description

Project Code

Key Field Length

10

 

After the table was created, in the Add Field window, a Description UDF and a Supervisor UDF were added to the UDT to maintain project description and supervisor data.

In the User-Defined Table Maintenance window, all project codes were entered in the Project Code UDF column. The corresponding project descriptions and supervisors for each project were entered in the Description and Supervisor UDF columns, as follows:

Project Code

Description

Supervisor

01234567

LA

Alice

01234568

Irvine

Steve

01234569

Phoenix

Mark

01234570

Detroit

Jane

01234571

Tempe

Bob

 

For the GL General Journal Detail table, a Project Code field UDF was created using the Add Field window, and was set to validate against the project code UDT. This new UDF was then added to the Lines tab grid of the General Journal Entry panel in General Ledger. The Description and Supervisor UDFs were also added as display-only fields.

During data entry in General Journal Entry, all entries in the Project Code field are now validated against the project code UDT. When a valid entry is made, the Description and Supervisor fields are populated with the description and supervisor information corresponding to the project code in the UDT. For example, if 01234568 is entered in the Project Code field, Irvine appears in the Description field and Steve appears in the Supervisor field.

© Sage Group plc 2019. Privacy Policy | Copyright/Trademarks