Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MPSync_ImportGroupsFromExcelBroker
|
{
|
MDSDefinition: MPSync
|
EDIModelLink.Destination MPSync_DestinationGroupsForExcelImport
|
{
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.outputgroupstomodel'
|
EDIMLTable IOGroup
|
{
|
PrimaryKeyColumns: Name
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IOGroup
|
TypeIndex: IOGroupTypeIndex
|
WithSoftDelete: true
|
EDIMLColumn IconForStockingPoints { Attribute: IconForStockingPoints ValueType: String }
|
EDIMLColumn IconForUnits { Attribute: IconForUnits ValueType: String }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
}
|
}
|
EDITransformation.Transformation MPSync_TransformationGroupsForExcelImport
|
{
|
EDITableTransformation
|
{
|
InputTable: Groups_MP
|
OutputTable: IOGroup
|
EDIColumnMatch { InputColumn: IconForStockingPoints OutputColumn: IconForStockingPoints }
|
EDIColumnMatch { InputColumn: IconForUnits OutputColumn: IconForUnits }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
}
|
}
|
EDIXLSLink.Source MPSync_SourceGroupsForExcelImport
|
{
|
FileName: 'MP_Groups.xlsx'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.inputgroupsfromexcel'
|
EDIXLSLinkTable Groups_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn IconForStockingPoints { ValueType: String }
|
EDIXLSLinkColumn IconForUnits { ValueType: String }
|
EDIXLSLinkColumn Name { ValueType: String }
|
]
|
}
|
}
|
}
|
