ACP User's guide does describe the Supported File Types in Customization Manager in Appendix A.
But depending on the file type, Autopatch will perform specific actions.
As an example, if you deal with fmb files, Autopatch will compile it into a fmb. If you deals with a "sql" type, it will just copy the sql file, while dealing with a "create view" type will execute the associated sql script.
Is it possible to have complemantary information on what are the actions performed by autopatch for each type ?