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.