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
210
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
zAR-BIP-model-step-runs
BASE TABLE · InnoDB
Custom/model/helper tables172433.05 MB2026-05-28 18:07:16-
orderitems_composite
BASE TABLE · InnoDB
Live EFACS mirror678,270380.98 MB2026-06-08 11:32:23Current order lines. Join to orders by orderid and ordertype.
shipmentitems
BASE TABLE · InnoDB
Live EFACS mirror533,840375.33 MB2026-06-04 15:32:45-
zCRT_retained_CalcCostHistory
BASE TABLE · InnoDB
Custom/model/helper tables934,006253.70 MB2026-04-03 14:25:29-
zCRU_BOM_Flat
BASE TABLE · InnoDB
Useful derived outputs2,240,169221.30 MB2026-04-03 13:51:11Derived flattened BOM for fast where-used/explosion queries.
bom
BASE TABLE · InnoDB
Live EFACS mirror635,262160.33 MB2026-06-08 09:55:29Raw EFACS BOM rows. Use cautiously where multiple methods/old rows exist.
zAR-BIP-model-step-events
BASE TABLE · InnoDB
Custom/model/helper tables257,178137.80 MB2026-05-28 18:07:16-
allpartmaster
BASE TABLE · InnoDB
Live EFACS mirror84,973101.69 MB2026-06-08 10:17:40Part master: descriptions, dimensions, costing flags, pricing fields and part metadata.
bom_incSK
BASE TABLE · InnoDB
Unclassified656,34799.64 MB--
stocktransactions
BASE TABLE · InnoDB
Live EFACS mirror144,29196.75 MB2026-06-04 14:42:32-
allpartmaster_incSK
BASE TABLE · InnoDB
Unclassified87,75691.66 MB--
worksorders_composite
BASE TABLE · InnoDB
Live EFACS mirror255,97691.64 MB2026-06-08 11:32:06-
zAR-BIP-template-steps
BASE TABLE · InnoDB
Custom/model/helper tables539,43084.17 MB2026-05-17 16:31:47-
zAR-BIP-paramset-bom
BASE TABLE · InnoDB
Custom/model/helper tables380,90779.13 MB2026-05-17 16:30:10-
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,58569.63 MB2026-06-08 11:47:08Current order headers across order types such as SO, PO, QU and PR.
stockbatches
BASE TABLE · InnoDB
Live EFACS mirror9,47369.44 MB2026-06-08 11:17:08-
shipments
BASE TABLE · InnoDB
Live EFACS mirror242,03166.67 MB2026-06-08 11:17:41-
routingoperations
BASE TABLE · InnoDB
Live EFACS mirror97,61058.66 MB2026-06-08 10:17:52Raw routing operations by part, method and operation number.
zBSC_inputs_BOM
BASE TABLE · InnoDB
Custom/model/helper tables382,09248.59 MB--
zCRU_PartWorkcentres
BASE TABLE · InnoDB
Custom/model/helper tables213,61337.61 MB2026-04-03 13:50:28-
ztmpCostrollupCleanbom
BASE TABLE · InnoDB
Custom/model/helper tables385,82537.59 MB--
zAR-BIP-paramset-routings
BASE TABLE · InnoDB
Custom/model/helper tables95,38532.08 MB2026-05-17 16:30:10-
zAR-BIP-model-run-purchases
BASE TABLE · InnoDB
Custom/model/helper tables166,79731.84 MB2026-05-20 07:36:37-
zCRU_CleanBOM
BASE TABLE · InnoDB
Custom/model/helper tables360,66931.58 MB--
routings_tabletouse
BASE TABLE · InnoDB
Live EFACS mirror95,77430.56 MB--
zCRU_PartWorkcentreSummary
BASE TABLE · InnoDB
Custom/model/helper tables289,44330.06 MB2026-04-03 13:52:16-
zCRU_output_CleanBOM_ExPhantom
BASE TABLE · InnoDB
Custom/model/helper tables442,96426.58 MB--
zBSC_workings_02_stepcosts
BASE TABLE · InnoDB
Custom/model/helper tables96,00226.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 10:17:57Part revision and allowed-operation settings.
zCRT_retained_FinalApiPriceSnapshot
BASE TABLE · InnoDB
Useful derived outputs92,93221.66 MB2026-04-03 14:55:20-
zCRU_CostRollup
BASE TABLE · InnoDB
Useful derived outputs92,62020.06 MB2026-04-03 13:52:14Derived rolled-up part costing output. Not raw EFACS source data.
zCRU_CostRollup_20251101
BASE TABLE · InnoDB
Custom/model/helper tables92,08920.06 MB--
zefacs_part_family_flags
BASE TABLE · InnoDB
Useful derived outputs67,91618.06 MB2026-03-25 16:30:33-
ztmpCostrollupParts
BASE TABLE · InnoDB
Custom/model/helper tables91,91317.55 MB--
zCRU_Rollup
BASE TABLE · InnoDB
Custom/model/helper tables92,66016.03 MB2026-04-03 13:52:10-
zBSC_inputs_Parts
BASE TABLE · InnoDB
Custom/model/helper tables91,91915.03 MB--
zAR-BIP-stateset-stockedparts
BASE TABLE · InnoDB
Custom/model/helper tables35,84914.08 MB2026-05-17 16:31:08-
stockedparts
BASE TABLE · InnoDB
Live EFACS mirror37,03113.03 MB2026-06-04 14:42:32-
zCSA_order_prices
BASE TABLE · InnoDB
Custom/model/helper tables36,00312.58 MB--
zCMP_CostRollup_toMatchCRU
BASE TABLE · InnoDB
Custom/model/helper tables92,71712.55 MB2026-04-03 14:26:44-
zBSC_workings_01_demand
BASE TABLE · InnoDB
Custom/model/helper tables82,31912.52 MB--
zBSC_inputs_Routing
BASE TABLE · InnoDB
Custom/model/helper tables95,44512.03 MB--
bommethods
BASE TABLE · InnoDB
Live EFACS mirror124,73010.52 MB2026-06-08 10:17:44-
zCMP_output_PricesForAPI
BASE TABLE · InnoDB
Useful derived outputs93,14610.52 MB2026-04-03 14:26:47Derived price output used by pricing tools. Not raw EFACS source data.
zCRT_output_PricesForAPI
BASE TABLE · InnoDB
Custom/model/helper tables92,96310.52 MB2026-04-03 14:25:41-
ztmpCostrollupRoutings
BASE TABLE · InnoDB
Custom/model/helper tables98,86010.52 MB--
wip
BASE TABLE · InnoDB
Live EFACS mirror29,51010.03 MB2026-06-04 14:42:32-
zAR-BIP-template-headers
BASE TABLE · InnoDB
Custom/model/helper tables69,64210.03 MB2026-05-17 16:31:47-
zCRU_RoutingUnit
BASE TABLE · InnoDB
Custom/model/helper tables90,65510.03 MB2026-04-03 13:49:45-
zCRU_RoutingUnitCapped
BASE TABLE · InnoDB
Custom/model/helper tables90,51310.03 MB2026-04-03 13:49:47-
zCMP_output_PricesForAPI_20251203
BASE TABLE · InnoDB
Custom/model/helper tables92,6559.52 MB--
zCRT_outputs_CurrentCleanCost
BASE TABLE · InnoDB
Custom/model/helper tables93,3729.03 MB2026-04-03 14:25:31-
zAR-BIP-model-run-stock-movements
BASE TABLE · InnoDB
Custom/model/helper tables29,1678.55 MB2026-05-20 07:31:10-
zCRU_Parts
BASE TABLE · InnoDB
Custom/model/helper tables93,6588.52 MB2026-04-03 13:50:32-
tradersaddresses
BASE TABLE · InnoDB
Live EFACS mirror9,2727.63 MB2026-06-04 14:42:32Trader addresses with invoice/delivery/main-address flags.
zBSC_workings_rtg_agg
BASE TABLE · InnoDB
Custom/model/helper tables58,8587.52 MB--
zCRU_PartOwnStepCost
BASE TABLE · InnoDB
Custom/model/helper tables93,0067.52 MB--
routingmethods
BASE TABLE · InnoDB
Live EFACS mirror92,5706.52 MB2026-06-08 10:17:49-
zCMP_output_ExtensiontoCRU
BASE TABLE · InnoDB
Custom/model/helper tables93,5186.52 MB--
zCRU_PartChecks
BASE TABLE · InnoDB
Custom/model/helper tables92,8916.52 MB--
zCRU_output_CleanRouting_ExPhantom
BASE TABLE · InnoDB
Custom/model/helper tables89,7666.52 MB--
zAR-BIP-model-run-demand-orders
BASE TABLE · InnoDB
Custom/model/helper tables16,5576.11 MB--
zHCAssembly_Parts
BASE TABLE · InnoDB
Custom/model/helper tables1,2245.70 MB2026-06-06 21:58:18-
zBSC_results_summary
BASE TABLE · InnoDB
Custom/model/helper tables92,4175.52 MB--
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:02:58Customers and suppliers. tradertype C = customer, S = supplier.
zCMP_inputs_YearOfOrderItems
BASE TABLE · InnoDB
Custom/model/helper tables36,6113.52 MB2026-04-03 14:25:49-
zCRU_PartStepRoutingCost
BASE TABLE · InnoDB
Custom/model/helper tables58,5633.52 MB--
zHCK_classifyAsUsedOrShipped
BASE TABLE · InnoDB
Custom/model/helper tables53,4553.52 MB--
zHCK_monthlyTally_ByRawPart
BASE TABLE · InnoDB
Custom/model/helper tables19,5853.52 MB--
zAR-BIP-model-run-completions
BASE TABLE · InnoDB
Custom/model/helper tables5,1622.63 MB2026-05-20 07:31:10-
zAR-BIP-paramset-orderitems
BASE TABLE · InnoDB
Custom/model/helper tables3,7212.63 MB2026-05-17 16:30:10-
zCMP_workings_YearOfOrderItems_WithPeriod
BASE TABLE · InnoDB
Custom/model/helper tables24,3472.52 MB2026-04-03 14:25:49-
zt2
BASE TABLE · InnoDB
Custom/model/helper tables68,7752.52 MB--
zAR-BIP-stateset-stock-by-location
BASE TABLE · InnoDB
Custom/model/helper tables8,8652.22 MB2026-05-17 16:31:08-
emediadetails
BASE TABLE · InnoDB
Live EFACS mirror1,2821.63 MB2026-06-04 14:41:58-
zAR-BIP-stateset-orderitems
BASE TABLE · InnoDB
Custom/model/helper tables9251.59 MB2026-05-17 16:31:08-
zAR-BIP-stateset-purchase-orderitems
BASE TABLE · InnoDB
Custom/model/helper tables8711.56 MB2026-05-17 17:09:07-
drawing_files
BASE TABLE · InnoDB
Live EFACS mirror14,6621.52 MB-Drawing number to file-name mapping used by part image/CAD lookup tools.
zCMP_results_AllForecasts
BASE TABLE · InnoDB
Custom/model/helper tables6,1601.52 MB2026-04-03 14:25:50-
zCMP_results_ExtrapolateFromLast
BASE TABLE · InnoDB
Custom/model/helper tables5,9841.52 MB2026-04-03 14:25:50-
zCMP_results_ExtrapolateFromLine
BASE TABLE · InnoDB
Custom/model/helper tables6,0621.52 MB2026-04-03 14:25:50-
zCMP_results_PurchaseCostLimits
BASE TABLE · InnoDB
Custom/model/helper tables5,7271.52 MB2026-04-03 14:25:50-
zCMP_workings_LinearRegression
BASE TABLE · InnoDB
Custom/model/helper tables6,1631.52 MB2026-04-03 14:25:50-
zCMP_workings_MonthsSinceOrder
BASE TABLE · InnoDB
Custom/model/helper tables13,5581.52 MB2026-04-03 14:26:26-
zCMP_workings_YearOfOrderItems_Averages
BASE TABLE · InnoDB
Custom/model/helper tables6,0071.52 MB2026-04-03 14:25:49-
zHCK_classificationofsteps
BASE TABLE · InnoDB
Custom/model/helper tables12,4161.52 MB--
zt3
BASE TABLE · InnoDB
Custom/model/helper tables11,3031.52 MB--
zAR-BIP-stateset-wo-stocktransactions-summary
BASE TABLE · InnoDB
Custom/model/helper tables2,2621.28 MB2026-05-17 16:31:08-
zAR-BIP-stateset-wip
BASE TABLE · InnoDB
Custom/model/helper tables1,2821.17 MB2026-05-17 16:31:08-
traderscontacts
BASE TABLE · InnoDB
Live EFACS mirror2,2300.92 MB2026-06-04 14:42:32Named contacts for customers/suppliers.
zCRT_inputs_VolumeSetLines
BASE TABLE · InnoDB
Custom/model/helper tables7,0790.69 MB2026-04-02 21:27:15-
zCRT_inputs_VolumeSetLines_ord
BASE TABLE · InnoDB
Custom/model/helper tables7,0790.69 MB2026-04-02 21:30:40-
zCRT_inputs_VolumeSetLines_ship
BASE TABLE · InnoDB
Custom/model/helper tables7,0790.69 MB2026-04-02 21:31:36-
zAR-BIP-model-run-allocations
BASE TABLE · InnoDB
Custom/model/helper tables1,9740.63 MB2026-05-20 07:31:10-
contactcommunications
BASE TABLE · InnoDB
Live EFACS mirror1,6460.52 MB2026-05-29 07:38:54Email, phone and other communication destinations for trader contacts.
zCMP_output_LeadTimesEstimate
BASE TABLE · InnoDB
Custom/model/helper tables6,4400.50 MB--
zAR-BIP-model-run-day-summary
BASE TABLE · InnoDB
Custom/model/helper tables1,5220.45 MB2026-05-20 07:31:10-
zAR-BIP-stateset-worksorders
BASE TABLE · InnoDB
Custom/model/helper tables5500.42 MB2026-05-17 16:31:08-
zFCS_product_stats_latest
BASE TABLE · InnoDB
Custom/model/helper tables3,4460.42 MB--
zCMP_workings_LastTradedPrice
BASE TABLE · InnoDB
Custom/model/helper tables6,0440.36 MB2026-04-03 14:25:50-
zCMP_workings_LastTradedPeriod
BASE TABLE · InnoDB
Custom/model/helper tables6,0950.31 MB2026-04-03 14:25:50-
zAR-BIP-paramset-orders
BASE TABLE · InnoDB
Custom/model/helper tables6970.28 MB--
zHCAssembly_TargetList
BASE TABLE · InnoDB
Custom/model/helper tables30.25 MB2026-06-07 06:53:30-
contracts
BASE TABLE · InnoDB
Live EFACS mirror4550.23 MB2026-05-07 10:01:16Contract headers and commercial contract metadata.
zAR-BIP-stateset-orders
BASE TABLE · InnoDB
Custom/model/helper tables2240.20 MB--
zHKU_AnnualDemandV1
BASE TABLE · InnoDB
Custom/model/helper tables2,1150.19 MB--
zBSC_inputs_Demand
BASE TABLE · InnoDB
Custom/model/helper tables2,2900.17 MB--
zFCS_master_products
BASE TABLE · InnoDB
Custom/model/helper tables3,2830.17 MB--
zCRT_log
BASE TABLE · InnoDB
Custom/model/helper tables4450.16 MB2026-04-03 14:25:46-
customer_custom
BASE TABLE · InnoDB
Live EFACS mirror7720.13 MB2026-06-01 15:50:16Customer-specific EFACS extension fields.
zAR-BIP-stateset-purchase-orders
BASE TABLE · InnoDB
Custom/model/helper tables2250.13 MB--
zAR-HRA-workings-user-audit
BASE TABLE · InnoDB
Custom/model/helper tables940.13 MB2026-05-11 09:48:40-
zCRT_retained_LastAppliedPriceChange
BASE TABLE · InnoDB
Custom/model/helper tables3050.13 MB2026-04-03 14:25:41-
ztmpAnnualDemandModel
BASE TABLE · InnoDB
Custom/model/helper tables1,0390.13 MB--
zAR-BIPI-instance-headers
BASE TABLE · InnoDB
Custom/model/helper tables5690.11 MB2026-05-17 16:31:49-
zBSC_reports_OrphanManufactured
BASE TABLE · InnoDB
Custom/model/helper tables1,4450.11 MB--
zCMP_workings_RecentNettpriceFromEfacs_saved
BASE TABLE · InnoDB
Useful derived outputs1,6970.11 MB--
zCRT_retained_PriceHistory
BASE TABLE · InnoDB
Custom/model/helper tables3050.11 MB2026-04-03 14:25:41-
proformas
BASE TABLE · InnoDB
Live EFACS mirror2540.09 MB2026-06-04 14:41:58-
zCRU_ArbitraryStepCost
BASE TABLE · InnoDB
Custom/model/helper tables1,4730.09 MB2026-04-03 13:50:32-
machines
BASE TABLE · InnoDB
Live EFACS mirror950.08 MB2026-03-19 20:51:55-
zAR-BIP-model-run-week-summary
BASE TABLE · InnoDB
Custom/model/helper tables2110.08 MB2026-05-20 07:31:10-
zAR-HRA-workings-user-profiles
BASE TABLE · InnoDB
Custom/model/helper tables40.08 MB2026-05-11 07:40:21-
zSOE_picklist_uom_learning
BASE TABLE · InnoDB
Custom/model/helper tables1250.08 MB2026-05-26 11:27:05-
ynlook
BASE TABLE · InnoDB
Live EFACS mirror3580.06 MB--
zAR-BIP-model-runs
BASE TABLE · InnoDB
Custom/model/helper tables30.06 MB2026-05-20 07:36:37-
zAR-BIP-paramsets
BASE TABLE · InnoDB
Custom/model/helper tables10.06 MB2026-05-17 16:31:16-
zAR-BIP-statesets
BASE TABLE · InnoDB
Custom/model/helper tables20.06 MB2026-05-17 17:09:07-
zAR-HRA-workings-activity-blocks
BASE TABLE · InnoDB
Custom/model/helper tables50.06 MB2026-05-11 07:47:34-
zAR-HRA-workings-day-change-requests
BASE TABLE · InnoDB
Custom/model/helper tables20.06 MB2026-05-11 09:48:40-
zAR-HRA-workings-holiday-requests
BASE TABLE · InnoDB
Custom/model/helper tables60.06 MB2026-05-11 07:33:13-
zAR_DRR_executions
BASE TABLE · InnoDB
Custom/model/helper tables00.06 MB--
zAR_DRR_procedures
BASE TABLE · InnoDB
Custom/model/helper tables30.06 MB--
zCRT_mgr_Run
BASE TABLE · InnoDB
Custom/model/helper tables300.06 MB2026-04-03 14:25:46-
zHSP_output_pricestoupdate
BASE TABLE · InnoDB
Custom/model/helper tables2840.06 MB--
zPipeline_SP_Log
BASE TABLE · InnoDB
Custom/model/helper tables390.06 MB2026-04-03 14:26:47-
stocklocations
BASE TABLE · InnoDB
Live EFACS mirror1470.05 MB2026-05-20 06:20:46-
zAR-BIP-staffing-set-days
BASE TABLE · InnoDB
Custom/model/helper tables130.05 MB--
zAR-BIP-staffing-sets
BASE TABLE · InnoDB
Custom/model/helper tables10.05 MB--
zAR-HRA-workings-actual-hours-submissions
BASE TABLE · InnoDB
Custom/model/helper tables310.05 MB2026-05-11 07:42:38-
zAR-HRA-workings-hour-entries
BASE TABLE · InnoDB
Custom/model/helper tables00.05 MB--
zAR-HRA-workings-people
BASE TABLE · InnoDB
Custom/model/helper tables30.05 MB2026-05-09 13:07:41-
zAR-HRA-workings-sickness-events
BASE TABLE · InnoDB
Custom/model/helper tables00.05 MB--
zAR-HRA-workings-team-leader-change-requests
BASE TABLE · InnoDB
Custom/model/helper tables40.05 MB2026-05-11 07:40:23-
zAR-HRA-workings-team-links
BASE TABLE · InnoDB
Custom/model/helper tables00.05 MB--
zCRT_inputs_TractrixConfig
BASE TABLE · InnoDB
Custom/model/helper tables00.05 MB--
zCRT_retained_TractrixHistory
BASE TABLE · InnoDB
Custom/model/helper tables00.05 MB--
zCRT_retained_TractrixState
BASE TABLE · InnoDB
Custom/model/helper tables00.05 MB--
zCRT_retained_VolumeSetSummary
BASE TABLE · InnoDB
Custom/model/helper tables60.05 MB2026-04-03 14:25:41-
zCRT_workings_MinSalesFloorTargets_zz_tmp
BASE TABLE · InnoDB
Custom/model/helper tables3030.05 MB--
zCSA_bounds
BASE TABLE · InnoDB
Custom/model/helper tables80.05 MB--
zAR-BIP-labour-capacity-recruitment
BASE TABLE · InnoDB
Custom/model/helper tables00.03 MB--
zAR-BIP-labour-capacity-sets
BASE TABLE · InnoDB
Custom/model/helper tables30.03 MB--
zAR-BIP-labour-capacity-staff
BASE TABLE · InnoDB
Custom/model/helper tables400.03 MB--
zAR-BIP-paramset-stock-by-location
BASE TABLE · InnoDB
Custom/model/helper tables00.03 MB--
zAR-BIP-paramset-wo-stocktransactions-summary
BASE TABLE · InnoDB
Custom/model/helper tables00.03 MB--
zAR-BIP-workcentre-set-items
BASE TABLE · InnoDB
Custom/model/helper tables950.03 MB--
zAR-BIP-workcentre-sets
BASE TABLE · InnoDB
Custom/model/helper tables10.03 MB--
zAR-HRA-workings-admin-leave-events
BASE TABLE · InnoDB
Custom/model/helper tables00.03 MB2026-05-10 10:06:26-
zAR-HRA-workings-user-hour-templates
BASE TABLE · InnoDB
Custom/model/helper tables70.03 MB2026-05-09 20:49:29-
zBIPmodel3_ai_requests
BASE TABLE · InnoDB
Custom/model/helper tables00.03 MB2026-05-29 16:06:51-
zBIPmodel3_instruction_packs
BASE TABLE · InnoDB
Custom/model/helper tables00.03 MB2026-05-29 16:06:51-
zBIPmodel3_model_summaries
BASE TABLE · InnoDB
Custom/model/helper tables00.03 MB--
zCRT_inputs_VolumeSets
BASE TABLE · InnoDB
Custom/model/helper tables60.03 MB2026-04-02 21:27:14-
zCRT_inputs_VolumeSets_ord
BASE TABLE · InnoDB
Custom/model/helper tables60.03 MB2026-04-02 21:30:40-
zCRT_inputs_VolumeSets_ship
BASE TABLE · InnoDB
Custom/model/helper tables60.03 MB2026-04-02 21:31:35-
zAR-BIP-paramset-stockedparts
BASE TABLE · InnoDB
Custom/model/helper tables00.02 MB--
zAR-BIP-paramset-wip
BASE TABLE · InnoDB
Custom/model/helper tables00.02 MB--
zAR-BIP-paramset-worksorders
BASE TABLE · InnoDB
Custom/model/helper tables00.02 MB--
zAR-BIP-workcentre-settings
BASE TABLE · InnoDB
Custom/model/helper tables950.02 MB2026-05-28 17:42:43-
zBSC_inputs_Workcentres
BASE TABLE · InnoDB
Custom/model/helper tables950.02 MB--
zBSC_params
BASE TABLE · InnoDB
Custom/model/helper tables60.02 MB--
zCRT_inputs_VolumeSetTargets
BASE TABLE · InnoDB
Custom/model/helper tables60.02 MB2026-04-02 21:27:14-
zCRT_inputs_VolumeSetTargets_ord
BASE TABLE · InnoDB
Custom/model/helper tables60.02 MB2026-04-02 21:30:40-
zCRT_inputs_VolumeSetTargets_ship
BASE TABLE · InnoDB
Custom/model/helper tables60.02 MB2026-04-02 21:31:35-
zCRT_workings_FamilyDiscountApplied_zz_tmp
BASE TABLE · InnoDB
Custom/model/helper tables1010.02 MB--
zCRT_workings_FamilyDiscountPartids_zz_tmp
BASE TABLE · InnoDB
Custom/model/helper tables1010.02 MB2026-04-03 14:25:41-
zCRT_workings_MinSalesFloorApplied_zz_tmp
BASE TABLE · InnoDB
Custom/model/helper tables2040.02 MB--
zCRU_Workcentres
BASE TABLE · InnoDB
Custom/model/helper tables950.02 MB2026-04-03 13:49:39-
zFCS_baseline_params
BASE TABLE · InnoDB
Custom/model/helper tables00.02 MB--
zFCS_calc_jobs
BASE TABLE · InnoDB
Custom/model/helper tables00.02 MB--
zFCS_calc_lock
BASE TABLE · InnoDB
Custom/model/helper tables00.02 MB--
zFCS_demand_view_daily
BASE TABLE · InnoDB
Custom/model/helper tables00.02 MB--
zHCAssembly_Config
BASE TABLE · InnoDB
Custom/model/helper tables40.02 MB2026-06-07 06:53:30-
zHCK_datesfor4weeks
BASE TABLE · InnoDB
Custom/model/helper tables280.02 MB--
zHCK_months
BASE TABLE · InnoDB
Custom/model/helper tables120.02 MB--
zHCK_parentparts
BASE TABLE · InnoDB
Custom/model/helper tables870.02 MB--
zHCK_timesbychildanddateandworkcentre
BASE TABLE · InnoDB
Custom/model/helper tables930.02 MB--
zMSP_todays_pricing_table
BASE TABLE · InnoDB
Custom/model/helper tables00.02 MB--
zSOE_receiving_sessions
BASE TABLE · InnoDB
Custom/model/helper tables170.02 MB2026-04-30 14:49:59-
zSOE_shipment_quantity_received
BASE TABLE · InnoDB
Custom/model/helper tables40.02 MB--
zUMP_modified_pos_processing
BASE TABLE · InnoDB
Custom/model/helper tables00.02 MB--
zUMP_updating_modified_pos
BASE TABLE · InnoDB
Custom/model/helper tables560.02 MB--
ztmpCostrollupWorkcentres
BASE TABLE · InnoDB
Custom/model/helper tables950.02 MB--
bom_TEMP_distinctrowsonly
VIEW
Live/compatibility views00.00 MB--
bom_viewtouse
VIEW
Live/compatibility views00.00 MB-Current BOM view generated from the raw BOM. Prefer for user-facing current BOM lookups.
orderitems
VIEW
Live/compatibility views00.00 MB--
orderitems_compositeview
VIEW
Live/compatibility views00.00 MB--
orders
VIEW
Live/compatibility views00.00 MB--
orders_compositeview
VIEW
Live/compatibility views00.00 MB--
routings_viewtouse
VIEW
Live/compatibility views00.00 MB-Current routing view. Prefer for user-facing current routing lookups.
worksorders
VIEW
Live/compatibility views00.00 MB--
worksorders_compositeview
VIEW
Live/compatibility views00.00 MB--
zCMP_workings_RecentNettpriceFromEfacs_view
VIEW
Live/compatibility views00.00 MB--
zCSA_bounds_5y
VIEW
Live/compatibility views00.00 MB--
zCSA_part_5y
VIEW
Live/compatibility views00.00 MB--