Fusion Reference
Product Master
Supply chainThe item master and its satellites — translations, revisions, categories, catalogs, and item structures — that every balance, order, and movement points back to; owned by the Product Model (EGP)
8 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) |
|---|---|
| EGP_CATEGORIES_B | FscmTopModelAM.ScmExtractAM.EgpBiccExtractAM.CategoryExtractPVO |
| EGP_CATEGORY_SETS_B | FscmTopModelAM.ScmExtractAM.EgpBiccExtractAM.CatalogExtractPVO |
| EGP_COMPONENTS_B | FscmTopModelAM.ScmExtractAM.EgpBiccExtractAM.ComponentsExtractPVO |
| EGP_ITEM_CAT_ASSIGNMENTS | FscmTopModelAM.ScmExtractAM.EgpBiccExtractAM.ItemCatAssignmentsExtractPVO |
| EGP_STRUCTURES_B | FscmTopModelAM.ScmExtractAM.EgpBiccExtractAM.StructuresExtractPVO |
| EGP_SYSTEM_ITEMS_B | FscmTopModelAM.ScmExtractAM.EgpBiccExtractAM.ItemExtractPVO |
| EGP_SYSTEM_ITEMS_TL | FscmTopModelAM.ScmExtractAM.EgpBiccExtractAM.ItemTranslationExtractPVO |
Tables
Master · 7
- EGP_CATEGORIES_BThe category master — one row per category with its user-facing category code and active window; categories are global and keyed by CATEGORY_IDProduct: EGPmaster
- EGP_COMPONENTS_BItem structure component lines — one row per component per operation per effectivity window, child of the structure header, with quantity, yield, and WIP supply behaviorProduct: EGPmaster
- EGP_ITEM_CAT_ASSIGNMENTSThe item-to-category assignment — one row per item, organization, catalog (category set), and category; the bridge every category rollup crossesProduct: EGPmaster
- EGP_ITEM_REVISIONS_BItem revisions — one row per revision level of an item in an organization, with effectivity and implementation dates and the change-order line that introduced itProduct: EGPmaster
- EGP_STRUCTURES_BItem structure (BOM) headers — one row per manufacturing or engineering bill per named variant, identified by BILL_SEQUENCE_ID, with common-structure sharing and change-order linkageProduct: EGPmaster
- EGP_SYSTEM_ITEMS_BThe item master — one row per item per inventory organization, carrying the item number as a real column plus status, type, unit of measure, and the control flags for every functional area; every balance, transaction, and order line joins back to it on INVENTORY_ITEM_ID + ORGANIZATION_IDProduct: EGPmaster
- EGP_SYSTEM_ITEMS_TLThe item master's translation companion — item description and long description in every installed language, one row per item per organization per language; the only place the item description existsProduct: EGPmaster