Fusion Reference
Manufacturing
Supply chainWork definitions, work orders, and shop-floor execution records for production — owned by the manufacturing products (WIE/WIS)
11 tables
Extraction map
The BICC extract data store (PVO) reaching each of this module’s tables — the bulk path out of the SaaS database. Full details, OTBI subject areas, and provenance links live on each table page.
| Table | BICC extract data store (PVO) |
|---|---|
| WIE_OPERATION_TRANSACTIONS | FscmTopModelAM.ScmExtractAM.WieBiccExtractAM.WOOperationTransactionExtractPVO |
| WIE_RESOURCE_TRANSACTIONS | FscmTopModelAM.ScmExtractAM.WieBiccExtractAM.WOResourceTransactionExtractPVO |
| WIE_WO_OPERATION_MATERIALS | FscmTopModelAM.ScmExtractAM.WieBiccExtractAM.WOOperationMaterialExtractPVO |
| WIE_WO_OPERATION_RESOURCES | FscmTopModelAM.ScmExtractAM.WieBiccExtractAM.WOOperationResourceExtractPVO |
| WIE_WO_OPERATIONS_B | FscmTopModelAM.ScmExtractAM.WieBiccExtractAM.WOOperationExtractPVO |
| WIE_WORK_ORDERS_B | FscmTopModelAM.ScmExtractAM.WieBiccExtractAM.WorkOrderExtractPVO |
| WIS_RESOURCES_B | FscmTopModelAM.ScmExtractAM.WisBiccExtractAM.ResourceExtractPVO |
| WIS_WD_OPERATIONS_B | FscmTopModelAM.ScmExtractAM.WisBiccExtractAM.WDOperationExtractPVO |
| WIS_WORK_CENTERS_B | FscmTopModelAM.ScmExtractAM.WisBiccExtractAM.WorkCenterExtractPVO |
| WIS_WORK_DEFINITIONS | FscmTopModelAM.ScmExtractAM.WisBiccExtractAM.WorkDefinitionExtractPVO |
Tables
Master · 5
- WIS_RESOURCES_BThe production resource master — each row an equipment or labor resource that performs operations at work centers, unique per plant by resource codeProduct: WISmaster
- WIS_WD_OPERATIONS_BWork definition operations — the ordered, date-effective steps of a work definition, each pointing at the work center where it runs and optionally at a reusable standard operationProduct: WISmaster
- WIS_WD_VERSIONSWork definition versions — dated snapshots of the version-controlled header attributes, with the approval status gating which version execution usesProduct: WISmaster
- WIS_WORK_CENTERS_BThe work center master — a physical station inside a work area where a type of operation happens; deliberately thin, with names in the translation companion and capacity on the resource assignmentsProduct: WISmaster
- WIS_WORK_DEFINITIONSThe work definition header — one row per item + definition-name combination in a plant, binding the produced item, the item structure supplying material requirements, and the work method; the Fusion successor to the routingProduct: WISmaster
Transaction · 6
- WIE_OPERATION_TRANSACTIONSThe shop-floor product ledger — one row per movement of primary-product quantity through operation dispatch states: completions, moves, scrap, reject, and their reversalsProduct: WIEtransaction
- WIE_RESOURCE_TRANSACTIONSThe resource charge ledger — labor and equipment usage charged (or reversed) against work order operation resources, with full lineage down to the resource assignmentProduct: WIEtransaction
- WIE_WO_OPERATION_MATERIALSComponent requirements of each work order operation — one row per material line with per-assembly usage, total requirement, supply method, and running issued/allocated/picked countersProduct: WIEtransaction
- WIE_WO_OPERATION_RESOURCESLabor and equipment requirements for each work order operation — usage rate, required and actual usage, assigned units, and charge behaviorProduct: WIEtransaction
- WIE_WO_OPERATIONS_BWork order operations — one row per execution step with its sequence, work center, count-point behavior, and the quantity balances sitting at each dispatch stateProduct: WIEtransaction
- WIE_WORK_ORDERS_BThe work order header — the primary product being built, the work definition version it was created from, the build quantity, status, and planned/actual execution datesProduct: WIEtransaction