Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MPSync_ImportTransportCapacitiesFromDBBroker
|
{
|
MDSDefinition: MPSync
|
EDIModelLink.Destination MPSync_DestinationTransportCapacitiesForImport
|
{
|
EDIMLTable IOTransportCapacity
|
{
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: UnitID
|
TargetType: IOTransportCapacity
|
TypeIndex: IOTransportCapacityTypeIndex
|
EDIMLColumn HasSecondaryCapacity { Attribute: HasSecondaryCapacity ValueType: Boolean }
|
EDIMLColumn LotSize { Attribute: LotSize ValueType: Real }
|
EDIMLColumn MaximumCapacity { Attribute: MaximumCapacity ValueType: Real }
|
EDIMLColumn MinimumCapacity { Attribute: MinimumCapacity ValueType: Real }
|
EDIMLColumn SecondaryLotSize { Attribute: SecondaryLotSize ValueType: Real }
|
EDIMLColumn SecondaryMaximumCapacity { Attribute: SecondaryMaximumCapacity ValueType: Real }
|
EDIMLColumn SecondaryMinimumCapacity { Attribute: SecondaryMinimumCapacity ValueType: Real }
|
EDIMLColumn SecondaryUnitOfMeasureName { Attribute: SecondaryUnitOfMeasureName ValueType: String }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn TimeUnit { Attribute: TimeUnit ValueType: String }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
}
|
}
|
EDIODBCLink.Source MPSync_SourceTransportCapacitiesForImport
|
{
|
DataIntegrityStrategy: 'Disabled'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.syncobject'
|
EDIODBCLinkTable TransportCapacities
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: UnitID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn HasSecondaryCapacity
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn LotSize
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn MaximumCapacity
|
{
|
ValueType: Real
|
}
|
EDIODBCLinkColumn MinimumCapacity
|
{
|
ValueType: Real
|
}
|
EDIODBCLinkColumn SecondaryLotSize
|
{
|
ValueType: Real
|
}
|
EDIODBCLinkColumn SecondaryMaximumCapacity
|
{
|
ValueType: Real
|
}
|
EDIODBCLinkColumn SecondaryMinimumCapacity
|
{
|
ValueType: Real
|
}
|
EDIODBCLinkColumn SecondaryUnitOfMeasureName
|
{
|
ValueType: String
|
}
|
EDIODBCLinkColumn Start
|
{
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn TimeUnit
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UnitID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
}
|
EDITransformation.Transformation MPSync_TransformationTransportCapacitiesForImport
|
{
|
EDITableTransformation
|
{
|
InputTable: TransportCapacities
|
OutputTable: IOTransportCapacity
|
EDIColumnMatch { InputColumn: HasSecondaryCapacity OutputColumn: HasSecondaryCapacity }
|
EDIColumnMatch { InputColumn: LotSize OutputColumn: LotSize }
|
EDIColumnMatch { InputColumn: MaximumCapacity OutputColumn: MaximumCapacity }
|
EDIColumnMatch { InputColumn: MinimumCapacity OutputColumn: MinimumCapacity }
|
EDIColumnMatch { InputColumn: SecondaryLotSize OutputColumn: SecondaryLotSize }
|
EDIColumnMatch { InputColumn: SecondaryMaximumCapacity OutputColumn: SecondaryMaximumCapacity }
|
EDIColumnMatch { InputColumn: SecondaryMinimumCapacity OutputColumn: SecondaryMinimumCapacity }
|
EDIColumnMatch { InputColumn: SecondaryUnitOfMeasureName OutputColumn: SecondaryUnitOfMeasureName }
|
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: TimeUnit OutputColumn: TimeUnit }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
}
|
}
|
}
|
