Our customer wishes to extend standard Dynamics 365 Business Central with an elementary feature: the addition of a lookup field to the Customer table to be populated by the user. This field has to be carried over to the whole bunch of sales documents and also needs to be included in the warehouse shipping.
From customer wish to test automation
Data model
Even though the purpose of such a field will be very specific, we will generically name it Lookup Value Code. As with any other lookup field in Business Central, this Lookup Value Code field will have a table relation (foreign key) with another table, in our case a new table called Lookup Value.
The following relational diagram schematically describes the data model of this...
