Fusion Reference
Order Management
Supply chainSales order headers, lines, and fulfillment records across the order-to-cash cycle — owned by Distributed Order Orchestration (DOO)
6 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) |
|---|---|
| DOO_FULFILL_LINES_ALL | FscmTopModelAM.ScmExtractAM.DooBiccExtractAM.FulfillLineExtractPVO |
| DOO_HEADERS_ALL | FscmTopModelAM.ScmExtractAM.DooBiccExtractAM.HeaderExtractPVO |
| DOO_HOLD_INSTANCES | FscmTopModelAM.ScmExtractAM.DooBiccExtractAM.HoldInstanceExtractPVO |
| DOO_LINES_ALL | FscmTopModelAM.ScmExtractAM.DooBiccExtractAM.LineExtractPVO |
| DOO_ORDER_CHARGE_COMPONENTS | FscmTopModelAM.ScmExtractAM.DooBiccExtractAM.OrderChargeComponentExtractPVO |
| DOO_ORDER_CHARGES | FscmTopModelAM.ScmExtractAM.DooBiccExtractAM.OrderChargeExtractPVO |
Tables
Transaction · 6
- DOO_FULFILL_LINES_ALLFulfillment lines — the executable, shippable unit of an order line and the correct analytics grain for order-to-ship reporting, with the quantity lifecycle, schedule/actual dates, fulfillment org, and amountsProduct: DOOtransaction
- DOO_HEADERS_ALLThe sales order header — one row per orchestration order, carrying the order number, source-system references, sold-to customer, currency, and the status the whole order-to-cash cycle hangs off; business-unit stripedProduct: DOOtransaction
- DOO_HOLD_INSTANCESHold instances — one row per hold applied to an orchestration order, order line, or fulfillment line, with who applied and released it and when; the "why isn't this line shipping" tableProduct: DOOtransaction
- DOO_LINES_ALLSales order lines — the middle tier between the header and the fulfillment lines, carrying the item, ordered/shipped/fulfilled quantities, selling price, and line statusProduct: DOOtransaction
- DOO_ORDER_CHARGE_COMPONENTSThe price-waterfall detail — one row per price element (list price, discounts, net price, margin) under each charge, carrying the actual amounts in both charge and header currencyProduct: DOOtransaction
- DOO_ORDER_CHARGESThe price-waterfall charge header — one row per charge (product price, freight, fees) applied to a fulfillment line, classified by charge type, subtype, and price typeProduct: DOOtransaction