Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MP_ImportUnitsBroker
|
{
|
MDSDefinition: MacroPlan
|
EDIModelLink.Destination OutputUnitsToModel
|
{
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.outputunitstomodel'
|
EDIMLTable Unit
|
{
|
PrimaryKeyColumns: ID
|
TargetType: Unit
|
TypeIndex: UnitTypeIndex
|
EDIMLColumn CampaignTypeDuration { Attribute: CampaignTypeDuration ValueType: Duration }
|
EDIMLColumn CapacitySmoothingPercentageDelta { Attribute: CapacitySmoothingPercentageDelta ValueType: Real }
|
EDIMLColumn CapacityType { Attribute: CapacityType ValueType: String }
|
EDIMLColumn CurrencyID { Attribute: CurrencyID ValueType: String }
|
EDIMLColumn DisplayIndexForExcel { Attribute: DisplayIndexForExcel ValueType: Number }
|
EDIMLColumn EndDate { Attribute: EndDate ValueType: Date }
|
EDIMLColumn GISCity { Attribute: GISCity ValueType: String }
|
EDIMLColumn GISCountryCode { Attribute: GISCountryCode ValueType: String }
|
EDIMLColumn GISPostalCode { Attribute: GISPostalCode ValueType: String }
|
EDIMLColumn GroupName { Attribute: GroupName ValueType: String }
|
EDIMLColumn HasCapacitySmoothing { Attribute: HasCapacitySmoothing ValueType: Boolean }
|
EDIMLColumn HasMaximumQuantity { Attribute: HasMaximumQuantity ValueType: Boolean }
|
EDIMLColumn HasUserFrozenFutureDuration { Attribute: HasUserFrozenFutureDuration ValueType: Boolean }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn IconName { Attribute: IconName ValueType: String }
|
EDIMLColumn IsIncludedInSupplySpecification { Attribute: IsIncludedInSupplySpecification ValueType: Boolean }
|
EDIMLColumn IsOverlapCapacitySmoothing { Attribute: IsOverlapCapacitySmoothing ValueType: Boolean }
|
EDIMLColumn IsPlannedInfinite { Attribute: IsPlannedInfinite ValueType: Boolean }
|
EDIMLColumn IsSmoothCapacityOverAllPeriods { Attribute: IsSmoothCapacityOverAllPeriods ValueType: Boolean }
|
EDIMLColumn IsSupplier { Attribute: IsSupplier ValueType: Boolean }
|
EDIMLColumn LotSize { Attribute: LotSize ValueType: Real }
|
EDIMLColumn MaximumQuantity { Attribute: MaximumQuantity ValueType: Real }
|
EDIMLColumn MinimumQuantity { Attribute: MinimumQuantity ValueType: Real }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn Notes { Attribute: Notes ValueType: String }
|
EDIMLColumn ParentUnitID { Attribute: ParentUnitID ValueType: String }
|
EDIMLColumn QuantityToProcess { Attribute: QuantityToProcess ValueType: String }
|
EDIMLColumn StartDate { Attribute: StartDate ValueType: Date }
|
EDIMLColumn UnitOfMeasureName { Attribute: UnitOfMeasureName ValueType: String }
|
EDIMLColumn UserCapacitySmoothingLength { Attribute: UserCapacitySmoothingLength ValueType: Number }
|
EDIMLColumn UserFrozenFutureDuration { Attribute: UserFrozenFutureDuration ValueType: Duration }
|
EDIMLColumn UseShiftOptimization { Attribute: UseShiftOptimization ValueType: Boolean }
|
}
|
}
|
EDITransformation.Transformation TransformUnitsForImport
|
{
|
EDITableTransformation
|
{
|
InputTable: Units_MP
|
OutputTable: Unit
|
EDIColumnMatch
|
{
|
InputColumn: IconName
|
OutputColumn: IconName
|
}
|
EDIColumnMatch
|
{
|
InputColumn: HasUserFrozenFutureDuration
|
OutputColumn: HasUserFrozenFutureDuration
|
}
|
EDIColumnMatch { InputColumn: IsSupplier OutputColumn: IsSupplier }
|
EDIColumnMatch
|
{
|
InputColumn: LotSize
|
OutputColumn: LotSize
|
}
|
EDIColumnMatch
|
{
|
InputColumn: MaximumQuantity
|
OutputColumn: MaximumQuantity
|
}
|
EDIColumnMatch
|
{
|
InputColumn: MinimumQuantity
|
OutputColumn: MinimumQuantity
|
}
|
EDIColumnMatch
|
{
|
InputColumn: CapacitySmoothingPercentageDelta
|
OutputColumn: CapacitySmoothingPercentageDelta
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Notes
|
OutputColumn: Notes
|
}
|
EDIColumnMatch
|
{
|
InputColumn: QuantityToProcess
|
OutputColumn: QuantityToProcess
|
}
|
EDIColumnMatch
|
{
|
InputColumn: HasCapacitySmoothing
|
OutputColumn: HasCapacitySmoothing
|
}
|
EDIColumnMatch
|
{
|
InputColumn: IsOverlapCapacitySmoothing
|
OutputColumn: IsOverlapCapacitySmoothing
|
}
|
EDIColumnMatch
|
{
|
InputColumn: UserFrozenFutureDuration
|
OutputColumn: UserFrozenFutureDuration
|
}
|
EDIColumnMatch
|
{
|
InputColumn: CampaignTypeDuration
|
OutputColumn: CampaignTypeDuration
|
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>
|
*]
|
}
|
}
|
EDIColumnMatch
|
{
|
InputColumn: DisplayIndex
|
OutputColumn: DisplayIndexForExcel
|
}
|
EDIColumnMatch
|
{
|
InputColumn: IsSmoothCapacityOverAllPeriods
|
OutputColumn: IsSmoothCapacityOverAllPeriods
|
}
|
EDIColumnMatch
|
{
|
InputColumn: UserCapacitySmoothingLength
|
OutputColumn: UserCapacitySmoothingLength
|
}
|
EDIColumnMatch
|
{
|
InputColumn: GISCity
|
OutputColumn: GISCity
|
}
|
EDIColumnMatch
|
{
|
InputColumn: GISCountryCode
|
OutputColumn: GISCountryCode
|
}
|
EDIColumnMatch
|
{
|
InputColumn: EndDate
|
OutputColumn: EndDate
|
}
|
EDIColumnMatch
|
{
|
InputColumn: CapacityType
|
OutputColumn: CapacityType
|
}
|
EDIColumnMatch
|
{
|
InputColumn: CurrencyID
|
OutputColumn: CurrencyID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: GISPostalCode
|
OutputColumn: GISPostalCode
|
}
|
EDIColumnMatch
|
{
|
InputColumn: ParentUnitID
|
OutputColumn: ParentUnitID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: StartDate
|
OutputColumn: StartDate
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Name
|
OutputColumn: Name
|
}
|
EDIColumnMatch
|
{
|
InputColumn: IsPlannedInfinite
|
OutputColumn: IsPlannedInfinite
|
}
|
EDIColumnMatch
|
{
|
InputColumn: ID
|
OutputColumn: ID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: GroupName
|
OutputColumn: GroupName
|
}
|
EDIColumnMatch
|
{
|
InputColumn: UnitOfMeasureName
|
OutputColumn: UnitOfMeasureName
|
}
|
EDIColumnMatch
|
{
|
InputColumn: HasMaximumQuantity
|
OutputColumn: HasMaximumQuantity
|
}
|
EDIColumnMatch
|
{
|
InputColumn: IsIncludedInSupplySpecification
|
OutputColumn: IsIncludedInSupplySpecification
|
}
|
EDIColumnMatch
|
{
|
InputColumn: UseShiftOptimization
|
OutputColumn: UseShiftOptimization
|
}
|
}
|
}
|
EDIXLSLink.Source InputUnitsFromExcel
|
{
|
FileName: 'MP_Units.xlsx'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.inputunitsfromexcel'
|
EDIXLSLinkTable Units_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn CampaignTypeDuration { ValueType: String }
|
EDIXLSLinkColumn CapacitySmoothingPercentageDelta { ValueType: Real }
|
EDIXLSLinkColumn CapacityType { ValueType: String }
|
EDIXLSLinkColumn CurrencyID { ValueType: String }
|
EDIXLSLinkColumn DisplayIndex { ValueType: Number }
|
EDIXLSLinkColumn EndDate { ValueType: Date }
|
EDIXLSLinkColumn GISCity { ValueType: String }
|
EDIXLSLinkColumn GISCountryCode { ValueType: String }
|
EDIXLSLinkColumn GISPostalCode { ValueType: String }
|
EDIXLSLinkColumn GroupName { ValueType: String }
|
EDIXLSLinkColumn HasCapacitySmoothing { ValueType: Boolean }
|
EDIXLSLinkColumn HasMaximumQuantity { ValueType: Boolean }
|
EDIXLSLinkColumn ID { ValueType: String }
|
EDIXLSLinkColumn IsIncludedInSupplySpecification { ValueType: Boolean }
|
EDIXLSLinkColumn IsOverlapCapacitySmoothing { ValueType: Boolean }
|
EDIXLSLinkColumn IsPlannedInfinite { ValueType: Boolean }
|
EDIXLSLinkColumn IsSmoothCapacityOverAllPeriods { ValueType: Boolean }
|
EDIXLSLinkColumn LotSize { ValueType: Real }
|
EDIXLSLinkColumn MaximumQuantity { ValueType: Real }
|
EDIXLSLinkColumn MinimumQuantity { ValueType: Real }
|
EDIXLSLinkColumn Name { ValueType: String }
|
EDIXLSLinkColumn Notes { ValueType: String }
|
EDIXLSLinkColumn ParentUnitID { ValueType: String }
|
EDIXLSLinkColumn QuantityToProcess { ValueType: String }
|
EDIXLSLinkColumn StartDate { ValueType: Date }
|
EDIXLSLinkColumn UnitOfMeasureName { ValueType: String }
|
EDIXLSLinkColumn UserCapacitySmoothingLength { ValueType: Number }
|
EDIXLSLinkColumn IconName { ValueType: String }
|
EDIXLSLinkColumn HasUserFrozenFutureDuration { ValueType: Boolean }
|
EDIXLSLinkColumn UserFrozenFutureDuration { ValueType: Duration }
|
EDIXLSLinkColumn UseShiftOptimization { ValueType: Boolean }
|
EDIXLSLinkColumn IsSupplier { ValueType: Boolean }
|
]
|
}
|
}
|
}
|
