System fields in table

For any table >> system will automatically create 3 fields

DataAreaId - current logged in compnay [ctrl + n]
RecVersion - unique Rec version - int64 [Concurrent updates to the same table by multiple users]

RecId - unique Record id [int 64] - one time generated number

All these three fields are non-editable fields

Comments

Post a Comment

Popular posts from this blog

D365 – Data Entity Method Call Sequence

Image
  1. initValue 2. validateField 3. validateWrite 4. update 4.1. doUpdate 4.1.1. persistEntity 4.1.1.1. doPersistEntity 4.1.1.1.1. initializeDataSources 4.1.1.1.1.1. initializeEntityDataSource Note: initializeDataSource is called once for each DataSource in Entity. 4.1.1.1.2. mapEntityToDataSources Note: initializeDataSource is called once for each DataSource in Entity. 4.1.1.1.3. saveDataSources 4.1.1.1.3.1. updateEntityDataSource 4.1.1.1.4. mapEntityToDataSource (maybe for another record) 4.1.1.1.5. saveDataSources 4.1.1.1.5.1. updateEntityDataSource for update operation and (insertEntityDataSource for insert) 4.1.1.1.5.1.1. mapDataSourceToEntity 4.1.1.1.5.1.2. doSaveDataSource 4.1.1.1.5.1.2.1. updateDataSource 4.1.1.1.5.1.2.1.1. preupInsertDataSource 4.1.1.1.5.1.2.1.1.1. validateWrite of table Plus: postLoad This method is called during the export for setting the value to unmapped fields after entity is downloaded to datasource. EXPORT:        Entity- postLoad...
Read more

X++ code to create a customized lookup on form

Image
Override the lookup method on Formdatasource field(on which you want to show lookup) , and copy the following code to your method. Comment the super() method in the lookup. public void lookup(FormControl _formControl, str _filterStr) { SysTableLookup sysTableLookup; // systemclass to create //customlookup Query query; QueryBuildDataSource qbd; ; sysTableLookup = SysTableLookup::newParameters(tablenum(InventTable),_formcontrol); // Construct query on the table, // whose records you want to show as lookup. query = new Query(); qbd = query.addDataSource(tablenum(InventTable)); qbd.addRange(fieldnum(InventTable,ItemType)).value(SysQuery::value(enum2str (ItemType::Item))); // add the fields to the lookup list sysTableLookup.addLookupfield(fieldnum(InventTable,ItemId)); sysTableLookup.addLookupfield(fieldnum(InventTable,ItemName)); // pass the query as parameter // system will show the records in the lookup // as per your query sysTableLookup.parmQuery(query); sysTableLookup.performFormLo...
Read more

Creating a Report Bound to a Report Data Provider Class (X++ Business Logic) [AX 2012]

Image
In this walkthrough, you use a report data provider (RDP) class with business logic to process data and then display the outcome of the business logic on a report. An RDP class is an X++ class that is used to access and process data for a Reporting Services report. The options for a data source type for a Microsoft Dynamics AX report are query, business logic, and RDP. An RDP class is an appropriate data source type when the following conditions are met. You cannot query directly for the data you want to render on a report. The data to be processed and displayed is from Microsoft Dynamics AX. The following illustration is a preview of the report that you create in this walkthrough. Note The data that displays in your report may vary depending upon the sample data that is available to you. The following elements are required to set RDP as your data source type. Temporary table – RDP class fills a temporary table with data that will be used by Reporting Services to display the re...
Read more