Database Limitations in axapta • The maximum number of rows in one company is 4,294,967,296, as this is the highest record ID possible in Axapta. • The maximum number of bind variables given in the where clause of a select statement is 200. • The maximum number of tables per layer is 7999 in the GLS layer. • The maximum number of tables per layer is 1999 in the DIS and LOS layers. • The maximum number of tables per layer is 9999 in the BUS, VAR, CUS, and USR layers. • The maximum number of user-defined fields in a table is 11439—notice that Oracle has a limit of 1000.
Microsoft Dynamics Ax,AIF,Axapta, Enterprise portal,,Microsoft , United State,U.S., SharePoint , BI Tools, Performance Tuning, SSRS,Business Logic,Ax ERP Errors and solution,Dynamics 365 Errors Solution,Business software .