Quintiq file version 2.0
|
#parent: #root
|
EDIBroker SM_ImportBookmarksBroker
|
{
|
MDSDefinition: ScenarioManager
|
EDIModelLink.Destination OutputBookmarksToModel
|
{
|
EDIMLTable Bookmark
|
{
|
PrimaryKeyColumns: Name
|
TargetType: Bookmark
|
TypeIndex: BookmarkTypeIndex
|
EDIMLColumn IsFolder { Attribute: IsFolder ValueType: Boolean }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn ParentName { Attribute: ParentName ValueType: String }
|
}
|
EDIMLTable BookmarkPeriodSpecificationElement
|
{
|
PrimaryKeyColumns: BookmarkName
|
PrimaryKeyColumns: PeriodSpecificationID
|
TargetType: BookmarkPeriodSpecificationElement
|
TypeIndex: BookmarkPeriodSpecificationTypeIndex
|
EDIMLColumn BookmarkName { Attribute: BookmarkName ValueType: String }
|
EDIMLColumn PeriodSpecificationID { Attribute: PeriodSpecificationID ValueType: String }
|
EDIMLTableOwner
|
{
|
TargetType: Bookmark
|
TypeIndex: BookmarkTypeIndex
|
EDIMLForeignKeyColumn
|
{
|
Column: BookmarkName
|
TypeIndexAttribute: Name
|
}
|
}
|
}
|
EDIMLTable BookmarkPeriodSpecificationPeriodElement
|
{
|
PrimaryKeyColumns: BookmarkName
|
PrimaryKeyColumns: PeriodEnd
|
PrimaryKeyColumns: PeriodSpecificationID
|
PrimaryKeyColumns: PeriodStart
|
TargetType: BookmarkPeriodSpecificationPeriodElement
|
TypeIndex: BookmarkPeriodSpecificationPeriodTypeIndex
|
EDIMLColumn BookmarkName { Attribute: BookmarkName ValueType: String }
|
EDIMLColumn PeriodEnd { Attribute: PeriodEnd ValueType: DateTime }
|
EDIMLColumn PeriodSpecificationID { Attribute: PeriodSpecificationID ValueType: String }
|
EDIMLColumn PeriodStart { Attribute: PeriodStart ValueType: DateTime }
|
EDIMLColumn UniqueIdentifier { Attribute: UniqueIdentifier ValueType: String }
|
EDIMLTableOwner
|
{
|
TargetType: Bookmark
|
TypeIndex: BookmarkTypeIndex
|
EDIMLForeignKeyColumn
|
{
|
Column: BookmarkName
|
TypeIndexAttribute: Name
|
}
|
}
|
}
|
EDIMLTable BookmarkProductElement
|
{
|
PrimaryKeyColumns: BookmarkName
|
PrimaryKeyColumns: ProductID
|
TargetType: BookmarkProductElement
|
TypeIndex: BookmarkProductTypeIndex
|
EDIMLColumn BookmarkName { Attribute: BookmarkName ValueType: String }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLTableOwner
|
{
|
TargetType: Bookmark
|
TypeIndex: BookmarkTypeIndex
|
EDIMLForeignKeyColumn
|
{
|
Column: BookmarkName
|
TypeIndexAttribute: Name
|
}
|
}
|
}
|
EDIMLTable BookmarkSalesSegmentElement
|
{
|
PrimaryKeyColumns: BookmarkName
|
PrimaryKeyColumns: SalesSegmentName
|
TargetType: BookmarkSalesSegmentElement
|
TypeIndex: BookmarkSalesSegmentTypeIndex
|
EDIMLColumn BookmarkName { Attribute: BookmarkName ValueType: String }
|
EDIMLColumn SalesSegmentName { Attribute: SalesSegmentName ValueType: String }
|
EDIMLTableOwner
|
{
|
TargetType: Bookmark
|
TypeIndex: BookmarkTypeIndex
|
EDIMLForeignKeyColumn
|
{
|
Column: BookmarkName
|
TypeIndexAttribute: Name
|
}
|
}
|
}
|
EDIMLTable BookmarkStockingPointElement
|
{
|
PrimaryKeyColumns: BookmarkName
|
PrimaryKeyColumns: StockingPointID
|
TargetType: BookmarkStockingPointElement
|
TypeIndex: BookmarkStockingPointTypeIndex
|
EDIMLColumn BookmarkName { Attribute: BookmarkName ValueType: String }
|
EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
|
EDIMLTableOwner
|
{
|
TargetType: Bookmark
|
TypeIndex: BookmarkTypeIndex
|
EDIMLForeignKeyColumn
|
{
|
Column: BookmarkName
|
TypeIndexAttribute: Name
|
}
|
}
|
}
|
EDIMLTable BookmarkUnitElement
|
{
|
PrimaryKeyColumns: BookmarkName
|
PrimaryKeyColumns: UnitID
|
TargetType: BookmarkUnitElement
|
TypeIndex: BookmarkUnitTypeIndex
|
EDIMLColumn BookmarkName { Attribute: BookmarkName ValueType: String }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
EDIMLTableOwner
|
{
|
TargetType: Bookmark
|
TypeIndex: BookmarkTypeIndex
|
EDIMLForeignKeyColumn
|
{
|
Column: BookmarkName
|
TypeIndexAttribute: Name
|
}
|
}
|
}
|
}
|
EDITransformation.Transformation TransformBookmarksForImport
|
{
|
EDITableTransformation
|
{
|
InputTable: BookmarkPSPElements_SM
|
OutputTable: BookmarkPeriodSpecificationPeriodElement
|
EDIColumnMatch { InputColumn: BookmarkName OutputColumn: BookmarkName }
|
EDIColumnMatch { InputColumn: PeriodEnd OutputColumn: PeriodEnd }
|
EDIColumnMatch { InputColumn: PeriodSpecificationID OutputColumn: PeriodSpecificationID }
|
EDIColumnMatch { InputColumn: PeriodStart OutputColumn: PeriodStart }
|
EDIColumnMatch { InputColumn: UniqueIdentifier OutputColumn: UniqueIdentifier }
|
}
|
EDITableTransformation
|
{
|
InputTable: BookmarkPeriodSpecElements_SM
|
OutputTable: BookmarkPeriodSpecificationElement
|
EDIColumnMatch { InputColumn: BookmarkName OutputColumn: BookmarkName }
|
EDIColumnMatch { InputColumn: PeriodSpecificationID OutputColumn: PeriodSpecificationID }
|
}
|
EDITableTransformation
|
{
|
InputTable: BookmarkProductElements_SM
|
OutputTable: BookmarkProductElement
|
EDIColumnMatch
|
{
|
InputColumn: BookmarkName
|
OutputColumn: BookmarkName
|
}
|
EDIColumnMatch
|
{
|
InputColumn: ProductID
|
OutputColumn: ProductID
|
}
|
}
|
EDITableTransformation
|
{
|
InputTable: BookmarkSalesSegmentElements_SM
|
OutputTable: BookmarkSalesSegmentElement
|
EDIColumnMatch
|
{
|
InputColumn: BookmarkName
|
OutputColumn: BookmarkName
|
}
|
EDIColumnMatch
|
{
|
InputColumn: SalesSegmentName
|
OutputColumn: SalesSegmentName
|
}
|
}
|
EDITableTransformation
|
{
|
InputTable: BookmarkStockingPointElements_S
|
OutputTable: BookmarkStockingPointElement
|
EDIColumnMatch
|
{
|
InputColumn: BookmarkName
|
OutputColumn: BookmarkName
|
}
|
EDIColumnMatch
|
{
|
InputColumn: StockingPointID
|
OutputColumn: StockingPointID
|
}
|
}
|
EDITableTransformation
|
{
|
InputTable: BookmarkUnitElements_SM
|
OutputTable: BookmarkUnitElement
|
EDIColumnMatch
|
{
|
InputColumn: BookmarkName
|
OutputColumn: BookmarkName
|
}
|
EDIColumnMatch
|
{
|
InputColumn: UnitID
|
OutputColumn: UnitID
|
}
|
}
|
EDITableTransformation
|
{
|
InputTable: Bookmarks_SM
|
OutputTable: Bookmark
|
EDIColumnMatch
|
{
|
InputColumn: IsFolder
|
OutputColumn: IsFolder
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Name
|
OutputColumn: Name
|
}
|
EDIColumnMatch
|
{
|
InputColumn: ParentName
|
OutputColumn: ParentName
|
}
|
}
|
}
|
EDIXLSLink.Source ImportBookmarksFromExcel
|
{
|
FileName: 'SM_Bookmarks.xlsx'
|
EDIXLSLinkTable BookmarkPSPElements_SM
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn BookmarkName { ValueType: String }
|
EDIXLSLinkColumn PeriodSpecificationID { ValueType: String }
|
EDIXLSLinkColumn PeriodStart { ValueType: DateTime }
|
EDIXLSLinkColumn PeriodEnd { ValueType: DateTime }
|
EDIXLSLinkColumn UniqueIdentifier { ValueType: String }
|
]
|
}
|
EDIXLSLinkTable BookmarkPeriodSpecElements_SM
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn BookmarkName { ValueType: String }
|
EDIXLSLinkColumn PeriodSpecificationID { ValueType: String }
|
]
|
}
|
EDIXLSLinkTable BookmarkProductElements_SM
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn BookmarkName { ValueType: String }
|
EDIXLSLinkColumn ProductID { ValueType: String }
|
]
|
}
|
EDIXLSLinkTable BookmarkSalesSegmentElements_SM
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn BookmarkName { ValueType: String }
|
EDIXLSLinkColumn SalesSegmentName { ValueType: String }
|
]
|
}
|
EDIXLSLinkTable BookmarkStockingPointElements_S
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn BookmarkName { ValueType: String }
|
EDIXLSLinkColumn StockingPointID { ValueType: String }
|
]
|
}
|
EDIXLSLinkTable BookmarkUnitElements_SM
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn BookmarkName { ValueType: String }
|
EDIXLSLinkColumn UnitID { ValueType: String }
|
]
|
}
|
EDIXLSLinkTable Bookmarks_SM
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn IsFolder { ValueType: String }
|
EDIXLSLinkColumn Name { ValueType: String }
|
EDIXLSLinkColumn ParentName { ValueType: String }
|
]
|
}
|
}
|
}
|
