The Data module gives you the option to view and export information from the Fishbowl database, though none of it can be updated from this module. You can run queries, save them, and export them to CSV and XLS files.
In the Data module you can simply click the green button that says “New” and you’ll be able to create a new query. Enter a name and description and then type a query under that. If the query isn’t valid, you’ll get an error message. I personally ran more than a dozen queries, and I’d like to share them so you can do the same thing, if you like:
SELECT * FROM Customer
SELECT * FROM Part
SELECT * FROM Ship
SELECT * FROM Pick
SELECT * FROM Vendor
SELECT * FROM SO
SELECT * FROM PO
SELECT * FROM WO
SELECT * FROM MO
SELECT * FROM BOM
SELECT * FROM RMA
SELECT * FROM Report
SELECT * FROM Tag
SELECT * FROM Location
SELECT * FROM Currency