Hi everyone, I am making a small module for collecting some useful information I need, and I would like some light over this point.
I am using the community edition (1.7) on my localhost so I do not have many rows in my base, giving me trouble on these points :
- Is it possible for an order to have multiple payments related to it ? It seems to be the case in the database, but I would like confirmation.
For example, Order1 is 170$, and it is associated with Payment1 100$ and Payment2 70$ in SALES_FLAT_ORDER_PAYMENT table.
- How is SALES_PAYMENT_TRANSACTION related to SALES_FLAT_ORDER_PAYMENT ?
The table has a payment_id attribute so I suppose that one payment can be related to multiple transactions.
I can’t make testings myself since I can’t populate my base with real payments :(
I would be glad receiving your lights on my questions