Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MP_ImportActualUnitPeriodsBroker
|
{
|
MDSDefinition: MacroPlan
|
EDIModelLink.Destination OutputActualUnitPeriodsToModel
|
{
|
EDIMLTable ActualUnitPeriod
|
{
|
PrimaryKeyColumns: Date
|
PrimaryKeyColumns: UnitID
|
TargetType: ActualUnitPeriod
|
TypeIndex: ActualUnitPeriodTypeIndex
|
EDIMLColumn ActualTotalAvailableDuration { Attribute: ActualTotalAvailableDuration ValueType: Duration }
|
EDIMLColumn ActualTotalAvailableQuantity { Attribute: ActualTotalAvailableQuantity ValueType: Real }
|
EDIMLColumn ActualUtilizationPercentage { Attribute: ActualUtilizationPercentage ValueType: Real }
|
EDIMLColumn Date { Attribute: Date ValueType: Date }
|
EDIMLColumn Description { Attribute: Description ValueType: String }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
}
|
}
|
EDITransformation.Transformation TransformActualUnitPeriodsForImport
|
{
|
EDITableTransformation
|
{
|
InputTable: ActualUnitPeriods_MP
|
OutputTable: ActualUnitPeriod
|
EDIColumnMatch
|
{
|
InputColumn: Description
|
OutputColumn: Description
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Date
|
OutputColumn: Date
|
}
|
EDIColumnMatch
|
{
|
InputColumn: ActualUtilizationPercentage
|
OutputColumn: ActualUtilizationPercentage
|
}
|
EDIColumnMatch
|
{
|
InputColumn: ActualTotalAvailableQuantity
|
OutputColumn: ActualTotalAvailableQuantity
|
}
|
EDIColumnMatch
|
{
|
InputColumn: ActualTotalAvailableDuration
|
OutputColumn: ActualTotalAvailableDuration
|
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: UnitID
|
OutputColumn: UnitID
|
}
|
}
|
}
|
EDIXLSLink.Source InputActualUnitPeriodsFromExcel
|
{
|
FileName: 'MP_ActualUnitPeriods.xlsx'
|
EDIXLSLinkTable ActualUnitPeriods_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn ActualTotalAvailableDuration { ValueType: String }
|
EDIXLSLinkColumn ActualTotalAvailableQuantity { ValueType: Real }
|
EDIXLSLinkColumn ActualUtilizationPercentage { ValueType: Real }
|
EDIXLSLinkColumn Date { ValueType: Date }
|
EDIXLSLinkColumn Description { ValueType: String }
|
EDIXLSLinkColumn UnitID { ValueType: String }
|
]
|
}
|
}
|
}
|
