in the orders table, add a new column named OrderReferanceNumber, set the data type to varchar(30)
on the confirm page, open the server behaviors panel and double click the eCart store Order summary behavior. select the OrderReferanceNumber column and click the lightning bolt next to value. Expand the eCart object data binding group and select the session id binding.
now double click the universal email server behavior. click the DW Edit icon to edit the email.
remove the Order ID session variable binding and replace it with the session id binding.