Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MP_ExportCampaignsBroker
|
{
|
MDSDefinition: MacroPlan
|
EDIModelLink.Source OutputCampaignsFromModel
|
{
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.outputcampaignsfrommodel'
|
EDIMLTable CampaignType_MP
|
{
|
PrimaryKeyColumns: Name
|
PrimaryKeyColumns: UnitID
|
TargetType: CampaignType_MP
|
TypeIndex: CampaignTypeTypeIndex
|
EDIMLColumn Color { Attribute: Color ValueType: String }
|
EDIMLColumn DefaultMaxDuration { Attribute: DefaultMaxDuration ValueType: Duration }
|
EDIMLColumn DefaultMaxQuantity { Attribute: DefaultMaxQuantity ValueType: Real }
|
EDIMLColumn DefaultMinDuration { Attribute: DefaultMinDuration ValueType: Duration }
|
EDIMLColumn DefaultMinQuantity { Attribute: DefaultMinQuantity ValueType: Real }
|
EDIMLColumn HasInputMaxDuration { Attribute: HasInputMaxDuration ValueType: Boolean }
|
EDIMLColumn HasInputMaxQuantity { Attribute: HasInputMaxQuantity ValueType: Boolean }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
}
|
EDIMLTable Campaign_MP
|
{
|
PrimaryKeyColumns: CampaignID
|
PrimaryKeyColumns: UnitID
|
TargetType: Campaign_MP
|
TypeIndex: CampaignTypeIndex
|
EDIMLColumn CampaignID { Attribute: CampaignID ValueType: String }
|
EDIMLColumn CampaignTypeName { Attribute: CampaignTypeName ValueType: String }
|
EDIMLColumn Comment { Attribute: Comment ValueType: String }
|
EDIMLColumn Duration { Attribute: Duration ValueType: Duration }
|
EDIMLColumn EarliestStart { Attribute: EarliestStart ValueType: DateTime }
|
EDIMLColumn HasInputMaxDuration { Attribute: HasInputMaxDuration ValueType: Boolean }
|
EDIMLColumn HasInputMaxQuantity { Attribute: HasInputMaxQuantity ValueType: Boolean }
|
EDIMLColumn MaxDuration { Attribute: MaxDuration ValueType: Duration }
|
EDIMLColumn MaxQuantity { Attribute: MaxQuantity ValueType: Real }
|
EDIMLColumn MinDuration { Attribute: MinDuration ValueType: Duration }
|
EDIMLColumn MinQuantity { Attribute: MinQuantity ValueType: Real }
|
EDIMLColumn SequenceNumber { Attribute: SequenceNumber ValueType: Number }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
EDIMLColumn HasNextTransitionDurationByOpt { Attribute: HasNextTransitionDurationByOpt ValueType: Boolean }
|
EDIMLColumn NextTransitionDurationByOpt { Attribute: NextTransitionDurationByOpt ValueType: Duration }
|
EDIMLColumn OptNextCampaignTypeName { Attribute: OptNextCampaignTypeName ValueType: String }
|
}
|
EDIMLTable OperationInCampaignType
|
{
|
PrimaryKeyColumns: CampaignTypeName
|
PrimaryKeyColumns: OperationID
|
PrimaryKeyColumns: UnitID
|
TargetType: OperationInCampaignType
|
TypeIndex: OperationInCampaignTypeTypeIndex
|
EDIMLColumn CampaignTypeName { Attribute: CampaignTypeName ValueType: String }
|
EDIMLColumn OperationID { Attribute: OperationID ValueType: String }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
}
|
EDIMLTable OperationInTransitionType
|
{
|
PrimaryKeyColumns: OperationID
|
PrimaryKeyColumns: TransitionTypeName
|
PrimaryKeyColumns: UnitID
|
TargetType: OperationInTransitionType
|
TypeIndex: OperationInTransitionTypeTypeIndex
|
EDIMLColumn OperationID { Attribute: OperationID ValueType: String }
|
EDIMLColumn TransitionTypeName { Attribute: TransitionTypeName ValueType: String }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
}
|
EDIMLTable TransitionType_MP
|
{
|
PrimaryKeyColumns: Name
|
PrimaryKeyColumns: UnitID
|
TargetType: TransitionType_MP
|
TypeIndex: TransitionTypeTypeIndex
|
EDIMLColumn DefaultMaxDuration { Attribute: DefaultMaxDuration ValueType: Duration }
|
EDIMLColumn DefaultMaxQuantity { Attribute: DefaultMaxQuantity ValueType: Real }
|
EDIMLColumn DefaultMinDuration { Attribute: DefaultMinDuration ValueType: Duration }
|
EDIMLColumn DefaultMinQuantity { Attribute: DefaultMinQuantity ValueType: Real }
|
EDIMLColumn FromCampaignTypeName { Attribute: FromCampaignTypeName ValueType: String }
|
EDIMLColumn HasInputMaxDuration { Attribute: HasInputMaxDuration ValueType: Boolean }
|
EDIMLColumn HasInputMaxQuantity { Attribute: HasInputMaxQuantity ValueType: Boolean }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn ToCampaignTypeName { Attribute: ToCampaignTypeName ValueType: String }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
}
|
}
|
EDITransformation.Transformation TransformCampaignsForExport
|
{
|
EDITableTransformation
|
{
|
InputTable: CampaignType_MP
|
OutputTable: CampaignTypes_MP
|
EDIColumnMatch { InputColumn: Color OutputColumn: Color }
|
EDIColumnMatch { InputColumn: DefaultMaxDuration OutputColumn: DefaultMaxDuration }
|
EDIColumnMatch { InputColumn: DefaultMaxQuantity OutputColumn: DefaultMaxQuantity }
|
EDIColumnMatch { InputColumn: DefaultMinDuration OutputColumn: DefaultMinDuration }
|
EDIColumnMatch { InputColumn: DefaultMinQuantity OutputColumn: DefaultMinQuantity }
|
EDIColumnMatch { InputColumn: HasInputMaxDuration OutputColumn: HasInputMaxDuration }
|
EDIColumnMatch { InputColumn: HasInputMaxQuantity OutputColumn: HasInputMaxQuantity }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
}
|
EDITableTransformation
|
{
|
InputTable: Campaign_MP
|
OutputTable: Campaign_MP
|
EDIColumnMatch { InputColumn: CampaignID OutputColumn: CampaignID }
|
EDIColumnMatch { InputColumn: CampaignTypeName OutputColumn: CampaignTypeName }
|
EDIColumnMatch { InputColumn: Comment OutputColumn: Comment }
|
EDIColumnMatch { InputColumn: Duration OutputColumn: Duration }
|
EDIColumnMatch { InputColumn: EarliestStart OutputColumn: EarliestStart }
|
EDIColumnMatch { InputColumn: HasInputMaxDuration OutputColumn: HasInputMaxDuration }
|
EDIColumnMatch { InputColumn: HasInputMaxQuantity OutputColumn: HasInputMaxQuantity }
|
EDIColumnMatch { InputColumn: MaxDuration OutputColumn: MaxDuration }
|
EDIColumnMatch { InputColumn: MaxQuantity OutputColumn: MaxQuantity }
|
EDIColumnMatch { InputColumn: MinDuration OutputColumn: MinDuration }
|
EDIColumnMatch { InputColumn: MinQuantity OutputColumn: MinQuantity }
|
EDIColumnMatch { InputColumn: SequenceNumber OutputColumn: SequenceNumber }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
EDIColumnMatch { InputColumn: HasNextTransitionDurationByOpt OutputColumn: HasNextTransitionDurationByOpt }
|
EDIColumnMatch { InputColumn: NextTransitionDurationByOpt OutputColumn: NextTransitionDurationByOpt }
|
EDIColumnMatch { InputColumn: OptNextCampaignTypeName OutputColumn: OptNextCampaignTypeName }
|
}
|
EDITableTransformation
|
{
|
InputTable: OperationInCampaignType
|
OutputTable: OperationInCampaignTypes_MP
|
EDIColumnMatch { InputColumn: CampaignTypeName OutputColumn: CampaignTypeName }
|
EDIColumnMatch { InputColumn: OperationID OutputColumn: OperationID }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
}
|
EDITableTransformation
|
{
|
InputTable: OperationInTransitionType
|
OutputTable: OperationInTransitionTypes_MP
|
EDIColumnMatch { InputColumn: OperationID OutputColumn: OperationID }
|
EDIColumnMatch { InputColumn: TransitionTypeName OutputColumn: TransitionTypeName }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
}
|
EDITableTransformation
|
{
|
InputTable: TransitionType_MP
|
OutputTable: TransitionTypes_MP
|
EDIColumnMatch { InputColumn: DefaultMaxDuration OutputColumn: DefaultMaxDuration }
|
EDIColumnMatch { InputColumn: DefaultMaxQuantity OutputColumn: DefaultMaxQuantity }
|
EDIColumnMatch { InputColumn: DefaultMinDuration OutputColumn: DefaultMinDuration }
|
EDIColumnMatch { InputColumn: DefaultMinQuantity OutputColumn: DefaultMinQuantity }
|
EDIColumnMatch { InputColumn: FromCampaignTypeName OutputColumn: FromCampaignTypeName }
|
EDIColumnMatch { InputColumn: HasInputMaxDuration OutputColumn: HasInputMaxDuration }
|
EDIColumnMatch { InputColumn: HasInputMaxQuantity OutputColumn: HasInputMaxQuantity }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
EDIColumnMatch { InputColumn: ToCampaignTypeName OutputColumn: ToCampaignTypeName }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
}
|
}
|
EDIXLSLink.Destination OutputCampaignsToExcel
|
{
|
FileName: 'MP_Campaigns'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.outputcampaignstoexcel'
|
EDIXLSLinkTable CampaignTypes_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn Color { ValueType: String }
|
EDIXLSLinkColumn DefaultMaxDuration { ValueType: Duration }
|
EDIXLSLinkColumn DefaultMaxQuantity { ValueType: Real }
|
EDIXLSLinkColumn DefaultMinDuration { ValueType: Duration }
|
EDIXLSLinkColumn DefaultMinQuantity { ValueType: Real }
|
EDIXLSLinkColumn HasInputMaxDuration { ValueType: Boolean }
|
EDIXLSLinkColumn HasInputMaxQuantity { ValueType: Boolean }
|
EDIXLSLinkColumn Name { ValueType: String }
|
EDIXLSLinkColumn UnitID { ValueType: String }
|
]
|
}
|
EDIXLSLinkTable Campaign_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn CampaignID { ValueType: String }
|
EDIXLSLinkColumn CampaignTypeName { ValueType: String }
|
EDIXLSLinkColumn Comment { ValueType: String }
|
EDIXLSLinkColumn Duration { ValueType: Duration }
|
EDIXLSLinkColumn EarliestStart { ValueType: DateTime }
|
EDIXLSLinkColumn HasInputMaxDuration { ValueType: Boolean }
|
EDIXLSLinkColumn HasInputMaxQuantity { ValueType: Boolean }
|
EDIXLSLinkColumn MaxDuration { ValueType: Duration }
|
EDIXLSLinkColumn MaxQuantity { ValueType: Real }
|
EDIXLSLinkColumn MinDuration { ValueType: Duration }
|
EDIXLSLinkColumn MinQuantity { ValueType: Real }
|
EDIXLSLinkColumn SequenceNumber { ValueType: Number }
|
EDIXLSLinkColumn UnitID { ValueType: String }
|
EDIXLSLinkColumn HasNextTransitionDurationByOpt { ValueType: Boolean }
|
EDIXLSLinkColumn NextTransitionDurationByOpt { ValueType: Duration }
|
EDIXLSLinkColumn OptNextCampaignTypeName { ValueType: String }
|
]
|
}
|
EDIXLSLinkTable OperationInCampaignTypes_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn CampaignTypeName { ValueType: String }
|
EDIXLSLinkColumn OperationID { ValueType: String }
|
EDIXLSLinkColumn UnitID { ValueType: String }
|
]
|
}
|
EDIXLSLinkTable OperationInTransitionTypes_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn OperationID { ValueType: String }
|
EDIXLSLinkColumn TransitionTypeName { ValueType: String }
|
EDIXLSLinkColumn UnitID { ValueType: String }
|
]
|
}
|
EDIXLSLinkTable TransitionTypes_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn DefaultMaxDuration { ValueType: Duration }
|
EDIXLSLinkColumn DefaultMaxQuantity { ValueType: Real }
|
EDIXLSLinkColumn DefaultMinDuration { ValueType: Duration }
|
EDIXLSLinkColumn DefaultMinQuantity { ValueType: Real }
|
EDIXLSLinkColumn FromCampaignTypeName { ValueType: String }
|
EDIXLSLinkColumn HasInputMaxDuration { ValueType: Boolean }
|
EDIXLSLinkColumn HasInputMaxQuantity { ValueType: Boolean }
|
EDIXLSLinkColumn Name { ValueType: String }
|
EDIXLSLinkColumn ToCampaignTypeName { ValueType: String }
|
EDIXLSLinkColumn UnitID { ValueType: String }
|
]
|
}
|
}
|
}
|
