This file is used to store information on video taken with various Sony Camcorder models. This file is reported to accompany a .m2ts file (See links section below).
The mysterious .MODD file appears to contain information regarding dates and time-lines related to your recording. Attempts to delete these files in order to improve video archiving have resulted in loss of time-line data and some claim to have experienced a loss of audio data.