Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MP_ExportChangeLossSettingsBroker
|
{
|
MDSDefinition: MacroPlan
|
TimeZone: 'ACT'
|
UseOSTimeZone: false
|
EDIModelLink.Source InputChangeLossSettingsFromModel
|
{
|
EDIMLTable ChangeLossSettingExcel
|
{
|
TargetType: ChangeLossSettingExcel
|
EDIMLColumn ChangeLossNumber { Attribute: ChangeLossNumber ValueType: String }
|
EDIMLColumn EndDate { Attribute: EndDate ValueType: Date }
|
EDIMLColumn Product1 { Attribute: Product1 ValueType: String }
|
EDIMLColumn Product2 { Attribute: Product2 ValueType: String }
|
EDIMLColumn StartDate { Attribute: StartDate ValueType: Date }
|
EDIMLColumn Unit { Attribute: Unit ValueType: String }
|
}
|
}
|
EDITransformation.Transformation TransformChangeLossSettingsForExport
|
{
|
EDITableTransformation
|
{
|
InputTable: ChangeLossSettingExcel
|
OutputTable: ChangeoverLossSetting
|
EDIColumnMatch { InputColumn: ChangeLossNumber OutputColumn: ChangeLossNumber }
|
EDIColumnMatch { InputColumn: EndDate OutputColumn: EndDate }
|
EDIColumnMatch { InputColumn: Product1 OutputColumn: Product1 }
|
EDIColumnMatch { InputColumn: Product2 OutputColumn: Product2 }
|
EDIColumnMatch { InputColumn: StartDate OutputColumn: StartDate }
|
EDIColumnMatch { InputColumn: Unit OutputColumn: Unit }
|
}
|
}
|
EDIXLSLink.Destination OutputChangeLossSettingsToExcel
|
{
|
FileName: 'MP_ChangeoverLossSettings'
|
EDIXLSLinkTable ChangeoverLossSetting
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn Product1 { ValueType: String }
|
EDIXLSLinkColumn Product2 { ValueType: String }
|
EDIXLSLinkColumn Unit { ValueType: String }
|
EDIXLSLinkColumn StartDate { ValueType: Date }
|
EDIXLSLinkColumn EndDate { ValueType: Date }
|
EDIXLSLinkColumn ChangeLossNumber { ValueType: String }
|
]
|
}
|
}
|
}
|
