Quintiq file version 2.0 
 | 
#parent: #root 
 | 
EDIBroker MP_ExportSalesSegmentsBroker 
 | 
{ 
 | 
  MDSDefinition: MacroPlan 
 | 
  EDIModelLink.Source InputSalesSegmentsFromModel 
 | 
  { 
 | 
    SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.inputsalessegmentsfrommodel' 
 | 
    EDIMLTable SalesLevel_MP 
 | 
    { 
 | 
      PrimaryKeyColumns: Name 
 | 
      TargetType: SalesLevel_MP 
 | 
      TypeIndex: SalesLevelTypeIndex 
 | 
      EDIMLColumn Level { Attribute: Level ValueType: Number } 
 | 
      EDIMLColumn Name { Attribute: Name ValueType: String } 
 | 
    } 
 | 
    EDIMLTable SalesSegment_MP 
 | 
    { 
 | 
      PrimaryKeyColumns: Name 
 | 
      TargetType: SalesSegment_MP 
 | 
      TypeIndex: SalesSegmentTypeIndex 
 | 
      EDIMLColumn DisplayIndex { Attribute: DisplayIndex ValueType: Number } 
 | 
      EDIMLColumn Name { Attribute: Name ValueType: String } 
 | 
      EDIMLColumn ParentName { Attribute: ParentName ValueType: String } 
 | 
    } 
 | 
  } 
 | 
  EDITransformation.Transformation TransformSalesSegmentsForExport 
 | 
  { 
 | 
    EDITableTransformation 
 | 
    { 
 | 
      InputTable: SalesLevel_MP 
 | 
      OutputTable: SalesLevels_MP 
 | 
      EDIColumnMatch 
 | 
      { 
 | 
        InputColumn: Level 
 | 
        OutputColumn: Level 
 | 
      } 
 | 
      EDIColumnMatch 
 | 
      { 
 | 
        InputColumn: Name 
 | 
        OutputColumn: Name 
 | 
      } 
 | 
    } 
 | 
    EDITableTransformation 
 | 
    { 
 | 
      InputTable: SalesSegment_MP 
 | 
      OutputTable: SalesSegments_MP 
 | 
      EDIColumnMatch 
 | 
      { 
 | 
        InputColumn: Name 
 | 
        OutputColumn: Name 
 | 
      } 
 | 
      EDIColumnMatch 
 | 
      { 
 | 
        InputColumn: DisplayIndex 
 | 
        OutputColumn: DisplayIndex 
 | 
      } 
 | 
      EDIColumnMatch 
 | 
      { 
 | 
        InputColumn: ParentName 
 | 
        OutputColumn: ParentName 
 | 
      } 
 | 
    } 
 | 
  } 
 | 
  EDIXLSLink.Destination OutputSalesSegmentsToExcel 
 | 
  { 
 | 
    FileName: 'MP_SalesSegments' 
 | 
    SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.outputsalessegmentstoexcel' 
 | 
    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 } 
 | 
      ] 
 | 
    } 
 | 
  } 
 | 
} 
 |