|
|
SAP Business One SDK 10.0 - Database Tables Reference |
FITL resource
Table Name: RFTL
Table Description: FITL resource
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| Created | Creation date | Date | 8 | - | Â | Â | Â |
| Updated | Update dateS | Date | 8 | - | Â | Â | Â |
| Language | Language code | Int | 11 | - | Â | Â | Â |
| Name | FITL name | nVarChar | 64 | - | Â | Â | Â |
| Num | Item number | Int | 11 | - | Â | Â | Â |
| ItemType | Item type | Int | 11 | - | Â | 4 | Button |
| Â | Â | Â | Â | Â | Â | 121 | Check box |
| Â | Â | Â | Â | Â | Â | 114 | Edit popup |
| Â | Â | Â | Â | Â | Â | 16 | Edit text |
| Â | Â | Â | Â | Â | Â | 118 | Extended edit |
| Â | Â | Â | Â | Â | Â | 99 | Folder |
| Â | Â | Â | Â | Â | Â | 101 | FwdBck button |
| Â | Â | Â | Â | Â | Â | 123 | Graph |
| Â | Â | Â | Â | Â | Â | 124 | Icon |
| Â | Â | Â | Â | Â | Â | 116 | Link button |
| Â | Â | Â | Â | Â | Â | 127 | Matrix |
| Â | Â | Â | Â | Â | Â | 120 | Media |
| Â | Â | Â | Â | Â | Â | 103 | Multi page |
| Â | Â | Â | Â | Â | Â | 115 | Pane button |
| Â | Â | Â | Â | Â | Â | 104 | Pane popup |
| Â | Â | Â | Â | Â | Â | 117 | Picture |
| Â | Â | Â | Â | Â | Â | 98 | Pipe |
| Â | Â | Â | Â | Â | Â | 125 | Popup |
| Â | Â | Â | Â | Â | Â | 119 | Preview |
| Â | Â | Â | Â | Â | Â | 112 | Progress |
| Â | Â | Â | Â | Â | Â | 122 | Radio button |
| Â | Â | Â | Â | Â | Â | 100 | Rectangle |
| Â | Â | Â | Â | Â | Â | 113 | Select popup |
| Â | Â | Â | Â | Â | Â | 8 | Static text |
| Â | Â | Â | Â | Â | Â | 102 | User group |
| Â | Â | Â | Â | Â | Â | 0 | User item |
| Enabled | Enabled | VarChar | 1 | - | 1 | 0 | No |
| Â | Â | Â | Â | Â | Â | 1 | Yes |
| _Top | Top | Int | 11 | - | Â | Â | Â |
| _Bottom | Bottom | Int | 11 | - | Â | Â | Â |
| _Left | Left | Int | 11 | - | Â | Â | Â |
| _Right | Right | Int | 11 | - | Â | Â | Â |
| ItemRes | Item 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 | - | Â | Â | Â |
| VarNum | Variable number | Int | 11 | - | Â | Â | Â |
| AttrVar | Attribute variable | Int | 11 | - | Â | Â | Â |
| NewLineVar | New line variable | Int | 11 | - | Â | Â | Â |
| ProcVar | Proc variable | 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 |
| Invisible | Invisible | VarChar | 1 | - | 0 | 0 | No |
| Â | Â | Â | Â | Â | Â | 1 | Yes |
| SuppressZe | Suppress zeros | VarChar | 1 | - | 0 | 0 | No |
| Â | Â | Â | Â | Â | Â | 1 | Yes |
| DfltButton | Default button | 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 |
| Override | Override validation | 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 |
| TabOrder | TAB order | Int | 11 | - | Â | Â | Â |
| LinkTo | Link to item | Int | 11 | - | Â | Â | Â |
| DragEntity | Drag entity | Int | 11 | - | Â | Â | Â |
| FromPane | From pane | Int | 11 | - | Â | Â | Â |
| ToPane | To pane | Int | 11 | - | Â | Â | Â |
| Class | Class | Int | 11 | - | Â | Â | Â |
| ItemString | Item string | nVarChar | 64 | - | Â | Â | Â |
| StringUpd | String update date | Date | 8 | - | Â | Â | Â |
| StringLen | String length | Int | 11 | - | Â | Â | Â |
| ItemDesc | Item description | nVarChar | 30 | - | Â | Â | Â |
| DescUpd | Description update date | Date | 8 | - | Â | Â | Â |
| DescLen | Description length | Int | 11 | - | Â | Â | Â |
| FrameRed | Frame red | Int | 11 | - | Â | Â | Â |
| FrameGreen | Frame green | Int | 11 | - | Â | Â | Â |
| FrameBlue | Frame blue | Int | 11 | - | Â | Â | Â |
| BodyRed | Body red | Int | 11 | - | Â | Â | Â |
| BodyGreen | Body green | Int | 11 | - | Â | Â | Â |
| BodyBlue | Body blue | Int | 11 | - | Â | Â | Â |
| TextRed | Text red | Int | 11 | - | Â | Â | Â |
| TextGreen | Text green | Int | 11 | - | Â | Â | Â |
| TextBlue | Text blue | Int | 11 | - | Â | Â | Â |
| ThumbRed | Thumb red | Int | 11 | - | Â | Â | Â |
| ThumbGreen | Thumb green | Int | 11 | - | Â | Â | Â |
| ThumbBlue | Thumb blue | 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 | - | Â | Â | Â |
| UniqueID | Unique ID | nVarChar | 10 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | Language |
| Â | Â | Name |
| Â | Â | Num |
| M_NAME | No | Name |
| Â | Â | Num |
| STRING | No | ItemString |
| UNIQUE_ID | Yes | Language |
| Â | Â | Name |
| Â | Â | UniqueID |