📚 SAP Business One SDK Help

Table Name: RITM

Table Description: Reporting Element

Field Description Type Size Related Default Value Constraints
DocCode Report nVarChar 8 RDOC      
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 - Y Y Yes
            N No
SupZeros Suppress Zeros VarChar 1 - N Y Yes
            N 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 - 255    
BGGreen Background - Green Int 11 - 255    
BGBlue Background - Blue Int 11 - 255    
FGRed Text - Red Int 11 - 0    
FGGreen Text - Green Int 11 - 0    
FGBlue Text - Blue Int 11 - 0    
MrkrRed Bold - Red Int 11 - 255    
MrkrGreen Bold - Green Int 11 - 255    
MrkrBlue Bold - Blue Int 11 - 255    
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 - 0    
Justific Horizontal Justification Int 6 - 2 1 Right
            2 Left
            3 Centralized
            4 Language-Dependent
WRAP Segment Int 6 - 2 0 Allow Overflow
            1 Adjust to Cell
            2 Divide into Rows
PictSize Picture Size Int 6 - 0 0 Original Size
            1 Fit Field Size Non-Proportionally
            2 Fit Field Size Proportionally
            3 Fit Field Height
            4 Fit Fields Width
DataSource Data Source Int 6 - 1 1 Static
            2 Variable
            3 Data
            4 Calculation
ItemStr String Text 16 -      
VarNum Variable No. Int 6 -      
FileName File Name nVarChar 20 -      
FieldNum Field No. nVarChar 52 -      
ShowDescr Display Description VarChar 1 - Y Y Yes
            N 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
ChangFlags Changeable Int 11 -      
ApplID Item No. Int 6 -      
CalcCol Calculation Column Int 6 -      
YJustific Vertical Alignment Int 6 - 3 1 Top
            2 Bottom
            3 Centralized
SortLevel Sort Level Int 6 - 0    
RevOrder Reverse Sort VarChar 1 - N Y Descending
            N Ascending
SortType Sort Type Int 6 - 0 0 Alpha
            1 Numeric
            2 Currency
            3 Date
IsUnique Unique VarChar 1 - N Y Yes
            N No
IsGroup Set as Group VarChar 1 - N Y Yes
            N No
NewPage New Page VarChar 1 - N Y Yes
            N No
BarCode Print as Bar Code VarChar 1 - N Y Yes
            N No
Condition Condition Text 16 -      
LinkTo Link to Field nVarChar 20 -      
Operator1 Operator 1 Int 6 -      
Operator2 Operator 2 Int 6 -      
Operation Operation Int 6 - 0 0  
            1 +
            2 -
            3 x
            4 /
            5 %
            17 Left Part (Characters)
            18 Right Part (Mantissa)
            19 Round
            6 $Concat
            7 $Right
            8 $Left
            9 $Sentence
            16 $Length
            20 $Currency
            21 $Number
            10 Less than
            11 Less or Equal
            12 Equal
            13 Not equal
            14 Greater or Equal
            15 Greater than
BCStandard Bar Code Standard Int 6 - 0 0 EAN-13
            1 Code 39
            2 Code 128
SumInWords Display Total as a Word VarChar 1 - N Y Yes
            N No
ExcFonting Block Font Change VarChar 1 - N Y Yes
            N 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 Link to Field nVarChar 20 -      
NextSeg Next Segment Item Number nVarChar 20 -      
HightAdjst Height Adjustments VarChar 1 - N Y Yes
            N No
DupRpttAre Duplicate Repetitive Area VarChar 1 - N Y Yes
            N No
LnsRpttAre No. of Rows in Repetitive Area Int 11 - 0    
RptDupDist Distance To Rptt Dup. (pixels) Int 11 - 0    
FieldId Unique ID 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
Key Unique Field
PRIMARY Yes DocCode
    ItemId
CONTAINER No DocCode
    Container
    ContIndex
    ItemGroup
APPL_ID No DocCode
    ApplID
TYPE No DocCode
    Type
    ItemIndex