Order Number Location

1 month 2 weeks ago #324139 by nphic
Order Number Location was created by nphic
Folks,

I'm developing a MySQL report that needs to include the Order Number from the Payment Slip. Can you share with me the table and field name that this element is stored?

Thanks,
Joe

Please Log in to join the conversation.

1 month 2 weeks ago #324141 by krileon
Replied by krileon on topic Order Number Location
The "item_number", "invoice", or "proformainvoice" column should be relevant to you in the _cbsubs_payment_baskets database table.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in to join the conversation.

1 month 2 weeks ago #324145 by nphic
Replied by nphic on topic Order Number Location
Kyle,

Thanks for getting me on the right track! It turns out that the Basket Id is on the Payment Slip. How can I change the Payment Slip to have the Invoice Number?

Thanks,
Joe

Please Log in to join the conversation.

1 month 2 weeks ago #324150 by krileon
Replied by krileon on topic Order Number Location
You mean the payment slip for the offline payment gateway? You can completely customize how that displays within the offline payment gateway at the bottom under "Presentation of payment slip" section.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.426 seconds