EFACS Browser

Read-only structure and broad data-source overview from efacdb_full.
This screen must never write to EFACS. Hide/show preferences are stored locally in Monolith only; the EFACS data and structure are not changed.
Objects
438
Showing
32
Hidden by default/rule
228
Database
efacdb_full
Reset

Tables and Views

Schema-first broad sweep; open a table for columns/indexes/status counts.
ObjectCategoryRows est.SizeUpdatedNotesVisibility
orderitems_composite
BASE TABLE · InnoDB
Live EFACS mirror678,286380.98 MB2026-06-08 13:17:52Current order lines. Join to orders by orderid and ordertype.
shipmentitems
BASE TABLE · InnoDB
Live EFACS mirror533,840375.33 MB2026-06-04 15:32:45-
bom
BASE TABLE · InnoDB
Live EFACS mirror635,264160.33 MB2026-06-08 12:32:13Raw EFACS BOM rows. Use cautiously where multiple methods/old rows exist.
allpartmaster
BASE TABLE · InnoDB
Live EFACS mirror84,973101.69 MB2026-06-08 12:47:02Part master: descriptions, dimensions, costing flags, pricing fields and part metadata.
stocktransactions
BASE TABLE · InnoDB
Live EFACS mirror144,29196.75 MB2026-06-04 14:42:32-
worksorders_composite
BASE TABLE · InnoDB
Live EFACS mirror255,97791.64 MB2026-06-08 13:17:34-
bom_tabletouse
BASE TABLE · InnoDB
Live EFACS mirror384,61977.70 MB2026-05-17 12:58:57Materialised current BOM-style table. Useful where view performance is poor.
orders_composite
BASE TABLE · InnoDB
Live EFACS mirror216,59069.63 MB2026-06-08 13:17:40Current order headers across order types such as SO, PO, QU and PR.
stockbatches
BASE TABLE · InnoDB
Live EFACS mirror9,48269.44 MB2026-06-08 13:17:29-
shipments
BASE TABLE · InnoDB
Live EFACS mirror242,03466.67 MB2026-06-08 13:02:30-
routingoperations
BASE TABLE · InnoDB
Live EFACS mirror97,61058.66 MB2026-06-08 10:17:52Raw routing operations by part, method and operation number.
routings_tabletouse
BASE TABLE · InnoDB
Live EFACS mirror95,77430.56 MB--
invoiceitems
BASE TABLE · InnoDB
Live EFACS mirror48,93726.09 MB2026-06-04 14:43:06-
shipmentitems_composite
BASE TABLE · InnoDB
Live EFACS mirror22,83125.19 MB2026-06-04 14:43:06-
partrevisions
BASE TABLE · InnoDB
Live EFACS mirror114,12525.13 MB2026-06-08 12:47:11Part revision and allowed-operation settings.
stockedparts
BASE TABLE · InnoDB
Live EFACS mirror37,03113.03 MB2026-06-04 14:42:32-
bommethods
BASE TABLE · InnoDB
Live EFACS mirror124,73310.52 MB2026-06-08 12:47:05-
wip
BASE TABLE · InnoDB
Live EFACS mirror29,51010.03 MB2026-06-04 14:42:32-
tradersaddresses
BASE TABLE · InnoDB
Live EFACS mirror9,2727.63 MB2026-06-04 14:42:32Trader addresses with invoice/delivery/main-address flags.
routingmethods
BASE TABLE · InnoDB
Live EFACS mirror92,5706.52 MB2026-06-08 10:17:49-
invoices
BASE TABLE · InnoDB
Live EFACS mirror11,3224.31 MB2026-06-04 14:41:58-
traders
BASE TABLE · InnoDB
Live EFACS mirror7,5683.67 MB2026-06-08 12:49:51Customers and suppliers. tradertype C = customer, S = supplier.
emediadetails
BASE TABLE · InnoDB
Live EFACS mirror1,2821.63 MB2026-06-04 14:41:58-
drawing_files
BASE TABLE · InnoDB
Live EFACS mirror14,6621.52 MB-Drawing number to file-name mapping used by part image/CAD lookup tools.
traderscontacts
BASE TABLE · InnoDB
Live EFACS mirror2,2300.92 MB2026-06-04 14:42:32Named contacts for customers/suppliers.
contactcommunications
BASE TABLE · InnoDB
Live EFACS mirror1,6460.52 MB2026-05-29 07:38:54Email, phone and other communication destinations for trader contacts.
contracts
BASE TABLE · InnoDB
Live EFACS mirror4550.23 MB2026-05-07 10:01:16Contract headers and commercial contract metadata.
customer_custom
BASE TABLE · InnoDB
Live EFACS mirror7720.13 MB2026-06-01 15:50:16Customer-specific EFACS extension fields.
proformas
BASE TABLE · InnoDB
Live EFACS mirror2540.09 MB2026-06-04 14:41:58-
machines
BASE TABLE · InnoDB
Live EFACS mirror950.08 MB2026-03-19 20:51:55-
ynlook
BASE TABLE · InnoDB
Live EFACS mirror3580.06 MB--
stocklocations
BASE TABLE · InnoDB
Live EFACS mirror1470.05 MB2026-05-20 06:20:46-