Hello, I have a question regarding the numbers in SQL as they pertain to Tessitura itself.Below are numbers in SQL, 5100d represents a membership level & 5120 represents all public programs.
Is (5100d) a GL code? and if so why does it only exist on the back end but not in tessitura itself & 5120 doesn't show up at all besides as a fund.
any and all help would be appreciated. thank you!
At what columns and in what tables are you looking in SQL? It looks like, based on your conventions for GL accounts, that 5100d would be a GL (5100-D-X). I'm not sure why it was referenced in the contribution in the first screenshot, but that would have been set up internally.
Also, you're referencing 5120 in the body of your post, but in the screenshot, I see 15-5210-X-X. Is that a typo? Or are you looking for an instance of 5120?
Hope this is of some help. Best of luck sorting through this.
Michael