fishbowl_archive

id, activeFlag, autoCreateTypeId, configurable, dateCreated, dateLastModified, defaultCalCategoryId, description, estimatedDuration, note, num, pickFromLocation, qbClassId, revision, statisticsDateRange, url, userId, customFields

7,013 rows

bomautocreatetype

id, name

5 rows

bominstructionitem

id, bomId, description, details, name, sortOrder, url, customFields

1,636 rows

bomitem

id, addToService, bomId, bomItemGroupId, description, groupDefault, maxQty, minQty, oneTimeItem, partId, priceAdjustment, productId, quantity, sortIdConfig, stage, stageBomId, typeId, uomId, useItemLocation, variableQty, customFields

79,044 rows

bomitemgroup

id, bomId, name, prompt, sortOrder

8 rows

bomitemtolocation

id, bomItemId, locationGroupId, locationId

0 rows

bomitemtype

id, name

6 rows

bomtolocation

id, bomId, locationGroupId, locationId

6,445 rows

calcategory

id, color, dateCreated, dateLastModified, lastChangedUserId, name, parentID, readOnly

8 rows

calevent

id, allDay, calCategoryId, dateCreated, dateEnd, dateLastModified, dateStart, lastChangedUserId, location, name, note

1 row

cardonfile

id, walletId, gatewayPaymentId, info, expDate, paymentMethodId, dateCreated, dateLastModified, lastChangedUserId

0 rows

carrier

id, activeFlag, description, name, readOnly, scac

10 rows

carrierservice

id, activeFlag, carrierId, code, name, readOnly

25 rows

cartontype

id, defaultFlag, description, height, len, name, sizeUOM, width

0 rows

company

id, EANUCCPrefix, abn, accountId, dateEntered, dateLastModified, defaultCarrierId, defaultFlag, lastChangedUser, name, taxExempt, TAXEXEMPTNUMBER, customFields

1 row

contact

id, accountId, addressId, datus, defaultFlag, contactName, typeId

988 rows

contacttype

id, name

9 rows

costlayer

id, dateCreated, dateLastModified, orgQty, orgTotalCost, partId, qty, recordId, statusId, tableId, totalCost

35,530 rows

costlayerstatus

id, name

3 rows

countryconst

id, abbreviation, name

247 rows

currency

id, activeFlag, code, dateCreated, dateLastModified, excludeFromUpdate, homeCurrency, lastChangedUserId, name, rate, symbol

1 row

customer

id, accountId, accountingHash, accountingId, activeFlag, carrierServiceId, creditLimit, currencyId, currencyRate, dateCreated, dateLastModified, defaultCarrierId, defaultPaymentTermsId, defaultPriorityId, defaultSalesmanId, defaultShipTermsId, jobDepth, lastChangedUser, name, note, number, parentId, qbClassId, statusId, sysUserId, taxExempt, taxExemptNumber, taxRateId, toBeEmailed, toBePrinted, url, issuableStatusId, customFields

86 rows

customerincltype

id, name

3 rows

customerparts

id, customerId, customerPartNumber, dateCreated, dateLastModified, dateLastPurchased, lastChangedUserId, lastPrice, productId

733 rows

customerstatus

id, name

5 rows

customfield

id, accessRight, activeFlag, customFieldTypeId, description, listId, name, required, sortOrder, tableId

36 rows

customfieldtype

id, description, name

9 rows

customlist

id, description, name

6 rows

customlistitem

id, description, listId, name

25 rows

databaseversion

id, alterCommand, dateUpdated, version

30 rows

dataexport

id, dataQuery, dateCreated, dateLastModified, description, lastChangedUserId, name

26 rows

defaultlocation

id, locationGroupId, locationId, partId

781 rows

fbschedule

id, actionSubType, actionTypeId, activeFlag, cronString, dateCreated, dateLastModified, dateNextScheduled, description, directory, email, emailReport, fileMask, fileName, javaClass, lastChangedUserId, name, parameters, reportId, pluginManaged

10 rows

fbscheduleactiontype

id, name

11 rows

fbschedulereportparameter

id, name, paramValue, scheduleId

0 rows

fobpoint

id, activeFlag, name

4 rows

guiproperties

id, userid, properties

69 rows

image

id, imageFull, imageThumbnail, recordId, tableName, type

3 rows

integratedapp

id, appKey, authorized, description, lastActivity, name, statusId

3 rows

integratedappstatus

id, name

3 rows

issuablestatus

id, name

3 rows

itemadjust

id, activeFlag, amount, description, expenseAsAccountId, incomeAsAccountId, name, percentage, taxRateId, taxableFlag, typeId

2 rows

itemadjusttype

id, name

2 rows

kitdisplaytype

id, name

2 rows

kititem

id, dateCreated, dateLastModified, defaultQty, description, discountId, kitItemTypeId, kitProductId, kitTypeId, maxQty, minQty, note, productId, qtyPriceAdjustment, soItemTypeId, sortOrder, taxRateId, uomId

0 rows

kititemtype

id, name

6 rows

kitoption

id, dateCreated, dateLastModified, defaultFlag, kitItemId, priceAdjustment, productId

0 rows

kittype

id, name

2 rows

lgsumtype

id, name

3 rows

location

id, activeFlag, countedAsAvailable, dateLastModified, defaultCustomerId, defaultFlag, defaultVendorId, description, locationGroupId, name, parentId, pickable, receivable, sortOrder, typeId, customFields

569 rows

locationgroup

id, activeFlag, dateLastModified, name, qbClassId

9 rows

locationtype

id, name

11 rows

memo

id, dateCreated, memo, recordId, tableId, userName

830 rows

mo

id, dateCompleted, dateCreated, dateIssued, dateLastModified, dateScheduled, locationGroupId, note, num, qbClassId, revision, soId, statusId, url, userId, customFields

4,003 rows

module

id, reportId, isModule, name

54 rows

moitem

id, addToService, bomId, bomItemId, dateScheduled, dateScheduledToStart, description, instructionNote, moId, oneTimeItem, parentId, partId, priceAdjustment, priorityId, qbClassId, qtyFulfilled, qtyToFulfill, soItemId, sortIdInstruct, stage, stageLevel, statusId, totalCost, typeId, uomId, calCategoryId

167,157 rows

moitemstatus

id, name

7 rows

mostatus

id, name

6 rows

notification

id, typeId, userId, locationGroupId, activeFlag

3 rows

notificationtype

id, name

2 rows

objecttoobject

id, note, recordId1, recordId2, tableId1, tableId2, typeId

95 rows

objecttoobjecttype

id, description, name

4 rows

ordertype

id, name

5 rows

pabaseamounttype

id, name

8 rows

part

id, abcCode, accountingHash, accountingId, activeFlag, adjustmentAccountId, alertNote, alwaysManufacture, cogsAccountId, configurable, consumptionRate, controlledFlag, cycleCountTol, dateCreated, dateLastModified, defaultBomId, defaultOutsourcedReturnItemId, defaultPoItemTypeId, defaultProductId, description, details, height, inventoryAccountId, lastChangedUser, leadTime, len, num, partClassId, pickInUomOfPart, receivingTol, revision, scrapAccountId, serializedFlag, sizeUomId, stdCost, taxId, trackingFlag, typeId, uomId, upc, url, varianceAccountId, weight, weightUomId, width, customFields

20,057 rows

partcategory

id, description, name

1 row

partcost

id, avgCost, dateCreated, dateLastModified, partId, qty, totalCost

4,143 rows

partcosthistory

id, avgCost, dateCaptured, nextCost, partId, quantity, stdCost, totalCost

Many rows

partreorder

id, locationGroupId, orderUpToLevel, partId, reorderPoint

499 rows

parttotracking

id, nextValue, partId, partTrackingId, primaryFlag

35,252 rows

parttracking

id, abbr, activeFlag, description, name, sortOrder, typeId, gs1Code

4 rows

parttrackingtype

id, name

8 rows

parttype

id, name

10 rows

patype

id, name

6 rows

paymentgateway

id, javaClass, login, name, other, other2, secret, dateExpiration

0 rows

paymentmethod

id, active, editable, name, typeId, depositAccountId

6 rows

paymentterms

id, accountingHash, accountingId, activeFlag, dateCreated, dateLastModified, defaultTerm, discount, discountDays, name, netDays, nextMonth, readOnly, typeId

13 rows

paymenttermstype

id, name

6 rows

paymenttype

id, name

10 rows

pick

id, dateCreated, dateFinished, dateLastModified, dateScheduled, dateStarted, locationGroupId, num, priority, statusId, toBePrinted, typeId, userId, customFields

19,098 rows

pickitem

id, destTagId, orderId, orderTypeId, partId, pickId, poItemId, qty, shipId, slotNum, soItemId, srcLocationId, srcTagId, statusId, tagId, typeId, uomId, woItemId, xoItemId

107,699 rows

pickitemstatus

id, name

7 rows

pickitemtype

id, name

3 rows

pickstatus

id, name

4 rows

picktype

id, name

3 rows

plugindata

id, dataKey, groupName, info, plugin

3 rows

plugininfo

id, channelId, groupId, info, plugin, recordId, tableName

0 rows

pluginproperties

id, dataKey, info, plugin

1 row

po

id, buyer, buyerId, carrierId, carrierServiceId, currencyId, currencyRate, customerSO, dateCompleted, dateConfirmed, dateCreated, dateFirstShip, dateIssued, dateLastModified, dateRevision, deliverTo, email, fobPointId, issuedByUserId, locationGroupId, note, num, paymentTermsId, phone, qbClassId, remitAddress, remitCity, remitCountryId, remitStateId, remitToName, remitZip, revisionNum, shipTermsId, shipToAddress, shipToCity, shipToCountryId, shipToName, shipToStateId, shipToZip, statusId, taxRateId, taxRateName, totalIncludesTax, totalTax, typeId, url, username, vendorContact, vendorId, vendorSO, customFields

3,454 rows

poitem

id, customerId, dateLastFulfillment, dateScheduledFulfillment, description, mcTotalCost, mcUnitCost, note, partId, outsourcedPartId, partNum, poId, poLineItem, qbClassId, qtyFulfilled, qtyPicked, qtyToFulfill, repairFlag, revLevel, statusId, taxId, taxRate, tbdCostFlag, totalCost, typeId, unitCost, uomId, vendorPartNum, outsourcedPartNumber, outsourcedPartDescription, customFields

7,687 rows

poitemstatus

id, name

10 rows

poitemtype

id, name

6 rows

post

id, amount, customerId, dateCreated, datePosted, editSequence, orderId, orderTypeId, postedTotalCost, quantity, refId, refItemId, refNumber, serialNum, statusId, txnId, txnLineId, typeId

31,046 rows

postatus

id, name

12 rows

postorderstatus

id, name

16 rows

postpo

id, dateCreated, dateLastModified, datePosted, extRefNumber, extTxnHash, extTxnId, extTxnNumber, journalPosted, journalTxnId, poId, postDate, statusId

4,193 rows

postpoitem

id, dateCreated, dateLastModified, extRefNumber, extTxnHash, extTxnId, extTxnLineId, poItemId, postPoId, postedTotalCost, mcPostedTotalCost, qty, receiptItemId, shipItemId, stdCost, receivedTotalCost

7,482 rows

postransaction

id, amount, authCode, changeGiven, confirmation, currencyRate, TEXT, depositToAccountId, expDate, merchantActNum, paymentMethodId, soId, transactionId, userId, info

0 rows

postso

id, dateCreated, dateLastModified, datePosted, extRefNumber, extTxnHash, extTxnId, extTxnNumber, journalPosted, journalTxnId, postDate, soId, statusId, totalTax

4,213 rows

postsoitem

id, adjustPercent, dateCreated, dateLastModified, extRefNumber, extTxnHash, extTxnId, extTxnLineId, postSOId, postedTotalCost, qty, receiptItemId, shipItemId, soItemId, totalPrice, totalPriceMc, totalTax, totalTaxMc

4,973 rows

poststatus

id, name

2 rows

posttype

id, name

10 rows

postwo

id, dateCreated, dateLastModified, datePosted, extRefNumber, extTxnHash, extTxnId, extTxnNumber, postDate, statusId, woId

14,184 rows

postwoitem

id, dateCreated, dateLastModified, extRefNumber, extTxnHash, extTxnId, extTxnLineId, postWoId, postedTotalCost, woItemId

126,448 rows

postxo

id, dateCreated, dateLastModified, datePosted, extRefNumber, extTxnHash, extTxnId, extTxnNumber, postDate, statusId, xoId

0 rows

postxoitem

id, dateCreated, dateLastModified, extTxnLineId, postXOId, postedTotalCost, qty, recordId, xoItemId

0 rows

potype

id, name

2 rows

pricingrule

id, customerInclId, customerInclTypeId, dateApplies, dateBegin, dateCreated, dateEnd, dateLastModified, description, isActive, isAutoApply, isTier2, name, paAmount, paApplies, paBaseAmountTypeId, paPercent, paTypeId, productInclId, productInclTypeId, qtyApplies, qtyMax, qtyMin, rndApplies, rndIsMinus, rndPMAmount, rndToAmount, rndTypeId, spcApplies, spcBuyX, spcGetYFree, userId

9 rows

priority

id, name

5 rows

product

id, accountingHash, accountingId, activeFlag, alertNote, cartonCount, defaultCartonTypeId, dateCreated, dateLastModified, defaultSoItemType, description, details, displayTypeId, height, incomeAccountId, kitFlag, kitGroupedFlag, len, num, partId, price, qbClassId, sellableInOtherUoms, showSoComboFlag, sizeUomId, sku, taxId, taxableFlag, uomId, upc, url, usePriceFlag, weight, weightUomId, width, customFields

7,611 rows

productincltype

id, name

4 rows

producttotree

id, productId, productTreeId

4 rows

producttree

id, description, name, parentId

1 row

propertycategory

id, name

5 rows

qbclass

id, accountingHash, accountingId, activeFlag, dateCreated, dateLastModified, name, parentId

2 rows

quicklist

id, customerId, name

11 rows

quicklistitem

id, productId, qListId, quantity

117 rows

receipt

id, locationGroupId, orderTypeId, poId, soId, statusId, typeId, userId, xoId

3,218 rows

receiptitem

id, billVendorFlag, billedTotalCost, mcBilledTotalCost, billedUnitCost, mcBilledUnitCost, carrierId, customerId, dateBilled, dateLastModified, dateReceived, dateReconciled, deliverTo, landedTotalCost, mcLandedTotalCost, locationId, orderTypeId, packageCount, partId, partTypeId, poItemId, qty, reason, receiptId, refNo, responsibilityId, shipItemId, soItemId, statusId, tagId, taxId, taxRate, trackingNum, typeId, uomId, xoItemId, outsourcedCost, carrierServiceId

7,906 rows

receiptitemstatus

id, name

4 rows

receiptitemtype

id, name

4 rows

receiptstatus

id, name

4 rows

receipttype

id, name

3 rows

register

id, name

0 rows

report

id, activeFlag, dateCreated, dateLastModified, description, lastChangedUserId, name, path, readOnly, reportTreeId, userId

357 rows

reportparameter

id, name, paramValue, REPORTID

3,583 rows

reporttomodule

id, moduleId, reportId

132 rows

reporttree

id, name, parentId, readOnly, userId

104 rows

responsibility

id, name

3 rows

revinfo

id, modifiedUserId, TEXT

259,595 rows

rma

id, customerId, dateCreated, dateExpires, dateLastModified, locationGroupId, num, statusId, userId, customFields

40 rows

rmaitem

id, crossShipFlag, dateResolved, issueId, lineNum, note, productId, productSubId, qty, resolutionId, returnFlag, rmaId, shipFlag, typeId, uomId, vendorId, vendorRMA

62 rows

rmaitemtype

id, activeFlag, name

4 rows

rmastatus

id, name

3 rows

rndtype

id, name

3 rows

serial

id, committedFlag, tagId

0 rows

serialnum

id, partTrackingId, serialId, serialNum

0 rows

ship

id, FOBPointId, billOfLading, carrierId, carrierServiceId, cartonCount, contact, dateCreated, dateLastModified, dateShipped, locationGroupId, note, num, orderTypeId, ownerIsFrom, poId, shipToId, shipmentIdentificationNumber, shippedBy, soId, statusId, xoId, shipToAddress, shipToCity, shipToName, shipToZip, shipToCountryId, shipToStateId, shipToResidential, customFields

4,206 rows

shipcarton

id, additionalHandling, carrierId, cartonNum, dateCreated, freightAmount, freightWeight, height, insuredValue, len, orderId, orderTypeId, shipId, shipperRelease, sizeUOM, sscc, trackingNum, weightUOM, width

4,425 rows

shipitem

id, dateLastModified, itemId, orderId, orderTypeId, poItemId, qtyShipped, shipCartonId, shipId, soItemId, tagId, totalCost, uomId, xoItemId

4,927 rows

shippingimport

id, cartonCost, cartonVoid, cartonWeight, ignoreThis, shipCartonId, trackingNum, processed

0 rows

shipstatus

id, name

4 rows

shipterms

id, activeFlag, name, readOnly

14 rows

so

id, billToAddress, billToCity, billToCountryId, billToName, billToStateId, billToZip, calCategoryId, carrierId, carrierServiceId, cost, createdByUserId, currencyId, currencyRate, customerContact, customerId, customerPO, dateCalStart, dateCalEnd, dateCompleted, dateCreated, dateExpired, dateFirstShip, dateIssued, dateLastModified, dateRevision, email, estimatedTax, fobPointId, locationGroupId, mcTotalTax, note, num, paymentTermsId, phone, priorityId, qbClassId, registerId, shipToResidential, revisionNum, salesman, salesmanId, salesmanInitials, shipTermsId, shipToAddress, shipToCity, shipToCountryId, shipToName, shipToStateId, shipToZip, statusId, taxRate, taxRateId, taxRateName, toBeEmailed, toBePrinted, totalIncludesTax, totalTax, subTotal, totalPrice, typeId, url, username, vendorPO, customFields, paymentLink

3,211 rows

soitem

id, adjustAmount, adjustPercentage, customerPartNum, dateLastFulfillment, dateLastModified, dateScheduledFulfillment, description, exchangeSOLineItem, itemAdjustId, markupCost, mcTotalPrice, note, productId, productNum, qbClassId, qtyFulfilled, qtyOrdered, qtyPicked, qtyToFulfill, revLevel, showItemFlag, soId, soLineItem, statusId, taxId, taxRate, taxableFlag, totalCost, totalPrice, typeId, unitPrice, uomId, customFields

4,394 rows

soitemstatus

id, name

12 rows

soitemtype

id, name

13 rows

sostatus

id, name

9 rows

sotype

id, name

3 rows

stateconst

id, code, countryConstID, name

84 rows

sysproperties

id, dateLastModified, owner, readAllowed, sysKey, sysValue, writeAllowed

219 rows

sysuser

id, activeFlag, email, firstName, initials, lastName, phone, userName, userPwd, passwordLastModified, mfaSecret, mfaBypassCounter, customFields

78 rows

tablereference

id, tableId, tableRefName, displayName, customFieldsFlag

53 rows

tag

id, dateCreated, dateLastCycleCount, dateLastModified, locationId, num, partId, qty, qtyCommitted, serializedFlag, trackingEncoding, typeId, usedFlag, woItemId

3,297 rows

tagtype

id, name

4 rows

taxrate

id, accountingHash, accountingId, activeFlag, code, dateCreated, dateLastModified, defaultFlag, description, name, orderTypeId, rate, taxAccountId, typeCode, typeId, unitCost, vendorId

1 row

taxratetype

id, name

2 rows

trackingdate

id, info, partTrackingId, tagId

134 rows

trackingdecimal

id, info, partTrackingId, tagId

0 rows

trackinginfo

id, info, infoDate, infoDouble, infoInteger, partTrackingId, qty, recordId, tableId

413,228 rows

trackinginfosn

id, partTrackingId, serialNum, trackingInfoId

204 rows

trackinginteger

id, info, partTrackingId, tagId

0 rows

trackingtext

id, info, partTrackingId, tagId

4,837 rows

trusteddevice

id, sysUserId, deviceId, expirationDate

0 rows

uom

id, activeFlag, code, defaultRecord, description, integral, name, readOnly, uomType

39 rows

uomconversion

id, description, factor, fromUomId, multiply, toUomId

64 rows

uomtype

id, name

6 rows

useraccess

id, groupId, modifyFlag, moduleName, viewFlag

3,119 rows

usergroup

id, name

19 rows

usergrouprel

id, groupId, userId

123 rows

userproperties

id, categoryId, subCategory1, subCategory2, sysProperty, userId, userKey, userValue

14 rows

usertolg

id, defaultFlag, locationGroupId, userId

195 rows

vendor

id, accountId, accountNum, accountingHash, accountingId, activeFlag, creditLimit, currencyId, currencyRate, dateEntered, dateLastModified, defaultCarrierId, defaultCarrierServiceId, defaultPaymentTermsId, defaultShipTermsId, lastChangedUser, leadTime, minOrderAmount, name, note, statusId, sysUserId, taxRateId, url, customFields

580 rows

vendorcostrule

id, dateCreated, dateLastModified, description, name, partId, qty, unitCost, userId, vendorId

0 rows

vendorparts

id, dateCreated, dateLastModified, defaultFlag, lastCost, lastDate, leadTime, partId, qtyMax, qtyMin, uomId, userId, vendorId, vendorPartNumber

1,546 rows

vendorstatus

id, name

5 rows

wallet

id, gatewayName, gatewayProfileId, customerId

0 rows

watch

id, alertLevel, columnName, comparison, criticalLevel, itemDesc, itemId, lgSumTypeId, locationGroupId, strId, sysUserId, tableId, typeId

52 rows

watchtype

id, name

2 rows

wo

id, calCategoryId, cost, customerId, dateCreated, dateFinished, dateLastModified, dateScheduled, dateScheduledToStart, dateStarted, locationGroupId, locationId, moItemId, note, num, priorityId, qbClassId, qtyOrdered, qtyScrapped, qtyTarget, statusId, userId, customFields

16,021 rows

woassignedusers

id, userId, woId

3 rows

woinstruction

id, bomInstructionItemId, dateFirstReady, dateLastFulfilled, description, details, name, qtyFulfilled, qtyReady, sortOrder, url, woId, customFields

56,578 rows

woitem

id, cost, standardCost, description, moItemId, partId, qtyScrapped, qtyTarget, qtyUsed, sortId, typeId, uomId, woId, oneTimeItem

171,503 rows

wostatus

id, name

3 rows

xo

id, carrierId, carrierServiceId, dateCompleted, dateConfirmed, dateCreated, dateFirstShip, dateIssued, dateLastModified, dateScheduled, fromAddress, fromAttn, fromCity, fromCountryId, fromLGId, fromName, fromStateId, fromZip, mainLocationTagId, note, num, ownerIsFrom, revisionNum, shipToAddress, shipToAttn, shipToCity, shipToCountryId, shipToLGId, shipToName, shipToStateId, shipToZip, statusId, typeId, userId, customFields

3 rows

... and 60 hidden tables

fishbowl_archive

Custom SQL query

Queries

Tables