biuan SAP® BUSINESS ONE SDK
API RFTL
RFTL - FITL resource Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CreatedCreation dateDate
8
UpdatedUpdate dateSDate
8
Language KEY UNIQUELanguage codeInt
11
UNIQUE_IDYes
NameFITL namenVarChar
64
NumItem numberInt
11
ItemTypeItem typeInt
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
11
EnabledEnabledVarChar
0
1) Yes
1
1
_TopTopInt
11
_BottomBottomInt
11
_LeftLeftInt
11
_RightRightInt
11
ItemResItem resourceInt
11
FontFont numberInt
11
FontSizeFont sizeInt
11
AttributesAttributesInt
11
StyleStyleInt
11
ModeModeInt
11
VarNumVariable numberInt
11
AttrVarAttribute variableInt
11
NewLineVarNew line variableInt
11
ProcVarProc variableInt
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
InvisibleInvisibleVarChar
0
1) Yes
1
0
SuppressZeSuppress zerosVarChar
0
1) Yes
1
0
DfltButtonDefault buttonVarChar
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
OverrideOverride validationVarChar
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
TabOrderTAB orderInt
11
LinkToLink to itemInt
11
DragEntityDrag entityInt
11
FromPaneFrom paneInt
11
ToPaneTo paneInt
11
ClassClassInt
11
ItemString KEYItem stringnVarChar
64
STRINGNo
StringUpdString update dateDate
8
StringLenString lengthInt
11
ItemDescItem descriptionnVarChar
30
DescUpdDescription update dateDate
8
DescLenDescription lengthInt
11
FrameRedFrame redInt
11
FrameGreenFrame greenInt
11
FrameBlueFrame blueInt
11
BodyRedBody redInt
11
BodyGreenBody greenInt
11
BodyBlueBody blueInt
11
TextRedText redInt
11
TextGreenText greenInt
11
TextBlueText blueInt
11
ThumbRedThumb redInt
11
ThumbGreenThumb greenInt
11
ThumbBlueThumb blueInt
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
UniqueIDUnique IDnVarChar
10

SELECT statement

SELECT RFTL.Created AS 'Creation date', RFTL.Updated AS 'Update dateS', RFTL.Language AS 'Language code', RFTL.Name AS 'FITL name', RFTL.Num AS 'Item number', RFTL.ItemType AS 'Item type', RFTL.Enabled AS 'Enabled', RFTL._Top AS 'Top', RFTL._Bottom AS 'Bottom', RFTL._Left AS 'Left', RFTL._Right AS 'Right', RFTL.ItemRes AS 'Item resource', RFTL.Font AS 'Font number', RFTL.FontSize AS 'Font size', RFTL.Attributes AS 'Attributes', RFTL.Style AS 'Style', RFTL.Mode AS 'Mode', RFTL.VarNum AS 'Variable number', RFTL.AttrVar AS 'Attribute variable', RFTL.NewLineVar AS 'New line variable', RFTL.ProcVar AS 'Proc variable', RFTL.LinkVar AS 'Link variable', RFTL.DragVar AS 'Drag variable', RFTL.FileCode AS 'File code', RFTL.FieldNum AS 'Field number', RFTL.IndexType AS 'Index type', RFTL.IndexVal AS 'Index value', RFTL.FatIdxType AS 'Father index type', RFTL.FatIdxVal AS 'Father index value', RFTL.Editable AS 'Editable', RFTL.Invisible AS 'Invisible', RFTL.SuppressZe AS 'Suppress zeros', RFTL.DfltButton AS 'Default button', RFTL.DataRequir AS 'Data required', RFTL.ForceUpper AS 'Force upper', RFTL.RightJust AS 'Right justified', RFTL.UserType AS 'User type', RFTL.Override AS 'Override validation', RFTL.Sentence AS 'Sentencing', RFTL.ShowType AS 'Show type', RFTL.DispDecr AS 'Display description', RFTL.TabOrder AS 'TAB order', RFTL.LinkTo AS 'Link to item', RFTL.DragEntity AS 'Drag entity', RFTL.FromPane AS 'From pane', RFTL.ToPane AS 'To pane', RFTL.Class AS 'Class', RFTL.ItemString AS 'Item string', RFTL.StringUpd AS 'String update date', RFTL.StringLen AS 'String length', RFTL.ItemDesc AS 'Item description', RFTL.DescUpd AS 'Description update date', RFTL.DescLen AS 'Description length', RFTL.FrameRed AS 'Frame red', RFTL.FrameGreen AS 'Frame green', RFTL.FrameBlue AS 'Frame blue', RFTL.BodyRed AS 'Body red', RFTL.BodyGreen AS 'Body green', RFTL.BodyBlue AS 'Body blue', RFTL.TextRed AS 'Text red', RFTL.TextGreen AS 'Text green', RFTL.TextBlue AS 'Text blue', RFTL.ThumbRed AS 'Thumb red', RFTL.ThumbGreen AS 'Thumb green', RFTL.ThumbBlue AS 'Thumb blue', RFTL.TxtFgRed AS 'Text foreground red', RFTL.TxtFgGreen AS 'Text foreground green', RFTL.TxtFgBlue AS 'Text foreground blue', RFTL.TxtBgRed AS 'Text background red', RFTL.TxtBgGreen AS 'Text background green', RFTL.TxtBgBlue AS 'Text background green', RFTL.UniqueID AS 'Unique ID' FROM RFTL AS RFTL

Related information




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