Historically speaking on the Film TC/Sound TC syncing. It was the only method by which AutoSync could sync from two different metadata columns. This was to support a very specific workflow back in the film production/transfer days for productions using Arri or Aaton systems to record timecode on film when shooting. The film camera and audio devices would sync to a master clock, and when the camera started rolling, it would expose an encoded timecode at the film’s edge. Something that looked like an elongated QR code.
During telecine, the Aaton or Arri readers would decode the timecode and drive the audio syncing process during the transfer. The metadata was mapped to the Film TC columns (since it was the timecode on the film) and Sound TC. Capturing from analog or DAT devices at the time, the timecode from the audio would be placed in the SoundTC column.
The goal was to minimize the amount of column manipulation and allow AutoSync to sync across two different columns: Film TC on video sources, and Sound TC on audio sources. The request to be able to sync across different columns was part of the original plan but stopped at the Film TC/Sound TC columns. There are several features in MC that could be expanded to better fit today’s workflows, and some, like AutoSequence did find additional uses beyond its original design concept for MOS film transfers and audio layback from sync in Media Composer. Another great feature that languishes is stereo-3D’s ability to sync the Left eye from one bin, and the right eye from another bin and put the result into yet a different bin. Something I have been asking since it was added in v6 to apply for AutoSync and even grouping might find some uses.
While film is still being used, the use of timecode on film has faded away and the overall usefulness of FilmTC has as well but still exists as an available column. It behaves like 24TC in the sense that is hardcoded to count at 24fps unlike the aux TC columns which will inherit the frame rate from the project rate. And as Job teBurg mentions, it functions as described in a film project.