ITMR - SAP B1 SDK Help

Table Name: ITMR

Field	Description	Type	Size	Related	Default Value	Constraints
DocCode	Report	nVarChar	8	-
ItemId	Item ID	Int	6	-
Container	Parent Type	Int	6	-
Type	Type	Int	6	-		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
VISIBLE	Visible	VarChar	1	-	1	1	Yes
						0	No
SupZeros	Suppress Zeros	VarChar	1	-	0	1	Yes
						0	No
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	-	2	1	Right
						2	Left
						3	Center
						4	Language Dependent
WRAP	Segment	VarChar	1	-	1	0	Allow overflow
						1	Fit to cell
						2	Devide to lines
PictSize	Picture Size	VarChar	1	-	1	0	Original size
						1	Size of box
						2	Adjust to box
						3	Adjust to box height
						4	Adjust to box width
DataSource	Data Source	VarChar	1	-	1	1	Static
						2	Var
						3	Data
						4	Calculation
ItemStr	String	Text	16	-
VarNum	Variable No.	Int	6	-
FileName	File Name	nVarChar	20	-
FieldNum	Field No.	nVarChar	10	-
ShowDescr	Display Description	VarChar	1	-	0	1	Yes
						0	No
CalcType	Calculation Type	nVarChar	2	-	1	0	Formula
						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]
ChangFlags	Changeable	Int	11	-
ApplID	Item No.	Int	6	-
CalcCol	Calculation Column	Int	6	-
YJustific	Vertical Alignment	VarChar	1	-	3	1	Top
						2	Bottom
						3	Center
SortLevel	Sort Level	Int	6	-	0
RevOrder	Reverse Sort	VarChar	1	-	0	1	Descending
						0	Ascending
SortType	Sort Type	VarChar	1	-	0	0	Alpha
						1	Numeric
						2	Money
						3	Date
IsUnique	Unique	VarChar	1	-	0	1	Yes
						0	No
IsGroup	Set as Group	VarChar	1	-	0	1	Yes
						0	No
NewPage	New Page	VarChar	1	-	0	1	Yes
						0	No
BarCode	Print as Barcode	VarChar	1	-	0	1	Yes
						0	No
Condition	Condition	Text	16	-
LinkTo	Link to Item	Int	6	-	0
Operator1	Operator 1	Int	6	-
Operator2	Operator 2	Int	6	-
Operation	Operation	Int	6	-	0	0
						1	+
						2	-
						3	x
						4	/
						5	%
						17	Left
						18	Right
						19	Round
						6	$Concat
						7	$Right
						8	$Left
						9	$Sentence
						16	$Len
						20	$Currency
						21	$Number
						10	Less
						11	LessEq
						12	Equally
						13	Not eq
						14	GrEq
						15	Greater
BCStandard	Barcode Standard	Int	6	-	0	0	EAN-13
						1	Code 39
						2	Code 128
SumInWords	Display Total as a Word	VarChar	1	-	0	1	Yes
						0	No
ExcFonting	Block Font Change	VarChar	1	-	0	1	Yes
						0	No
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	1	-	N	Y	Yes
						N	No
DupRpttAre	Duplicate Repeatative Area	VarChar	1	-	N	Y	Yes
						N	No
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	1	-	Y	Y	Yes
						N	No
DocType	Document Type	nVarChar	4	-
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	1	-	N	Y	Yes
						N	No
FieldId	Field Identifier	nVarChar	20	-
FGEnabled	Grid Enabled	VarChar	1	-	Y	Y	Yes
						N	No
BGEnabled	Background Enabled	VarChar	1	-	Y	Y	Yes
						N	No
MKEnabled	Highlight Enabled	VarChar	1	-	Y	Y	Yes
						N	No
BDEnabled	Frame Enabled	VarChar	1	-	Y	Y	Yes
						N	No
HidEmpRptt	Hide Empty Area	VarChar	1	-	N	Y	Yes
						N	No
RpttFtrAll	Display Rep. Footer on All	VarChar	1	-	N	Y	Yes
						N	No
GbiDataTyp	Data Type	Int	6	-	0	0
						1	C n
						2	C.. n
						3	I.. n
						4	D w.d
GbiDataLen	Data Length	nVarChar	6	-
PageBreak	Page Break	Int	6	-	0	0	None
						1	Before Area
						2	After Area
IsLogo	Is Logo	VarChar	1	-	N	Y	Yes
						N	No
VarDefName	Variable Definition Name	nVarChar	50	-
ResCode	Resource Code from RSBD	Int	11	-	-1
RevCode	Revision Code	Int	11	-	-1

Key	Unique	Field
PRIMARY	Yes	DocType
		Local
		Numerator
		Language
		ApplID
		ResCode
		RevCode
TP_LC_NM_L	No	DocType
		Local
		Numerator
		Language
TYP_LOC_NM	No	DocType
		Local
		Numerator
TYPE_LOC	No	DocType
		Local
TYPE	No	DocType