• Replies 1 reply
  • Subscribers 337 subscribers
  • Views 92 views
  • Users 0 members are here
Related

Package Payment Plan Ponderings

Matt Gonzales
$organization

What query would likely yield customers that pay their subscription in one payment, versus installments for a given year? Someone had suggested T_SCHEDULE, but I'm having a hard time tying it back to particular orders in T_ORDER. Then I realized it's something along the lines of there being only one payment for a given order with the payment amount being equal to the amount due, right? Am I making sense?

Thanks , Tessiturians.

  • Former Member
    Former Member $organization

    Table T_SCHEDULE is for pledges/contributions. For orders payment plans you should look into T_ORDER_SCHEDULE.

     

    Fernando Margueirat
    Senior Business Analyst
    The National Ballet of Canada
    470 Queens Quay West
    Toronto, Ontario
    M5V 3K4
    P: 416 345 9686 x453
    F: 416 345 8323

    http://national.ballet.ca

     

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matt Gonzales
    Sent: Wednesday, December 14, 2016 1:00 PM
    To: Fernando Margueirat <FMargueirat@national.ballet.ca>
    Subject: [Tessitura Technical Forum] Package Payment Plan Ponderings

     

    What query would likely yield customers that pay their subscription in one payment, versus installments for a given year? Someone had suggested T_SCHEDULE, but I'm having a hard time tying it back to particular orders in T_ORDER. Then I realized it's something along the lines of there being only one payment for a given order with the payment amount being equal to the amount due, right? Am I making sense?

    Thanks , Tessiturians.




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!