biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Inventory / Cycle Count Determination
API Columns Preferences / Column Preferences
CPRF - Column Preferences Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
FormIDForm IDnVarChar
20
ItemIDItem NumbernVarChar
20
ColIDColumnnVarChar
20
WidthWidthInt
11
VisInFormVisible in FormVarChar
Y) Yes
N) No
1
N
VisualIndxTabs LayoutInt
11
EditInFormEditable in FormVarChar
Y) Yes
N) No
1
N
VisInExpndVisible in ExpandedVarChar
Y) Yes
N) No
1
N
ExpandIndxExpanded IndexInt
11
EditInEXPEditable in ExpandedVarChar
Y) Yes
N) No
1
N
FoldedFolderVarChar
Y) Yes
N) No
1
N
UserSign KEY UNIQUEUser SignatureInt
6OUSR
Users
PRIMARYYes
ExtDisableExternally DisabledVarChar
N) No
Y) Yes
1
N
ExtInvsblExternally InvisibleVarChar
N) No
Y) Yes
1
N
TPLIdTemplate IDInt
6UICU
Customized Template
0

Table relationship map

SELECT statement

SELECT CPRF.FormID AS 'Form ID', CPRF.ItemID AS 'Item Number', CPRF.ColID AS 'Column', CPRF.Width AS 'Width', CPRF.VisInForm AS 'Visible in Form', CPRF.VisualIndx AS 'Tabs Layout', CPRF.EditInForm AS 'Editable in Form', CPRF.VisInExpnd AS 'Visible in Expanded', CPRF.ExpandIndx AS 'Expanded Index', CPRF.EditInEXP AS 'Editable in Expanded', CPRF.Folded AS 'Folder', CPRF.UserSign AS 'User Signature', CPRF.ExtDisable AS 'Externally Disabled', CPRF.ExtInvsbl AS 'Externally Invisible', CPRF.TPLId AS 'Template ID' FROM CPRF AS CPRF

Related information


Column Preferences ColumnPreferences Object· Table: CPRF
ColumnPreferences is a Data structure related to the FormPreferencesService. Source table: CPRF.
   Parent: Columns Preferences ColumnsPreferences Collection

Columns Preferences Params ColumnsPreferencesParams Object· Table: CPRF
The ColumnsPreferencesParams  specifies the identification key combination (user and FormId) for which the FormPreferencesService is related. Source table: CPRF.
   Parent: Form Preferences Service FormPreferencesService Service
Customized Template UICU SQL Table

Users OUSR SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates