threaded opening between Cummins and Allyson Transmission

Sounds like you mean the hole is at the very bottom? If so, it is probably the hole for a tach sensor. Most engines now get rpm from an engine position or cam sensor but the hole is still there and is usually open. Or like someone else said, could be the hole to access the drain plug on the torque converter.