Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MPSync_ImportShiftPatternsFromDBBroker
|
{
|
MDSDefinition: MPSync
|
EDIModelLink.Destination MPSync_DestinationShiftPatternsForImport
|
{
|
EDIMLTable IOShiftDay
|
{
|
PrimaryKeyColumns: ID
|
PrimaryKeyColumns: ShiftPatternName
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IOShiftDay
|
TypeIndex: IOShiftDayTypeIndex
|
WithSoftDelete: true
|
EDIMLColumn Capacity { Attribute: Capacity ValueType: Duration }
|
EDIMLColumn Day { Attribute: Day ValueType: Number }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn ShiftPatternName { Attribute: ShiftPatternName ValueType: String }
|
}
|
EDIMLTable IOShiftPattern
|
{
|
PrimaryKeyColumns: Name
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IOShiftPattern
|
TypeIndex: IOShiftPatternTypeIndex
|
WithSoftDelete: true
|
EDIMLColumn MinimumDuration { Attribute: MinimumDuration ValueType: Duration }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
}
|
EDIMLTable IOUnitShiftPattern
|
{
|
PrimaryKeyColumns: ShiftPatternName
|
PrimaryKeyColumns: UnitID
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IOUnitShiftPattern
|
TypeIndex: IOUnitShiftPatternTypeIndex
|
WithSoftDelete: true
|
EDIMLColumn IsAllowed { Attribute: IsAllowed ValueType: Boolean }
|
EDIMLColumn ShiftPatternName { Attribute: ShiftPatternName ValueType: String }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
}
|
}
|
EDIODBCLink.Source MPSync_SourceShiftPatternsForImport
|
{
|
DataIntegrityStrategy: 'Disabled'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.syncobject'
|
EDIODBCLinkTable ShiftDays
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: ID
|
PrimaryKeyColumns: ShiftPatternName
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn Capacity
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn Day
|
{
|
ValueType: Number
|
}
|
EDIODBCLinkColumn ID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ShiftPatternName
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable ShiftPatterns
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: Name
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn MinimumDuration
|
{
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn Name
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable UnitShiftPatterns
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: ShiftPatternName
|
PrimaryKeyColumns: UnitID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn IsAllowed
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn ShiftPatternName
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UnitID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
}
|
EDITransformation.Transformation MPSync_TransformationShiftPatternsForImport
|
{
|
EDITableTransformation
|
{
|
InputTable: ShiftDays
|
OutputTable: IOShiftDay
|
EDIColumnMatch
|
{
|
InputColumn: Day
|
OutputColumn: Day
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Capacity
|
OutputColumn: Capacity
|
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: ShiftPatternName
|
OutputColumn: ShiftPatternName
|
}
|
EDIColumnMatch
|
{
|
InputColumn: ID
|
OutputColumn: ID
|
}
|
}
|
EDITableTransformation
|
{
|
InputTable: ShiftPatterns
|
OutputTable: IOShiftPattern
|
EDIColumnMatch { InputColumn: MinimumDuration OutputColumn: MinimumDuration }
|
EDIColumnMatch
|
{
|
InputColumn: Name
|
OutputColumn: Name
|
}
|
}
|
EDITableTransformation
|
{
|
InputTable: UnitShiftPatterns
|
OutputTable: IOUnitShiftPattern
|
EDIColumnMatch { InputColumn: IsAllowed OutputColumn: IsAllowed }
|
EDIColumnMatch { InputColumn: ShiftPatternName OutputColumn: ShiftPatternName }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
}
|
}
|
}
|
