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

Hidden by default/rule

228

Database

efacdb_full

Tables and Views

Schema-first broad sweep; open a table for columns/indexes/status counts.

Object	Category	Updated	Notes
bom_TEMP_distinctrowsonly VIEW	Live/compatibility views	-	-
bom_viewtouse VIEW	Live/compatibility views	-	Current BOM view generated from the raw BOM. Prefer for user-facing current BOM lookups.
orderitems VIEW	Live/compatibility views	-	-
orderitems_compositeview VIEW	Live/compatibility views	-	-
orders VIEW	Live/compatibility views	-	-
orders_compositeview VIEW	Live/compatibility views	-	-
routings_viewtouse VIEW	Live/compatibility views	-	Current routing view. Prefer for user-facing current routing lookups.
worksorders VIEW	Live/compatibility views	-	-
worksorders_compositeview VIEW	Live/compatibility views	-	-
zCMP_workings_RecentNettpriceFromEfacs_view VIEW	Live/compatibility views	-	-
zCSA_bounds_5y VIEW	Live/compatibility views	-	-
zCSA_part_5y VIEW	Live/compatibility views	-	-

Category	Objects	MB
Live EFACS mirror	32	1716.7
Live/compatibility views	12	0.0
Useful derived outputs	6	291.7
Custom/model/helper tables	158	3617.5
Source/staging extracts	12	13.8
Backups, snapshots and deleted-row stores	203	3293.2
App/admin miscellany	13	34.0
Unclassified	2	191.3

traders.id + traders.tradertype -> orders/invoices/shipments traderid + tradertype

Customers and suppliers both live in traders. C = customer, S = supplier.

traders -> tradersaddresses

Addresses are keyed by traderid, tradertype and addressid with invoice/delivery/main flags.

traderscontacts -> contactcommunications

Email and phone values are stored as communication method rows, not fixed columns.

allpartmaster.partnum -> bom/bom_viewtouse bomparent and bomchild

Part master to BOM parent/child relationships.

allpartmaster.partnum -> routingoperations.partid

Part master to routing operations.

orders_composite.id + ordertype -> orderitems_composite.orderid + ordertype

Order headers to order lines.

invoices.id + invoicetype -> invoiceitems.invoiceid + invoicetype

Invoice headers to invoice lines.

shipments.id + shipmenttype -> shipmentitems.shipmentid + shipmenttype

Shipment headers to shipment lines.