📚 SAP Business One SDK Help

Table Name: ITEM

Table Description: Item Resource

Field Description Type Size Related Default Value Constraints
Created Creation Date Date 8 -      
Updated Update Date Date 8 -      
Name Form Name nVarChar 64 -      
Num Item Number Int 11 -      
ItemType Item Type Int 11 -   4 Button
            121 Check box
            114 Edit popup
            16 Edit text
            118 Extended edit
            99 Folder
            101 FwdBck button
            123 Graph
            124 Icon
            116 Link button
            127 Grid
            120 Media
            103 Multi page
            115 Pane button
            104 Pane popup
            117 Picture
            98 Pipe
            125 Popup
            119 Preview
            112 Progress
            122 Radio button
            100 Rectangle
            113 Select popup
            8 Static text
            102 ActiveX
            0 User item
            129 Button Combo
Enabled Enabled VarChar 1 - 1 0 No
            1 Yes
_Top Top Int 11 -      
_Bottom Bottom Int 11 -      
_Left Left Int 11 -      
_Right Right Int 11 -      
Font Font Number Int 11 -      
FontSize Font Size Int 11 -      
Attributes Attributes Int 11 -      
Style Style Int 11 -      
Mode Mode Int 11 -      
VarNum Variable Number Int 11 -      
AttrVar Attribute Variable Int 11 -      
NewLineVar New Line Variable Int 11 -      
ProcVar Proc Variable Int 11 -      
LinkVar Link Variable Int 11 -      
DragVar Drag Variable Int 11 -      
FileCode Table Name nVarChar 20 -      
FieldNum Field Alias nVarChar 10 -      
Editable Editable VarChar 1 - 1 0 No
            1 Yes
Invisible Invisible VarChar 1 - 0 0 No
            1 Yes
SuppressZe Suppress Zeros VarChar 1 - 0 0 No
            1 Yes
DfltButton Default Button 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
            3 Oppos Language
UserType Data Binding Type VarChar 1 - 0 0 Data
            1 User Variable
            2 Multiple Data Type
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
TabOrder TAB Order Int 11 -      
LinkTo Link to Item Int 11 -      
DragEntity Drag Entity Int 11 -      
FromPane From Pane Int 11 -      
ToPane To Pane Int 11 -      
Class Class Int 11 -      
StrIndex String Index Int 11 - 0    
HkeyIndex Hotkey Index Int 11 -      
DescIndex Description Index Int 11 - 0    
FrameRed Frame Red Int 11 -      
FrameGreen Frame Green Int 11 -      
FrameBlue Frame Blue Int 11 -      
BodyRed Body Red Int 11 -      
BodyGreen Body Green Int 11 -      
BodyBlue Body Blue Int 11 -      
TextRed Text Red Int 11 -      
TextGreen Text Green Int 11 -      
TextBlue Text Blue Int 11 -      
ThumbRed Thumb Red Int 11 -      
ThumbGreen Thumb Green Int 11 -      
ThumbBlue Thumb Blue Int 11 -      
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 -      
UniqueID Unique ID nVarChar 10 -      
ItemString Item String nVarChar 254 -      
ItemDesc Item Description nVarChar 254 -      
HotkeyPos Hotkey Position Int 11 -      
WrapText Wrap Text VarChar 1 - 0 0 No
            1 Yes
UsrSgnStr User Sign For String Change Int 11 - -1    
UsrSgnAttr User Sign For Attribs Change Int 11 - -1    
FontName 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
STRING No StrIndex
UNIQUE_ID Yes Name
    UniqueID