📚 SAP Business One SDK Help

Table Name: CPRF

Table Description: Column Preferences

Field Description Type Size Related Default Value Constraints
FormID Form ID nVarChar 20 -      
ItemID Item Number nVarChar 50 -      
ColID Column nVarChar 60 -      
Width Width Int 11 -      
VisInForm Visible in Form VarChar 1 - N Y Yes
            N No
VisualIndx Tabs Layout Int 11 -      
EditInForm Editable in Form VarChar 1 - N Y Yes
            N No
VisInExpnd Visible in Expanded VarChar 1 - N Y Yes
            N No
ExpandIndx Expanded Index Int 11 -      
EditInEXP Editable in Expanded VarChar 1 - N Y Yes
            N No
Folded Folder VarChar 1 - N Y Yes
            N No
UserSign User Signature Int 6 OUSR      
ExtDisable Externally Disabled VarChar 1 - N N No
            Y Yes
ExtInvsbl Externally Invisible VarChar 1 - N N No
            Y Yes
TPLId Template ID Int 6 UICU 0    
TableName Table Name nVarChar 20 -      
ItemUID ItemUID nVarChar 32 -      
Key Unique Field
PRIMARY Yes UserSign
    FormID
    ItemID
    ColID
    TPLId