Quintiq file version 2.0
|
#parent: #root
|
EDIBroker Converter_Q1Q2_ImportGlobalParameters
|
{
|
MDSDefinition: MacroPlan
|
EDIModelLink.Destination OutputConverterGlobalParameter
|
{
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.outputglobalparameterstomodel'
|
EDIMLTable Converter_GlobalParameter
|
{
|
PrimaryKeyColumns: ID
|
TargetType: Converter_GlobalParameter
|
TypeIndex: GPTypeIndex
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn YearlyInterestRate { Attribute: YearlyInterestRate ValueType: Real }
|
}
|
}
|
EDITransformation.Transformation TransformConverterGlobalParameter
|
{
|
EDITableTransformation
|
{
|
InputTable: GlobalParameters_MP
|
OutputTable: Converter_GlobalParameter
|
EDIColumnMatch
|
{
|
InputColumn: YearlyInterestRate
|
OutputColumn: YearlyInterestRate
|
}
|
EDIColumnMatch
|
{
|
InputColumn: ID
|
OutputColumn: ID
|
}
|
}
|
}
|
EDIXLSLink.Source InputConverterGlobalParameter
|
{
|
FileName: 'MP_GlobalParameters.xlsx'
|
MDSDependent: true
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.inputglobalparametersfromexcel'
|
EDIXLSLinkTable GlobalParameters_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn AbsoluteLowerLimit { ValueType: Real }
|
EDIXLSLinkColumn AbsoluteUpperLimit { ValueType: Real }
|
EDIXLSLinkColumn AutoScalingFrequency { ValueType: String }
|
EDIXLSLinkColumn BalanceTolerance { ValueType: Real }
|
EDIXLSLinkColumn BaseCurrency { ValueType: String }
|
EDIXLSLinkColumn BottleneckTolerance { ValueType: Real }
|
EDIXLSLinkColumn BottleneckWindowEnd { ValueType: String }
|
EDIXLSLinkColumn BottleneckWindowStart { ValueType: String }
|
EDIXLSLinkColumn DefaultAllocation { ValueType: Real }
|
EDIXLSLinkColumn DefaultEfficiency { ValueType: Real }
|
EDIXLSLinkColumn DefaultInventoryHoldingCost { ValueType: Real }
|
EDIXLSLinkColumn DefaultMaxCapacityForStockingPoint { ValueType: Real }
|
EDIXLSLinkColumn DefaultMaxLoadPercentage { ValueType: Real }
|
EDIXLSLinkColumn DefaultNumberOfUnits { ValueType: Number }
|
EDIXLSLinkColumn DefaultOperationInputOutputQuantity { ValueType: Real }
|
EDIXLSLinkColumn DefaultUnitOfMeasure { ValueType: String }
|
EDIXLSLinkColumn DisaggregationRatio { ValueType: String }
|
EDIXLSLinkColumn EndOfKPIHorizon { ValueType: Date }
|
EDIXLSLinkColumn HasByProductsInKPIs { ValueType: Boolean }
|
EDIXLSLinkColumn ID { ValueType: String }
|
EDIXLSLinkColumn IsAutotuneInBackground { ValueType: String }
|
EDIXLSLinkColumn IsPeggingRunAfterOptimization { ValueType: Boolean }
|
EDIXLSLinkColumn LotSizeTolerance { ValueType: Real }
|
EDIXLSLinkColumn NoiseThresholdOptimizerOutput { ValueType: String }
|
EDIXLSLinkColumn NumberOfDecimals { ValueType: Number }
|
EDIXLSLinkColumn PeriodTaskValidity { ValueType: String }
|
EDIXLSLinkColumn SanityCheckLimit { ValueType: Number }
|
EDIXLSLinkColumn StartOfKPIHorizon { ValueType: Date }
|
EDIXLSLinkColumn StockingPointBottleneckThreshold { ValueType: Real }
|
EDIXLSLinkColumn TimeUnitForUnitActual { ValueType: String }
|
EDIXLSLinkColumn UnitLowerBottleneckThreshold { ValueType: Real }
|
EDIXLSLinkColumn UnitUpperBottleneckThreshold { ValueType: Real }
|
EDIXLSLinkColumn UseAuditTrail { ValueType: Boolean }
|
EDIXLSLinkColumn UseDefaultDisplayIndex { ValueType: Boolean }
|
EDIXLSLinkColumn YearlyInterestRate { ValueType: Real }
|
EDIXLSLinkColumn DefaultMaxCapacityPerDayForUnit { ValueType: String }
|
EDIXLSLinkColumn DefaultMinCapacityPerDayForUnit { ValueType: String }
|
]
|
}
|
}
|
}
|
