Fishbowl 2017 Audit Table List

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” 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

TABLE_NAME
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