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