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

API ITMR

SBO SQL database table details

Field	Description	Type	Constraints	Size	Default	Primary_Key	Unique
DocCode	Report	nVarChar		8
ItemId	Item ID	Int		6
Container	Parent Type	Int		6
Type	Type	Int	1) Page header 2) Start of report 3) Repetitive area header 4) Repetitive area 5) Repetitive area footer 6) End of report 7) Page footer 10) Text field 11) Picture field 12) User field	6
VISIBLE	Visible	VarChar	1) Yes 0	1	1
SupZeros	Suppress Zeros	VarChar	1) Yes 0	1	0
ItemLeft	Left Item	Int		6
ItemTop	Top	Int		6
Width	Width	Int		6
Height	Height	Int		6
LMargin	Left Margin	Int		6	0
RMargin	Right Margin	Int		6	0
TMargin	Top Margin	Int		6	0
BMargin	Bottom Margin	Int		6	0
LeftLine	Left Border Line Thickness	Int		6	0
RightLine	Right Border Line Thickness	Int		6	0
TopLine	Top Border Line Thickness	Int		6	0
BottomLine	Bottom Border Line Thickness	Int		6	0
Shadow	Shadow Thickness	Int		6	0
BGRed	Background - Red	Int		11	65535
BGGreen	Background - Green	Int		11	65535
BGBlue	Background - Blue	Int		11	65535
FGRed	Text - Red	Int		11	0
FGGreen	Text - Green	Int		11	0
FGBlue	Text - Blue	Int		11	0
MrkrRed	Bold - Red	Int		11	65535
MrkrGreen	Bold - Green	Int		11	65535
MrkrBlue	Bold - Blue	Int		11	65535
BrdrRed	Border - Red	Int		11	0
BrdrGreen	Border - Green	Int		11	0
BrdrBlue	Border - Blue	Int		11	0
FromPane	From Area	Int		6	0
ToPane	To Area	Int		6	0
ItemGroup	Group No.	Int		6	0
FontName	Font Name	nVarChar		50	Arial
FontSize	Font Size	Int		6	12
TextStyle	Text Style	Int		11
Justific	Horizontal Justification	VarChar	1) Right 2) Left 3) Center 4) Language Dependent	1	2
WRAP	Segment	VarChar	0 1) Fit to cell 2) Devide to lines	1	1
PictSize	Picture Size	VarChar	0 1) Size of box 2) Adjust to box 3) Adjust to box height 4) Adjust to box width	1	1
DataSource	Data Source	VarChar	1) Static 2) Var 3) Data 4) Calculation	1	1
ItemStr	String	Text		16
VarNum	Variable No.	Int		6
FileName	File Name	nVarChar		20
FieldNum	Field No.	nVarChar		10
ShowDescr	Display Description	VarChar	1) Yes 0	1	0
CalcType	Calculation Type	nVarChar	0 1) Page number 17) Total Pages 2) Date 3) Time 4) Column total 5) Column average 6) General row no. 7) Group row no. 8) Sort field name 9) Sort field content 10) Continue 11) Continued on next page 12) Generation message 13) Column summary for page 14) Column average for page 15) Column summary for report 16) Column average for report -1) [new formula String]	2	1
ChangFlags	Changeable	Int		11
ApplID	Item No.	Int		6
CalcCol	Calculation Column	Int		6
YJustific	Vertical Alignment	VarChar	1) Top 2) Bottom 3) Center	1	3
SortLevel	Sort Level	Int		6	0
RevOrder	Reverse Sort	VarChar	1) Descending 0	1	0
SortType	Sort Type	VarChar	0 1) Numeric 2) Money 3) Date	1	0
IsUnique	Unique	VarChar	1) Yes 0	1	0
IsGroup	Set as Group	VarChar	1) Yes 0	1	0
NewPage	New Page	VarChar	1) Yes 0	1	0
BarCode	Print as Barcode	VarChar	1) Yes 0	1	0
Condition	Condition	Text		16
LinkTo	Link to Item	Int		6	0
Operator1	Operator 1	Int		6
Operator2	Operator 2	Int		6
Operation	Operation	Int	0 (-0) Aritmathic operation 1) + 2) - 3) x 4) / 5) % 17) Left 18) Right 19) Round (-1) String operation 6) $Concat 7) $Right 8) $Left 9) $Sentence 16) $Len 20) $Currency 21) $Number (-2) Condition operation 10) Less 11) LessEq 12) Equally 13) Not eq 14) GrEq 15) Greater	6	0
BCStandard	Barcode Standard	Int	0 1) Code 39 2) Code 128	6	0
SumInWords	Display Total as a Word	VarChar	1) Yes 0	1	0
ExcFonting	Block Font Change	VarChar	1) Yes 0	1	0
StrIndex	String Index	Int		11	0
ContIndex	Container Index	Int		6	0
ItemIndex	Item Index	Int		6	0
StrLength	String Length	Int		6
StrFiller	String Filler	VarChar		1
RelatedTo	Related to Item	Int		6	0
NextSeg	Next Segment Item Num	Int		6	0
HightAdjst	Height Adjustments	VarChar	Y) Yes N) No	1	N
DupRpttAre	Duplicate Repeatative Area	VarChar	Y) Yes N) No	1	N
LnsRpttAre	Num Lines In Repeatative Area	Int		11	0
RptDupDist	Distanse To Rptt Dup (pixels)	Int		11	0
ItemDesc	Item Description	nVarChar		50
ExportXml	Export to xml	VarChar	Y) Yes N) No	1	Y
DocType ^KEY	Document Type	nVarChar		4		TYPE	No
Local	Localization	nVarChar		2
Numerator	Numerator	Int		6
Language	Language	Int		6
Created	Creation Date	Date		8
Updated	Updated Date	Date		8
UsrSgnStr	User Sign For Strings Change	Int		11	-1
UsrSgnAttr	User Sign For Attribs Change	Int		11	-1
IsRef	Is the item refered by another	VarChar	Y) Yes N) No	1	N
FieldId	Field Identifier	nVarChar		20
FGEnabled	Grid Enabled	VarChar	Y) Yes N) No	1	Y
BGEnabled	Background Enabled	VarChar	Y) Yes N) No	1	Y
MKEnabled	Highlight Enabled	VarChar	Y) Yes N) No	1	Y
BDEnabled	Frame Enabled	VarChar	Y) Yes N) No	1	Y
HidEmpRptt	Hide Empty Area	VarChar	Y) Yes N) No	1	N
RpttFtrAll	Display Rep. Footer on All	VarChar	Y) Yes N) No	1	N
GbiDataTyp	Data Type	Int	0 1) C n 2) C.. n 3) I.. n 4) D w.d	6	0
GbiDataLen	Data Length	nVarChar		6
PageBreak	Page Break	Int	0 1) Before Area 2) After Area	6	0
IsLogo	Is Logo	VarChar	Y) Yes N) No	1	N
VarDefName	Variable Definition Name	nVarChar		50
ResCode	Resource Code from RSBD	Int		11	-1
RevCode	Revision Code	Int		11	-1

SELECT statement

SELECT
   ITMR.DocCode AS 'Report', 
   ITMR.ItemId AS 'Item ID', 
   ITMR.Container AS 'Parent Type', 
   ITMR.Type AS 'Type', 
   ITMR.VISIBLE AS 'Visible', 
   ITMR.SupZeros AS 'Suppress Zeros', 
   ITMR.ItemLeft AS 'Left Item', 
   ITMR.ItemTop AS 'Top', 
   ITMR.Width AS 'Width', 
   ITMR.Height AS 'Height', 
   ITMR.LMargin AS 'Left Margin', 
   ITMR.RMargin AS 'Right Margin', 
   ITMR.TMargin AS 'Top Margin', 
   ITMR.BMargin AS 'Bottom Margin', 
   ITMR.LeftLine AS 'Left Border Line Thickness', 
   ITMR.RightLine AS 'Right Border Line Thickness', 
   ITMR.TopLine AS 'Top Border Line Thickness', 
   ITMR.BottomLine AS 'Bottom Border Line Thickness', 
   ITMR.Shadow AS 'Shadow Thickness', 
   ITMR.BGRed AS 'Background - Red', 
   ITMR.BGGreen AS 'Background - Green', 
   ITMR.BGBlue AS 'Background - Blue', 
   ITMR.FGRed AS 'Text - Red', 
   ITMR.FGGreen AS 'Text - Green', 
   ITMR.FGBlue AS 'Text - Blue', 
   ITMR.MrkrRed AS 'Bold - Red', 
   ITMR.MrkrGreen AS 'Bold - Green', 
   ITMR.MrkrBlue AS 'Bold - Blue', 
   ITMR.BrdrRed AS 'Border - Red', 
   ITMR.BrdrGreen AS 'Border - Green', 
   ITMR.BrdrBlue AS 'Border - Blue', 
   ITMR.FromPane AS 'From Area', 
   ITMR.ToPane AS 'To Area', 
   ITMR.ItemGroup AS 'Group No.', 
   ITMR.FontName AS 'Font Name', 
   ITMR.FontSize AS 'Font Size', 
   ITMR.TextStyle AS 'Text Style', 
   ITMR.Justific AS 'Horizontal Justification', 
   ITMR.WRAP AS 'Segment', 
   ITMR.PictSize AS 'Picture Size', 
   ITMR.DataSource AS 'Data Source', 
   ITMR.ItemStr AS 'String', 
   ITMR.VarNum AS 'Variable No.', 
   ITMR.FileName AS 'File Name', 
   ITMR.FieldNum AS 'Field No.', 
   ITMR.ShowDescr AS 'Display Description', 
   ITMR.CalcType AS 'Calculation Type', 
   ITMR.ChangFlags AS 'Changeable', 
   ITMR.ApplID AS 'Item No.', 
   ITMR.CalcCol AS 'Calculation Column', 
   ITMR.YJustific AS 'Vertical Alignment', 
   ITMR.SortLevel AS 'Sort Level', 
   ITMR.RevOrder AS 'Reverse Sort', 
   ITMR.SortType AS 'Sort Type', 
   ITMR.IsUnique AS 'Unique', 
   ITMR.IsGroup AS 'Set as Group', 
   ITMR.NewPage AS 'New Page', 
   ITMR.BarCode AS 'Print as Barcode', 
   ITMR.Condition AS 'Condition', 
   ITMR.LinkTo AS 'Link to Item', 
   ITMR.Operator1 AS 'Operator 1', 
   ITMR.Operator2 AS 'Operator 2', 
   ITMR.Operation AS 'Operation', 
   ITMR.BCStandard AS 'Barcode Standard', 
   ITMR.SumInWords AS 'Display Total as a Word', 
   ITMR.ExcFonting AS 'Block Font Change', 
   ITMR.StrIndex AS 'String Index', 
   ITMR.ContIndex AS 'Container Index', 
   ITMR.ItemIndex AS 'Item Index', 
   ITMR.StrLength AS 'String Length', 
   ITMR.StrFiller AS 'String Filler', 
   ITMR.RelatedTo AS 'Related to Item', 
   ITMR.NextSeg AS 'Next Segment Item Num', 
   ITMR.HightAdjst AS 'Height Adjustments', 
   ITMR.DupRpttAre AS 'Duplicate Repeatative Area', 
   ITMR.LnsRpttAre AS 'Num Lines In Repeatative Area', 
   ITMR.RptDupDist AS 'Distanse To Rptt Dup (pixels)', 
   ITMR.ItemDesc AS 'Item Description', 
   ITMR.ExportXml AS 'Export to xml', 
   ITMR.DocType AS 'Document Type', 
   ITMR.Local AS 'Localization', 
   ITMR.Numerator AS 'Numerator', 
   ITMR.Language AS 'Language', 
   ITMR.Created AS 'Creation Date', 
   ITMR.Updated AS 'Updated Date', 
   ITMR.UsrSgnStr AS 'User Sign For Strings Change', 
   ITMR.UsrSgnAttr AS 'User Sign For Attribs Change', 
   ITMR.IsRef AS 'Is the item refered by another', 
   ITMR.FieldId AS 'Field Identifier', 
   ITMR.FGEnabled AS 'Grid Enabled', 
   ITMR.BGEnabled AS 'Background Enabled', 
   ITMR.MKEnabled AS 'Highlight Enabled', 
   ITMR.BDEnabled AS 'Frame Enabled', 
   ITMR.HidEmpRptt AS 'Hide Empty Area', 
   ITMR.RpttFtrAll AS 'Display Rep. Footer on All', 
   ITMR.GbiDataTyp AS 'Data Type', 
   ITMR.GbiDataLen AS 'Data Length', 
   ITMR.PageBreak AS 'Page Break', 
   ITMR.IsLogo AS 'Is Logo', 
   ITMR.VarDefName AS 'Variable Definition Name', 
   ITMR.ResCode AS 'Resource Code from RSBD', 
   ITMR.RevCode AS 'Revision Code'
FROM ITMR AS ITMR

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