Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MPSync_ImportUnitsFromExcelBroker
|
{
|
MDSDefinition: MPSync
|
EDIModelLink.Destination MPSync_DestinationUnitsForExcelImport
|
{
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.outputunitstomodel'
|
EDIMLTable IOUnit
|
{
|
PrimaryKeyColumns: ID
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IOUnit
|
TypeIndex: IOUnitTypeIndex
|
WithSoftDelete: true
|
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 DisplayIndex { Attribute: DisplayIndex 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 UseShiftOptimization { Attribute: UseShiftOptimization ValueType: Boolean }
|
EDIMLColumn UserCapacitySmoothingLength { Attribute: UserCapacitySmoothingLength ValueType: Number }
|
EDIMLColumn UserFrozenFutureDuration { Attribute: UserFrozenFutureDuration ValueType: Duration }
|
}
|
}
|
EDITransformation.Transformation MPSync_TransformationUnitsForExcelImport
|
{
|
EDITableTransformation
|
{
|
InputTable: Units_MP
|
OutputTable: IOUnit
|
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: CapacitySmoothingPercentageDelta OutputColumn: CapacitySmoothingPercentageDelta }
|
EDIColumnMatch { InputColumn: CapacityType OutputColumn: CapacityType }
|
EDIColumnMatch { InputColumn: CurrencyID OutputColumn: CurrencyID }
|
EDIColumnMatch { InputColumn: DisplayIndex OutputColumn: DisplayIndex }
|
EDIColumnMatch { InputColumn: EndDate OutputColumn: EndDate }
|
EDIColumnMatch { InputColumn: GISCity OutputColumn: GISCity }
|
EDIColumnMatch { InputColumn: GISCountryCode OutputColumn: GISCountryCode }
|
EDIColumnMatch { InputColumn: GISPostalCode OutputColumn: GISPostalCode }
|
EDIColumnMatch { InputColumn: GroupName OutputColumn: GroupName }
|
EDIColumnMatch { InputColumn: HasCapacitySmoothing OutputColumn: HasCapacitySmoothing }
|
EDIColumnMatch { InputColumn: HasMaximumQuantity OutputColumn: HasMaximumQuantity }
|
EDIColumnMatch { InputColumn: HasUserFrozenFutureDuration OutputColumn: HasUserFrozenFutureDuration }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: IconName OutputColumn: IconName }
|
EDIColumnMatch { InputColumn: IsIncludedInSupplySpecification OutputColumn: IsIncludedInSupplySpecification }
|
EDIColumnMatch { InputColumn: IsOverlapCapacitySmoothing OutputColumn: IsOverlapCapacitySmoothing }
|
EDIColumnMatch { InputColumn: IsPlannedInfinite OutputColumn: IsPlannedInfinite }
|
EDIColumnMatch { InputColumn: IsSmoothCapacityOverAllPeriods OutputColumn: IsSmoothCapacityOverAllPeriods }
|
EDIColumnMatch { InputColumn: IsSupplier OutputColumn: IsSupplier }
|
EDIColumnMatch { InputColumn: LotSize OutputColumn: LotSize }
|
EDIColumnMatch { InputColumn: MaximumQuantity OutputColumn: MaximumQuantity }
|
EDIColumnMatch { InputColumn: MinimumQuantity OutputColumn: MinimumQuantity }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
EDIColumnMatch { InputColumn: Notes OutputColumn: Notes }
|
EDIColumnMatch { InputColumn: ParentUnitID OutputColumn: ParentUnitID }
|
EDIColumnMatch { InputColumn: QuantityToProcess OutputColumn: QuantityToProcess }
|
EDIColumnMatch { InputColumn: StartDate OutputColumn: StartDate }
|
EDIColumnMatch { InputColumn: UnitOfMeasureName OutputColumn: UnitOfMeasureName }
|
EDIColumnMatch { InputColumn: UseShiftOptimization OutputColumn: UseShiftOptimization }
|
EDIColumnMatch { InputColumn: UserCapacitySmoothingLength OutputColumn: UserCapacitySmoothingLength }
|
EDIColumnMatch { InputColumn: UserFrozenFutureDuration OutputColumn: UserFrozenFutureDuration }
|
}
|
}
|
EDIXLSLink.Source MPSync_SourceUnitsForExcelImport
|
{
|
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 }
|
]
|
}
|
}
|
}
|
