Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MP_ExportForecastsBroker
|
{
|
MDSDefinition: MacroPlan
|
EDIModelLink.Source InputForecastFromModel
|
{
|
EDIMLTable Forecast
|
{
|
PrimaryKeyColumns: ID
|
TargetType: Forecast
|
TypeIndex: SalesDemandIndex
|
EDIMLColumn CurrencyID { Attribute: CurrencyID ValueType: String }
|
EDIMLColumn DefaultUOMConversionFactor { Attribute: DefaultUOMConversionFactor ValueType: Real }
|
EDIMLColumn DemandUncertaintyPercentage { Attribute: DemandUncertaintyPercentage ValueType: Real }
|
EDIMLColumn DerivedPriorityName { Attribute: DerivedPriorityName ValueType: String }
|
EDIMLColumn EndDate { Attribute: EndDate ValueType: Date }
|
EDIMLColumn ExpectedQuantity { Attribute: ExpectedQuantity ValueType: Real }
|
EDIMLColumn FulfilledQuantity { Attribute: FulfilledQuantity ValueType: Real }
|
EDIMLColumn HasPostponedSalesDemand { Attribute: HasPostponedSalesDemand ValueType: Boolean }
|
EDIMLColumn HasValidConversionFactor { Attribute: HasValidConversionFactor ValueType: Boolean }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn IsExcludedFromFulfillmentKPI { Attribute: IsExcludedFromFulfillmentKPI ValueType: Boolean }
|
EDIMLColumn IsExcludedFromFulfillmentKPIUser { Attribute: IsExcludedFromFulfillmentKPIUser ValueType: Boolean }
|
EDIMLColumn IsLeaf { Attribute: IsLeaf ValueType: Boolean }
|
EDIMLColumn IsManuallyConfigured { Attribute: IsManuallyConfigured ValueType: Boolean }
|
EDIMLColumn IsPostponed { Attribute: IsPostponed ValueType: Boolean }
|
EDIMLColumn IsSoftDeleted { Attribute: IsSoftDeleted ValueType: Boolean }
|
EDIMLColumn IsValidData { Attribute: IsValidData ValueType: Boolean }
|
EDIMLColumn IsWithinSalesDemandQtyThreshold { Attribute: IsWithinSalesDemandQtyThreshold ValueType: Boolean }
|
EDIMLColumn OutsideOfPlanningHorizonQuantity { Attribute: OutsideOfPlanningHorizonQuantity ValueType: Real }
|
EDIMLColumn PISPConversionFactor { Attribute: PISPConversionFactor ValueType: Real }
|
EDIMLColumn Price { Attribute: Price ValueType: Real }
|
EDIMLColumn PriceUoM { Attribute: PriceUoM ValueType: String }
|
EDIMLColumn PriorityName { Attribute: PriorityName ValueType: String }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn Quantity { Attribute: Quantity ValueType: Real }
|
EDIMLColumn QuantityInDefaultUoM { Attribute: QuantityInDefaultUoM ValueType: Real }
|
EDIMLColumn QuantityPerDay { Attribute: QuantityPerDay ValueType: Real }
|
EDIMLColumn SalesDemandConversionFactor { Attribute: SalesDemandConversionFactor ValueType: Real }
|
EDIMLColumn SalesSegmentName { Attribute: SalesSegmentName ValueType: String }
|
EDIMLColumn SanityCheckDataMostSevere { Attribute: SanityCheckDataMostSevere ValueType: String }
|
EDIMLColumn SanityCheckDataMostSevereCount { Attribute: SanityCheckDataMostSevereCount ValueType: Number }
|
EDIMLColumn SanityCheckDataTotalViolationCount { Attribute: SanityCheckDataTotalViolationCount ValueType: Number }
|
EDIMLColumn StartDate { Attribute: StartDate ValueType: Date }
|
EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
|
EDIMLColumn UnitOfMeasureName { Attribute: UnitOfMeasureName ValueType: String }
|
EDIMLColumn Variance { Attribute: Variance ValueType: Real }
|
}
|
}
|
EDITransformation.Transformation TransformForecastForExport
|
{
|
EDITableTransformation
|
{
|
InputTable: Forecast
|
OutputTable: Forecasts_MP
|
EDIColumnMatch { InputColumn: CurrencyID OutputColumn: CurrencyID }
|
EDIColumnMatch { InputColumn: DemandUncertaintyPercentage OutputColumn: DemandUncertaintyPercentage }
|
EDIColumnMatch { InputColumn: EndDate OutputColumn: EndDate }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: IsExcludedFromFulfillmentKPIUser OutputColumn: IsExcludedFromFulfillmentKPIUser }
|
EDIColumnMatch { InputColumn: Price OutputColumn: Price }
|
EDIColumnMatch { InputColumn: PriorityName OutputColumn: PriorityName }
|
EDIColumnMatch { InputColumn: ProductID OutputColumn: ProductID }
|
EDIColumnMatch { InputColumn: Quantity OutputColumn: Quantity }
|
EDIColumnMatch { InputColumn: SalesSegmentName OutputColumn: SalesSegmentName }
|
EDIColumnMatch { InputColumn: StartDate OutputColumn: StartDate }
|
EDIColumnMatch { InputColumn: StockingPointID OutputColumn: StockingPointID }
|
EDIColumnMatch { InputColumn: UnitOfMeasureName OutputColumn: UnitOfMeasureName }
|
}
|
}
|
EDIXLSLink.Destination OutputForecastsToExcel
|
{
|
FileName: 'MP_Forecasts'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.outputforecaststoexcel'
|
EDIXLSLinkTable Forecasts_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn CurrencyID { ValueType: String }
|
EDIXLSLinkColumn DemandUncertaintyPercentage { ValueType: Real }
|
EDIXLSLinkColumn EndDate { ValueType: Date }
|
EDIXLSLinkColumn ID { ValueType: String }
|
EDIXLSLinkColumn Price { ValueType: Real }
|
EDIXLSLinkColumn PriorityName { ValueType: String }
|
EDIXLSLinkColumn ProductID { ValueType: String }
|
EDIXLSLinkColumn Quantity { ValueType: Real }
|
EDIXLSLinkColumn SalesSegmentName { ValueType: String }
|
EDIXLSLinkColumn StartDate { ValueType: Date }
|
EDIXLSLinkColumn StockingPointID { ValueType: String }
|
EDIXLSLinkColumn UnitOfMeasureName { ValueType: String }
|
EDIXLSLinkColumn IsExcludedFromFulfillmentKPIUser { ValueType: Boolean }
|
]
|
}
|
}
|
}
|
