# Fishbowl 2017 Audit Table List

> A reference list of the Fishbowl 2017 audit tables (suffixed with _AUD), plus an example query for reading them.

As of 2/6/2017 this is the Fishbowl Audit Table List. Audit tables are suffixed with "_AUD".

For example, the Sales Order table is "SO" and its audit table is "SO_AUD". When we have more information about using audit tables, we will update this post with new information.

## Example Query

```sql
select * from so_aud
```

## Tables

```
ACCOUNTGROUP
ADDRESS
ASACCOUNT
ASSOCPRICE
BOM
BOMITEM
BOMITEMGROUP
BOMITEMTOLOCATION
BOMTOLOCATION
CALCATEGORY
CALEVENT
CARRIER
CARRIERSERVICE
CARTONTYPE
COMPANY
CONTACT
COSTLAYER
COUNTRYCONST
CURRENCY
CUSTOMDECIMAL
CUSTOMER
CUSTOMERPARTS
CUSTOMFIELD
CUSTOMINTEGER
CUSTOMLIST
CUSTOMLISTITEM
CUSTOMSET
CUSTOMTIMESTAMP
CUSTOMVARCHAR
CUSTOMVARCHARLONG
DATAEXPORT
DEFAULTLOCATION
FBSCHEDULE
FOBPOINT
INTEGRATEDAPP
ITEMADJUST
KITITEM
KITOPTION
LOCATION
LOCATIONGROUP
MEMO
MO
MOITEM
OBJECTTOOBJECT
PART
PARTCOST
PARTREORDER
PARTTOTRACKING
PARTTRACKING
PAYMENTMETHOD
PAYMENTTERMS
PICK
PICKITEM
PLUGINDATA
PLUGINPROPERTIES
PO
POITEM
POSTRANSACTION
PRICINGRULE
PRODUCT
PRODUCTTOTREE
PRODUCTTREE
QBCLASS
QUICKLIST
QUICKLISTITEM
RECEIPT
RECEIPTITEM
REGISTER
REPORT
REPORTPARAMETER
REPORTSECURITY
REPORTTOMODULE
REPORTTREE
RMA
RMAITEM
SERIAL
SERIALNUM
SHIP
SHIPCARTON
SHIPITEM
SHIPTERMS
SHIPUPSCARTONDETAILS
SHIPUPSDETAILS
SO
SOITEM
SOITEMTOMOITEM
STATECONST
SYSPROPERTIES
SYSUSER
TAXRATE
TRACKINGDATE
TRACKINGDECIMAL
TRACKINGINFO
TRACKINGINFOSN
TRACKINGINTEGER
TRACKINGTEXT
UOM
UOMCONVERSION
UPSACCOUNT
UPSRETURNSHIPMENT
USERACCESS
USERGROUP
USERGROUPREL
USERPROPERTIES
USERTOLG
VENDOR
VENDORCOSTRULE
VENDORPARTS
WATCH
WO
WOASSIGNEDUSERS
WOITEM
XO
XOITEM
```

---

*From Israel Lopez Consulting (ILC). Custom Fishbowl Inventory integrations and software, and Fishbowl experts since 2015. Written by Israel Lopez, published February 6, 2017. Questions about this topic, or want to reach the people who wrote it? Visit https://israellopezconsulting.com/contact*
