Fishbowl 2017 Audit Table List

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

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