Stardard place for payment references ?

Hi,

I did a quick search of the forums and couldn't find an answer to my question.

Is there a standard place that payment references are stored in the database ( I have no addons, out of the box zen cart install ), for example looking at the orders table in the database there is a payment_method and payment_module_code, but there doesn't seem to be a reference anywhere?

thanks for any help.

What do you mean by "payment references"?

gjh42:

What do you mean by "payment references"?

The unique code that can be used to track down the payment in your payment system.

Each order is assigned an order number. That's a good starting point.
Anything else largely depends on what payment system is used for each payment. So ... what payment module(s) are you using to collect payments in your store?

DrByte:

Each order is assigned an order number. That's a good starting point.
Anything else largely depends on what payment system is used for each payment. So ... what payment module(s) are you using to collect payments in your store?

I was thinking there might be a central place that stores something like

orderid - the id
paymenttype - paypal, eway, etc
paymentreference - the unquie payment id
paymentsuccess - success

Yes, that information is stored with all the order data.

What exactly are you wishing to do with it? Surely there's a business reason behind why you're asking the question.

DrByte:

Yes, that information is stored with all the order data.

What exactly are you wishing to do with it? Surely there's a business reason behind why you're asking the question.

Basically we have some code in zen-cart which pushes orders into an inventory system.

I would like to be able to get the payment information and push that data to the inventory system.

I don't see anything in the orders table that looks like a payment reference, all I can see is payment_method and payment_module_code there is order_id but that is of no help to me.

If the payment module received and stored any transaction number data, it likely stored it in the orders_status_history records for that order as part of free-form comment text.