biuan SAP® BUSINESS ONE SDK
API Attachments / Item
ITEM - Item Resource Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CreatedCreation DateDate
8
UpdatedUpdate DateDate
8
Name KEY UNIQUEForm NamenVarChar
64
UNIQUE_IDYes
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) Grid
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) ActiveX
0
129) Button Combo
11
EnabledEnabledVarChar
0
1) Yes
1
1
_TopTopInt
11
_BottomBottomInt
11
_LeftLeftInt
11
_RightRightInt
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
FileCodeTable NamenVarChar
20
FieldNumField AliasnVarChar
10
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
2) Language dependant
3) Oppos Language
1
1
UserTypeData Binding TypeVarChar
0
1) User Variable
2) Multiple Data Type
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
StrIndex KEYString IndexInt
11
0STRINGNo
HkeyIndexHotkey IndexInt
11
DescIndexDescription IndexInt
11
0
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 BlueInt
11
UniqueIDUnique IDnVarChar
10
ItemStringItem StringnVarChar
127
ItemDescItem DescriptionnVarChar
127
HotkeyPosHotkey PositionInt
11
WrapTextWrap TextVarChar
0
1) Yes
1
0
UsrSgnStrUser Sign For String ChangeInt
11
-1
UsrSgnAttrUser Sign For Attribs ChangeInt
11
-1
FontNameFont NamenVarChar
32
ResCodeResource Code from RSBDInt
11
-1
RevCodeRevision CodeInt
11
-1
BindObjIdBind Object IdInt
11
-1

SELECT statement

SELECT ITEM.Created AS 'Creation Date', ITEM.Updated AS 'Update Date', ITEM.Name AS 'Form Name', ITEM.Num AS 'Item Number', ITEM.ItemType AS 'Item Type', ITEM.Enabled AS 'Enabled', ITEM._Top AS 'Top', ITEM._Bottom AS 'Bottom', ITEM._Left AS 'Left', ITEM._Right AS 'Right', ITEM.Font AS 'Font Number', ITEM.FontSize AS 'Font Size', ITEM.Attributes AS 'Attributes', ITEM.Style AS 'Style', ITEM.Mode AS 'Mode', ITEM.VarNum AS 'Variable Number', ITEM.AttrVar AS 'Attribute Variable', ITEM.NewLineVar AS 'New Line Variable', ITEM.ProcVar AS 'Proc Variable', ITEM.LinkVar AS 'Link Variable', ITEM.DragVar AS 'Drag Variable', ITEM.FileCode AS 'Table Name', ITEM.FieldNum AS 'Field Alias', ITEM.Editable AS 'Editable', ITEM.Invisible AS 'Invisible', ITEM.SuppressZe AS 'Suppress Zeros', ITEM.DfltButton AS 'Default Button', ITEM.DataRequir AS 'Data Required', ITEM.ForceUpper AS 'Force Upper', ITEM.RightJust AS 'Right Justified', ITEM.UserType AS 'Data Binding Type', ITEM.ShowType AS 'Show type', ITEM.DispDecr AS 'Display Description', ITEM.TabOrder AS 'TAB Order', ITEM.LinkTo AS 'Link to Item', ITEM.DragEntity AS 'Drag Entity', ITEM.FromPane AS 'From Pane', ITEM.ToPane AS 'To Pane', ITEM.Class AS 'Class', ITEM.StrIndex AS 'String Index', ITEM.HkeyIndex AS 'Hotkey Index', ITEM.DescIndex AS 'Description Index', ITEM.FrameRed AS 'Frame Red', ITEM.FrameGreen AS 'Frame Green', ITEM.FrameBlue AS 'Frame Blue', ITEM.BodyRed AS 'Body Red', ITEM.BodyGreen AS 'Body Green', ITEM.BodyBlue AS 'Body Blue', ITEM.TextRed AS 'Text Red', ITEM.TextGreen AS 'Text Green', ITEM.TextBlue AS 'Text Blue', ITEM.ThumbRed AS 'Thumb Red', ITEM.ThumbGreen AS 'Thumb Green', ITEM.ThumbBlue AS 'Thumb Blue', ITEM.TxtFgRed AS 'Text Foreground Red', ITEM.TxtFgGreen AS 'Text Foreground Green', ITEM.TxtFgBlue AS 'Text Foreground blue', ITEM.TxtBgRed AS 'Text Background Red', ITEM.TxtBgGreen AS 'Text Background Green', ITEM.TxtBgBlue AS 'Text Background Blue', ITEM.UniqueID AS 'Unique ID', ITEM.ItemString AS 'Item String', ITEM.ItemDesc AS 'Item Description', ITEM.HotkeyPos AS 'Hotkey Position', ITEM.WrapText AS 'Wrap Text', ITEM.UsrSgnStr AS 'User Sign For String Change', ITEM.UsrSgnAttr AS 'User Sign For Attribs Change', ITEM.FontName AS 'Font Name', ITEM.ResCode AS 'Resource Code from RSBD', ITEM.RevCode AS 'Revision Code', ITEM.BindObjId AS 'Bind Object Id' FROM ITEM AS ITEM

Related information


Item Item Method· Table: ITEM
Retrieves an existing attachment item from the Attachments object.
   Parent: Attachments Attachments Collection


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