Where are Specifications and Long Descriptions stored in tables?

peter-kimbark

We're looking to find where the longer description texts are stored for multiple places so that we can pull the information out with certain Query's we are running. 

1) Work Order and Engineer Master header specifications.

2) Work Order and Engineer Master Leg Header specifications.

3) The long description located in an operation card under the Setup/Run tab (field is untitled). 

4) Sales Order Line Specifications. 

unknown

WORKORDER_BINARY,

OPERATION_BINARY,

CUST_ORDER_BINARY,

...See the trend yet lol?

Select cast(cast(BITS as varbinary(max)) as nvarchar(max)), * from workorder_binary where workorder_type in ('M','W')