User-Defined Table Maintenance - Fields

 

User-Defined Table Maintenance

Expand/Collapse all Show/Hide All

User-Defined Table Grid

Enter data for the key field column and each corresponding user-defined field column in the table.

The heading of the first column displays the key field description entered in the Key Field Description field in the Add User-Defined Table window. The headings of all other columns display the user-defined field (UDF) description entered in the Description field in the Add Field window.

Note Data that has been entered in the key field cannot be modified. To change the key field data, you must delete the row by selecting it and clicking the Delete Row button. Then reenter the correct data.

Expand/Collapse item Example

A user-defined table (UDT) was created to store information about General Ledger projects, including project codes, project descriptions, and project supervisors. All General Ledger projects have a 10-character project code, which was used as the key field to the table. UDFs for the project description and supervisor were added to the UDT.

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

Project Code

Description

Supervisor

01234567

LA

Alice

01234568

Irvine

Steve

01234569

Phoenix

Mark

01234570

Detroit

Jane

01234571

Tempe

Bob

 

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