Extending Microsoft Dynamics 365 for Operations Cookbook

How to do it...

In these steps, we create a table that puts the concept of date-effectivity into use:

1. Create a new integer EDT named ConWHSOdometer with a label Odometer.
2. Create a new table named ConWHSVehicleTableServiceData.
3. Drag the ConWHSVehicleId EDT on to the Fields node, and rename it to VehicleId. Configure the field's properties to be a primary key (cannot edit after creation and is mandatory). Create a foreign key relationship, but do not create an index.
4. Drag the ConWHSOdometer EDT onto the Fields node, and rename to Odometer.
5. We can now choose whether our changes can be updated daily, or for every change made. This is done using the table's Valid Time State Field Type property. We want to allow changes to be made frequently, ...