biuan SAP® BUSINESS ONE SDK
API RMTL
RMTL - MITL resource Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CreatedCreation dateDate
8
UpdatedUpdate dateDate
8
Language KEY UNIQUELanguage codeInt
11
UNIQUE_IDYes
NameMITL namenVarChar
64
NumColumn numberInt
11
ItemTypeItem typeInt
0
16) Edit text
105) Bar
113) Select popup
116) Link button
121) Check box
117) Picture
11
0
EnabledEnabledVarChar
0
1) Yes
1
1
CellTypeCellTypeInt
0
16) Edit text
105) Bar
113) Select popup
116) Link button
121) Check box
11
16
CellResCell resourceInt
11
FontFont numberInt
11
FontSizeFont sizeInt
11
AttributesAttributesInt
11
StyleStyleInt
11
ModeModeInt
11
TitleTypeTitle typeInt
0
117) Picture
11
0
TitleEnablTitle enabledVarChar
1
TitleResTitle resourceInt
11
TitleFontTitle font numberInt
11
TFontSizeTitle font sizeInt
11
TitleAttrTitle attributesInt
11
TitleStyleTitle styleInt
11
TitleModeTitle modeInt
11
VarNumVariable numberInt
11
LinkVarLink variableInt
11
DragVarDrag variableInt
11
FileCodeFile codenVarChar
8
FieldNumField numberInt
11
IndexTypeIndex typeVarChar
0
1) Static
1
0
IndexValIndex valueInt
11
FatIdxTypeFather index typeVarChar
0
1) Static
1
0
FatIdxValFather index valueInt
11
EditableEditableVarChar
0
1) Yes
1
1
SuppressZeSuppress zerosVarChar
0
1) Yes
1
0
DataRequirData requiredVarChar
0
1) Yes
1
0
ForceUpperForce upperVarChar
0
1) Yes
1
0
RightJustRight justifiedVarChar
0
1) Yes
1
1
UserTypeUser typeVarChar
0
1) Yes
1
0
SentenceSentencingVarChar
0
1) Yes
1
0
ShowTypeShow typeVarChar
0
1) Value only
2) Description only
1
0
DispDecrDisplay descriptionVarChar
0
1) Yes
1
0
LinkToLink to itemInt
11
DragEntityDrag entityInt
11
ClassClassInt
11
ItemStringItem stringnVarChar
64
StringUpdString update dateDate
8
StringLenString lengthInt
11
TitleTitle stringnVarChar
64
TitleUpdTitle updatedDate
8
TitleLenTitle lengthInt
11
ItemDescItem descriptionnVarChar
30
DescUpdDescription update dateDate
8
DescLenDescription lengthInt
11
TxtFgRedText foreground redInt
11
TxtFgGreenText foreground greenInt
11
TxtFgBlueText foreground blueInt
11
TxtBgRedText background redInt
11
TxtBgGreenText background greenInt
11
TxtBgBlueText background greenInt
11
TtlFgRedTitle foreground redInt
11
TtlFgGreenTitle foreground greenInt
11
TtlFgBlueTitle foreground blueInt
11
TtlBgRedTitle background redInt
11
TtlBgGreenTitle background greenInt
11
TtlBgBlueTitle background blueInt
11
WidthWidthInt
11
UserLenUser lengthInt
11
SuppRepeatSuppress repeatingVarChar
0
1) Yes
1
0
AutoGraphAuto graphVarChar
0
1) Yes
1
0
AutoCummAuto cummulativeVarChar
0
1) Yes
1
0
UniqueIDUnique IDnVarChar
10

SELECT statement

SELECT RMTL.Created AS 'Creation date', RMTL.Updated AS 'Update date', RMTL.Language AS 'Language code', RMTL.Name AS 'MITL name', RMTL.Num AS 'Column number', RMTL.ItemType AS 'Item type', RMTL.Enabled AS 'Enabled', RMTL.CellType AS 'CellType', RMTL.CellRes AS 'Cell resource', RMTL.Font AS 'Font number', RMTL.FontSize AS 'Font size', RMTL.Attributes AS 'Attributes', RMTL.Style AS 'Style', RMTL.Mode AS 'Mode', RMTL.TitleType AS 'Title type', RMTL.TitleEnabl AS 'Title enabled', RMTL.TitleRes AS 'Title resource', RMTL.TitleFont AS 'Title font number', RMTL.TFontSize AS 'Title font size', RMTL.TitleAttr AS 'Title attributes', RMTL.TitleStyle AS 'Title style', RMTL.TitleMode AS 'Title mode', RMTL.VarNum AS 'Variable number', RMTL.LinkVar AS 'Link variable', RMTL.DragVar AS 'Drag variable', RMTL.FileCode AS 'File code', RMTL.FieldNum AS 'Field number', RMTL.IndexType AS 'Index type', RMTL.IndexVal AS 'Index value', RMTL.FatIdxType AS 'Father index type', RMTL.FatIdxVal AS 'Father index value', RMTL.Editable AS 'Editable', RMTL.SuppressZe AS 'Suppress zeros', RMTL.DataRequir AS 'Data required', RMTL.ForceUpper AS 'Force upper', RMTL.RightJust AS 'Right justified', RMTL.UserType AS 'User type', RMTL.Sentence AS 'Sentencing', RMTL.ShowType AS 'Show type', RMTL.DispDecr AS 'Display description', RMTL.LinkTo AS 'Link to item', RMTL.DragEntity AS 'Drag entity', RMTL.Class AS 'Class', RMTL.ItemString AS 'Item string', RMTL.StringUpd AS 'String update date', RMTL.StringLen AS 'String length', RMTL.Title AS 'Title string', RMTL.TitleUpd AS 'Title updated', RMTL.TitleLen AS 'Title length', RMTL.ItemDesc AS 'Item description', RMTL.DescUpd AS 'Description update date', RMTL.DescLen AS 'Description length', RMTL.TxtFgRed AS 'Text foreground red', RMTL.TxtFgGreen AS 'Text foreground green', RMTL.TxtFgBlue AS 'Text foreground blue', RMTL.TxtBgRed AS 'Text background red', RMTL.TxtBgGreen AS 'Text background green', RMTL.TxtBgBlue AS 'Text background green', RMTL.TtlFgRed AS 'Title foreground red', RMTL.TtlFgGreen AS 'Title foreground green', RMTL.TtlFgBlue AS 'Title foreground blue', RMTL.TtlBgRed AS 'Title background red', RMTL.TtlBgGreen AS 'Title background green', RMTL.TtlBgBlue AS 'Title background blue', RMTL.Width AS 'Width', RMTL.UserLen AS 'User length', RMTL.SuppRepeat AS 'Suppress repeating', RMTL.AutoGraph AS 'Auto graph', RMTL.AutoCumm AS 'Auto cummulative', RMTL.UniqueID AS 'Unique ID' FROM RMTL AS RMTL

Related information




SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates