SchemaSpy Analysis of Z:\\Dropbox\\git\\FishbowlDataDictionary\\data\\FishbowlDB_Latest.FDB - ConstraintsCommunity Fishbowl Inventory Data Dictionary Generated by
SchemaSpy
362 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
INTEG_1000 CUSTOMLISTITEM.LISTID CUSTOMLIST.ID Restrict delete 
INTEG_1007 CUSTOMFIELDTYPE.TABLEID TABLEREFERENCE.TABLEID Restrict delete 
INTEG_1013 CUSTOMFIELD.CUSTOMFIELDTYPEID CUSTOMFIELDTYPE.ID Restrict delete 
INTEG_1015 CUSTOMFIELD.TABLEID TABLEREFERENCE.TABLEID Restrict delete 
INTEG_1016 CUSTOMFIELD.LISTID CUSTOMLIST.ID Restrict delete 
INTEG_1021 CUSTOMVARCHAR.CUSTOMFIELDID CUSTOMFIELD.ID Restrict delete 
INTEG_1027 CUSTOMTIMESTAMP.CUSTOMFIELDID CUSTOMFIELD.ID Restrict delete 
INTEG_1033 CUSTOMINTEGER.CUSTOMFIELDID CUSTOMFIELD.ID Restrict delete 
INTEG_1039 CUSTOMDECIMAL.CUSTOMFIELDID CUSTOMFIELD.ID Restrict delete 
INTEG_1044 CUSTOMSET.CUSTOMFIELDID CUSTOMFIELD.ID Restrict delete 
INTEG_1047 DEFAULTLOCATION.PARTID PART.ID Restrict delete 
INTEG_1049 DEFAULTLOCATION.LOCATIONID LOCATION.ID Restrict delete 
INTEG_1051 DEFAULTLOCATION.LOCATIONGROUPID LOCATIONGROUP.ID Restrict delete 
INTEG_1053 TAG.TYPEID TAGTYPE.ID Restrict delete 
INTEG_1056 PICK.TYPEID PICKTYPE.ID Restrict delete 
INTEG_1057 PICK.STATUSID PICKSTATUS.ID Restrict delete 
INTEG_1058 PICK.USERID SYSUSER.ID Restrict delete 
INTEG_1060 PICK.PRIORITY PRIORITY.ID Restrict delete 
INTEG_1062 PICK.LOCATIONGROUPID LOCATIONGROUP.ID Restrict delete 
INTEG_1065 SHIP.LOCATIONGROUPID LOCATIONGROUP.ID Restrict delete 
INTEG_1069 CURRENCY.LASTCHANGEDUSERID SYSUSER.ID Restrict delete 
INTEG_1082 FBSCHEDULE.ACTIONTYPEID FBSCHEDULEACTIONTYPE.ID Restrict delete 
INTEG_1086 FBSCHEDULEHISTORY.SCHEDULEID FBSCHEDULE.ID Restrict delete 
INTEG_1113 XO.TYPEID XOTYPE.ID Restrict delete 
INTEG_1115 XO.STATUSID XOSTATUS.ID Restrict delete 
INTEG_1119 XO.FROMLGID LOCATIONGROUP.ID Restrict delete 
INTEG_1121 XO.SHIPTOLGID LOCATIONGROUP.ID Restrict delete 
INTEG_1122 XO.MAINLOCATIONTAGID TAG.ID Restrict delete 
INTEG_1124 XO.USERID SYSUSER.ID Restrict delete 
INTEG_1126 XO.CARRIERID CARRIER.ID Restrict delete 
INTEG_1130 XOITEM.XOID XO.ID Restrict delete 
INTEG_1132 XOITEM.TYPEID XOITEMTYPE.ID Restrict delete 
INTEG_1134 XOITEM.STATUSID XOITEMSTATUS.ID Restrict delete 
INTEG_1135 XOITEM.PARTID PART.ID Restrict delete 
INTEG_1138 XOITEM.UOMID UOM.ID Restrict delete 
INTEG_1151 TIINVENTORYLOG.INVENTORYLOGID INVENTORYLOG.ID Restrict delete 
INTEG_1153 FBSCHEDULEREPORTPARAMETER.SCHEDULEID FBSCHEDULE.ID Restrict delete 
INTEG_1155 PO.CURRENCYID CURRENCY.ID Restrict delete 
INTEG_1163 COSTLAYER.PARTID PART.ID Restrict delete 
INTEG_1164 FBSCHEDULE.REPORTID REPORT.ID Restrict delete 
INTEG_1165 FBSCHEDULE.LASTCHANGEDUSERID SYSUSER.ID Restrict delete 
INTEG_1166 VENDOR.CURRENCYID CURRENCY.ID Restrict delete 
INTEG_1168 COSTLAYER.TABLEID TABLEREFERENCE.TABLEID Restrict delete 
INTEG_1171 COSTLAYER.STATUSID COSTLAYERSTATUS.ID Restrict delete 
INTEG_1175 INVENTORYLOGTOCOSTLAYER.INVENTORYLOGID INVENTORYLOG.ID Restrict delete 
INTEG_1178 INVENTORYLOGTOCOSTLAYER.COSTLAYERID COSTLAYER.ID Restrict delete 
INTEG_1191 OBJECTTOOBJECT.TABLEID1 TABLEREFERENCE.TABLEID Restrict delete 
INTEG_1194 OBJECTTOOBJECT.TABLEID2 TABLEREFERENCE.TABLEID Restrict delete 
INTEG_1197 OBJECTTOOBJECT.TYPEID OBJECTTOOBJECTTYPE.ID Restrict delete 
INTEG_1201 ORDERHISTORY.ORDERTYPEID ORDERTYPE.ID Restrict delete 
INTEG_1203 ORDERHISTORY.USERID SYSUSER.ID Restrict delete 
INTEG_1217 RMA.CUSTOMERID CUSTOMER.ID Restrict delete 
INTEG_1219 RMA.STATUSID RMASTATUS.ID Restrict delete 
INTEG_1221 RMA.USERID SYSUSER.ID Restrict delete 
INTEG_1223 RMA.LOCATIONGROUPID LOCATIONGROUP.ID Restrict delete 
INTEG_1227 RMAITEM.RMAID RMA.ID Restrict delete 
INTEG_1230 RMAITEM.PRODUCTID PRODUCT.ID Restrict delete 
INTEG_1232 RMAITEM.UOMID UOM.ID Restrict delete 
INTEG_1234 RMAITEM.TYPEID RMAITEMTYPE.ID Restrict delete 
INTEG_1235 RMAITEM.PRODUCTSUBID PRODUCT.ID Restrict delete 
INTEG_1236 RMAITEM.VENDORID VENDOR.ID Restrict delete 
INTEG_1244 POSTSO.SOID SO.ID Restrict delete 
INTEG_1246 POSTSO.STATUSID POSTORDERSTATUS.ID Restrict delete 
INTEG_1251 POSTSOITEM.POSTSOID POSTSO.ID Restrict delete 
INTEG_1253 POSTSOITEM.SOITEMID SOITEM.ID Restrict delete 
INTEG_1259 POSTPO.POID PO.ID Restrict delete 
INTEG_1261 POSTPO.STATUSID POSTORDERSTATUS.ID Restrict delete 
INTEG_1266 POSTPOITEM.POSTPOID POSTPO.ID Restrict delete 
INTEG_1267 POSTPOITEM.POITEMID POITEM.ID Restrict delete 
INTEG_1268 CUSTOMERPARTS.PRODUCTID PRODUCT.ID Restrict delete 
INTEG_1273 POSTXO.XOID XO.ID Restrict delete 
INTEG_1275 POSTXO.STATUSID POSTORDERSTATUS.ID Restrict delete 
INTEG_1280 POSTXOITEM.POSTXOID POSTXO.ID Restrict delete 
INTEG_1281 POSTXOITEM.XOITEMID XOITEM.ID Restrict delete 
INTEG_1284 CUSTOMERPARTS.CUSTOMERID CUSTOMER.ID Restrict delete 
INTEG_1287 CUSTOMERPARTS.LASTCHANGEDUSERID SYSUSER.ID Restrict delete 
INTEG_1288 CUSTOMER.CURRENCYID CURRENCY.ID Restrict delete 
INTEG_1289 SO.CURRENCYID CURRENCY.ID Restrict delete 
INTEG_130 LOCATIONGROUP.QBCLASSID QBCLASS.ID Restrict delete 
INTEG_1310 RECEIPT.STATUSID RECEIPTSTATUS.ID Restrict delete 
INTEG_1312 RECEIPT.TYPEID RECEIPTTYPE.ID Restrict delete 
INTEG_1314 RECEIPT.ORDERTYPEID ORDERTYPE.ID Restrict delete 
INTEG_1316 RECEIPT.USERID SYSUSER.ID Restrict delete 
INTEG_1318 RECEIPT.LOCATIONGROUPID LOCATIONGROUP.ID Restrict delete 
INTEG_1322 RECEIPTITEM.RECEIPTID RECEIPT.ID Restrict delete 
INTEG_1324 RECEIPTITEM.TYPEID RECEIPTITEMTYPE.ID Restrict delete 
INTEG_1326 RECEIPTITEM.PARTTYPEID PARTTYPE.ID Restrict delete 
INTEG_1328 RECEIPTITEM.STATUSID RECEIPTITEMSTATUS.ID Restrict delete 
INTEG_1330 RECEIPTITEM.UOMID UOM.ID Restrict delete 
INTEG_1331 INVENTORYLOG.TYPEID INVENTORYLOGTYPE.ID Restrict delete 
INTEG_1332 PRODUCT.DEFAULTSOITEMTYPE SOITEMTYPE.ID Restrict delete 
INTEG_1333 INVENTORYLOG.USERID SYSUSER.ID Restrict delete 
INTEG_1334 TAXRATE.TYPEID TAXRATETYPE.ID Restrict delete 
INTEG_1335 TAXRATE.TAXACCOUNTID ASACCOUNT.ID Restrict delete 
INTEG_1336 LOCATION.DEFAULTCUSTOMERID CUSTOMER.ID Restrict delete 
INTEG_1337 LOCATION.DEFAULTVENDORID VENDOR.ID Restrict delete 
INTEG_1338 PART.DEFAULTPRODUCTID PRODUCT.ID Restrict delete 
INTEG_134 STATECONST.COUNTRYCONSTID COUNTRYCONST.ID Restrict delete 
INTEG_135 PRODUCT.TAXID TAXRATE.ID Restrict delete 
INTEG_1356 KITITEM.KITITEMTYPEID KITITEMTYPE.ID Restrict delete 
INTEG_1358 KITITEM.KITPRODUCTID PRODUCT.ID Restrict delete 
INTEG_1359 KITITEM.PRODUCTID PRODUCT.ID Restrict delete 
INTEG_1360 KITITEM.DISCOUNTID ITEMADJUST.ID Restrict delete 
INTEG_1361 KITITEM.TAXRATEID TAXRATE.ID Restrict delete 
INTEG_1365 KITITEM.UOMID UOM.ID Restrict delete 
INTEG_1366 KITITEM.SOITEMTYPEID SOITEMTYPE.ID Restrict delete 
INTEG_1368 KITITEM.KITTYPEID KITTYPE.ID Restrict delete 
INTEG_1372 KITOPTION.KITITEMID KITITEM.ID Restrict delete 
INTEG_1374 KITOPTION.PRODUCTID PRODUCT.ID Restrict delete 
INTEG_1382 USERPROPERTIES.USERID SYSUSER.ID Restrict delete 
INTEG_1384 USERPROPERTIES.CATEGORYID PROPERTYCATEGORY.ID Restrict delete 
INTEG_1387 PRODUCT.DISPLAYTYPEID KITDISPLAYTYPE.ID Restrict delete 
INTEG_151 PRICINGRULE.PRODUCTINCLTYPEID PRODUCTINCLTYPE.ID Restrict delete 
INTEG_153 PRICINGRULE.CUSTOMERINCLTYPEID CUSTOMERINCLTYPE.ID Restrict delete 
INTEG_155 PRICINGRULE.USERID SYSUSER.ID Restrict delete 
INTEG_156 ITEMADJUST.INCOMEASACCOUNTID ASACCOUNT.ID Restrict delete 
INTEG_157 ITEMADJUST.EXPENSEASACCOUNTID ASACCOUNT.ID Restrict delete 
INTEG_172 PARTTRACKING.TYPEID PARTTRACKINGTYPE.ID Restrict delete 
INTEG_189 PARTTOTRACKING.PARTID PART.ID Restrict delete 
INTEG_191 PARTTOTRACKING.PARTTRACKINGID PARTTRACKING.ID Restrict delete 
INTEG_195 SERIALNUM.SERIALID SERIAL.ID Restrict delete 
INTEG_197 SERIALNUM.PARTTRACKINGID PARTTRACKING.ID Restrict delete 
INTEG_218 UOM.UOMTYPE UOMTYPE.ID Restrict delete 
INTEG_222 UOMCONVERSION.TOUOMID UOM.ID Restrict delete 
INTEG_224 UOMCONVERSION.FROMUOMID UOM.ID Restrict delete 
INTEG_233 ACCOUNT.TYPEID ACCOUNTTYPE.ID Restrict delete 
INTEG_236 ACCOUNTGROUPRELATION.GROUPID ACCOUNTGROUP.ID Restrict delete 
INTEG_237 ACCOUNTGROUPRELATION.ACCOUNTID ACCOUNT.ID Restrict delete 
INTEG_245 LOCATION.TYPEID LOCATIONTYPE.ID Restrict delete 
INTEG_248 LOCATION.LOCATIONGROUPID LOCATIONGROUP.ID Restrict delete 
INTEG_253 PAYMENTTERMS.TYPEID PAYMENTTERMSTYPE.ID Restrict delete 
INTEG_259 ADDRESS.ACCOUNTID ACCOUNT.ID Restrict delete 
INTEG_261 ADDRESS.TYPEID ADDRESSTYPE.ID Restrict delete 
INTEG_263 SOITEM.TAXID TAXRATE.ID Restrict delete 
INTEG_264 PART.TAXID TAXRATE.ID Restrict delete 
INTEG_265 POITEM.TAXID TAXRATE.ID Restrict delete 
INTEG_266 PO.TAXRATEID TAXRATE.ID Restrict delete 
INTEG_267 RECEIPTITEM.TAXID TAXRATE.ID Restrict delete 
INTEG_276 ASACCOUNT.TYPEID ASACCOUNTTYPE.ID Restrict delete 
INTEG_278 TRACKINGTEXT.PARTTRACKINGID PARTTRACKING.ID Restrict delete 
INTEG_280 TRACKINGTEXT.TAGID TAG.ID Restrict delete 
INTEG_285 TRACKINGDECIMAL.PARTTRACKINGID PARTTRACKING.ID Restrict delete 
INTEG_287 TRACKINGDECIMAL.TAGID TAG.ID Restrict delete 
INTEG_292 TRACKINGINTEGER.PARTTRACKINGID PARTTRACKING.ID Restrict delete 
INTEG_294 TRACKINGINTEGER.TAGID TAG.ID Restrict delete 
INTEG_300 PART.TYPEID PARTTYPE.ID Restrict delete 
INTEG_302 PART.UOMID UOM.ID Restrict delete 
INTEG_305 PART.COGSACCOUNTID ASACCOUNT.ID Restrict delete 
INTEG_306 PART.INVENTORYACCOUNTID ASACCOUNT.ID Restrict delete 
INTEG_307 PART.WEIGHTUOMID UOM.ID Restrict delete 
INTEG_311 PARTREORDER.PARTID PART.ID Restrict delete 
INTEG_312 PARTREORDER.LOCATIONGROUPID LOCATIONGROUP.ID Restrict delete 
INTEG_317 INVENTORYLOG.PARTID PART.ID Restrict delete 
INTEG_319 INVENTORYLOG.BEGLOCATIONID LOCATION.ID Restrict delete 
INTEG_321 INVENTORYLOG.ENDLOCATIONID LOCATION.ID Restrict delete 
INTEG_322 INVENTORYLOG.LOCATIONGROUPID LOCATIONGROUP.ID Restrict delete 
INTEG_324 TRACKINGDATE.PARTTRACKINGID PARTTRACKING.ID Restrict delete 
INTEG_328 PARTCOST.PARTID PART.ID Restrict delete 
INTEG_33 PART.ADJUSTMENTACCOUNTID ASACCOUNT.ID Restrict delete 
INTEG_338 TAG.PARTID PART.ID Restrict delete 
INTEG_34 PART.VARIANCEACCOUNTID ASACCOUNT.ID Restrict delete 
INTEG_340 TAG.LOCATIONID LOCATION.ID Restrict delete 
INTEG_342 TRACKINGDATE.TAGID TAG.ID Restrict delete 
INTEG_347 TRACKINGINFOSN.TRACKINGINFOID TRACKINGINFO.ID Restrict delete 
INTEG_349 TRACKINGINFOSN.PARTTRACKINGID PARTTRACKING.ID Restrict delete 
INTEG_35 PART.SCRAPACCOUNTID ASACCOUNT.ID Restrict delete 
INTEG_355 TIINVENTORYLOGSN.TIINVENTORYLOGID TIINVENTORYLOG.ID Restrict delete 
INTEG_356 PRODUCT.PARTID PART.ID Restrict delete 
INTEG_359 PRODUCT.INCOMEACCOUNTID ASACCOUNT.ID Restrict delete 
INTEG_363 COMPANY.ACCOUNTID ACCOUNT.ID Restrict delete 
INTEG_365 COMPANY.DEFAULTCARRIERID CARRIER.ID Restrict delete 
INTEG_371 VENDOR.ACCOUNTID ACCOUNT.ID Restrict delete 
INTEG_373 VENDOR.STATUSID VENDORSTATUS.ID Restrict delete 
INTEG_375 VENDOR.DEFAULTPAYMENTTERMSID PAYMENTTERMS.ID Restrict delete 
INTEG_377 VENDOR.DEFAULTSHIPTERMSID SHIPTERMS.ID Restrict delete 
INTEG_379 VENDOR.DEFAULTCARRIERID CARRIER.ID Restrict delete 
INTEG_387 TAXRATE.VENDORID VENDOR.ID Restrict delete 
INTEG_391 CUSTOMER.ACCOUNTID ACCOUNT.ID Restrict delete 
INTEG_393 CUSTOMER.STATUSID CUSTOMERSTATUS.ID Restrict delete 
INTEG_395 CUSTOMER.DEFAULTPAYMENTTERMSID PAYMENTTERMS.ID Restrict delete 
INTEG_397 CUSTOMER.DEFAULTSHIPTERMSID SHIPTERMS.ID Restrict delete 
INTEG_4 CUSTOMVARCHARLONG.CUSTOMFIELDID CUSTOMFIELD.ID Restrict delete 
INTEG_400 CUSTOMER.TAXRATEID TAXRATE.ID Restrict delete 
INTEG_402 TIINVENTORYLOGSN.PARTTRACKINGID PARTTRACKING.ID Restrict delete 
INTEG_404 TAG.ACCOUNTID ACCOUNT.ID Restrict delete 
INTEG_406 TIINVENTORYLOG.PARTTRACKINGID PARTTRACKING.ID Restrict delete 
INTEG_411 VENDORPARTS.PARTID PART.ID Restrict delete 
INTEG_413 VENDORPARTS.VENDORID VENDOR.ID Restrict delete 
INTEG_416 VENDORPARTS.UOMID UOM.ID Restrict delete 
INTEG_420 CONTACT.ACCOUNTID ACCOUNT.ID Restrict delete 
INTEG_422 CONTACT.TYPEID CONTACTTYPE.ID Restrict delete 
INTEG_426 PO.CARRIERID CARRIER.ID Restrict delete 
INTEG_428 PO.FOBPOINTID FOBPOINT.ID Restrict delete 
INTEG_430 PO.PAYMENTTERMSID PAYMENTTERMS.ID Restrict delete 
INTEG_432 PO.SHIPTERMSID SHIPTERMS.ID Restrict delete 
INTEG_434 PO.TYPEID POTYPE.ID Restrict delete 
INTEG_436 PO.STATUSID POSTATUS.ID Restrict delete 
INTEG_438 PO.VENDORID VENDOR.ID Restrict delete 
INTEG_441 PO.QBCLASSID QBCLASS.ID Restrict delete 
INTEG_443 PO.LOCATIONGROUPID LOCATIONGROUP.ID Restrict delete 
INTEG_449 CALEVENT.LASTCHANGEDUSERID SYSUSER.ID Restrict delete 
INTEG_45 CUSTOMER.DEFAULTCARRIERID CARRIER.ID Restrict delete 
INTEG_453 SO.STATUSID SOSTATUS.ID Restrict delete 
INTEG_455 SO.FOBPOINTID FOBPOINT.ID Restrict delete 
INTEG_457 SO.PAYMENTTERMSID PAYMENTTERMS.ID Restrict delete 
INTEG_459 SO.TYPEID SOTYPE.ID Restrict delete 
INTEG_46 PRODUCT.QBCLASSID QBCLASS.ID Restrict delete 
INTEG_461 SO.CUSTOMERID CUSTOMER.ID Restrict delete 
INTEG_464 SO.TAXRATEID TAXRATE.ID Restrict delete 
INTEG_465 SO.QBCLASSID QBCLASS.ID Restrict delete 
INTEG_467 SO.LOCATIONGROUPID LOCATIONGROUP.ID Restrict delete 
INTEG_471 POSTRANSACTION.SOID SO.ID Restrict delete 
INTEG_473 POSTRANSACTION.PAYMENTMETHODID PAYMENTMETHOD.ID Restrict delete 
INTEG_474 POSTRANSACTION.DEPOSITTOACCOUNTID ASACCOUNT.ID Restrict delete 
INTEG_477 POITEM.PARTID PART.ID Restrict delete 
INTEG_479 POITEM.POID PO.ID Restrict delete 
INTEG_481 POITEM.TYPEID POITEMTYPE.ID Restrict delete 
INTEG_483 POITEM.STATUSID POITEMSTATUS.ID Restrict delete 
INTEG_484 POITEM.UOMID UOM.ID Restrict delete 
INTEG_489 POITEM.QBCLASSID QBCLASS.ID Restrict delete 
INTEG_492 SOITEM.PRODUCTID PRODUCT.ID Restrict delete 
INTEG_494 SOITEM.SOID SO.ID Restrict delete 
INTEG_496 SOITEM.TYPEID SOITEMTYPE.ID Restrict delete 
INTEG_498 SOITEM.STATUSID SOITEMSTATUS.ID Restrict delete 
INTEG_499 SOITEM.UOMID UOM.ID Restrict delete 
INTEG_503 SOITEM.QBCLASSID QBCLASS.ID Restrict delete 
INTEG_507 SHIP.ORDERTYPEID ORDERTYPE.ID Restrict delete 
INTEG_509 SHIP.CARRIERID CARRIER.ID Restrict delete 
INTEG_511 SHIP.FOBPOINTID FOBPOINT.ID Restrict delete 
INTEG_513 SHIP.STATUSID SHIPSTATUS.ID Restrict delete 
INTEG_517 SHIPCARTON.SHIPID SHIP.ID Restrict delete 
INTEG_519 SHIPCARTON.CARRIERID CARRIER.ID Restrict delete 
INTEG_522 SHIPCARTON.ORDERTYPEID ORDERTYPE.ID Restrict delete 
INTEG_526 SHIPITEM.SHIPID SHIP.ID Restrict delete 
INTEG_528 SHIPITEM.ORDERTYPEID ORDERTYPE.ID Restrict delete 
INTEG_530 SHIPITEM.UOMID UOM.ID Restrict delete 
INTEG_531 TRACKINGINFO.PARTTRACKINGID PARTTRACKING.ID Restrict delete 
INTEG_533 SERIAL.TAGID TAG.ID Restrict delete 
INTEG_535 VENDORPARTS.USERID SYSUSER.ID Restrict delete 
INTEG_544 USERLOG.USERID SYSUSER.ID Restrict delete 
INTEG_545 PICKITEM.TYPEID PICKITEMTYPE.ID Restrict delete 
INTEG_559 ITEMADJUST.TYPEID ITEMADJUSTTYPE.ID Restrict delete 
INTEG_569 BOM.AUTOCREATETYPEID BOMAUTOCREATETYPE.ID Restrict delete 
INTEG_571 BOM.USERID SYSUSER.ID Restrict delete 
INTEG_575 BOMTOLOCATION.BOMID BOM.ID Restrict delete 
INTEG_577 BOMTOLOCATION.LOCATIONID LOCATION.ID Restrict delete 
INTEG_579 BOMTOLOCATION.LOCATIONGROUPID LOCATIONGROUP.ID Restrict delete 
INTEG_583 BOMITEMGROUP.BOMID BOM.ID Restrict delete 
INTEG_590 BOMITEM.BOMID BOM.ID Restrict delete 
INTEG_592 BOMITEM.TYPEID BOMITEMTYPE.ID Restrict delete 
INTEG_593 BOMITEM.PARTID PART.ID Restrict delete 
INTEG_595 BOMITEM.UOMID UOM.ID Restrict delete 
INTEG_599 BOMITEM.BOMITEMGROUPID BOMITEMGROUP.ID Restrict delete 
INTEG_603 BOMITEMTOLOCATION.BOMITEMID BOMITEM.ID Restrict delete 
INTEG_605 BOMITEMTOLOCATION.LOCATIONID LOCATION.ID Restrict delete 
INTEG_607 BOMITEMTOLOCATION.LOCATIONGROUPID LOCATIONGROUP.ID Restrict delete 
INTEG_620 USERTOLG.USERID SYSUSER.ID Restrict delete 
INTEG_621 USERTOLG.LOCATIONGROUPID LOCATIONGROUP.ID Restrict delete 
INTEG_630 USERGROUPREL.USERID SYSUSER.ID Restrict delete 
INTEG_632 USERGROUPREL.GROUPID USERGROUP.ID Restrict delete 
INTEG_637 USERACCESS.GROUPID USERGROUP.ID Restrict delete 
INTEG_644 MO.STATUSID MOSTATUS.ID Restrict delete 
INTEG_656 WATCH.SYSUSERID SYSUSER.ID Restrict delete 
INTEG_658 WATCH.TYPEID WATCHTYPE.ID Restrict delete 
INTEG_664 WATCH.LOCATIONGROUPID LOCATIONGROUP.ID Restrict delete 
INTEG_665 WATCH.LGSUMTYPEID LGSUMTYPE.ID Restrict delete 
INTEG_666 MO.LOCATIONGROUPID LOCATIONGROUP.ID Restrict delete 
INTEG_668 MO.USERID SYSUSER.ID Restrict delete 
INTEG_669 MO.QBCLASSID QBCLASS.ID Restrict delete 
INTEG_677 MOITEM.MOID MO.ID Restrict delete 
INTEG_678 MOITEM.PARENTID MOITEM.ID Restrict delete 
INTEG_679 MOITEM.PARTID PART.ID Restrict delete 
INTEG_680 MOITEM.BOMID BOM.ID Restrict delete 
INTEG_681 MOITEM.BOMITEMID BOMITEM.ID Restrict delete 
INTEG_683 MOITEM.TYPEID BOMITEMTYPE.ID Restrict delete 
INTEG_685 MOITEM.STATUSID MOITEMSTATUS.ID Restrict delete 
INTEG_686 MOITEM.UOMID UOM.ID Restrict delete 
INTEG_689 MOITEM.QBCLASSID QBCLASS.ID Restrict delete 
INTEG_693 SOITEMTOMOITEM.SOITEMID SOITEM.ID Restrict delete 
INTEG_705 POST.STATUSID POSTSTATUS.ID Restrict delete 
INTEG_707 POST.ORDERTYPEID ORDERTYPE.ID Restrict delete 
INTEG_709 POST.TYPEID POSTTYPE.ID Restrict delete 
INTEG_713 QUICKLIST.CUSTOMERID CUSTOMER.ID Restrict delete 
INTEG_718 QUICKLISTITEM.QLISTID QUICKLIST.ID Restrict delete 
INTEG_720 QUICKLISTITEM.PRODUCTID PRODUCT.ID Restrict delete 
INTEG_731 WO.MOITEMID MOITEM.ID Restrict delete 
INTEG_733 WO.STATUSID WOSTATUS.ID Restrict delete 
INTEG_735 WO.USERID SYSUSER.ID Restrict delete 
INTEG_736 WO.LOCATIONGROUPID LOCATIONGROUP.ID Restrict delete 
INTEG_737 WO.LOCATIONID LOCATION.ID Restrict delete 
INTEG_738 WO.QBCLASSID QBCLASS.ID Restrict delete 
INTEG_742 WOASSIGNEDUSERS.WOID WO.ID Restrict delete 
INTEG_744 WOASSIGNEDUSERS.USERID SYSUSER.ID Restrict delete 
INTEG_748 WOITEM.WOID WO.ID Restrict delete 
INTEG_750 WOITEM.MOITEMID MOITEM.ID Restrict delete 
INTEG_751 WOITEM.TYPEID BOMITEMTYPE.ID Restrict delete 
INTEG_752 WOITEM.PARTID PART.ID Restrict delete 
INTEG_756 WOITEM.UOMID UOM.ID Restrict delete 
INTEG_765 POSTWO.WOID WO.ID Restrict delete 
INTEG_767 POSTWO.STATUSID POSTORDERSTATUS.ID Restrict delete 
INTEG_772 POSTWOITEM.POSTWOID POSTWO.ID Restrict delete 
INTEG_773 POSTWOITEM.WOITEMID WOITEM.ID Restrict delete 
INTEG_775 PART.DEFAULTBOMID BOM.ID Restrict delete 
INTEG_776 TAG.WOITEMID WOITEM.ID Restrict delete 
INTEG_777 MO.SOID SO.ID Restrict delete 
INTEG_778 CUSTOMER.PARENTID CUSTOMER.ID Restrict delete 
INTEG_779 POITEM.CUSTOMERID CUSTOMER.ID Restrict delete 
INTEG_780 RECEIPTITEM.CUSTOMERID CUSTOMER.ID Restrict delete 
INTEG_781 POST.CUSTOMERID CUSTOMER.ID Restrict delete 
INTEG_782 WO.CUSTOMERID CUSTOMER.ID Restrict delete 
INTEG_792 VENDORCOSTRULE.PARTID PART.ID Restrict delete 
INTEG_798 VENDORCOSTRULE.VENDORID VENDOR.ID Restrict delete 
INTEG_800 VENDORCOSTRULE.USERID SYSUSER.ID Restrict delete 
INTEG_802 ADDRESS.LOCATIONGROUPID LOCATIONGROUP.ID Restrict delete 
INTEG_804 SO.SHIPTERMSID SHIPTERMS.ID Restrict delete 
INTEG_805 SO.CARRIERID CARRIER.ID Restrict delete 
INTEG_806 RECEIPTITEM.CARRIERID CARRIER.ID Restrict delete 
INTEG_807 RECEIPTITEM.PARTID PART.ID Restrict delete 
INTEG_808 WATCH.ITEMID PART.ID Restrict delete 
INTEG_818 REPORT.REPORTTREEID REPORTTREE.ID Restrict delete 
INTEG_820 VENDOR.TAXRATEID TAXRATE.ID Restrict delete 
INTEG_826 MODULE.REPORTID REPORT.ID Restrict delete 
INTEG_831 REPORTPARAMETER.REPORTID REPORT.ID Restrict delete 
INTEG_832 PART.SIZEUOMID UOM.ID Restrict delete 
INTEG_833 PRODUCT.SIZEUOMID UOM.ID Restrict delete 
INTEG_834 PRODUCT.WEIGHTUOMID UOM.ID Restrict delete 
INTEG_836 PRODUCT.UOMID UOM.ID Restrict delete 
INTEG_843 ASSOCPRICETYPE.ACCOUNTID ASACCOUNT.ID Restrict delete 
INTEG_847 ASSOCPRICE.PRODUCTID PRODUCT.ID Restrict delete 
INTEG_849 ASSOCPRICE.ASSOCPRICETYPEID ASSOCPRICETYPE.ID Restrict delete 
INTEG_851 REPORTTOMODULE.REPORTID REPORT.ID Restrict delete 
INTEG_853 REPORTTOMODULE.MODULEID MODULE.ID Restrict delete 
INTEG_857 REPORTSECURITY.REPORTID REPORT.ID Restrict delete 
INTEG_859 REPORTSECURITY.USERGROUPID USERGROUP.ID Restrict delete 
INTEG_861 ITEMADJUST.TAXRATEID TAXRATE.ID Restrict delete 
INTEG_870 INTEGRATIONPROPERTIES.TYPEID INTEGRATIONTYPE.ID Restrict delete 
INTEG_873 SHIP.SHIPPEDBY SYSUSER.ID Restrict delete 
INTEG_881 CALCATEGORY.LASTCHANGEDUSERID SYSUSER.ID Restrict delete 
INTEG_884 SHIP.UPSSERVICEID UPSSERVICES.ID Restrict delete 
INTEG_885 CALEVENT.CALCATEGORYID CALCATEGORY.ID Restrict delete 
INTEG_899 SO.UPSSERVICEID UPSSERVICES.ID Restrict delete 
INTEG_900 CUSTOMER.DEFAULTSHIPSERVICEID UPSSERVICES.ID Restrict delete 
INTEG_903 TAXRATE.ORDERTYPEID ORDERTYPE.ID Restrict delete 
INTEG_913 SHIPUPSDETAILS.SHIPID SHIP.ID Restrict delete 
INTEG_915 SHIPUPSDETAILS.PAYMENTTYPE UPSPAYMENTTYPE.ID Restrict delete 
INTEG_916 SHIPUPSDETAILS.STATEID STATECONST.ID Restrict delete 
INTEG_920 SHIPUPSCARTONDETAILS.SHIPCARTONID SHIPCARTON.ID Restrict delete 
INTEG_923 SHIPUPSCARTONDETAILS.CODFUNDS UPSCOD.ID Restrict delete 
INTEG_928 UPSRETURNSHIPMENT.SHIPID SHIP.ID Restrict delete 
INTEG_933 SHIPCARTON.DELIVERYCONFIRMATIONID DCOPTIONS.ID Restrict delete 
INTEG_935 SHIPCARTON.PACKAGETYPEID PACKAGETYPES.ID Restrict delete 
INTEG_942 PAYMENTMETHOD.TYPEID PAYMENTTYPE.ID Restrict delete 
INTEG_945 SO.PRIORITYID PRIORITY.ID Restrict delete 
INTEG_946 MOITEM.PRIORITYID PRIORITY.ID Restrict delete 
INTEG_948 SHIPITEM.SHIPCARTONID SHIPCARTON.ID Restrict delete 
INTEG_958 INTEGRATEDAPP.STATUSID INTEGRATEDAPPSTATUS.ID Restrict delete 
INTEG_978 PICKITEM.STATUSID PICKITEMSTATUS.ID Restrict delete 
INTEG_980 PICKITEM.PICKID PICK.ID Restrict delete 
INTEG_982 PICKITEM.PARTID PART.ID Restrict delete 
INTEG_983 WO.PRIORITYID PRIORITY.ID Restrict delete 
INTEG_985 PICKITEM.UOMID UOM.ID Restrict delete 
INTEG_987 PICKITEM.ORDERTYPEID ORDERTYPE.ID Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected