Quintiq file version 2.0
|
#parent: #root
|
EDIBroker Converter_Q2Q3_ImportOperationPreference
|
{
|
MDSDefinition: MacroPlan
|
EDIModelLink.Destination DestinationConvertOperationPreference
|
{
|
EDIMLTable Converter_OperationPreference
|
{
|
PrimaryKeyColumns: ID
|
TargetType: Converter_OperationPreference
|
TypeIndex: ConvertOperationPrefTypeIndex
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn PreferenceBonus { Attribute: PreferenceBonus ValueType: Real }
|
}
|
}
|
EDITransformation.Transformation TransformationConvertOperationPreference
|
{
|
EDITableTransformation
|
{
|
InputTable: Operations_MP
|
OutputTable: Converter_OperationPreference
|
EDIColumnMatch
|
{
|
InputColumn: ID
|
OutputColumn: ID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: PreferenceBonus
|
OutputColumn: PreferenceBonus
|
}
|
}
|
}
|
EDIXLSLink.Source SourceConvertOperationPreference
|
{
|
FileName: 'MP_Routings.xlsx'
|
EDIXLSLinkTable Operations_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn HasUserLotSize { ValueType: String }
|
EDIXLSLinkColumn HasUserMaximumQuantity { ValueType: String }
|
EDIXLSLinkColumn ID { ValueType: String }
|
EDIXLSLinkColumn IsEnabled { ValueType: String }
|
EDIXLSLinkColumn LotSize { ValueType: String }
|
EDIXLSLinkColumn MaximumQuantity { ValueType: String }
|
EDIXLSLinkColumn MinimumQuantity { ValueType: String }
|
EDIXLSLinkColumn PreferenceBonus { ValueType: Real }
|
EDIXLSLinkColumn RoutingID { ValueType: String }
|
EDIXLSLinkColumn RoutingStepName { ValueType: String }
|
EDIXLSLinkColumn Throughput { ValueType: String }
|
EDIXLSLinkColumn UnitID { ValueType: String }
|
EDIXLSLinkColumn UserLeadTime { ValueType: String }
|
EDIXLSLinkColumn StandardDeviationLeadTimeOperation { ValueType: String }
|
]
|
}
|
}
|
}
|
