It has posted in the details table WITH the session ID correctly posting, but the Summary was not posted.
I may see a problem - I renamed the detailedorderid to OrderReferenceID in the details table which is also the same named column in the summary table. Could that be causing the issue??
The only way I catch the problem is because the email comes in with the order info and I have a backend to retrieve the info. So we will sometimes get the email go in the back and the order does not appear. I can look at the database directly and see the items they purchased in the details table, but nothing in the summary table.