950210 - What Table Are All Form Settings Stored in?

Symptom

What table are all Form Settings stored in?

Solution

Table: CPRF - Column Preferences.

To see where all Form Settings are stored, go to Reports → Query Generator → Enter CPRF and choose Execute.

This returns all the Form Settings for every form in SAP Business One.

Other terms

visible, active, FormID, fields, variables