Extending Microsoft Dynamics 365 Finance and Supply Chain Management Cookbook - Second Edition

Create the date-time effective table

To create a date-time effective table, follow these steps:

1. Create a new table called ConVMSVehicleOdometerTable.
2. Complete the table as a Main table, in the same way as ConVMSVehicleTable was created. Don't add a primary index or Find or Exist methods yet.
3. Add a VehicleId field based on ConVMSVehicleId and a foreign key relation to ConVMSVehicleTable on VehicleId.
4. Make the VehicleId field not visible, mandatory, and not editable.
5. Create a new Real EDT named ConVMSVehicleOdometer that extends Qty. Set the Label and other properties as desired.
6. Drag the new EDT to the Fields node of ConVMSVehicleOdometerTable and rename it to Odometer.
7. Create a field group named Overview and add the Odometer field – remember ...