Are enums stored in a table?

Finance and Operations/AX User Forum
1

Hi,

I am working with Axapta from a data warehousing / reporting perspective and am looking for a table where we can extract custom attributes configured in Axapte (i.e. enumname, enumvalue, enumtext).

Is there a single table that can be used for this purpose or is the data stored in many tables?

Thanks

2

Hello,

I do not think the details you are looking for are stored in any SQL table.

For the data warehousing, you can use the value. For ex -
Item = 0
BOM = 1
Service = 2

I hope this helps,