Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MP_ImportLanesBroker
|
{
|
MDSDefinition: MacroPlan
|
EDIModelLink.Destination OutputLanesToModel
|
{
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.outputlanestomodel'
|
EDIMLTable Lane
|
{
|
PrimaryKeyColumns: ID
|
TargetType: Lane
|
TypeIndex: LaneTypeIndex
|
EDIMLColumn End { Attribute: End ValueType: Date }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn IsEnabled { Attribute: IsEnabled ValueType: Boolean }
|
EDIMLColumn StandardDeviationLeadTimeLane { Attribute: StandardDeviationLeadTimeLane ValueType: Duration }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn SystemName { Attribute: SystemName ValueType: String }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
EDIMLColumn UserLeadTime { Attribute: UserLeadTime ValueType: Duration }
|
EDIMLTableOwner
|
{
|
TargetType: Unit
|
TypeIndex: UnitTypeIndex
|
EDIMLForeignKeyColumn
|
{
|
Column: UnitID
|
TypeIndexAttribute: ID
|
}
|
}
|
}
|
EDIMLTable LaneLeg
|
{
|
PrimaryKeyColumns: DestinationStockingPointID
|
PrimaryKeyColumns: LaneID
|
PrimaryKeyColumns: OriginStockingPointID
|
TargetType: LaneLeg
|
TypeIndex: LaneLegTypeIndex
|
EDIMLColumn CO2Emission { Attribute: CO2Emission ValueType: Real }
|
EDIMLColumn DestinationStockingPointID { Attribute: DestinationStockingPointID ValueType: String }
|
EDIMLColumn End { Attribute: End ValueType: Date }
|
EDIMLColumn HasStandardDeviationLeadTimeLaneLeg { Attribute: HasStandardDeviationLeadTimeLaneLeg ValueType: Boolean }
|
EDIMLColumn HasUserLeadTime { Attribute: HasUserLeadTime ValueType: Boolean }
|
EDIMLColumn IsEnabled { Attribute: IsEnabled ValueType: Boolean }
|
EDIMLColumn LaneID { Attribute: LaneID ValueType: String }
|
EDIMLColumn OriginStockingPointID { Attribute: OriginStockingPointID ValueType: String }
|
EDIMLColumn StandardDeviationLeadTimeLaneLeg { Attribute: StandardDeviationLeadTimeLaneLeg ValueType: Duration }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn SystemName { Attribute: SystemName ValueType: String }
|
EDIMLColumn UserLeadTime { Attribute: UserLeadTime ValueType: Duration }
|
EDIMLTableOwner
|
{
|
TargetType: Lane
|
TypeIndex: LaneTypeIndex
|
EDIMLForeignKeyColumn
|
{
|
Column: LaneID
|
TypeIndexAttribute: ID
|
}
|
}
|
}
|
EDIMLTable ProductInLane
|
{
|
PrimaryKeyColumns: LaneID
|
PrimaryKeyColumns: ProductID
|
TargetType: ProductInLane
|
TypeIndex: ProductInLaneTypeIndex
|
EDIMLColumn IsExcluded { Attribute: IsExcluded ValueType: Boolean }
|
EDIMLColumn LaneID { Attribute: LaneID ValueType: String }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLTableOwner
|
{
|
TargetType: Product_MP
|
TypeIndex: ProductTypeIndex
|
EDIMLForeignKeyColumn
|
{
|
Column: ProductID
|
TypeIndexAttribute: ID
|
}
|
}
|
}
|
}
|
EDITransformation.Transformation TransformLanesForImport
|
{
|
EDITableTransformation
|
{
|
InputTable: LaneLegs_MP
|
OutputTable: LaneLeg
|
EDIColumnMatch { InputColumn: CO2Emission OutputColumn: CO2Emission }
|
EDIColumnMatch
|
{
|
InputColumn: HasStandardDeviationLeadTimeLaneLeg
|
OutputColumn: HasStandardDeviationLeadTimeLaneLeg
|
}
|
EDIColumnMatch
|
{
|
InputColumn: UserLeadTime
|
OutputColumn: UserLeadTime
|
}
|
EDIColumnMatch
|
{
|
InputColumn: OriginStockingPointID
|
OutputColumn: OriginStockingPointID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Start
|
OutputColumn: Start
|
}
|
EDIColumnMatch
|
{
|
InputColumn: LaneID
|
OutputColumn: LaneID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: End
|
OutputColumn: End
|
}
|
EDIColumnMatch
|
{
|
InputColumn: DestinationStockingPointID
|
OutputColumn: DestinationStockingPointID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: IsEnabled
|
OutputColumn: IsEnabled
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Name
|
OutputColumn: SystemName
|
}
|
EDIColumnMatch
|
{
|
InputColumn: HasUserLeadTime
|
OutputColumn: HasUserLeadTime
|
}
|
EDIColumnMatch
|
{
|
InputColumn: StandardDeviationLeadTimeLaneLeg
|
OutputColumn: StandardDeviationLeadTimeLaneLeg
|
}
|
}
|
EDITableTransformation
|
{
|
InputTable: Lanes_MP
|
OutputTable: Lane
|
EDIColumnMatch
|
{
|
InputColumn: Start
|
OutputColumn: Start
|
}
|
EDIColumnMatch
|
{
|
InputColumn: UnitID
|
OutputColumn: UnitID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: End
|
OutputColumn: End
|
}
|
EDIColumnMatch
|
{
|
InputColumn: ID
|
OutputColumn: ID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: IsEnabled
|
OutputColumn: IsEnabled
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Name
|
OutputColumn: SystemName
|
}
|
EDIColumnMatch
|
{
|
InputColumn: UserLeadTime
|
OutputColumn: UserLeadTime
|
}
|
EDIColumnMatch
|
{
|
InputColumn: StandardDeviationLeadTimeLane
|
OutputColumn: StandardDeviationLeadTimeLane
|
}
|
}
|
EDITableTransformation
|
{
|
InputTable: ProductInLanes_MP
|
OutputTable: ProductInLane
|
EDIColumnMatch
|
{
|
InputColumn: IsExcluded
|
OutputColumn: IsExcluded
|
}
|
EDIColumnMatch
|
{
|
InputColumn: LaneID
|
OutputColumn: LaneID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: ProductID
|
OutputColumn: ProductID
|
}
|
}
|
}
|
EDIXLSLink.Source InputLanesFromExcel
|
{
|
FileName: 'MP_Lanes.xlsx'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.inputlanesfromexcel'
|
EDIXLSLinkTable LaneLegs_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn DestinationStockingPointID { ValueType: String }
|
EDIXLSLinkColumn End { ValueType: Date }
|
EDIXLSLinkColumn IsEnabled { ValueType: Boolean }
|
EDIXLSLinkColumn LaneID { ValueType: String }
|
EDIXLSLinkColumn Name { ValueType: String }
|
EDIXLSLinkColumn OriginStockingPointID { ValueType: String }
|
EDIXLSLinkColumn Start { ValueType: Date }
|
EDIXLSLinkColumn UserLeadTime { ValueType: Duration }
|
EDIXLSLinkColumn HasUserLeadTime { ValueType: Boolean }
|
EDIXLSLinkColumn HasStandardDeviationLeadTimeLaneLeg { ValueType: Boolean }
|
EDIXLSLinkColumn StandardDeviationLeadTimeLaneLeg { ValueType: Duration }
|
EDIXLSLinkColumn CO2Emission { ValueType: Real }
|
]
|
}
|
EDIXLSLinkTable Lanes_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn End { ValueType: Date }
|
EDIXLSLinkColumn ID { ValueType: String }
|
EDIXLSLinkColumn IsEnabled { ValueType: Boolean }
|
EDIXLSLinkColumn Name { ValueType: String }
|
EDIXLSLinkColumn Start { ValueType: Date }
|
EDIXLSLinkColumn UnitID { ValueType: String }
|
EDIXLSLinkColumn UserLeadTime { ValueType: Duration }
|
EDIXLSLinkColumn StandardDeviationLeadTimeLane { ValueType: Duration }
|
]
|
}
|
EDIXLSLinkTable ProductInLanes_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn IsExcluded { ValueType: Boolean }
|
EDIXLSLinkColumn ProductID { ValueType: String }
|
EDIXLSLinkColumn LaneID { ValueType: String }
|
]
|
}
|
}
|
}
|
