Use cases for generic extension tables (CGEEX)

Denis MARETTE

Hello,

I have just learned about generic extension tables (CGEEX).
However, this seems to be a fairly old concept in M3.
A priori, this feature is still maintained in the Cloud.

However, I have always heard about CUGEx tables when it comes to managing specific additional fields.

Have you ever used this feature? In what context?
What is the difference between it and CUGEX tables?
Is it a good idea to continue using it in a cloud environment?

Thank you for your input.

Prabodha Amarapema

We have used CUGEX tables in the past, and their usage generally depends on the context. These tables are often used to store data that cannot be accommodated within the standard Infor M3 tables—for example, additional Item Master data, Customer Master data, and so on.

However, I think now Infor does not recommend using CUGEX tables. The main reasons are:

• Generic-purpose tables are not going to be supported.
• They may cause performance issues.

Further CUGEX tables are not ideal;

• store lots of records
• for the transaction records

The best alternative is to create a Dynamic Table tailored to your business case using XtendM3.