The purpose of this function is to allow the user to update the details of entries on the DICT_TABLE table of the data dictionary.
This form is accessed by an option on the navigation bar in the List Table screen.
For a complete description of how this type of form works please see Transaction Pattern UPDATE 1.
|Database ID||STRING||Required. Primary Key, as loaded by the IMPORT DATABASE function.|
|Table ID||STRING||Required. Primary Key, as loaded by the IMPORT TABLE function.|
|Name||STRING||Required. The name for this entry.|
|Description||TEXT||Optional. A description for this entry.|
|Audit Logging?||STRING||Optional. This indicates if changes to this table will be recorded in the Audit Logging database. Possible values are:
|Default Sort Seq||STRING||Optional. When occurrences of this table are retrieved for LIST screens this will be used as the sort sequence (unless other sorting criteria has been specified either for the TASK or by the use of the column headings).|
|Alternative Language Table||STRING||Optional. The identity of the table which provides text in alternative languages for this table. If non-empty the following rules must be satisfied:
|Alternative Language Columns||STRING||Display only. The list of columns on the alternative table which provide text in different languages.|
|Alias for START_DATE||STRING||This is where a column designates the record's start date, but has a different name.|
|Alias for END_DATE||STRING||This is where a column designates the record's end date, but has a different name.|
|Extra Names Database||STRING||This is the ID of the database which contains the Extra Names Table, if different from the current database.|
|Extra Names Table||STRING||This is the ID of the table which stores the names of any User Defined Fields.|
|Extra Values Database||STRING||This is the ID of the database which contains the Extra Values Table, if different from the current database.|
|Extra Values Table||STRING||This is the ID of the table which stores the values for any User Defined Fields.|
|The following fields are set automatically by the system:|
|created_date||DATE+TIME||The date and time on which this record was created.|
|created_user||STRING||The identity of the USER who created this record.|
|revised_date||DATE+TIME||The date and time on which this record was last changed.|
|revised_user||STRING||The identity of the USER who last changed this record.|