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

API Attachments / Item

SBO SQL database table details

Field	Description	Type	Constraints	Size	Default	Primary_Key	Unique
Created	Creation Date	Date		8
Updated	Update Date	Date		8
Name ^KEY ^UNIQUE	Form Name	nVarChar		64		UNIQUE_ID	Yes
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) 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
Enabled	Enabled	VarChar	0 1) Yes	1	1
_Top	Top	Int		11
_Bottom	Bottom	Int		11
_Left	Left	Int		11
_Right	Right	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	Table Name	nVarChar		20
FieldNum	Field Alias	nVarChar		10
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 2) Language dependant 3) Oppos Language	1	1
UserType	Data Binding Type	VarChar	0 1) User Variable 2) Multiple Data Type	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
StrIndex ^KEY	String Index	Int		11	0	STRING	No
HkeyIndex	Hotkey Index	Int		11
DescIndex	Description Index	Int		11	0
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 Blue	Int		11
UniqueID	Unique ID	nVarChar		10
ItemString	Item String	nVarChar		127
ItemDesc	Item Description	nVarChar		127
HotkeyPos	Hotkey Position	Int		11
WrapText	Wrap Text	VarChar	0 1) Yes	1	0
UsrSgnStr	User Sign For String Change	Int		11	-1
UsrSgnAttr	User Sign For Attribs Change	Int		11	-1
FontName	Font Name	nVarChar		32
ResCode	Resource Code from RSBD	Int		11	-1
RevCode	Revision Code	Int		11	-1
BindObjId	Bind Object Id	Int		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 Method· Table: ITEM

Retrieves an existing attachment item from the Attachments object.

Parent: Attachments Attachments Collection

biuan SAP® BUSINESS ONE

Collection
Attachments

Method
Item

Enumeration

BoBOTFromStatus

BoBOTToStatus

Method

Add

GetAsXML

GetByKey

SaveToFile

SaveXML

Object

BillOfExchangeTransaction_Lines BOT1

BillOfExchangeTrans_BankPages OBNK

BillOfExchangeTrans_Deposits ODPS

Property

BankPages

BOETransactionkey

8.8 DTW DB

Browser

Deposits

IsBoeReconciled

8.8 DTW DB

Lines

PostingDate

8.8 DTW DB

StatusFrom

8.8 DTW DB

StatusTo

8.8 DTW DB

TaxDate

8.8 DTW DB

TransactionDate

8.8 DB

TransactionNumber

8.8 DB

TransactionTime

8.8 DB

UserFields

Method

Add

Item

Refresh

Object

Attachment

Property

Count

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