Fusion Reference
Cost Management
Supply chainCost accounting records — item costs, cost distributions, and the cost-processing layer margin analytics draw from
12 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) |
|---|---|
| CST_COST_BOOKS_B | FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CostBookExtractPVO |
| CST_COST_DISTRIBUTION_LINES | FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CostDistributionLinesExtractPVO |
| CST_COST_DISTRIBUTIONS | FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CostDistributionsExtractPVO |
| CST_COST_ELEMENTS_B | FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CostElementExtractPVO |
| CST_COST_INV_ORGS | FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstCostInvOrgsExtractPVO |
| CST_COST_ORG_BOOKS | FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CostOrgBooksExtractPVO |
| CST_PERPAVG_COST | FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstPerpavgCostExtractPVO |
| CST_STD_COSTS | FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstStdCostDetailsExtractPVO |
| CST_TRANSACTION_COSTS | FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstTransactionCostsExtractPVO |
| CST_TRANSACTIONS | FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstTransactionsExtractPVO |
Tables
Transaction · 6
- CST_COST_DISTRIBUTION_LINESThe debit and credit lines under each cost distribution — per cost element, with entered and ledger amounts and both the user-entered and final SLA-derived GL accountsProduct: CSTtransaction
- CST_COST_DISTRIBUTIONSCost distribution headers — one per costed transaction event, carrying the cost org/book, item, event class, GL date, and accounting state ahead of subledger accountingProduct: CSTtransaction
- CST_PERPAVG_COSTThe perpetual average cost history — recomputed transaction by transaction per cost org, book, item, valuation unit, and cost element; the latest row is the current averageProduct: CSTtransaction
- CST_STD_COSTSStandard cost records — the date-effective standard unit cost per cost org, cost book, and item (optionally per valuation unit), with publish statusProduct: CSTtransaction
- CST_TRANSACTION_COSTSThe actual cost attached to each costing transaction — one row per transaction, cost element, and expense pool per effective date; a complete cost history including every adjustmentProduct: CSTtransaction
- CST_TRANSACTIONSThe costed-transaction spine — inventory transactions after import into costing, exploded per cost org-book and stamped with cost status; what distributions and cost rows hang offProduct: CSTtransaction
Control · 5
- CST_COST_BOOKS_BThe cost book master — book codes that attach to cost organizations to give multiple parallel cost representations of the same operationsProduct: CSTcontrol
- CST_COST_ELEMENTS_BThe cost element master — the buckets (material, overhead, and so on) item cost decomposes into, striped by reference data setProduct: CSTcontrol
- CST_COST_ELEMENTS_TLThe cost element master's translation companion — per-language element descriptionsProduct: CSTcontrol
- CST_COST_INV_ORGSThe cost-org to inventory-org bridge — which cost organization costs each inventory org, with dated validity; an inventory org belongs to exactly one cost orgProduct: CSTcontrol
- CST_COST_ORG_BOOKSThe cost org + book association — the working grain of Fusion costing, carrying the ledger, currency, calendar, and whether accounting is created for the combinationProduct: CSTcontrol