Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MPSync_ImportRoutingsFromExcelBroker
|
{
|
MDSDefinition: MPSync
|
EDIModelLink.Destination MPSync_DestinationRoutingsForExcelImport
|
{
|
EDIMLTable IOOperation
|
{
|
PrimaryKeyColumns: ID
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IOOperation
|
TypeIndex: IOOperationTypeIndex
|
WithSoftDelete: true
|
EDIMLColumn CO2Emission { Attribute: CO2Emission ValueType: Real }
|
EDIMLColumn HasUserLotSize { Attribute: HasUserLotSize ValueType: Boolean }
|
EDIMLColumn HasUserMaximumQuantity { Attribute: HasUserMaximumQuantity ValueType: Boolean }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn IsEnabled { Attribute: IsEnabled ValueType: Boolean }
|
EDIMLColumn RoutingID { Attribute: RoutingID ValueType: String }
|
EDIMLColumn RoutingStepName { Attribute: RoutingStepName ValueType: String }
|
EDIMLColumn StandardDeviationLeadTimeOperation { Attribute: StandardDeviationLeadTimeOperation ValueType: Duration }
|
EDIMLColumn Throughput { Attribute: Throughput ValueType: Real }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
EDIMLColumn UserLeadTime { Attribute: UserLeadTime ValueType: Duration }
|
EDIMLColumn UserLotSize { Attribute: UserLotSize ValueType: Real }
|
EDIMLColumn UserMaximumQuantity { Attribute: UserMaximumQuantity ValueType: Real }
|
EDIMLColumn UserMinimumQuantity { Attribute: UserMinimumQuantity ValueType: Real }
|
}
|
EDIMLTable IOOperationBOM
|
{
|
PrimaryKeyColumns: IsInput
|
PrimaryKeyColumns: OperationID
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: StockingPointID
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IOOperationBOM
|
TypeIndex: IOOperationBOMTypeIndex
|
WithSoftDelete: true
|
EDIMLColumn InputGroupID { Attribute: InputGroupID ValueType: Number }
|
EDIMLColumn IsExcluded { Attribute: IsExcluded ValueType: Boolean }
|
EDIMLColumn IsInput { Attribute: IsInput ValueType: Boolean }
|
EDIMLColumn MaxQuantityInGroup { Attribute: MaxQuantityInGroup ValueType: Real }
|
EDIMLColumn MinQuantityInGroup { Attribute: MinQuantityInGroup ValueType: Real }
|
EDIMLColumn OperationID { Attribute: OperationID ValueType: String }
|
EDIMLColumn OperationInputSetName { Attribute: OperationInputSetName ValueType: String }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn Quantity { Attribute: Quantity ValueType: Real }
|
EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
|
}
|
EDIMLTable IOOperationInputGroup
|
{
|
PrimaryKeyColumns: InputGroupID
|
PrimaryKeyColumns: OperationID
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IOOperationInputGroup
|
TypeIndex: IOOperationInputGroupTypeIndex
|
WithSoftDelete: true
|
EDIMLColumn InputGroupID { Attribute: InputGroupID ValueType: Number }
|
EDIMLColumn InputGroupQuantity { Attribute: InputGroupQuantity ValueType: Real }
|
EDIMLColumn OperationID { Attribute: OperationID ValueType: String }
|
}
|
EDIMLTable IOOperationInputSet
|
{
|
PrimaryKeyColumns: Name
|
PrimaryKeyColumns: OperationID
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IOOperationInputSet
|
TypeIndex: IOOperationInputSetTypeIndex
|
WithSoftDelete: true
|
EDIMLColumn MaxQuantity { Attribute: MaxQuantity ValueType: Real }
|
EDIMLColumn MinQuantity { Attribute: MinQuantity ValueType: Real }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn OperationID { Attribute: OperationID ValueType: String }
|
}
|
EDIMLTable IOOperationLink
|
{
|
PrimaryKeyColumns: DestOperationID
|
PrimaryKeyColumns: SourceOperationID
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IOOperationLink
|
TypeIndex: IOOperationLinkTypeIndex
|
WithSoftDelete: true
|
EDIMLColumn DestGroupID { Attribute: DestGroupID ValueType: Number }
|
EDIMLColumn DestHasUserQuantity { Attribute: DestHasUserQuantity ValueType: Boolean }
|
EDIMLColumn DestMaxQuantity { Attribute: DestMaxQuantity ValueType: Real }
|
EDIMLColumn DestMinQuantity { Attribute: DestMinQuantity ValueType: Real }
|
EDIMLColumn DestOperationID { Attribute: DestOperationID ValueType: String }
|
EDIMLColumn DestQuantity { Attribute: DestQuantity ValueType: Real }
|
EDIMLColumn SourceGroupID { Attribute: SourceGroupID ValueType: Number }
|
EDIMLColumn SourceOperationID { Attribute: SourceOperationID ValueType: String }
|
EDIMLColumn SourceQuantity { Attribute: SourceQuantity ValueType: Real }
|
}
|
EDIMLTable IORouting
|
{
|
PrimaryKeyColumns: ID
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IORouting
|
TypeIndex: IORoutingTypeIndex
|
WithSoftDelete: true
|
EDIMLColumn AllowedWIPInventory { Attribute: AllowWIPInventory ValueType: Boolean }
|
EDIMLColumn End { Attribute: End ValueType: Date }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn IsEnabled { Attribute: IsEnabled ValueType: Boolean }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
}
|
EDIMLTable IORoutingConfiguratorView
|
{
|
PrimaryKeyColumns: ID
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IORoutingConfiguratorView
|
TypeIndex: IORoutingConfiguratorViewTypeIndex
|
WithSoftDelete: true
|
EDIMLColumn EdgeThickness { Attribute: EdgeThickness ValueType: Number }
|
EDIMLColumn FontName { Attribute: FontName ValueType: String }
|
EDIMLColumn FontSize { Attribute: FontSize ValueType: Number }
|
EDIMLColumn GridHeight { Attribute: GridHeight ValueType: Number }
|
EDIMLColumn GridPointDistance { Attribute: GridPointDistance ValueType: Number }
|
EDIMLColumn GridWidth { Attribute: GridWidth ValueType: Number }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn IsCompactMode { Attribute: IsCompactMode ValueType: Boolean }
|
EDIMLColumn IsGridVisible { Attribute: IsGridVisible ValueType: Boolean }
|
EDIMLColumn OffsetX { Attribute: OffsetX ValueType: Number }
|
EDIMLColumn OffsetY { Attribute: OffsetY ValueType: Number }
|
EDIMLColumn OperationHeight { Attribute: OperationHeight ValueType: Number }
|
EDIMLColumn OperationInputOutputWidth { Attribute: OperationInputOutputWidth ValueType: Number }
|
EDIMLColumn OperationOffsetX { Attribute: OperationOffsetX ValueType: Number }
|
EDIMLColumn OperationOffsetY { Attribute: OperationOffsetY ValueType: Number }
|
EDIMLColumn OperationWidth { Attribute: OperationWidth ValueType: Number }
|
EDIMLColumn PISPHeight { Attribute: PISPHeight ValueType: Number }
|
EDIMLColumn PISPWidth { Attribute: PISPWidth ValueType: Number }
|
EDIMLColumn Padding { Attribute: Padding ValueType: Number }
|
EDIMLColumn RoutingStepDistance { Attribute: RoutingStepDistance ValueType: Number }
|
EDIMLColumn RoutingStepMinimumHeight { Attribute: RoutingStepMinimumHeight ValueType: Number }
|
EDIMLColumn RoutingStepMinimumWidth { Attribute: RoutingStepMinimumWidth ValueType: Number }
|
EDIMLColumn User { Attribute: User ValueType: String }
|
EDIMLColumn UserOperationInputOutputHeight { Attribute: UserOperationInputOutputHeight ValueType: Number }
|
}
|
EDIMLTable IORoutingStep
|
{
|
PrimaryKeyColumns: Name
|
PrimaryKeyColumns: RoutingID
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IORoutingStep
|
TypeIndex: IORoutingStepTypeIndex
|
WithSoftDelete: true
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn RoutingID { Attribute: RoutingID ValueType: String }
|
EDIMLColumn SequenceNumberForExcel { Attribute: SequenceNumberForExcel ValueType: Number }
|
EDIMLColumn Tool { Attribute: Tool ValueType: String }
|
}
|
}
|
EDITransformation.Transformation MPSync_TransformationRoutingsForExcelImport
|
{
|
EDITableTransformation
|
{
|
InputTable: OperationBOMs_MP
|
OutputTable: IOOperationBOM
|
EDIColumnMatch { InputColumn: InputGroupID OutputColumn: InputGroupID }
|
EDIColumnMatch { InputColumn: IsExcluded OutputColumn: IsExcluded }
|
EDIColumnMatch { InputColumn: IsInput OutputColumn: IsInput }
|
EDIColumnMatch { InputColumn: MaxQuantityInGroup OutputColumn: MaxQuantityInGroup }
|
EDIColumnMatch { InputColumn: MinQuantityInGroup OutputColumn: MinQuantityInGroup }
|
EDIColumnMatch { InputColumn: OperationID OutputColumn: OperationID }
|
EDIColumnMatch { InputColumn: OperationInputSetName OutputColumn: OperationInputSetName }
|
EDIColumnMatch { InputColumn: ProductID OutputColumn: ProductID }
|
EDIColumnMatch { InputColumn: Quantity OutputColumn: Quantity }
|
EDIColumnMatch { InputColumn: StockingPointID OutputColumn: StockingPointID }
|
}
|
EDITableTransformation
|
{
|
InputTable: OperationInputGroups_MP
|
OutputTable: IOOperationInputGroup
|
EDIColumnMatch { InputColumn: InputGroupID OutputColumn: InputGroupID }
|
EDIColumnMatch { InputColumn: InputGroupQuantity OutputColumn: InputGroupQuantity }
|
EDIColumnMatch { InputColumn: OperationID OutputColumn: OperationID }
|
}
|
EDITableTransformation
|
{
|
InputTable: OperationInputSet
|
OutputTable: IOOperationInputSet
|
EDIColumnMatch
|
{
|
InputColumn: MaxQuantity
|
OutputColumn: MaxQuantity
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToReal xmlns="http://www.quintiq.com/GEB/StringToReal" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<NumericFormatString>Standard</NumericFormatString>
|
<LocaleString>English (United States)</LocaleString>
|
<CurrencyString></CurrencyString>
|
<CustomFormatString></CustomFormatString>
|
</StringToReal>
|
*]
|
}
|
}
|
EDIColumnMatch
|
{
|
InputColumn: MinQuantity
|
OutputColumn: MinQuantity
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToReal xmlns="http://www.quintiq.com/GEB/StringToReal" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<NumericFormatString>Standard</NumericFormatString>
|
<LocaleString>English (United States)</LocaleString>
|
<CurrencyString></CurrencyString>
|
<CustomFormatString></CustomFormatString>
|
</StringToReal>
|
*]
|
}
|
}
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
EDIColumnMatch { InputColumn: OperationID OutputColumn: OperationID }
|
}
|
EDITableTransformation
|
{
|
InputTable: OperationLinks_MP
|
OutputTable: IOOperationLink
|
EDIColumnMatch { InputColumn: DestGroupID OutputColumn: DestGroupID }
|
EDIColumnMatch { InputColumn: DestHasUserQuantity OutputColumn: DestHasUserQuantity }
|
EDIColumnMatch { InputColumn: DestMaxQuantity OutputColumn: DestMaxQuantity }
|
EDIColumnMatch { InputColumn: DestMinQuantity OutputColumn: DestMinQuantity }
|
EDIColumnMatch { InputColumn: DestOperationID OutputColumn: DestOperationID }
|
EDIColumnMatch { InputColumn: DestQuantity OutputColumn: DestQuantity }
|
EDIColumnMatch { InputColumn: SourceGroupID OutputColumn: SourceGroupID }
|
EDIColumnMatch { InputColumn: SourceOperationID OutputColumn: SourceOperationID }
|
EDIColumnMatch { InputColumn: SourceQuantity OutputColumn: SourceQuantity }
|
}
|
EDITableTransformation
|
{
|
InputTable: Operations_MP
|
OutputTable: IOOperation
|
EDIColumnMatch { InputColumn: CO2Emission OutputColumn: CO2Emission }
|
EDIColumnMatch { InputColumn: HasUserLotSize OutputColumn: HasUserLotSize }
|
EDIColumnMatch { InputColumn: HasUserMaximumQuantity OutputColumn: HasUserMaximumQuantity }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: IsEnabled OutputColumn: IsEnabled }
|
EDIColumnMatch { InputColumn: LotSize OutputColumn: UserLotSize }
|
EDIColumnMatch { InputColumn: MaximumQuantity OutputColumn: UserMaximumQuantity }
|
EDIColumnMatch { InputColumn: MinimumQuantity OutputColumn: UserMinimumQuantity }
|
EDIColumnMatch { InputColumn: RoutingID OutputColumn: RoutingID }
|
EDIColumnMatch { InputColumn: RoutingStepName OutputColumn: RoutingStepName }
|
EDIColumnMatch { InputColumn: StandardDeviationLeadTimeOperation OutputColumn: StandardDeviationLeadTimeOperation }
|
EDIColumnMatch { InputColumn: Throughput OutputColumn: Throughput }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
EDIColumnMatch
|
{
|
InputColumn: UserLeadTime
|
OutputColumn: UserLeadTime
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToDuration xmlns="http://www.quintiq.com/GEB/StringToDuration" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<SingularDayString>day</SingularDayString>
|
<PluralDayString>days</PluralDayString>
|
</StringToDuration>
|
*]
|
}
|
}
|
}
|
EDITableTransformation
|
{
|
InputTable: RoutingConfiguratorView_MP
|
OutputTable: IORoutingConfiguratorView
|
EDIColumnMatch
|
{
|
InputColumn: EdgeThickness
|
OutputColumn: EdgeThickness
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToNumber xmlns="http://www.quintiq.com/GEB/StringToNumber" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<NumericFormatString>Standard</NumericFormatString>
|
<LocaleString>English (United States)</LocaleString>
|
<CurrencyString></CurrencyString>
|
<CustomFormatString></CustomFormatString>
|
</StringToNumber>
|
*]
|
}
|
}
|
EDIColumnMatch { InputColumn: FontName OutputColumn: FontName }
|
EDIColumnMatch
|
{
|
InputColumn: FontSize
|
OutputColumn: FontSize
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToNumber xmlns="http://www.quintiq.com/GEB/StringToNumber" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<NumericFormatString>Standard</NumericFormatString>
|
<LocaleString>English (United States)</LocaleString>
|
<CurrencyString></CurrencyString>
|
<CustomFormatString></CustomFormatString>
|
</StringToNumber>
|
*]
|
}
|
}
|
EDIColumnMatch
|
{
|
InputColumn: GridHeight
|
OutputColumn: GridHeight
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToNumber xmlns="http://www.quintiq.com/GEB/StringToNumber" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<NumericFormatString>Standard</NumericFormatString>
|
<LocaleString>English (United States)</LocaleString>
|
<CurrencyString></CurrencyString>
|
<CustomFormatString></CustomFormatString>
|
</StringToNumber>
|
*]
|
}
|
}
|
EDIColumnMatch
|
{
|
InputColumn: GridPointDistance
|
OutputColumn: GridPointDistance
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToNumber xmlns="http://www.quintiq.com/GEB/StringToNumber" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<NumericFormatString>Standard</NumericFormatString>
|
<LocaleString>English (United States)</LocaleString>
|
<CurrencyString></CurrencyString>
|
<CustomFormatString></CustomFormatString>
|
</StringToNumber>
|
*]
|
}
|
}
|
EDIColumnMatch
|
{
|
InputColumn: GridWidth
|
OutputColumn: GridWidth
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToNumber xmlns="http://www.quintiq.com/GEB/StringToNumber" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<NumericFormatString>Standard</NumericFormatString>
|
<LocaleString>English (United States)</LocaleString>
|
<CurrencyString></CurrencyString>
|
<CustomFormatString></CustomFormatString>
|
</StringToNumber>
|
*]
|
}
|
}
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: IsCompactMode OutputColumn: IsCompactMode }
|
EDIColumnMatch { InputColumn: IsGridVisible OutputColumn: IsGridVisible }
|
EDIColumnMatch
|
{
|
InputColumn: OffsetX
|
OutputColumn: OffsetX
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToNumber xmlns="http://www.quintiq.com/GEB/StringToNumber" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<NumericFormatString>Standard</NumericFormatString>
|
<LocaleString>English (United States)</LocaleString>
|
<CurrencyString></CurrencyString>
|
<CustomFormatString></CustomFormatString>
|
</StringToNumber>
|
*]
|
}
|
}
|
EDIColumnMatch
|
{
|
InputColumn: OffsetY
|
OutputColumn: OffsetY
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToNumber xmlns="http://www.quintiq.com/GEB/StringToNumber" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<NumericFormatString>Standard</NumericFormatString>
|
<LocaleString>English (United States)</LocaleString>
|
<CurrencyString></CurrencyString>
|
<CustomFormatString></CustomFormatString>
|
</StringToNumber>
|
*]
|
}
|
}
|
EDIColumnMatch
|
{
|
InputColumn: OperationHeight
|
OutputColumn: OperationHeight
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToNumber xmlns="http://www.quintiq.com/GEB/StringToNumber" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<NumericFormatString>Standard</NumericFormatString>
|
<LocaleString>English (United States)</LocaleString>
|
<CurrencyString></CurrencyString>
|
<CustomFormatString></CustomFormatString>
|
</StringToNumber>
|
*]
|
}
|
}
|
EDIColumnMatch
|
{
|
InputColumn: OperationInputOutputWidth
|
OutputColumn: OperationInputOutputWidth
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToNumber xmlns="http://www.quintiq.com/GEB/StringToNumber" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<NumericFormatString>Standard</NumericFormatString>
|
<LocaleString>English (United States)</LocaleString>
|
<CurrencyString></CurrencyString>
|
<CustomFormatString></CustomFormatString>
|
</StringToNumber>
|
*]
|
}
|
}
|
EDIColumnMatch
|
{
|
InputColumn: OperationOffsetX
|
OutputColumn: OperationOffsetX
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToNumber xmlns="http://www.quintiq.com/GEB/StringToNumber" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<NumericFormatString>Standard</NumericFormatString>
|
<LocaleString>English (United States)</LocaleString>
|
<CurrencyString></CurrencyString>
|
<CustomFormatString></CustomFormatString>
|
</StringToNumber>
|
*]
|
}
|
}
|
EDIColumnMatch
|
{
|
InputColumn: OperationOffsetY
|
OutputColumn: OperationOffsetY
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToNumber xmlns="http://www.quintiq.com/GEB/StringToNumber" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<NumericFormatString>Standard</NumericFormatString>
|
<LocaleString>English (United States)</LocaleString>
|
<CurrencyString></CurrencyString>
|
<CustomFormatString></CustomFormatString>
|
</StringToNumber>
|
*]
|
}
|
}
|
EDIColumnMatch
|
{
|
InputColumn: OperationWidth
|
OutputColumn: OperationWidth
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToNumber xmlns="http://www.quintiq.com/GEB/StringToNumber" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<NumericFormatString>Standard</NumericFormatString>
|
<LocaleString>English (United States)</LocaleString>
|
<CurrencyString></CurrencyString>
|
<CustomFormatString></CustomFormatString>
|
</StringToNumber>
|
*]
|
}
|
}
|
EDIColumnMatch
|
{
|
InputColumn: PISPHeight
|
OutputColumn: PISPHeight
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToNumber xmlns="http://www.quintiq.com/GEB/StringToNumber" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<NumericFormatString>Standard</NumericFormatString>
|
<LocaleString>English (United States)</LocaleString>
|
<CurrencyString></CurrencyString>
|
<CustomFormatString></CustomFormatString>
|
</StringToNumber>
|
*]
|
}
|
}
|
EDIColumnMatch
|
{
|
InputColumn: PISPWidth
|
OutputColumn: PISPWidth
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToNumber xmlns="http://www.quintiq.com/GEB/StringToNumber" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<NumericFormatString>Standard</NumericFormatString>
|
<LocaleString>English (United States)</LocaleString>
|
<CurrencyString></CurrencyString>
|
<CustomFormatString></CustomFormatString>
|
</StringToNumber>
|
*]
|
}
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Padding
|
OutputColumn: Padding
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToNumber xmlns="http://www.quintiq.com/GEB/StringToNumber" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<NumericFormatString>Standard</NumericFormatString>
|
<LocaleString>English (United States)</LocaleString>
|
<CurrencyString></CurrencyString>
|
<CustomFormatString></CustomFormatString>
|
</StringToNumber>
|
*]
|
}
|
}
|
EDIColumnMatch
|
{
|
InputColumn: RoutingStepDistance
|
OutputColumn: RoutingStepDistance
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToNumber xmlns="http://www.quintiq.com/GEB/StringToNumber" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<NumericFormatString>Standard</NumericFormatString>
|
<LocaleString>English (United States)</LocaleString>
|
<CurrencyString></CurrencyString>
|
<CustomFormatString></CustomFormatString>
|
</StringToNumber>
|
*]
|
}
|
}
|
EDIColumnMatch
|
{
|
InputColumn: RoutingStepMinimumHeight
|
OutputColumn: RoutingStepMinimumHeight
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToNumber xmlns="http://www.quintiq.com/GEB/StringToNumber" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<NumericFormatString>Standard</NumericFormatString>
|
<LocaleString>English (United States)</LocaleString>
|
<CurrencyString></CurrencyString>
|
<CustomFormatString></CustomFormatString>
|
</StringToNumber>
|
*]
|
}
|
}
|
EDIColumnMatch
|
{
|
InputColumn: RoutingStepMinimumWidth
|
OutputColumn: RoutingStepMinimumWidth
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToNumber xmlns="http://www.quintiq.com/GEB/StringToNumber" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<NumericFormatString>Standard</NumericFormatString>
|
<LocaleString>English (United States)</LocaleString>
|
<CurrencyString></CurrencyString>
|
<CustomFormatString></CustomFormatString>
|
</StringToNumber>
|
*]
|
}
|
}
|
EDIColumnMatch { InputColumn: User OutputColumn: User }
|
EDIColumnMatch
|
{
|
InputColumn: UserOperationInputOutputHeight
|
OutputColumn: UserOperationInputOutputHeight
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToNumber xmlns="http://www.quintiq.com/GEB/StringToNumber" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<NumericFormatString>Standard</NumericFormatString>
|
<LocaleString>English (United States)</LocaleString>
|
<CurrencyString></CurrencyString>
|
<CustomFormatString></CustomFormatString>
|
</StringToNumber>
|
*]
|
}
|
}
|
}
|
EDITableTransformation
|
{
|
InputTable: RoutingSteps_MP
|
OutputTable: IORoutingStep
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
EDIColumnMatch { InputColumn: RoutingID OutputColumn: RoutingID }
|
EDIColumnMatch { InputColumn: SequenceNumber OutputColumn: SequenceNumberForExcel }
|
EDIColumnMatch { InputColumn: Tool OutputColumn: Tool }
|
}
|
EDITableTransformation
|
{
|
InputTable: Routings_MP
|
OutputTable: IORouting
|
EDIColumnMatch { InputColumn: AllowWIPInventory OutputColumn: AllowedWIPInventory }
|
EDIColumnMatch { InputColumn: End OutputColumn: End }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: IsEnabled OutputColumn: IsEnabled }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
EDIColumnMatch { InputColumn: Start OutputColumn: Start }
|
}
|
}
|
EDIXLSLink.Source MPSync_SourceInputRoutingsForExcelImport
|
{
|
FileName: 'MP_Routings.xlsx'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.inputroutingsfromexcel'
|
EDIXLSLinkTable OperationBOMs_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn InputGroupID { ValueType: Number }
|
EDIXLSLinkColumn IsExcluded { ValueType: Boolean }
|
EDIXLSLinkColumn IsInput { ValueType: Boolean }
|
EDIXLSLinkColumn MaxQuantityInGroup { ValueType: Real }
|
EDIXLSLinkColumn MinQuantityInGroup { ValueType: Real }
|
EDIXLSLinkColumn OperationID { ValueType: String }
|
EDIXLSLinkColumn OperationInputSetName { ValueType: String }
|
EDIXLSLinkColumn ProductID { ValueType: String }
|
EDIXLSLinkColumn Quantity { ValueType: Real }
|
EDIXLSLinkColumn StockingPointID { ValueType: String }
|
]
|
}
|
EDIXLSLinkTable OperationInputGroups_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn InputGroupID { ValueType: Number }
|
EDIXLSLinkColumn InputGroupQuantity { ValueType: Real }
|
EDIXLSLinkColumn OperationID { ValueType: String }
|
]
|
}
|
EDIXLSLinkTable OperationInputSet
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn MaxQuantity { ValueType: String }
|
EDIXLSLinkColumn MinQuantity { ValueType: String }
|
EDIXLSLinkColumn Name { ValueType: String }
|
EDIXLSLinkColumn OperationID { ValueType: String }
|
]
|
}
|
EDIXLSLinkTable OperationLinks_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn DestGroupID { ValueType: Number }
|
EDIXLSLinkColumn DestHasUserQuantity { ValueType: Boolean }
|
EDIXLSLinkColumn DestMaxQuantity { ValueType: Real }
|
EDIXLSLinkColumn DestMinQuantity { ValueType: Real }
|
EDIXLSLinkColumn DestOperationID { ValueType: String }
|
EDIXLSLinkColumn DestQuantity { ValueType: Real }
|
EDIXLSLinkColumn SourceGroupID { ValueType: Real }
|
EDIXLSLinkColumn SourceOperationID { ValueType: String }
|
EDIXLSLinkColumn SourceQuantity { ValueType: Real }
|
]
|
}
|
EDIXLSLinkTable Operations_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn HasUserLotSize { ValueType: Boolean }
|
EDIXLSLinkColumn HasUserMaximumQuantity { ValueType: Boolean }
|
EDIXLSLinkColumn ID { ValueType: String }
|
EDIXLSLinkColumn IsEnabled { ValueType: Boolean }
|
EDIXLSLinkColumn RoutingID { ValueType: String }
|
EDIXLSLinkColumn RoutingStepName { ValueType: String }
|
EDIXLSLinkColumn StandardDeviationLeadTimeOperation { ValueType: Duration }
|
EDIXLSLinkColumn Throughput { ValueType: Real }
|
EDIXLSLinkColumn UnitID { ValueType: String }
|
EDIXLSLinkColumn UserLeadTime { ValueType: String }
|
EDIXLSLinkColumn LotSize { ValueType: Real }
|
EDIXLSLinkColumn MaximumQuantity { ValueType: Real }
|
EDIXLSLinkColumn MinimumQuantity { ValueType: Real }
|
EDIXLSLinkColumn CO2Emission { ValueType: Real }
|
]
|
}
|
EDIXLSLinkTable RoutingConfiguratorView_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn EdgeThickness { ValueType: String }
|
EDIXLSLinkColumn FontName { ValueType: String }
|
EDIXLSLinkColumn FontSize { ValueType: String }
|
EDIXLSLinkColumn GridHeight { ValueType: String }
|
EDIXLSLinkColumn GridPointDistance { ValueType: String }
|
EDIXLSLinkColumn GridWidth { ValueType: String }
|
EDIXLSLinkColumn ID { ValueType: String }
|
EDIXLSLinkColumn IsCompactMode { ValueType: String }
|
EDIXLSLinkColumn IsGridVisible { ValueType: String }
|
EDIXLSLinkColumn OffsetX { ValueType: String }
|
EDIXLSLinkColumn OffsetY { ValueType: String }
|
EDIXLSLinkColumn OperationHeight { ValueType: String }
|
EDIXLSLinkColumn OperationInputOutputWidth { ValueType: String }
|
EDIXLSLinkColumn OperationOffsetX { ValueType: String }
|
EDIXLSLinkColumn OperationOffsetY { ValueType: String }
|
EDIXLSLinkColumn OperationWidth { ValueType: String }
|
EDIXLSLinkColumn Padding { ValueType: String }
|
EDIXLSLinkColumn PISPHeight { ValueType: String }
|
EDIXLSLinkColumn PISPWidth { ValueType: String }
|
EDIXLSLinkColumn RoutingStepDistance { ValueType: String }
|
EDIXLSLinkColumn RoutingStepMinimumHeight { ValueType: String }
|
EDIXLSLinkColumn RoutingStepMinimumWidth { ValueType: String }
|
EDIXLSLinkColumn User { ValueType: String }
|
EDIXLSLinkColumn UserOperationInputOutputHeight { ValueType: String }
|
]
|
}
|
EDIXLSLinkTable RoutingSteps_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn Name { ValueType: String }
|
EDIXLSLinkColumn RoutingID { ValueType: String }
|
EDIXLSLinkColumn SequenceNumber { ValueType: Number }
|
EDIXLSLinkColumn Tool { ValueType: String }
|
]
|
}
|
EDIXLSLinkTable Routings_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn End { ValueType: Date }
|
EDIXLSLinkColumn ID { ValueType: String }
|
EDIXLSLinkColumn IsEnabled { ValueType: Boolean }
|
EDIXLSLinkColumn Name { ValueType: String }
|
EDIXLSLinkColumn Start { ValueType: Date }
|
EDIXLSLinkColumn AllowWIPInventory { ValueType: Boolean }
|
]
|
}
|
}
|
}
|
