Skip to main content

Posts

Showing posts with the label dynamics ax limitation

Database Limitations in axapta

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.