Field Details
| Field name | Data type | Length | Mandatory | Comments |
|---|---|---|---|---|
| MENU_ID | Decimal | Yes |
|
|
| MENU_NAME | String | 30 | Yes | |
| LAST_UPDATE_DATE | DateTime | No | yyyy-mm-dd hh:mi:ss:mmmm | |
| LAST_UPDATED_BY | Decimal | No |
|
|
| LAST_UPDATE_LOGIN | Int | 15 | No | |
| CREATION_DATE | DateTime | No | yyyy-mm-dd hh:mi:ss:mmmm | |
| CREATED_BY | Int | 15 | No | |
| TYPE | String | 30 | No | |
| SECURITY_GROUP_ID | Decimal | No |
|
|
| USER_MENU_NAME | String | 80 | Yes | |
| DESCRIPTION | String | 240 | No | |
| LANGUAGE | String | 4 | Yes |
Note: The MENU_ID must be unique.