I understand I can build functionality in this table so it will pop-up as an option in Production Elements.
However, I am trying to write a custom report that will reference this information and am lost on how to actually pull the data that I've populated in these fields under each performance.
Example, the Text_1 through Text_4 columns display in T_INVENTORY. When I populate these fields in Production Elements, that data exists in that table. But where on earth is TR_INV_CONTENT??
Is there any easy way of searching for tables like this in the future through SQL when it's not in either system tables or in the Tessitura Help Documents?
Hi Sarah,
Types defined in TR_INV_CONTENT are connected to their peformance/package and have their "content" stored in TX_INV_CONTENT.
--Gawain
Oops, sorry everyone it looks like that question was already answered on the network. If anyone's curious it's in TX_INV_CONTENT.
If tables like this could be also referenced in the Tess Documentation it'll help tremendously.
Thanks Gawain! I'm happy to see it's stored somewhere - phew!