Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MPSync_ImportCampaignsFromDBBroker
|
{
|
MDSDefinition: MPSync
|
EDIModelLink.Destination MPSync_DestinationCampaignsForImport
|
{
|
EDIMLTable IOCampaignType_MP
|
{
|
PrimaryKeyColumns: Name
|
PrimaryKeyColumns: UnitID
|
TargetType: IOCampaignType_MP
|
TypeIndex: IOCampaignTypeTypeIndex
|
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 IOCampaign_MP
|
{
|
PrimaryKeyColumns: CampaignID
|
PrimaryKeyColumns: UnitID
|
TargetType: IOCampaign_MP
|
TypeIndex: IOCampaignTypeIndex
|
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 HasNextTransitionDurationByOpt { Attribute: HasNextTransitionDurationByOpt ValueType: String }
|
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 NextTransitionDurationByOpt { Attribute: NextTransitionDurationByOpt ValueType: Real }
|
EDIMLColumn OptNextCampaignTypeName { Attribute: OptNextCampaignTypeName ValueType: String }
|
EDIMLColumn SequenceNumber { Attribute: SequenceNumber ValueType: Number }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
}
|
EDIMLTable IOOperationInCampaignType
|
{
|
PrimaryKeyColumns: CampaignTypeName
|
PrimaryKeyColumns: OperationID
|
PrimaryKeyColumns: UnitID
|
TargetType: IOOperationInCampaignType
|
TypeIndex: IOOperationInCampaignTypeTypeIndex
|
EDIMLColumn CampaignTypeName { Attribute: CampaignTypeName ValueType: String }
|
EDIMLColumn OperationID { Attribute: OperationID ValueType: String }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
}
|
EDIMLTable IOOperationInTransitionType
|
{
|
PrimaryKeyColumns: OperationID
|
PrimaryKeyColumns: TransitionTypeName
|
PrimaryKeyColumns: UnitID
|
TargetType: IOOperationInTransitionType
|
TypeIndex: IOOperationInTransitionTypeTypeIndex
|
EDIMLColumn OperationID { Attribute: OperationID ValueType: String }
|
EDIMLColumn TransitionTypeName { Attribute: TransitionTypeName ValueType: String }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
}
|
EDIMLTable IOTransitionType_MP
|
{
|
PrimaryKeyColumns: Name
|
PrimaryKeyColumns: UnitID
|
TargetType: IOTransitionType_MP
|
TypeIndex: IOTransitionTypeTypeIndex
|
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 }
|
}
|
}
|
EDIODBCLink.Source MPSync_SourceCampaignsForImport
|
{
|
DataIntegrityStrategy: 'Disabled'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.syncobject'
|
EDIODBCLinkTable CampaignTypes
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: Name
|
PrimaryKeyColumns: UnitID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn Color
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DefaultMaxDuration
|
{
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn DefaultMaxQuantity
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn DefaultMinDuration
|
{
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn DefaultMinQuantity
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn HasInputMaxDuration
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn HasInputMaxQuantity
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn Name
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UnitID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable Campaign_MP
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: CampaignID
|
PrimaryKeyColumns: UnitID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn CampaignID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn CampaignTypeName
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Comment
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Duration
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn EarliestStart
|
{
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn HasInputMaxDuration
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn HasInputMaxQuantity
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn HasNextTransitionDurationByOpt
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MaxDuration
|
{
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn MaxQuantity
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn MinDuration
|
{
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn MinQuantity
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn NextTransitionDurationByOpt
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn OptNextCampaignTypeName
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn SequenceNumber
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn UnitID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable OperationInCampaignTypes
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: CampaignTypeName
|
PrimaryKeyColumns: OperationID
|
PrimaryKeyColumns: UnitID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn CampaignTypeName
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn OperationID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UnitID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable OperationInTransitionTypes
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: OperationID
|
PrimaryKeyColumns: TransitionTypeName
|
PrimaryKeyColumns: UnitID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn OperationID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn TransitionTypeName
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UnitID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable TransitionTypes
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: Name
|
PrimaryKeyColumns: UnitID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn DefaultMaxDuration
|
{
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn DefaultMaxQuantity
|
{
|
ValueType: Real
|
}
|
EDIODBCLinkColumn DefaultMinDuration
|
{
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn DefaultMinQuantity
|
{
|
ValueType: Real
|
}
|
EDIODBCLinkColumn FromCampaignTypeName
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn HasInputMaxDuration
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn HasInputMaxQuantity
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn Name
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ToCampaignTypeName
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UnitID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
}
|
EDITransformation.Transformation MPSync_TransitionCampaignsForImport
|
{
|
EDITableTransformation
|
{
|
InputTable: CampaignTypes
|
OutputTable: IOCampaignType_MP
|
EDIColumnMatch { InputColumn: DefaultMaxDuration OutputColumn: DefaultMaxDuration }
|
EDIColumnMatch { InputColumn: DefaultMinDuration OutputColumn: DefaultMinDuration }
|
EDIColumnMatch
|
{
|
InputColumn: DefaultMinQuantity
|
OutputColumn: DefaultMinQuantity
|
}
|
EDIColumnMatch
|
{
|
InputColumn: DefaultMaxQuantity
|
OutputColumn: DefaultMaxQuantity
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Color
|
OutputColumn: Color
|
}
|
EDIColumnMatch { InputColumn: HasInputMaxDuration OutputColumn: HasInputMaxDuration }
|
EDIColumnMatch { InputColumn: HasInputMaxQuantity OutputColumn: HasInputMaxQuantity }
|
EDIColumnMatch
|
{
|
InputColumn: UnitID
|
OutputColumn: UnitID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Name
|
OutputColumn: Name
|
}
|
}
|
EDITableTransformation
|
{
|
InputTable: Campaign_MP
|
OutputTable: IOCampaign_MP
|
EDIColumnMatch { InputColumn: CampaignID OutputColumn: CampaignID }
|
EDIColumnMatch { InputColumn: CampaignTypeName OutputColumn: CampaignTypeName }
|
EDIColumnMatch { InputColumn: Comment OutputColumn: Comment }
|
EDIColumnMatch
|
{
|
InputColumn: Duration
|
OutputColumn: Duration
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<RealToDuration xmlns="http://www.quintiq.com/GEB/RealToDuration" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<Conversion>RealToDays</Conversion>
|
</RealToDuration>
|
*]
|
}
|
}
|
EDIColumnMatch { InputColumn: EarliestStart OutputColumn: EarliestStart }
|
EDIColumnMatch { InputColumn: HasInputMaxDuration OutputColumn: HasInputMaxDuration }
|
EDIColumnMatch { InputColumn: HasInputMaxQuantity OutputColumn: HasInputMaxQuantity }
|
EDIColumnMatch { InputColumn: HasNextTransitionDurationByOpt OutputColumn: HasNextTransitionDurationByOpt }
|
EDIColumnMatch { InputColumn: MaxDuration OutputColumn: MaxDuration }
|
EDIColumnMatch { InputColumn: MaxQuantity OutputColumn: MaxQuantity }
|
EDIColumnMatch { InputColumn: MinDuration OutputColumn: MinDuration }
|
EDIColumnMatch { InputColumn: MinQuantity OutputColumn: MinQuantity }
|
EDIColumnMatch { InputColumn: NextTransitionDurationByOpt OutputColumn: NextTransitionDurationByOpt }
|
EDIColumnMatch { InputColumn: OptNextCampaignTypeName OutputColumn: OptNextCampaignTypeName }
|
EDIColumnMatch { InputColumn: SequenceNumber OutputColumn: SequenceNumber }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
}
|
EDITableTransformation
|
{
|
InputTable: OperationInCampaignTypes
|
OutputTable: IOOperationInCampaignType
|
EDIColumnMatch
|
{
|
InputColumn: UnitID
|
OutputColumn: UnitID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: OperationID
|
OutputColumn: OperationID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: CampaignTypeName
|
OutputColumn: CampaignTypeName
|
}
|
}
|
EDITableTransformation
|
{
|
InputTable: OperationInTransitionTypes
|
OutputTable: IOOperationInTransitionType
|
EDIColumnMatch { InputColumn: OperationID OutputColumn: OperationID }
|
EDIColumnMatch { InputColumn: TransitionTypeName OutputColumn: TransitionTypeName }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
}
|
EDITableTransformation
|
{
|
InputTable: TransitionTypes
|
OutputTable: IOTransitionType_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: ToCampaignTypeName
|
OutputColumn: ToCampaignTypeName
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Name
|
OutputColumn: Name
|
}
|
EDIColumnMatch
|
{
|
InputColumn: UnitID
|
OutputColumn: UnitID
|
}
|
}
|
}
|
}
|
