Quintiq file version 2.0 
 | 
#parent: #root 
 | 
EDIBroker MPSync_ImportSalesSegmentsFromExcelBroker 
 | 
{ 
 | 
  MDSDefinition: MPSync 
 | 
  EDIModelLink.Destination MPSync_DestinationSalesSegmentsForExcelImport 
 | 
  { 
 | 
    SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.outputsalessegmentstomodel' 
 | 
    EDIMLTable IOSalesLevel_MP 
 | 
    { 
 | 
      PrimaryKeyColumns: Name 
 | 
      SoftDeleteAttribute: IsSoftDeleted 
 | 
      TargetType: IOSalesLevel_MP 
 | 
      TypeIndex: IOSalesLevelTypeIndex 
 | 
      WithSoftDelete: true 
 | 
      EDIMLColumn Level { Attribute: Level ValueType: Number } 
 | 
      EDIMLColumn Name { Attribute: Name ValueType: String } 
 | 
    } 
 | 
    EDIMLTable IOSalesSegment_MP 
 | 
    { 
 | 
      PrimaryKeyColumns: Name 
 | 
      SoftDeleteAttribute: IsSoftDeleted 
 | 
      TargetType: IOSalesSegment_MP 
 | 
      TypeIndex: IOSaleSegmentTypeIndex 
 | 
      WithSoftDelete: true 
 | 
      EDIMLColumn DisplayIndex { Attribute: DisplayIndex ValueType: Number } 
 | 
      EDIMLColumn Name { Attribute: Name ValueType: String } 
 | 
      EDIMLColumn ParentName { Attribute: ParentName ValueType: String } 
 | 
    } 
 | 
  } 
 | 
  EDITransformation.Transformation MPSync_TransformationSalesSegmentsForExcelImport 
 | 
  { 
 | 
    EDITableTransformation 
 | 
    { 
 | 
      InputTable: SalesLevels_MP 
 | 
      OutputTable: IOSalesLevel_MP 
 | 
      EDIColumnMatch { InputColumn: Level OutputColumn: Level } 
 | 
      EDIColumnMatch { InputColumn: Name OutputColumn: Name } 
 | 
    } 
 | 
    EDITableTransformation 
 | 
    { 
 | 
      InputTable: SalesSegments_MP 
 | 
      OutputTable: IOSalesSegment_MP 
 | 
      EDIColumnMatch { InputColumn: DisplayIndex OutputColumn: DisplayIndex } 
 | 
      EDIColumnMatch { InputColumn: Name OutputColumn: Name } 
 | 
      EDIColumnMatch { InputColumn: ParentName OutputColumn: ParentName } 
 | 
    } 
 | 
  } 
 | 
  EDIXLSLink.Source MPSync_SourceSalesSegmentsForExcelImport 
 | 
  { 
 | 
    FileName: 'MP_SalesSegments.xlsx' 
 | 
    SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.inputsalessegmentsfromexcel' 
 | 
    EDIXLSLinkTable SalesLevels_MP 
 | 
    { 
 | 
      Columns: 
 | 
      [ 
 | 
        EDIXLSLinkColumn Level { ValueType: Number } 
 | 
        EDIXLSLinkColumn Name { ValueType: String } 
 | 
      ] 
 | 
    } 
 | 
    EDIXLSLinkTable SalesSegments_MP 
 | 
    { 
 | 
      Columns: 
 | 
      [ 
 | 
        EDIXLSLinkColumn DisplayIndex { ValueType: Number } 
 | 
        EDIXLSLinkColumn Name { ValueType: String } 
 | 
        EDIXLSLinkColumn ParentName { ValueType: String } 
 | 
      ] 
 | 
    } 
 | 
  } 
 | 
} 
 |