Adding Transaction Number To Email

When a we receive a paid membership or renewal, I need to add a unique reference to a document to be emailed after a few days.

One part of the reference will be their membership number, however, I would like to add a transaction reference. However, how can I insert the latest reference e.g. renewal, and not anyone e.g. the original joining one.

I also need to insert the date( & time) of the transaction

I hope this makes sense!

I should have mentioned that I will be using the CB Mailer.

I have found the date parameters:
[SUBSCRIPTION_SIGNUP_DATE]
[SUBSCRIPTION_LAST_RENEWAL_DATE]

Just need a transaction reference now!

Also, can I use my own substitution fields or is it set to the ones you show?

Depends entirely on where you're sending that email from as to what substitutions are available. Are you using the emails configured in your plans directly or CBSubs Mailer? You may have to use CB Query Field to query for that information then substitute it in.

I would like to use the CB Subs Mailer, as I can automatically send on joining and renewal.

Or would you suggest a different mail system?

By transaction number do you mean the item number (e.g. M37-42-10), the invoice number (e.g. U240441192696044), or the actual transaction id sent by the payment gateway (e.g. 9093733366416)? The problem is all 3 are stored with the basket and not with the subscription. The emails work off subscription and not basket. This means CBSubs Mailer and the presentation tab emails won't have access to this information. I believe the only way you'll be able to substitute that in is probably to query for the users most recently paid basket using CB Query Field.

Thanks for the quick response.

Invoice or transaction would be best, as it is to go onto a document where we might need to trace 'authenticity', so it needs to be real, unique and traceable.

Can you point me to a guide so I can try to use the CB Query Field?