Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MPSync_ImportServiceLevelsFromDBBroker
|
{
|
MDSDefinition: MPSync
|
EDIModelLink.Destination MpSync_DestinationServiceLevelForImport
|
{
|
EDIMLTable IOFulfillmentTarget
|
{
|
PrimaryKeyColumns: ID
|
TargetType: IOFulfillmentTarget
|
TypeIndex: IOFulfillmentTargetTypeIndex
|
EDIMLColumn End { Attribute: End ValueType: Date }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn IsEnabled { Attribute: IsEnabled ValueType: Boolean }
|
EDIMLColumn IsUsedForPlanningFulfillment { Attribute: IsUsedForPlanningFulfillment ValueType: Boolean }
|
EDIMLColumn IsUsedForSafetyStockCalculation { Attribute: IsUsedForSafetyStockCalculation ValueType: Boolean }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn SalesSegmentName { Attribute: SalesSegmentName ValueType: String }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
|
EDIMLColumn TargetPercentage { Attribute: TargetPercentage ValueType: Real }
|
}
|
EDIMLTable IOServiceLevel
|
{
|
PrimaryKeyColumns: ID
|
TargetType: IOServiceLevel
|
TypeIndex: IOServiceLevelTypeIndex
|
EDIMLColumn End { Attribute: End ValueType: Date }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn IsEnabled { Attribute: IsEnabled ValueType: Boolean }
|
EDIMLColumn IsUsedForPlanningFulfillment { Attribute: IsUsedForPlanningFulfillment ValueType: Boolean }
|
EDIMLColumn IsUsedForSafetyStockCalculation { Attribute: IsUsedForSafetyStockCalculation ValueType: Boolean }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn SalesSegmentName { Attribute: SalesSegmentName ValueType: String }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
|
EDIMLColumn TargetPercentage { Attribute: TargetPercentage ValueType: Real }
|
}
|
}
|
EDIODBCLink.Source MPSync_SourceServiceLevelForImport
|
{
|
DataIntegrityStrategy: 'Disabled'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.syncobject'
|
EDIODBCLinkTable FulfillmentTargets
|
{
|
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
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsUsedForPlanningFulfillment
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsUsedForSafetyStockCalculation
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn Name
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ProductID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn SalesSegmentName
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Start
|
{
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn StockingPointID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn TargetPercentage
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
}
|
EDIODBCLinkTable ServiceLevels
|
{
|
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
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsUsedForPlanningFulfillment
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsUsedForSafetyStockCalculation
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn Name
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ProductID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn SalesSegmentName
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Start
|
{
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn StockingPointID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn TargetPercentage
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
}
|
}
|
EDITransformation.Transformation TransformationServiceLevelForImport
|
{
|
EDITableTransformation
|
{
|
InputTable: FulfillmentTargets
|
OutputTable: IOFulfillmentTarget
|
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: IsUsedForPlanningFulfillment OutputColumn: IsUsedForPlanningFulfillment }
|
EDIColumnMatch { InputColumn: IsUsedForSafetyStockCalculation OutputColumn: IsUsedForSafetyStockCalculation }
|
EDIColumnMatch
|
{
|
InputColumn: Name
|
OutputColumn: Name
|
}
|
EDIColumnMatch
|
{
|
InputColumn: ProductID
|
OutputColumn: ProductID
|
}
|
EDIColumnMatch { InputColumn: SalesSegmentName OutputColumn: SalesSegmentName }
|
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: StockingPointID
|
OutputColumn: StockingPointID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: TargetPercentage
|
OutputColumn: TargetPercentage
|
}
|
}
|
EDITableTransformation
|
{
|
InputTable: ServiceLevels
|
OutputTable: IOServiceLevel
|
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: IsUsedForPlanningFulfillment OutputColumn: IsUsedForPlanningFulfillment }
|
EDIColumnMatch { InputColumn: IsUsedForSafetyStockCalculation OutputColumn: IsUsedForSafetyStockCalculation }
|
EDIColumnMatch
|
{
|
InputColumn: Name
|
OutputColumn: Name
|
}
|
EDIColumnMatch
|
{
|
InputColumn: ProductID
|
OutputColumn: ProductID
|
}
|
EDIColumnMatch { InputColumn: SalesSegmentName OutputColumn: SalesSegmentName }
|
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: StockingPointID
|
OutputColumn: StockingPointID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: TargetPercentage
|
OutputColumn: TargetPercentage
|
}
|
}
|
}
|
}
|
