Data Retrieval recap in Microsoft Dynamics 365 Finance and Operations apps

Data Retrieval recap in Microsoft Dynamics 365 Finance and Operations apps

All select statements use a table variable to fetch records.  This variable must be declared before a select statement can be executed

The results of a select statement are returned in a table buffer variable. 

The transaction integrity checking process is performed by the transaction tracking system which is commonly abbreviated as TTS