Get a table ID in SQL - D365

Hi

select ID from SysTableIdView where SysTableIdView.Name = 'CustTable'

Regards,

Get enum value of a Enum in SQL- D365

 Hi,

SELECT

    et.Name AS enumIdName, 
    ev.EnumValue AS enumValue, 
    ev.Name AS enumValueName
FROM EnumIdTable et
INNER JOIN EnumValueTable ev 
    ON et.Id = ev.EnumId
WHERE et.Name = 'LedgerPostingType'
  AND ev.Name = 'PurchPckSlpPurchaseOffsetAccount';

Regards