|
|
SAP Business One SDK 10.0 - Database Tables Reference |
MITL resource
Table Name: RMTL
Table Description: MITL resource
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| Created | Creation date | Date | 8 | - | Â | Â | Â |
| Updated | Update date | Date | 8 | - | Â | Â | Â |
| Language | Language code | Int | 11 | - | Â | Â | Â |
| Name | MITL name | nVarChar | 64 | - | Â | Â | Â |
| Num | Column number | Int | 11 | - | Â | Â | Â |
| ItemType | Item type | Int | 11 | - | 0 | 0 | None |
| Â | Â | Â | Â | Â | Â | 16 | Edit text |
| Â | Â | Â | Â | Â | Â | 105 | Bar |
| Â | Â | Â | Â | Â | Â | 113 | Select popup |
| Â | Â | Â | Â | Â | Â | 116 | Link button |
| Â | Â | Â | Â | Â | Â | 121 | Check box |
| Â | Â | Â | Â | Â | Â | 117 | Picture |
| Enabled | Enabled | VarChar | 1 | - | 1 | 0 | No |
| Â | Â | Â | Â | Â | Â | 1 | Yes |
| CellType | CellType | Int | 11 | - | 16 | 0 | None |
| Â | Â | Â | Â | Â | Â | 16 | Edit text |
| Â | Â | Â | Â | Â | Â | 105 | Bar |
| Â | Â | Â | Â | Â | Â | 113 | Select popup |
| Â | Â | Â | Â | Â | Â | 116 | Link button |
| Â | Â | Â | Â | Â | Â | 121 | Check box |
| CellRes | Cell resource | Int | 11 | - | Â | Â | Â |
| Font | Font number | Int | 11 | - | Â | Â | Â |
| FontSize | Font size | Int | 11 | - | Â | Â | Â |
| Attributes | Attributes | Int | 11 | - | Â | Â | Â |
| Style | Style | Int | 11 | - | Â | Â | Â |
| Mode | Mode | Int | 11 | - | Â | Â | Â |
| TitleType | Title type | Int | 11 | - | 0 | 0 | None |
| Â | Â | Â | Â | Â | Â | 117 | Picture |
| TitleEnabl | Title enabled | VarChar | 1 | - | Â | Â | Â |
| TitleRes | Title resource | Int | 11 | - | Â | Â | Â |
| TitleFont | Title font number | Int | 11 | - | Â | Â | Â |
| TFontSize | Title font size | Int | 11 | - | Â | Â | Â |
| TitleAttr | Title attributes | Int | 11 | - | Â | Â | Â |
| TitleStyle | Title style | Int | 11 | - | Â | Â | Â |
| TitleMode | Title mode | Int | 11 | - | Â | Â | Â |
| VarNum | Variable number | Int | 11 | - | Â | Â | Â |
| LinkVar | Link variable | Int | 11 | - | Â | Â | Â |
| DragVar | Drag variable | Int | 11 | - | Â | Â | Â |
| FileCode | File code | nVarChar | 8 | - | Â | Â | Â |
| FieldNum | Field number | Int | 11 | - | Â | Â | Â |
| IndexType | Index type | VarChar | 1 | - | 0 | 0 | Variable |
| Â | Â | Â | Â | Â | Â | 1 | Static |
| IndexVal | Index value | Int | 11 | - | Â | Â | Â |
| FatIdxType | Father index type | VarChar | 1 | - | 0 | 0 | Variable |
| Â | Â | Â | Â | Â | Â | 1 | Static |
| FatIdxVal | Father index value | Int | 11 | - | Â | Â | Â |
| Editable | Editable | VarChar | 1 | - | 1 | 0 | No |
| Â | Â | Â | Â | Â | Â | 1 | Yes |
| SuppressZe | Suppress zeros | VarChar | 1 | - | 0 | 0 | No |
| Â | Â | Â | Â | Â | Â | 1 | Yes |
| DataRequir | Data required | VarChar | 1 | - | 0 | 0 | No |
| Â | Â | Â | Â | Â | Â | 1 | Yes |
| ForceUpper | Force upper | VarChar | 1 | - | 0 | 0 | No |
| Â | Â | Â | Â | Â | Â | 1 | Yes |
| RightJust | Right justified | VarChar | 1 | - | 1 | 0 | No |
| Â | Â | Â | Â | Â | Â | 1 | Yes |
| UserType | User type | VarChar | 1 | - | 0 | 0 | No |
| Â | Â | Â | Â | Â | Â | 1 | Yes |
| Sentence | Sentencing | VarChar | 1 | - | 0 | 0 | No |
| Â | Â | Â | Â | Â | Â | 1 | Yes |
| ShowType | Show type | VarChar | 1 | - | 0 | 0 | Value + Description |
| Â | Â | Â | Â | Â | Â | 1 | Value only |
| Â | Â | Â | Â | Â | Â | 2 | Description only |
| DispDecr | Display description | VarChar | 1 | - | 0 | 0 | No |
| Â | Â | Â | Â | Â | Â | 1 | Yes |
| LinkTo | Link to item | Int | 11 | - | Â | Â | Â |
| DragEntity | Drag entity | Int | 11 | - | Â | Â | Â |
| Class | Class | Int | 11 | - | Â | Â | Â |
| ItemString | Item string | nVarChar | 64 | - | Â | Â | Â |
| StringUpd | String update date | Date | 8 | - | Â | Â | Â |
| StringLen | String length | Int | 11 | - | Â | Â | Â |
| Title | Title string | nVarChar | 64 | - | Â | Â | Â |
| TitleUpd | Title updated | Date | 8 | - | Â | Â | Â |
| TitleLen | Title length | Int | 11 | - | Â | Â | Â |
| ItemDesc | Item description | nVarChar | 30 | - | Â | Â | Â |
| DescUpd | Description update date | Date | 8 | - | Â | Â | Â |
| DescLen | Description length | Int | 11 | - | Â | Â | Â |
| TxtFgRed | Text foreground red | Int | 11 | - | Â | Â | Â |
| TxtFgGreen | Text foreground green | Int | 11 | - | Â | Â | Â |
| TxtFgBlue | Text foreground blue | Int | 11 | - | Â | Â | Â |
| TxtBgRed | Text background red | Int | 11 | - | Â | Â | Â |
| TxtBgGreen | Text background green | Int | 11 | - | Â | Â | Â |
| TxtBgBlue | Text background green | Int | 11 | - | Â | Â | Â |
| TtlFgRed | Title foreground red | Int | 11 | - | Â | Â | Â |
| TtlFgGreen | Title foreground green | Int | 11 | - | Â | Â | Â |
| TtlFgBlue | Title foreground blue | Int | 11 | - | Â | Â | Â |
| TtlBgRed | Title background red | Int | 11 | - | Â | Â | Â |
| TtlBgGreen | Title background green | Int | 11 | - | Â | Â | Â |
| TtlBgBlue | Title background blue | Int | 11 | - | Â | Â | Â |
| Width | Width | Int | 11 | - | Â | Â | Â |
| UserLen | User length | Int | 11 | - | Â | Â | Â |
| SuppRepeat | Suppress repeating | VarChar | 1 | - | 0 | 0 | No |
| Â | Â | Â | Â | Â | Â | 1 | Yes |
| AutoGraph | Auto graph | VarChar | 1 | - | 0 | 0 | No |
| Â | Â | Â | Â | Â | Â | 1 | Yes |
| AutoCumm | Auto cummulative | VarChar | 1 | - | 0 | 0 | No |
| Â | Â | Â | Â | Â | Â | 1 | Yes |
| UniqueID | Unique ID | nVarChar | 10 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | Language |
| Â | Â | Name |
| Â | Â | Num |
| M_NAME | No | Name |
| Â | Â | Num |
| UNIQUE_ID | Yes | Language |
| Â | Â | Name |
| Â | Â | UniqueID |