Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MPSync_ImportUnitAvailabilitiesFromDBBroker
|
{
|
MDSDefinition: MPSync
|
EDIModelLink.Destination MPSync_DestinationUnitAvailabilitiesForImport
|
{
|
EDIMLTable IOUnitAvailability
|
{
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: UnitID
|
TargetType: IOUnitAvailability
|
TypeIndex: IOUnitAvailabilityTypeIndex
|
EDIMLColumn Allocation { Attribute: Allocation ValueType: Real }
|
EDIMLColumn Efficiency { Attribute: Efficiency ValueType: Real }
|
EDIMLColumn Maintenance { Attribute: Maintenance ValueType: Duration }
|
EDIMLColumn MaximumLoadPercentage { Attribute: MaximumLoadPercentage ValueType: Real }
|
EDIMLColumn MinimumLoadThreshold { Attribute: MinimumLoadThreshold ValueType: Real }
|
EDIMLColumn NrOfUnitsOpen { Attribute: NrOfUnitsOpen ValueType: Number }
|
EDIMLColumn ShiftPatternName { Attribute: ShiftPatternName ValueType: String }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn TimeUnit { Attribute: TimeUnit ValueType: String }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
}
|
}
|
EDIODBCLink.Source MPSync_SourceUnitAvailabilitiesForImport
|
{
|
DataIntegrityStrategy: 'Disabled'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.syncobject'
|
EDIODBCLinkTable UnitAvailabilities
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: UnitID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn Allocation
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn Efficiency
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn Maintenance
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn MaximumLoadPercentage
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn MinimumLoadThreshold
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn NrOfUnitsOpen
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn ShiftPatternName
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Start
|
{
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn TimeUnit
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UnitID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
}
|
EDITransformation.Transformation MPSync_TransformationUnitAvailabilitiesForImport
|
{
|
EDITableTransformation
|
{
|
InputTable: UnitAvailabilities
|
OutputTable: IOUnitAvailability
|
EDIColumnMatch
|
{
|
InputColumn: Maintenance
|
OutputColumn: Maintenance
|
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: MinimumLoadThreshold
|
OutputColumn: MinimumLoadThreshold
|
}
|
EDIColumnMatch
|
{
|
InputColumn: MaximumLoadPercentage
|
OutputColumn: MaximumLoadPercentage
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Allocation
|
OutputColumn: Allocation
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Efficiency
|
OutputColumn: Efficiency
|
}
|
EDIColumnMatch
|
{
|
InputColumn: TimeUnit
|
OutputColumn: TimeUnit
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Start
|
OutputColumn: Start
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<DateTimeToDate xmlns="http://www.quintiq.com/GEB/DateTimeToDate" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
</DateTimeToDate>
|
*]
|
}
|
}
|
EDIColumnMatch
|
{
|
InputColumn: NrOfUnitsOpen
|
OutputColumn: NrOfUnitsOpen
|
}
|
EDIColumnMatch
|
{
|
InputColumn: UnitID
|
OutputColumn: UnitID
|
}
|
}
|
}
|
}
|
