Adding to Luc van Vugt little miniseries on his blog about things we can do to clean up NAV here is another one.
Table 18 Customer has a little known field called “Chain Name”. It is field No. 18 and has been in the system “forever”. Well almost…
If I remember right this field has roots as far back as I can remember and I actually use it quite often as customers often request some kind of Chain association to be indicated on the customer card. However the field as it is today has a few issues. First it is not located on any page so kind of hard to use for the end user and secondly it doesn’t have a table, but is free text (or I should say Code as it is a code 10 field).
Now we normally don’t call code fields something ending on “Name”, but that is maybe beside the point in this case.
My suggestion would be one of two:
Either we need to get rid of the field and remove it from the table. Hey that is the easy thing to do.
Alternative we should rename the field to “Chain Code”. Create a Chain Table with associated List Page and setup a table relation. We of course should also add the field to the customer card.
My 10 cent on this one.