Yes, The coupon code is stored in a session variable.
add a new column to the orders table to capture the coupon code.
On the Confirm page, double click the eCart store order Summary in database server behavior, and bind the new coupon code database column to the coupon code session variable.