Today I found a hidden gem that I never noticed. It is actually in AX 2012 R2 CU7 and also in AX R3 (unchanged from the look of it).
I was going to through some DMF classes and I stumbled across this interesting class DMFDefaultMappingGP.
It has a number of select statements you can use to query GP to import into AX. Naming of the fields seem to have been done nicely, it should automatically map to the staging automaticly. I found nothing that calls these methods – only way I can think of is to copy the string and paste it into DIEF query. You will see some of the queries like InventTable and Project are empty. Either Microsoft started this and stopped after a while.
I can see the vision Microsoft started off here.
I will do some experimenting and see how it works out.