RFTL - biuan.com SDK Developer - SAP® Business ONE (SBO)

API RFTL

SBO SQL database table details

Field	Description	Type	Constraints	Size	Default	Primary_Key	Unique
Created	Creation date	Date		8
Updated	Update dateS	Date		8
Language ^KEY ^UNIQUE	Language code	Int		11		UNIQUE_ID	Yes
Name	FITL name	nVarChar		64
Num	Item number	Int		11
ItemType	Item type	Int	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
Enabled	Enabled	VarChar	0 1) Yes	1	1
_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	0 1) Static	1	0
IndexVal	Index value	Int		11
FatIdxType	Father index type	VarChar	0 1) Static	1	0
FatIdxVal	Father index value	Int		11
Editable	Editable	VarChar	0 1) Yes	1	1
Invisible	Invisible	VarChar	0 1) Yes	1	0
SuppressZe	Suppress zeros	VarChar	0 1) Yes	1	0
DfltButton	Default button	VarChar	0 1) Yes	1	0
DataRequir	Data required	VarChar	0 1) Yes	1	0
ForceUpper	Force upper	VarChar	0 1) Yes	1	0
RightJust	Right justified	VarChar	0 1) Yes	1	1
UserType	User type	VarChar	0 1) Yes	1	0
Override	Override validation	VarChar	0 1) Yes	1	0
Sentence	Sentencing	VarChar	0 1) Yes	1	0
ShowType	Show type	VarChar	0 1) Value only 2) Description only	1	0
DispDecr	Display description	VarChar	0 1) Yes	1	0
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 ^KEY	Item string	nVarChar		64		STRING	No
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

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

biuan SAP® BUSINESS ONE

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