Definition of table menu
A file consisting of a list of menus. This includes any sub-menus that are used in the system. There should always be at least one menu called 'DEFAULT' included with any system. , Table Dump Name menu

Alphabetical Field Summary

  • cre-date: (DATE) Date record was created
  • cre-time: (CHAR) Time record was created at
  • cre-user-name: (CHAR) User who created this record
  • extern-guid: (CHAR) External Global Unique ID for this record
  • gui-menu: (LOGC) Yes if menu is intended for user with GUI
  • menu-box: (LOGC) Indicate whether or not to frame menu with a box
  • menu-cols: (INTG) Number of columns to display (1 or 2)
  • menu-custom: (LOGC) Is this a site customized menu
  • menu-desc[4]: (CHAR) Description or reason for menu
  • menu-type: (LOGC) Select whether menu is a Top or Sub Menu (informational only
  • obj-id: (CHAR) A unique object identifier
  • state-tag: (CHAR) Set to All or the two letter name of the state it's specific
  • upd-date: (DATE) Date record was last updated
  • upd-time: (CHAR) Time record was last updated
  • upd-user-name: (CHAR) User who last updated this record

    Alphabetical Index Summary

  • extern-guid: extern-guid
  • obj-id: (UNIQUE, PRIMARY) obj-id

    Other tables who reference menu

  • audit - The audit trail keeps a history of user activities and any o
  • group-perm - Group Permissions files. Possible entries in here for each o
  • menu-item - Contains pointers for contructing menu items. If the menuite
  • object - Object definitions for the system. This includes programs or
  • program - one entry for each program that can be run in association wi
  • user-default - User defaults file. This contains object/attribute pairs wit

    Tables menu references

  • menu-item - Contains pointers for contructing menu items. If the menuite
  • program - one entry for each program that can be run in association wi

    Detailed Alphabetical Field Listing
    cre-date Data type: DATE
    Format: 99/99/9999
    Help: Date record was created

    cre-time Data type: CHARACTER
    Format: x(8)
    Help: Time record was created at

    cre-user-name Data type: CHARACTER
    Format: x(16)
    Help: User who created this record

    extern-guid Data type: CHARACTER
    Format: x(32)
    Description: External Global Unique ID for this record
    Attributes: Index Component

    gui-menu Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Yes if menu is intended for user with GUI

    menu-box Data type: LOGICAL
    Format: Yes/No (Initial Value: Yes)
    Help: Indicate whether or not to frame menu with a box
    Attributes: Mandatory

    menu-cols Data type: INTEGER
    Format: 9 (Initial Value: 1)
    Help: Number of columns to display (1 or 2)
    Attributes: Mandatory

    menu-custom Data type: LOGICAL
    Format: Yes/No (Initial Value: No)
    Help: Is this a site customized menu

    menu-desc Data type: CHARACTER (Extent: 4)
    Format: x(32)
    Help: Description or reason for menu

    menu-type Data type: LOGICAL
    Format: Main/Sub (Initial Value: Yes)
    Help: Select whether menu is a Top or Sub Menu (informational only
    Attributes: Mandatory

    obj-id Data type: CHARACTER
    Format: x(16)
    Help: A unique object identifier
    Attributes: Index Component, Mandatory

    state-tag Data type: CHARACTER
    Format: x(3) (Initial Value: All)
    Description: Set to All or the two letter name of the state it's specific
    Help: All if for all states (base product) or state specific name

    upd-date Data type: DATE
    Format: 99/99/9999
    Help: Date record was last updated

    upd-time Data type: CHARACTER
    Format: x(8)
    Help: Time record was last updated

    upd-user-name Data type: CHARACTER
    Format: x(16)
    Help: User who last updated this record

    Created on 03/01/2019 by DBHTML V1.2