Inventory dimensions
The three Inventory cubes have differing levels of granularity and dimensionality. See the cube architecture diagrams for the dimensions related to each cube.
| Dimension | Attribute | Source |
|---|---|---|
| Accounting Unit | Accounting Unit | Accounting Unit |
| Calendar | Period Caption YTD Cross Reference Same Period Last Year YTD Cross Ref SPLY Year Link Month Link |
Analytics Calendar |
| Document Number |
Company Inventory Document Type |
InventoryTransactionLine.InventoryTransaction |
| Item |
Item Long Name Item Group Item Description Description2 Stock UOM Generic Name Major Purchasing Class Major Purchasing Class Desc Minor Purchasing Class Minor Purchasing Class Desc Major Inventory Class Major Inventory Class Desc Minor Inventory Class Minor Inventory Class Desc UNSPSC Segment UNSPSC Family UNSPSC Class UNSPSC Commodity Active Added Date Commodity Code Consignment Hazard Code Manufacturer Code Manufacturer Division Manufacturer Number |
Item |
| Manufacturer |
Manufacturer Code Manufacturer Division |
Manufacturer |
| Requesting Location | Requesting Location | InventoryTransaction.FromToCompanyLocation.RequestingLocation |
| Transaction System Code | Transaction System Code | InventoryTransactionLine.TransactionSystemCode |
| Costing Method | Costing Method | InventoryOnHand |
| Inventory Document Type | Document Type | InventoryTransaction |
| Shelf Location | Shelf Location | InventoryOnHand |
| Chart Account | Chart Account | InventoryOnHand |
| Reorder Document | Reorder Document | InventoryOnHand |