biuan SAP® BUSINESS ONE SDK
SQL Others / COLM resource
API COLM
COLM - COLM resource Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CreatedCreation DateDate
8
UpdatedUpdate DateDate
8
Name KEY UNIQUETable NamenVarChar
64
UNIQUE_IDYes
NumColumn NumberInt
11
ItemTypeItem TypeInt
0
16) Edit text
105) Bar
113) Select popup
116) Link button
121) Check box
117) Picture
11
0
EnabledEnabledVarChar
0
1) Yes
1
1
CellTypeCell TypeInt
0
16) Edit text
105) Bar
113) Select popup
116) Link button
121) Check box
117) Picture
11
16
FontFont NumberInt
11
FontSizeFont SizeInt
11
AttributesAttributesInt
11
StyleStyleInt
11
ModeModeInt
11
TitleTypeTitle TypeInt
0
117) Picture
11
0
TitleEnablTitle EnabledVarChar
1
TitleFontTitle Font NumberInt
11
TFontSizeTitle Font SizeInt
11
TitleAttTitle AttributesInt
11
TitleStyleTitle StyleInt
11
TitleModeTitle ModeInt
11
VarNumVariable NumberInt
11
LinkVarLink VariableInt
11
DragVarDrag VariableInt
11
FileCodeTable CodenVarChar
20
FieldNumField AliasnVarChar
10
EditableEditableVarChar
0
1) Yes
1
1
SuppressZeSuppress ZerosVarChar
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
1
1
UserTypeBinding TypeVarChar
0
1) User Variable
1
0
SentenceSentencingVarChar
0
1) Yes
1
0
ShowTypeShow TypeVarChar
0
1) Value only
2) Description only
1
0
DispDecrDisplay DescriptionVarChar
0
1) Yes
1
0
LinkToLink To ItemInt
11
DragEntityDrag EntityInt
11
ClassClassInt
11
TitleIndexTitle IndexInt
11
0
DescIndexDescription IndexInt
11
0
TxtFgRedText Foreground RedInt
11
TxtFgGreenText Foreground GreenInt
11
TxtFgBlueText Foreground BlueInt
11
TxtBgRedText Background RedInt
11
TxtBgGreenText Background GreenInt
11
TxtBgBlueText Background BlueInt
11
TtlFgRedTitle Foreground RedInt
11
TtlFgGreenTitle Foreground GreenInt
11
TtlFgBlueTitle Foreground BlueInt
11
TtlBgRedTitle Background RedInt
11
TtlBgGreenTitle Background GreenInt
11
TtlBgBlueTitle Background BlueInt
11
WidthWidthInt
11
SuppRepeatSuppress RepeatingVarChar
0
1) Yes
1
0
AutoGraphAuto GraphVarChar
0
1) Yes
1
0
AutoCummAuto CummulativeVarChar
0
1) Yes
1
0
UniqueIDUnique IDnVarChar
10
TitleStrTitle StringnVarChar
127
ColDescColumn DescriptionnVarChar
127
UsrSgnStrUser Sign For Strings ChangeInt
11
-1
UsrSgnAttrUser Sign For Attribs ChangeInt
11
-1
TtlFntNameTitle Font NamenVarChar
32
CllFntNameCell Font NamenVarChar
32
ResCodeResource Code from RSBDInt
11
-1
RevCodeRevision CodeInt
11
-1
BindObjIdBind Object IdInt
11
-1

SELECT statement

SELECT COLM.Created AS 'Creation Date', COLM.Updated AS 'Update Date', COLM.Name AS 'Table Name', COLM.Num AS 'Column Number', COLM.ItemType AS 'Item Type', COLM.Enabled AS 'Enabled', COLM.CellType AS 'Cell Type', COLM.Font AS 'Font Number', COLM.FontSize AS 'Font Size', COLM.Attributes AS 'Attributes', COLM.Style AS 'Style', COLM.Mode AS 'Mode', COLM.TitleType AS 'Title Type', COLM.TitleEnabl AS 'Title Enabled', COLM.TitleFont AS 'Title Font Number', COLM.TFontSize AS 'Title Font Size', COLM.TitleAtt AS 'Title Attributes', COLM.TitleStyle AS 'Title Style', COLM.TitleMode AS 'Title Mode', COLM.VarNum AS 'Variable Number', COLM.LinkVar AS 'Link Variable', COLM.DragVar AS 'Drag Variable', COLM.FileCode AS 'Table Code', COLM.FieldNum AS 'Field Alias', COLM.Editable AS 'Editable', COLM.SuppressZe AS 'Suppress Zeros', COLM.DataRequir AS 'Data Required', COLM.ForceUpper AS 'Force Upper', COLM.RightJust AS 'Right Justified', COLM.UserType AS 'Binding Type', COLM.Sentence AS 'Sentencing', COLM.ShowType AS 'Show Type', COLM.DispDecr AS 'Display Description', COLM.LinkTo AS 'Link To Item', COLM.DragEntity AS 'Drag Entity', COLM.Class AS 'Class', COLM.TitleIndex AS 'Title Index', COLM.DescIndex AS 'Description Index', COLM.TxtFgRed AS 'Text Foreground Red', COLM.TxtFgGreen AS 'Text Foreground Green', COLM.TxtFgBlue AS 'Text Foreground Blue', COLM.TxtBgRed AS 'Text Background Red', COLM.TxtBgGreen AS 'Text Background Green', COLM.TxtBgBlue AS 'Text Background Blue', COLM.TtlFgRed AS 'Title Foreground Red', COLM.TtlFgGreen AS 'Title Foreground Green', COLM.TtlFgBlue AS 'Title Foreground Blue', COLM.TtlBgRed AS 'Title Background Red', COLM.TtlBgGreen AS 'Title Background Green', COLM.TtlBgBlue AS 'Title Background Blue', COLM.Width AS 'Width', COLM.SuppRepeat AS 'Suppress Repeating', COLM.AutoGraph AS 'Auto Graph', COLM.AutoCumm AS 'Auto Cummulative', COLM.UniqueID AS 'Unique ID', COLM.TitleStr AS 'Title String', COLM.ColDesc AS 'Column Description', COLM.UsrSgnStr AS 'User Sign For Strings Change', COLM.UsrSgnAttr AS 'User Sign For Attribs Change', COLM.TtlFntName AS 'Title Font Name', COLM.CllFntName AS 'Cell Font Name', COLM.ResCode AS 'Resource Code from RSBD', COLM.RevCode AS 'Revision Code', COLM.BindObjId AS 'Bind Object Id' FROM COLM AS COLM

Related information
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