Quintiq file version 2.0 Component MatrixEditorProductPlanning { #keys: '[136682.2.1137897477]' BaseType: 'WebMatrixEditor' Children: [ Component MatrixEditorCellPISPIP { #keys: '[136682.2.1137897478]' BaseType: 'WebMatrixEditorCell' Children: [ Component DataExtractorPISPIP { #keys: '[136682.2.1137897479]' BaseType: 'WebDataExtractor' Properties: [ DataType: 'structured[ProductInStockingPoint_MP]' FixedFilter: 'not object.ProductInStockingPoint_MP().IsSystem() and object.ProductInStockingPoint_MP().IsLeaf()' Source: 'ApplicationMacroPlanner.DataHolderPISP' Taborder: 0 Transformation: 'Elements.ProductInStockingPointInPeriod' ] } ] Properties: [ Attributes: 'DisplaySupplyQuantity;DependentDemandAndSalesDemandQuantity;TargetInventoryLevel;InventoryLevelEnd;StockLevelInDays' Column: 'Period_MP' Row: 'ProductInStockingPoint_MP' Taborder: 2 ] } Component MatrixEditorRowsPISP { #keys: '[136682.2.1137897489]' BaseType: 'WebMatrixEditorHeaderLevel' Children: [ Component DataExtractorPISP { #keys: '[136682.2.1137897490]' BaseType: 'WebDataExtractor' Properties: [ DataType: 'structured[ProductInStockingPoint_MP]' FixedFilter: 'not object.IsSystem() and object.IsLeaf()' Source: 'ApplicationMacroPlanner.DataHolderPISP' Taborder: 0 Transformation: 'Elements' ] } ] Properties: [ Legend: 'Name' SortCriteria: 'Product_MP.DisplayIndex;Name' Taborder: 0 ] } Component MatrixEditorColumnsPeriod { #keys: '[136682.2.1137897491]' BaseType: 'WebMatrixEditorHeaderLevel' Children: [ Component DataExtractorPeriod { #keys: '[136682.2.1137897492]' BaseType: 'WebDataExtractor' Properties: [ DataType: 'structured[Period_MP]' Source: 'ApplicationMacroPlanner.DataHolderPeriods' Taborder: 0 Transformation: 'Elements' ] } ] Properties: [ Legend: 'Start' SortCriteria: 'Start' Taborder: 1 ] } Component UserConfigurableInformationMatrixEditorProductPlanning { #keys: '[136682.2.1137897493]' BaseType: 'WebUserConfigurableInformation' Properties: [ Identifier: 'Cell: PISPIP' ObjectType: 'ProductInStockingPointInPeriod' Taborder: 3 Text: 'Test text' Tooltip: '
SYNONYM(object.InventoryLevelEnd()) | VALUE( MacroPlan::GetDisplayValue( object.InventoryLevelEnd() ) ) | VALUE(object.ProductInStockingPoint_MP().UnitOfMeasureName()) | Inventory holding cost | VALUE(object.TotalBaseInventoryHoldingCost())VALUE( \' \'+ object.ProductInStockingPoint_MP().StockingPoint_MP().Currency_MP().Symbol() ) | VALUE( \'[\' + object.TotalBaseInventoryHoldingCostPerQuantity().Format(\'N(Dec(2))\') ) | VALUE( object.ProductInStockingPoint_MP().StockingPoint_MP().Currency_MP().Symbol() + \'/\' + object.ProductInStockingPoint_MP().UnitOfMeasure_MP().Name() + \']\' ) |
SYNONYM(object.StockLevelInDays()) | VALUE(object.StockLevelInDays) | day | ||||
Total supply | VALUE(object.SupplyQuantity()) | VALUE(object.ProductInStockingPoint_MP().UnitOfMeasureName()) | Total demand | VALUE(object.GetDemandQuantity()) | VALUE(object.ProductInStockingPoint_MP().UnitOfMeasureName()) | |
Inventory start | VALUE( guard( MacroPlan::GetDisplayValue( object.InventoryLevelStartPISPIP().InventoryLevelEnd() ), 0.0 ) ) | VALUE(object.ProductInStockingPoint_MP().UnitOfMeasureName()) | Sales demand | VALUE(object.SalesDemandQuantity()) | VALUE(object.ProductInStockingPoint_MP().UnitOfMeasureName()) | |
New supply | VALUE(object.NewSupplyQuantity()) | VALUE(object.ProductInStockingPoint_MP().UnitOfMeasureName()) | Dependent demand | VALUE(object.DependentDemandQuantity()) | VALUE(object.ProductInStockingPoint_MP().UnitOfMeasureName()) | |
Inventory supply | VALUE(object.InventorySupplyQuantity()) | VALUE(object.ProductInStockingPoint_MP().UnitOfMeasureName()) | Fulfilled demand | VALUE(object.FulfilledDemandQuantity() ) | VALUE(object.ProductInStockingPoint_MP().UnitOfMeasureName()) |