Quintiq file version 2.0
|
#parent: #root
|
EDIBroker Converter_Q2Q3_ImportInventoryLocationPreferences
|
{
|
MDSDefinition: MacroPlan
|
EDIModelLink.Destination DestinationConverterILP
|
{
|
EDIMLTable Converter_InventoryLocationPreferences
|
{
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: StockingPointID
|
TargetType: Converter_InventoryLocationPreferences
|
TypeIndex: ConvertILPTypeIndex
|
EDIMLColumn PreferenceBonus { Attribute: PreferenceBonus ValueType: Real }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
|
}
|
}
|
EDITransformation.Transformation TransformationConverterILP
|
{
|
EDITableTransformation
|
{
|
InputTable: InventoryLocationPreferences_MP
|
OutputTable: Converter_InventoryLocationPreferences
|
EDIColumnMatch
|
{
|
InputColumn: PreferenceBonus
|
OutputColumn: PreferenceBonus
|
}
|
EDIColumnMatch
|
{
|
InputColumn: ProductID
|
OutputColumn: ProductID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Start
|
OutputColumn: Start
|
}
|
EDIColumnMatch
|
{
|
InputColumn: StockingPointID
|
OutputColumn: StockingPointID
|
}
|
}
|
}
|
EDIXLSLink.Source SourceConverterILP
|
{
|
FileName: 'MP_InventoryLocationPreferences.xlsx'
|
EDIXLSLinkTable InventoryLocationPreferences_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn PreferenceBonus { ValueType: Real }
|
EDIXLSLinkColumn ProductID { ValueType: String }
|
EDIXLSLinkColumn Start { ValueType: Date }
|
EDIXLSLinkColumn StockingPointID { ValueType: String }
|
]
|
}
|
}
|
}
|
