Please enable JavaScript.
Coggle requires JavaScript to display documents.
Link ERP DB Dependencies, Move to Link MONitor, Move to SystemConfig…
Link ERP DB Dependencies
Move to Link MONitor
WorkCenters (sync)
PartsMade
WorkCenterMonitor
WorkCenterMetrics
ShopOpUser
MachineRunTimes
Users (sync)
Operations (sync)
Move to SystemConfig (Lists)
ShopOpTypes
ShipTypes
Schema_Version
SalesOrderTypes
PurchaseOrderTypes
MaterialCategories
DocumentCategories
InventoryAllocation
UserDelete
ScrapStatus
Partial
Reject
Shipping
Assembly
Stock
Unused Tables :
EstimateQBOperations
Customer Data
Customers POC
Production Log
EngineeringProjects
AuditLog
Large Tables
Documents
move customer PO to document repository
CityPostal
eval api services
WorkCenterMetrics
summarize & purge / moved to monitor system
MailerHistory
accrualsview & Accruals
ShipmentPackingList:PackingListID
Shipments:ID
InventoryAllocations:PullID
Inventory:InventoryID
ShopOrders:ShopOrderID
ShopOrderOperations:ShopOPID
WorkCenters:WorkCenterID
WorkCentersRate:WCRateID
EstimateOperations:OperationID
PurchaseOrdersLI:ID
PurchaseOrders:POID
VendorTbl:VendorID
VendorPOC:ID
VendorAddress:ID
PurchaseRequest:RequestID
EstimateMaterial:MaterialID
EstimateMaterialQB:MaterialQBID
EstimateOperations:OperationID
EstimateOperationsQB
PurchaseOrdersReceival:ID
ItemList:ItemID
SalesOrdersLI:SalesLIID
Customers:CustomerID
Estimate:EstimateID
Customers:CustomerID
ItemList:ItemID
EstimateChildParts:ChildID
EstimateMaterial
EstimateAdditionalCosts:ACID
CustomerAdresses:ID
EstimateOperations:OperationID
EstimateQuantityBreaks:QBID
SalesOrdersLI (as Parent)
SalesOrders:SalesID
CustomerAddresses:ID
SalesOrdersAdditionalCosts:ACID
CustomerPOC:CustomerPOCID
relationship with IA is backward: using IA.TempShipID
ShipmentPayments
a.k.a Invoice/Receivables
Other thoughts:
move all companies to single table
move all addresses to single table
move all persons to single table