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

Contributions vs Order Contributions

A. Freeman
$organization

Tables-wise, what is the difference between a contributions-module contribution and an in-an-order contribution?

Parents
  • $organization

    Hi Amanda

     

    The only obvious difference in T_contribution that I can see is the presence of data in the ‘n1n2ind’ field which does always get assigned a value in Contributions module (from the Tax Credit setting), but has no equivalent in Order Contribution.

     

    Another quick way is to join to t_transaction based on the ref_no in both tables. You will see data in the order_no column for the Order contribution, but not in those done through the Contributions module.

     

    Peter

     

    Peter Nelson

    Business Analyst, Information Systems

    T 02 9250 7180  M 0401 714 246 

     

    Sydney Opera House Bennelong Point

    GPO Box 4274 Sydney NSW 2001 AUSTRALIA

     

    SOH_LOGO.gif

    FACEBOOK.gifTWITTER.gifYOUTUBE.gifBLOG.gif

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Amanda Freeman
    Sent: Wednesday, 5 October 2011 02:42
    To: Peter Nelson
    Subject: [Tessitura Technical Forum] Contributions vs Order Contributions

     

    Tables-wise, what is the difference between a contributions-module contribution and an in-an-order contribution?




    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!
    Please consider the environment before printing this email.

    Please consider the environment before printing this email.
    =====This message is intended for the addressee(s) named and may contain confidential information.
    If you are not the intended recipient, please delete it and notify the sender.
    Views expressed in this email are those of the individual sender and are not necessarily the views of the Sydney Opera House Trust=====
Reply
  • $organization

    Hi Amanda

     

    The only obvious difference in T_contribution that I can see is the presence of data in the ‘n1n2ind’ field which does always get assigned a value in Contributions module (from the Tax Credit setting), but has no equivalent in Order Contribution.

     

    Another quick way is to join to t_transaction based on the ref_no in both tables. You will see data in the order_no column for the Order contribution, but not in those done through the Contributions module.

     

    Peter

     

    Peter Nelson

    Business Analyst, Information Systems

    T 02 9250 7180  M 0401 714 246 

     

    Sydney Opera House Bennelong Point

    GPO Box 4274 Sydney NSW 2001 AUSTRALIA

     

    SOH_LOGO.gif

    FACEBOOK.gifTWITTER.gifYOUTUBE.gifBLOG.gif

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Amanda Freeman
    Sent: Wednesday, 5 October 2011 02:42
    To: Peter Nelson
    Subject: [Tessitura Technical Forum] Contributions vs Order Contributions

     

    Tables-wise, what is the difference between a contributions-module contribution and an in-an-order contribution?




    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!
    Please consider the environment before printing this email.

    Please consider the environment before printing this email.
    =====This message is intended for the addressee(s) named and may contain confidential information.
    If you are not the intended recipient, please delete it and notify the sender.
    Views expressed in this email are those of the individual sender and are not necessarily the views of the Sydney Opera House Trust=====
Children
No Data