RE: Maximum number of fields on an entity
Hi,
It depends on the Maximum Capacity Specifications for SQL Server.
The SQL server tables limit is 1024 columns. This is the limit to the SQL Server views also.
When you create a new filed in a CRM entity the CRM add this field in the respective table and in the respective Filtered View. Depending on the field type the number of columns added in the Filtered view is different.
Example:
• If you add a text field in the Entity, the CRM will add 1 column in the Filtered View.
• If you add an Option Set field in the Entity, the CRM will add 2 columns in the Filtered View; 1 for the Value and 1 for the Label.
• If you add a Lookup field in the Entity, the CRM will add 3 columns in the Filtered View; 1 for the ID, 1 for the referenced Entity Logical Name, 1 for the Record Name.
So depending on the types of fields you have in the entity you can reach the 1024 limit at a different moment as the limit of the fields you can create in an Entity should be calculated as follows:
X *3 + Y*2 + Z*1 <= 1024
Where:
• X is the number of Lookup Fields
• Y is the number of Option Set / Boolean / Money fields
• Z is the number of fields from other type
Theoretically you can reach the limit at around 340 fields if you have a lot of Lookup fields in your entity: 340 *3 = 1020.
Hope it helps.
BR,
Judy
