| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DTW Administration / Setup / Inventory / Cycle Count Determination API Columns Preferences / Column Preferences | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CPRF - Column Preferences Table SBO SQL database table details
Table relationship mapSELECT statementSELECT
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 informationColumn Preferences ColumnPreferences Object· Table: CPRF ColumnPreferences is a Data structure related to the FormPreferencesService.
Source table: CPRF. ![]() 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. ![]() 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. Contact This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates |