How to add Personnel Number field on the data entity D365FO

Vijay Yelmame VY

468

Like(0)

Report

How to Add Personnel Number Field on the Data Entity in D365FO

Follow these steps to add the Personnel Number field to the CustCustomerV3Entity data entity in Dynamics 365 Finance and Operations.

Step 1: Create Extension for CustCustomerV3Entity

Step 2: Add New Fields

Add two new fields: TestHcmWorkerRecId,TestPersonnelNumber.

Repeat this step for the staging table as well.

Step 3: Create Code Extension for CustCustomerV3Entity

Create a new code extension for CustCustomerV3Entity and add the following code:


[ExtensionOf(tableStr(CustCustomerV3Entity))]
final class TESTCustCustomerV3Entity_Extension
{
    /// <summary>
    /// Provides the query to be used to compute the value of TestPersonnelNumber field.
    /// </summary>
    /// <returns>A query to be used to compute the value of TestPersonnelNumber field.</returns>
    public static str testCollectionAgent()
    {
        return smmUtility::workerPersonnelNumberQuery(
            tablestr(CustCustomerV3Entity), dataEntityDataSourceStr(CustCustomerV3Entity, CustTable), fieldstr(CustTable, TestHcmWorkerRecId));
    }

    public void mapEntityToDataSource(DataEntityRuntimeContext _entityCtx, DataEntityDataSourceRuntimeContext _dataSourceCtx)
    {
        if (_dataSourceCtx.name() == dataEntityDataSourceStr(CustCustomerV3Entity, CustTable))
        {
            this.TestHcmWorkerRecId = smmUtility::getEntityWorkerRecId(this.testCollectionAgent);
        }
        next mapEntityToDataSource(_entityCtx, _dataSourceCtx);
    }
}