SchemaSpy Analysis of Z:\\Dropbox\\git\\FishbowlDataDictionary\\data\\FishbowlDB_Latest.FDBCommunity Fishbowl Inventory Data Dictionary Generated by
SchemaSpy
Generated by SchemaSpy on Sat Mar 01 08:31 PST 2014
Database Type: Firebird 2.5/WI - WI-V2.5.2.26540 SourceForge.net

XML Representation
Insertion Order Deletion Order (for database loading/purging scripts)

Table / View Children Parents Columns Comments
ACCOUNT 7 1 2 Maintains the account primary key.
ACCOUNTGROUP 1 2 Also known as Customer Group, this defines the groups available in the system.
ACCOUNTGROUPRELATION 2 3 Defines the Account(Customer & Vendor) to Group relationship. Allows for many groups to associate with one Account.
ACCOUNTTYPE 1 2 Unknown
ADDRESS 3 14 Maintains a list of pre-defined addresses for Accounts(Customer & Vendor).
ADDRESSMULTILINEPOVIEW 7
ADDRESSMULTILINESOVIEW 4
ADDRESSMULTILINEVIEW 13
ADDRESSMULTILINEXOVIEW 7
ADDRESSTYPE 1 2 Reference table for address types.
ASACCOUNT 11 1 9 Table of QuickBooks General Ledger Accounts
ASACCOUNTTYPE 1 2 Reference table for General Ledger Account types
ASSOCPRICE 2 4 Unknown
ASSOCPRICETYPE 1 1 5 Reference table for Associated Price Types
BOM 5 2 17 Bill of Material Header table
BOMAUTOCREATETYPE 1 2 Reference table for Bill of Material create types
BOMITEM 2 5 23 Bill of Material Detail table
BOMITEMGROUP 1 1 5 Bill of Material Optional Group detail
BOMITEMTOLOCATION 3 4 Bill of Material Default Pick Location for Parts
BOMITEMTYPE 3 2 Reference table for Bill of Material Item types
BOMTOLOCATION 3 4 Bill of Material to Location Mapping
CALCATEGORY 1 1 8 Calendar Category List
CALEVENT 2 11 Calendar Events
CARRIER 9 6 List of Shipment Carriers
COMPANY 2 12 Company Table
CONTACT 2 7 Contact Information Table
CONTACTTYPE 1 2 Reference of Contact Types
COSTLAYER 1 3 11 FIFO/LIFO Inventory Valuation
COSTLAYERSTATUS 1 2 Reference Table of Costlayer Status
COUNTRYCONST 1 4 Reference List of Countries
CURRENCY 4 1 9 Reference list of currencies
CUSTOMDECIMAL 1 4 Custom Field storage for Decimal Numbers
CUSTOMER 10 9 28 Customer Information Table
CUSTOMERCONTACTVIEW 4
CUSTOMERINCLTYPE 1 2 Reference list of Pricing Rule Customer Applies To names
CUSTOMERPARTS 3 9 Unknown
CUSTOMERSTATUS 1 2 Reference list of Customer Statuses
CUSTOMFIELD 6 3 9 Maintains a list of Custom Fields and their Relationship to Modules
CUSTOMFIELDTYPE 1 1 4 Reference list of Custom Field types
CUSTOMFIELDVIEW 10
CUSTOMINTEGER 1 4 Custom Field Storage for Whole Numbers
CUSTOMLIST 2 3 Defines a Custom Field List
CUSTOMLISTITEM 1 4 Defines a Custom Field List Item (Selection)
CUSTOMSET 1 4 Custom Field Storage for List Items
CUSTOMTIMESTAMP 1 4 Custom Field Storage For Date Custom Fields
CUSTOMVARCHAR 1 4 Custom Field Storage for Text Custom Fields
CUSTOMVARCHARLONG 1 4 Custom Field Storage for Long Text Custom Fields
DATABASEVERSION 4 Maintains a list of when a database is upgraded to
DCOPTIONS 1 3 Unknown
DEFAULTLOCATION 3 4 Maintains a relationship of Part & Location Group to a SpecifiC Location for Putaway and Receiving.
FBSCHEDULE 2 3 19 Defines the list of Scheduled Tasks.
FBSCHEDULEACTIONTYPE 1 2 Reference list of Scheduled Task Action Types
FBSCHEDULEHISTORY 1 4 Maintains a list of Scheduled Task Completion History.
FBSCHEDULEREPORTPARAMETER 1 4 Defines the optional parameters of Reports when scheduled through the Schedule Module
FEDEXVIEW 15
FOBPOINT 3 2 Free on Board (FOB) Point Reference List
INTEGRATEDAPP 1 7 Maintains a list of Integrated Apps
INTEGRATEDAPPSTATUS 1 2 Defines an Integrated App status
INTEGRATIONPROPERTIES 1 4 Unknown
INTEGRATIONTYPE 1 2 Unknown
INVENTORYLOG 2 6 18 Transactional List of Inventory Movement
INVENTORYLOGTOCOSTLAYER 2 4 Maps an Inventory Log Record to FIFO/LIFO Costlayer Record
INVENTORYLOGTYPE 1 3 Defines a the Inventory Log Types Allowable
INVLOGTRACKINGSUMMARY 2
ITEMADJUST 1 4 11 Item Adjust Information
ITEMADJUSTTYPE 1 2 Item Adjust Types
KITDISPLAYTYPE 1 2 Reference List of Kit Display Options
KITITEM 1 8 18 Items within Kits
KITITEMTYPE 1 2 Kit Item Types
KITOPTION 2 7 Kit Item Optional Groups
KITTYPE 1 2 Kit Types
LGSUMTYPE 1 2 Uknown
LOCATION 7 4 15 Inventory Location - aka Shelf/Bin/Aisle
LOCATIONGROUP 19 1 5 Inventory Location Group - Warehouse
LOCATIONTYPE 1 2 Location Types
MEMO 6 Memo Storage Table
MO 1 5 15 Manufacture Order
MODULE 1 1 4 Unknown
MOITEM 3 10 25 Manufacture Order Items
MOITEMSTATUS 1 2 Reference list of Manufacture Order Item Status
MOSTATUS 1 2 Manufacture Order Status
OBJECTTOOBJECT 3 7 Maps Records from One Table to Another
OBJECTTOOBJECTTYPE 1 3 Object To Object Type
ORDERHISTORY 2 8 Order History
ORDERTYPE 8 2 Order Type
PABASEAMOUNTTYPE 2 Pricing Rule Product Base Amount Type List
PACKAGETYPES 1 3 UPS Package Types?
PART 18 12 45 Part Records
PARTCATEGORY 3 Unknown
PARTCOST 1 7 Maintains the Part Average Cost and QTY
PARTREORDER 2 5 Maintains the Part Reorder Point and Order Up To Level
PARTTOTRACKING 2 4 Maps a part to its part tracking types
PARTTRACKING 10 1 7 Defines Part Tracking, Lot, ExpDate, Serial Number, Revision
PARTTRACKINGTYPE 1 2 Reference table for parttracking types, text, number, date, serial
PARTTRACKINGVIEW 10
PARTTYPE 2 2 Reference table for part types
PATYPE 2 Reference table for pricing rule types
PAYMENTMETHOD 1 1 5 Maintains a list of payment methods
PAYMENTTERMS 4 1 14 Maintains the Payment Terms used
PAYMENTTERMSTYPE 1 2 Reference table for payment term types
PAYMENTTYPE 1 2 Unknown
PICK 1 5 12 Pick Record Header
PICKITEM 6 15 Pick Item Detail
PICKITEMSTATUS 1 2 Reference table for pick item statuses
PICKITEMTYPE 1 2 Reference table for pick item types
PICKSTATUS 1 2 Reference table for pick item status
PICKTYPE 1 2 Reference table for pick types
PO 2 11 45 Purchase Order Header Table
POITEM 1 8 25 Purchase Order Item Detail Table
POITEMSTATUS 1 2 Reference tbale for Purchase Order Item Status
POITEMTYPE 1 2 Reference table for Purchase Order item Types
POST 4 17 Maintains a list of miscalleneous QuickBooks posting records
POSTATUS 1 2 Reference table for Purchase Order status
POSTORDERSTATUS 4 2 Unknown
POSTPO 1 2 11 Contains header data for Purchase Order transactions to be posted to QuickBooks
POSTPOITEM 2 13 Contains detail data for Purchase Order transactions to be posted to QuickBooks
POSTRANSACTION 3 16 Point of Sale Payment Records
POSTSO 1 2 11 Contains header data for Sales Order transactions to be posted to QuickBooks
POSTSOITEM 2 12 Contains detail data for Sales Order transactions to be posted to QuickBooks
POSTSTATUS 1 2 Unknown
POSTTYPE 1 2 Unknown
POSTWO 1 2 11 Contains header data for finished Work Order transactions to be posted to QuickBooks
POSTWOITEM 2 9 Contains detail data for finished Work Order transactions to be posted to QuickBooks
POSTXO 1 2 11 Unused afaik
POSTXOITEM 2 9 Unused afaik
POTYPE 1 2 Reference table for Purchase Order Types
PRICINGRULE 3 32 Maintains the Pricing Rules used in Fishbowl Inventory
PRIORITY 4 2 Sales, Pick - Priority Reference Table
PRODUCT 10 9 33 Product table, also contains kit (header)
PRODUCTINCLTYPE 1 2 Pricing Rule Product Applies to Reference
PRODUCTTOTREE 3 Maps a Product to a Product Tree folder
PRODUCTTREE 4 Product Tree
PROPERTYCATEGORY 1 2 Unknown
QBCLASS 9 8 QuickBooks Classes
QOHVIEW 6
QTYALLOCATED 3
QTYALLOCATEDMO 3
QTYALLOCATEDPO 3
QTYALLOCATEDSO 3
QTYALLOCATEDTORECEIVE 3
QTYALLOCATEDTOSEND 3
QTYCOMMITTED 3
QTYDROPSHIP 3
QTYINVENTORY 14
QTYINVENTORYTOTALS 8
QTYNOTAVAILABLE 3
QTYNOTAVAILABLETOPICK 3
QTYONHAND 3
QTYONORDER 3
QTYONORDERMO 3
QTYONORDERPO 3
QTYONORDERSO 3
QTYONORDERTORECEIVE 3
QTYONORDERTOSEND 3
QUICKLIST 1 1 3 Sales Order Quicklist item record header
QUICKLISTITEM 2 4 QuickList item record detail
RECEIPT 1 5 7 Open Receipt Record Header
RECEIPTITEM 9 29 Receipt Item Record Detail
RECEIPTITEMSTATUS 1 2 Reference table for Receipt Item Status
RECEIPTITEMTYPE 1 2 Reference table for Receipt Item type
RECEIPTSTATUS 1 2 Reference table for Receipt Status
RECEIPTTYPE 1 2 Reference table for receipt type
REGISTER 2 Defines the Point of Sale Registers
REPORT 5 1 11 Maintains a list of System and Custom reports
REPORTPARAMETER 1 4 Maintains the saved Report optional parameters
REPORTSECURITY 2 4 Maps a user group to a report
REPORTTOMODULE 2 2 Maps a report to a module
REPORTTREE 1 5 The folder organizational structure for reports
RESPONSIBILITY 2 Not sure
RMA 1 4 9 RMA Module Header
RMAITEM 6 17 RMA Module Detail
RMAITEMTYPE 1 3 Reference table for RMA item types
RMASTATUS 1 2 Reference table for RMA status
RNDTYPE 2 Reference Table for Pricing Rule Round Type
SERIAL 1 1 3 On Hand Serial Storage
SERIALNUM 2 4 On Hand Serial Storage - Exact Field
SHIP 4 7 24 Ship Module Header
SHIPCARTON 2 5 22 Ship Cartons - Contains tracking number, weight, amount etc,.
SHIPCARTONPOVIEW 2
SHIPCARTONSOVIEW 2
SHIPCARTONXOVIEW 2
SHIPITEM 4 12 Ship Module Detail
SHIPPINGIMPORT 7 Temprorary table that supports the supervised update of Ship Carton, UPS, USPS, FedEx uses these
SHIPSTATUS 1 2 Reference table for Ship Status
SHIPTERMS 4 3 Reference table for Ship Terms
SHIPUPSCARTONDETAILS 2 12 UPS Module Ship Carton Details
SHIPUPSDETAILS 3 14 UPS Module ?
SO 4 13 50 Sales Order Header
SOITEM 2 7 31 Sales Order Detail
SOITEMSTATUS 1 2 Reference for Sales Order Item Status
SOITEMTOMOITEM 1 3 Maps a Sales Order Item to A Manufacture Order Item
SOITEMTYPE 3 2 Reference for Sales Order Item Type
SOSTATUS 1 2 Reference table for Sales Order Status
SOTYPE 1 2 Reference table for Sales Order Type
STATECONST 1 1 4 States - Provinces
SYSPROPERTIES 7 System Properties - Property Module
SYSUSER 24 7 System Users - or just users
TABLEREFERENCE 5 4 Reference to describe table references in other tables
TAG 6 5 15 Maintains tag records for Inventory and Locations, is Quantity On Hand
TAGSERIALVIEW 12
TAGTRACKINGVIEW 11
TAGTYPE 1 2 Reference table for Tag Types
TAXRATE 11 4 16 Tax Rates
TAXRATETYPE 1 2 Reference table for Tax Rate Types
TIINVENTORYLOG 1 2 8 Tracking Information for Inventory Log Records - Non Serialized
TIINVENTORYLOGSN 2 4 Tracking Information for Inventory Log Records - Serialized
TRACKDATE 3
TRACKDECIMAL 3
TRACKINGDATE 2 4 Part Tracking Information for Date Types
TRACKINGDECIMAL 2 4 Part Tracking Information for Decimal Types
TRACKINGINFO 1 1 9 Part Tracking Information to Modules - Non Serialized
TRACKINGINFOSN 2 4 Part Tracking Information to Modules - Serialized
TRACKINGINTEGER 2 4 Part Tracking Information for Whole Number Types
TRACKINGTEXT 2 4 Part Tracking Information for Text Types
TRACKINTEGER 3
TRACKTEXT 3
UOM 20 1 9 Unit of Measures
UOMCONVERSION 2 6 Unit of Measure conversions
UOMTYPE 1 2 Unit of Measure Types
UPSACCOUNT 3 Unknown?
UPSCOD 1 2 Unknown?
UPSPAYMENTTYPE 1 2 X
UPSRETURNSHIPMENT 1 3 X
UPSSERVICES 3 4 X
UPSVIEW 4
USERACCESS 1 5 Unkown
USERGROUP 3 2 Defines the User Groups
USERGROUPREL 2 3 Defines the User to User Group Relationship
USERLOG 1 4 Logs when users log into the system and off
USERPROPERTIES 2 8 Unknown
USERTOLG 2 4 Specifies which users can access information in Location Groups
VENDOR 6 7 23 Vendors
VENDORCONTACTVIEW 4
VENDORCOSTRULE 3 10 Vendor Cost Rules
VENDORPARTS 4 14 Vendors to Parts Mapping
VENDORSTATUS 1 2 Reference table for Vendor Status
WATCH 5 13 Unknown
WATCHTYPE 1 2 X
WO 3 8 22 Work Order Header
WOASSIGNEDUSERS 2 3 The Assign Users to Work Order Table
WOITEM 2 5 12 Work Order Item Detail
WOMOVIEW 2
WOSTATUS 1 2 Reference table for Work Order Statuses
XO 2 7 33 Transfer Order Header
XOITEM 1 5 17 Transfer Order Item Detail
XOITEMSTATUS 1 2 Reference table for Transfer Order Item Status
XOITEMTYPE 1 2 Reference table for Transfer Order Item Type
XOSTATUS 1 2 Reference table for Transfer Order Status
XOTYPE 1 2 Reference table for Transfer Order type
         
208 Tables     1,538  
41 Views     202