📚 SAP Business One SDK Help

Table Name: COLM

Table Description: COLM resource

Field Description Type Size Related Default Value Constraints
Created Creation Date Date 8 -      
Updated Update Date Date 8 -      
Name Table Name nVarChar 64 -      
Num Column Number Int 11 -      
ItemType Item Type Int 11 - 0 0 None
            16 Edit text
            105 Bar
            113 Select popup
            116 Link button
            121 Check box
            117 Picture
Enabled Enabled VarChar 1 - 1 0 No
            1 Yes
CellType Cell Type Int 11 - 16 0 None
            16 Edit text
            105 Bar
            113 Select popup
            116 Link button
            121 Check box
            117 Picture
Font Font Number Int 11 -      
FontSize Font Size Int 11 -      
Attributes Attributes Int 11 -      
Style Style Int 11 -      
Mode Mode Int 11 -      
TitleType Title Type Int 11 - 0 0 None
            117 Picture
TitleEnabl Title Enabled VarChar 1 -      
TitleFont Title Font Number Int 11 -      
TFontSize Title Font Size Int 11 -      
TitleAtt Title Attributes Int 11 -      
TitleStyle Title Style Int 11 -      
TitleMode Title Mode Int 11 -      
VarNum Variable Number Int 11 -      
LinkVar Link Variable Int 11 -      
DragVar Drag Variable Int 11 -      
FileCode Table Code nVarChar 20 -      
FieldNum Field Alias nVarChar 10 -      
Editable Editable VarChar 1 - 1 0 No
            1 Yes
SuppressZe Suppress Zeros VarChar 1 - 0 0 No
            1 Yes
DataRequir Data Required VarChar 1 - 0 0 No
            1 Yes
ForceUpper Force Upper VarChar 1 - 0 0 No
            1 Yes
RightJust Right Justified VarChar 1 - 1 0 No
            1 Yes
            2 Language dependant
UserType Binding Type VarChar 1 - 0 0 Data
            1 User Variable
Sentence Sentencing VarChar 1 - 0 0 No
            1 Yes
ShowType Show Type VarChar 1 - 0 0 Value + Description
            1 Value only
            2 Description only
DispDecr Display Description VarChar 1 - 0 0 No
            1 Yes
LinkTo Link To Item Int 11 -      
DragEntity Drag Entity Int 11 -      
Class Class Int 11 -      
TitleIndex Title Index Int 11 - 0    
DescIndex Description Index Int 11 - 0    
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 -      
TtlFgRed Title Foreground Red Int 11 -      
TtlFgGreen Title Foreground Green Int 11 -      
TtlFgBlue Title Foreground Blue Int 11 -      
TtlBgRed Title Background Red Int 11 -      
TtlBgGreen Title Background Green Int 11 -      
TtlBgBlue Title Background Blue Int 11 -      
Width Width Int 11 -      
SuppRepeat Suppress Repeating VarChar 1 - 0 0 No
            1 Yes
AutoGraph Auto Graph VarChar 1 - 0 0 No
            1 Yes
AutoCumm Auto Cummulative VarChar 1 - 0 0 No
            1 Yes
UniqueID Unique ID nVarChar 10 -      
TitleStr Title String nVarChar 254 -      
ColDesc Column Description nVarChar 254 -      
UsrSgnStr User Sign For Strings Change Int 11 - -1    
UsrSgnAttr User Sign For Attribs Change Int 11 - -1    
TtlFntName Title Font Name nVarChar 32 -      
CllFntName Cell 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    
Key Unique Field
PRIMARY Yes Name
    Num
    ResCode
    RevCode
UNIQUE_ID Yes Name
    UniqueID