Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MPSync_ImportLanesFromDBBroker
|
{
|
MDSDefinition: MPSync
|
EDIModelLink.Destination MPSync_DestinationLaneForImport
|
{
|
EDIMLTable IOLane
|
{
|
PrimaryKeyColumns: ID
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IOLane
|
TypeIndex: IOLaneTypeIndex
|
WithSoftDelete: true
|
EDIMLColumn End { Attribute: End ValueType: Date }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn IsEnabled { Attribute: IsEnabled ValueType: Boolean }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn StandardDeviationLeadTimeLane { Attribute: StandardDeviationLeadTimeLane ValueType: Duration }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
EDIMLColumn UserLeadTime { Attribute: UserLeadTime ValueType: Duration }
|
}
|
EDIMLTable IOLaneLeg
|
{
|
PrimaryKeyColumns: DestinationStockingPointID
|
PrimaryKeyColumns: LaneID
|
PrimaryKeyColumns: OriginStockingPointID
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IOLaneLeg
|
TypeIndex: IOLaneLegTypeIndex
|
WithSoftDelete: true
|
EDIMLColumn CO2Emission { Attribute: CO2Emission ValueType: Real }
|
EDIMLColumn DestinationStockingPointID { Attribute: DestinationStockingPointID ValueType: String }
|
EDIMLColumn End { Attribute: End ValueType: Date }
|
EDIMLColumn HasStandardDeviationLeadTimeLaneLeg { Attribute: HasStandardDeviationLeadTimeLaneLeg ValueType: Boolean }
|
EDIMLColumn HasUserLeadTime { Attribute: HasUserLeadTime ValueType: Boolean }
|
EDIMLColumn IsEnabled { Attribute: IsEnabled ValueType: Boolean }
|
EDIMLColumn LaneID { Attribute: LaneID ValueType: String }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn OriginStockingPointID { Attribute: OriginStockingPointID ValueType: String }
|
EDIMLColumn StandardDeviationLeadTimeLaneLeg { Attribute: StandardDeviationLeadTimeLaneLeg ValueType: Duration }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn UserLeadTime { Attribute: UserLeadTime ValueType: Duration }
|
}
|
EDIMLTable IOProductInLane
|
{
|
PrimaryKeyColumns: LaneID
|
PrimaryKeyColumns: ProductID
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IOProductInLane
|
TypeIndex: IOProductInLaneTypeIndex
|
WithSoftDelete: true
|
EDIMLColumn IsExcluded { Attribute: IsExcluded ValueType: Boolean }
|
EDIMLColumn LaneID { Attribute: LaneID ValueType: String }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
}
|
}
|
EDIODBCLink.Source MPSync_SourceLaneForImport
|
{
|
DataIntegrityStrategy: 'Disabled'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.syncobject'
|
EDIODBCLinkTable LaneLegs
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: DestinationStockingPointID
|
PrimaryKeyColumns: LaneID
|
PrimaryKeyColumns: OriginStockingPointID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn CO2Emission
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn DestinationStockingPointID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn End
|
{
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn HasStandardDeviationLeadTimeLaneLeg
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn HasUserLeadTime
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsEnabled
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn LaneID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Name
|
{
|
ValueType: String
|
}
|
EDIODBCLinkColumn OriginStockingPointID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn StandardDeviationLeadTimeLaneLeg
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn Start
|
{
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn UserLeadTime
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
}
|
EDIODBCLinkTable Lanes
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn End
|
{
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn ID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn IsEnabled
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn Name
|
{
|
ValueType: String
|
}
|
EDIODBCLinkColumn StandardDeviationLeadTimeLane
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn Start
|
{
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn UnitID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UserLeadTime
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
}
|
EDIODBCLinkTable ProductInLanes
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: LaneID
|
PrimaryKeyColumns: ProductID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn IsExcluded
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn LaneID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ProductID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
}
|
EDITransformation.Transformation MPSync_TransformationLaneForImport
|
{
|
EDITableTransformation
|
{
|
InputTable: LaneLegs
|
OutputTable: IOLaneLeg
|
EDIColumnMatch { InputColumn: CO2Emission OutputColumn: CO2Emission }
|
EDIColumnMatch { InputColumn: DestinationStockingPointID OutputColumn: DestinationStockingPointID }
|
EDIColumnMatch
|
{
|
InputColumn: End
|
OutputColumn: End
|
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: HasStandardDeviationLeadTimeLaneLeg OutputColumn: HasStandardDeviationLeadTimeLaneLeg }
|
EDIColumnMatch { InputColumn: HasUserLeadTime OutputColumn: HasUserLeadTime }
|
EDIColumnMatch { InputColumn: IsEnabled OutputColumn: IsEnabled }
|
EDIColumnMatch { InputColumn: LaneID OutputColumn: LaneID }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
EDIColumnMatch { InputColumn: OriginStockingPointID OutputColumn: OriginStockingPointID }
|
EDIColumnMatch
|
{
|
InputColumn: StandardDeviationLeadTimeLaneLeg
|
OutputColumn: StandardDeviationLeadTimeLaneLeg
|
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: 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: UserLeadTime
|
OutputColumn: UserLeadTime
|
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>
|
*]
|
}
|
}
|
}
|
EDITableTransformation
|
{
|
InputTable: Lanes
|
OutputTable: IOLane
|
EDIColumnMatch
|
{
|
InputColumn: End
|
OutputColumn: End
|
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: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: IsEnabled OutputColumn: IsEnabled }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
EDIColumnMatch
|
{
|
InputColumn: StandardDeviationLeadTimeLane
|
OutputColumn: StandardDeviationLeadTimeLane
|
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: 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: UnitID OutputColumn: UnitID }
|
EDIColumnMatch
|
{
|
InputColumn: UserLeadTime
|
OutputColumn: UserLeadTime
|
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>
|
*]
|
}
|
}
|
}
|
EDITableTransformation
|
{
|
InputTable: ProductInLanes
|
OutputTable: IOProductInLane
|
EDIColumnMatch { InputColumn: IsExcluded OutputColumn: IsExcluded }
|
EDIColumnMatch { InputColumn: LaneID OutputColumn: LaneID }
|
EDIColumnMatch { InputColumn: ProductID OutputColumn: ProductID }
|
}
|
}
|
}
|
