Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MPSync_ImportRoutingsFromDBBroker
|
{
|
MDSDefinition: MPSync
|
EDIModelLink.Destination MPSync_DestinationRoutingsForImport
|
{
|
EDIMLTable IOOperation
|
{
|
PrimaryKeyColumns: ID
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IOOperation
|
TypeIndex: IOOperationTypeIndex
|
WithSoftDelete: true
|
EDIMLColumn CO2Emission { Attribute: CO2Emission ValueType: Real }
|
EDIMLColumn HasUserLotSize { Attribute: HasUserLotSize ValueType: Boolean }
|
EDIMLColumn HasUserMaximumQuantity { Attribute: HasUserMaximumQuantity ValueType: Boolean }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn IsEnabled { Attribute: IsEnabled ValueType: Boolean }
|
EDIMLColumn RoutingID { Attribute: RoutingID ValueType: String }
|
EDIMLColumn RoutingStepName { Attribute: RoutingStepName ValueType: String }
|
EDIMLColumn StandardDeviationLeadTimeOperation { Attribute: StandardDeviationLeadTimeOperation ValueType: Duration }
|
EDIMLColumn Throughput { Attribute: Throughput ValueType: Real }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
EDIMLColumn UserLeadTime { Attribute: UserLeadTime ValueType: Duration }
|
EDIMLColumn UserLotSize { Attribute: UserLotSize ValueType: Real }
|
EDIMLColumn UserMaximumQuantity { Attribute: UserMaximumQuantity ValueType: Real }
|
EDIMLColumn UserMinimumQuantity { Attribute: UserMinimumQuantity ValueType: Real }
|
}
|
EDIMLTable IOOperationBOM
|
{
|
PrimaryKeyColumns: IsInput
|
PrimaryKeyColumns: OperationID
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: StockingPointID
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IOOperationBOM
|
TypeIndex: IOOperationBOMTypeIndex
|
WithSoftDelete: true
|
EDIMLColumn InputGroupID { Attribute: InputGroupID ValueType: Number }
|
EDIMLColumn IsExcluded { Attribute: IsExcluded ValueType: Boolean }
|
EDIMLColumn IsInput { Attribute: IsInput ValueType: Boolean }
|
EDIMLColumn MaxQuantityInGroup { Attribute: MaxQuantityInGroup ValueType: Real }
|
EDIMLColumn MinQuantityInGroup { Attribute: MinQuantityInGroup ValueType: Real }
|
EDIMLColumn OperationID { Attribute: OperationID ValueType: String }
|
EDIMLColumn OperationInputSetName { Attribute: OperationInputSetName ValueType: String }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn Quantity { Attribute: Quantity ValueType: Real }
|
EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
|
}
|
EDIMLTable IOOperationInputGroup
|
{
|
PrimaryKeyColumns: InputGroupID
|
PrimaryKeyColumns: OperationID
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IOOperationInputGroup
|
TypeIndex: IOOperationInputGroupTypeIndex
|
WithSoftDelete: true
|
EDIMLColumn InputGroupID { Attribute: InputGroupID ValueType: Number }
|
EDIMLColumn InputGroupQuantity { Attribute: InputGroupQuantity ValueType: Real }
|
EDIMLColumn OperationID { Attribute: OperationID ValueType: String }
|
}
|
EDIMLTable IOOperationInputSet
|
{
|
PrimaryKeyColumns: Name
|
PrimaryKeyColumns: OperationID
|
TargetType: IOOperationInputSet
|
TypeIndex: IOOperationInputSetTypeIndex
|
EDIMLColumn MaxQuantity { Attribute: MaxQuantity ValueType: Real }
|
EDIMLColumn MinQuantity { Attribute: MinQuantity ValueType: Real }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn OperationID { Attribute: OperationID ValueType: String }
|
}
|
EDIMLTable IOOperationLink
|
{
|
PrimaryKeyColumns: DestOperationID
|
PrimaryKeyColumns: SourceOperationID
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IOOperationLink
|
TypeIndex: IOOperationLinkTypeIndex
|
WithSoftDelete: true
|
EDIMLColumn DestGroupID { Attribute: DestGroupID ValueType: Number }
|
EDIMLColumn DestGroupQuantity { Attribute: DestGroupQuantity ValueType: Real }
|
EDIMLColumn DestHasUserQuantity { Attribute: DestHasUserQuantity ValueType: Boolean }
|
EDIMLColumn DestMaxQuantity { Attribute: DestMaxQuantity ValueType: Real }
|
EDIMLColumn DestMinQuantity { Attribute: DestMinQuantity ValueType: Real }
|
EDIMLColumn DestOperationID { Attribute: DestOperationID ValueType: String }
|
EDIMLColumn DestQuantity { Attribute: DestQuantity ValueType: Real }
|
EDIMLColumn SourceGroupID { Attribute: SourceGroupID ValueType: Number }
|
EDIMLColumn SourceOperationID { Attribute: SourceOperationID ValueType: String }
|
EDIMLColumn SourceQuantity { Attribute: SourceQuantity ValueType: Real }
|
}
|
EDIMLTable IORouting
|
{
|
PrimaryKeyColumns: ID
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IORouting
|
TypeIndex: IORoutingTypeIndex
|
WithSoftDelete: true
|
EDIMLColumn AllowWIPInventory { Attribute: AllowWIPInventory ValueType: Boolean }
|
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 Start { Attribute: Start ValueType: Date }
|
}
|
EDIMLTable IORoutingConfiguratorView
|
{
|
PrimaryKeyColumns: ID
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IORoutingConfiguratorView
|
TypeIndex: IORoutingConfiguratorViewTypeIndex
|
WithSoftDelete: true
|
EDIMLColumn EdgeThickness { Attribute: EdgeThickness ValueType: Number }
|
EDIMLColumn FontName { Attribute: FontName ValueType: String }
|
EDIMLColumn FontSize { Attribute: FontSize ValueType: Number }
|
EDIMLColumn GridHeight { Attribute: GridHeight ValueType: Number }
|
EDIMLColumn GridPointDistance { Attribute: GridPointDistance ValueType: Number }
|
EDIMLColumn GridWidth { Attribute: GridWidth ValueType: Number }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn IsCompactMode { Attribute: IsCompactMode ValueType: Boolean }
|
EDIMLColumn IsGridVisible { Attribute: IsGridVisible ValueType: Boolean }
|
EDIMLColumn OffsetX { Attribute: OffsetX ValueType: Number }
|
EDIMLColumn OffsetY { Attribute: OffsetY ValueType: Number }
|
EDIMLColumn OperationHeight { Attribute: OperationHeight ValueType: Number }
|
EDIMLColumn OperationInputOutputWidth { Attribute: OperationInputOutputWidth ValueType: Number }
|
EDIMLColumn OperationOffsetX { Attribute: OperationOffsetX ValueType: Number }
|
EDIMLColumn OperationOffsetY { Attribute: OperationOffsetY ValueType: Number }
|
EDIMLColumn OperationWidth { Attribute: OperationWidth ValueType: Number }
|
EDIMLColumn PISPHeight { Attribute: PISPHeight ValueType: Number }
|
EDIMLColumn PISPWidth { Attribute: PISPWidth ValueType: Number }
|
EDIMLColumn Padding { Attribute: Padding ValueType: Number }
|
EDIMLColumn RoutingStepDistance { Attribute: RoutingStepDistance ValueType: Number }
|
EDIMLColumn RoutingStepMinimumHeight { Attribute: RoutingStepMinimumHeight ValueType: Number }
|
EDIMLColumn RoutingStepMinimumWidth { Attribute: RoutingStepMinimumWidth ValueType: Number }
|
EDIMLColumn User { Attribute: User ValueType: String }
|
EDIMLColumn UserOperationInputOutputHeight { Attribute: UserOperationInputOutputHeight ValueType: Number }
|
}
|
EDIMLTable IORoutingStep
|
{
|
PrimaryKeyColumns: Name
|
PrimaryKeyColumns: RoutingID
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IORoutingStep
|
TypeIndex: IORoutingStepTypeIndex
|
WithSoftDelete: true
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn RoutingID { Attribute: RoutingID ValueType: String }
|
EDIMLColumn SequenceNumberForExcel { Attribute: SequenceNumberForExcel ValueType: Number }
|
EDIMLColumn Tool { Attribute: Tool ValueType: String }
|
}
|
}
|
EDIODBCLink.Source MPSync_SourceRoutingsForImport
|
{
|
DataIntegrityStrategy: 'Disabled'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.syncobject'
|
EDIODBCLinkTable OperationBOMs
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: OperationID
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: StockingPointID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn InputGroupID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn IsExcluded
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsInput
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn MaxQuantityInGroup
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn MinQuantityInGroup
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn OperationID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn OperationInputSetName
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ProductID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Quantity
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn StockingPointID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable OperationInputGroups
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: InputGroupID
|
PrimaryKeyColumns: InputGroupQuantity
|
PrimaryKeyColumns: OperationID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn InputGroupID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn InputGroupQuantity
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn OperationID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable OperationInputSets
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: Name
|
PrimaryKeyColumns: OperationID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn MaxQuantity
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn MinQuantity
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn Name
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn OperationID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable OperationLinks
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: DestOperationID
|
PrimaryKeyColumns: SourceOperationID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn DestGroupID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn DestGroupQuantity
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn DestHasUserQuantity
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DestMaxQuantity
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn DestMinQuantity
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn DestOperationID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DestQuantity
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn SourceGroupID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn SourceOperationID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn SourceQuantity
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
}
|
EDIODBCLinkTable Operations
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn CO2Emission
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn HasUserLotSize
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn HasUserMaximumQuantity
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn ID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn IsEnabled
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn LotSize
|
{
|
ValueType: Real
|
}
|
EDIODBCLinkColumn MaximumQuantity
|
{
|
ValueType: Real
|
}
|
EDIODBCLinkColumn MinimumQuantity
|
{
|
ValueType: Real
|
}
|
EDIODBCLinkColumn RoutingID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn RoutingStepName
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn StandardDeviationLeadTimeOperation
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn Throughput
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn UnitID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UserLeadTime
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
}
|
EDIODBCLinkTable RoutingConfiguratorViews
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn EdgeThickness
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn FontName
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn FontSize
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn GridHeight
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn GridPointDistance
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn GridWidth
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn ID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn IsCompactMode
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsGridVisible
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn OffsetX
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn OffsetY
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn OperationHeight
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn OperationInputOutputWidth
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn OperationOffsetX
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn OperationOffsetY
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn OperationWidth
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn PISPHeight
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn PISPWidth
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn Padding
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn RoutingStepDistance
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn RoutingStepMinimumHeight
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn RoutingStepMinimumWidth
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn User
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UserOperationInputOutputHeight
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
}
|
EDIODBCLinkTable RoutingSteps
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: Name
|
PrimaryKeyColumns: RoutingID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn Name
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn RoutingID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn SequenceNumber
|
{
|
ValueType: Number
|
}
|
EDIODBCLinkColumn Tool
|
{
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable Routings
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn AllowWIPInventory
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn End
|
{
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn ID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn IsEnabled
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn Name
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Start
|
{
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
}
|
}
|
EDITransformation.Transformation MPSync_TransformationRoutingsForImport
|
{
|
EDITableTransformation
|
{
|
InputTable: OperationBOMs
|
OutputTable: IOOperationBOM
|
EDIColumnMatch { InputColumn: IsExcluded OutputColumn: IsExcluded }
|
EDIColumnMatch { InputColumn: IsInput OutputColumn: IsInput }
|
EDIColumnMatch
|
{
|
InputColumn: OperationInputSetName
|
OutputColumn: OperationInputSetName
|
}
|
EDIColumnMatch
|
{
|
InputColumn: MaxQuantityInGroup
|
OutputColumn: MaxQuantityInGroup
|
}
|
EDIColumnMatch
|
{
|
InputColumn: StockingPointID
|
OutputColumn: StockingPointID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Quantity
|
OutputColumn: Quantity
|
}
|
EDIColumnMatch
|
{
|
InputColumn: MinQuantityInGroup
|
OutputColumn: MinQuantityInGroup
|
}
|
EDIColumnMatch
|
{
|
InputColumn: InputGroupID
|
OutputColumn: InputGroupID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: OperationID
|
OutputColumn: OperationID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: ProductID
|
OutputColumn: ProductID
|
}
|
}
|
EDITableTransformation
|
{
|
InputTable: OperationInputGroups
|
OutputTable: IOOperationInputGroup
|
EDIColumnMatch
|
{
|
InputColumn: OperationID
|
OutputColumn: OperationID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: InputGroupID
|
OutputColumn: InputGroupID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: InputGroupQuantity
|
OutputColumn: InputGroupQuantity
|
}
|
}
|
EDITableTransformation
|
{
|
InputTable: OperationInputSets
|
OutputTable: IOOperationInputSet
|
EDIColumnMatch { InputColumn: MaxQuantity OutputColumn: MaxQuantity }
|
EDIColumnMatch { InputColumn: MinQuantity OutputColumn: MinQuantity }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
EDIColumnMatch { InputColumn: OperationID OutputColumn: OperationID }
|
}
|
EDITableTransformation
|
{
|
InputTable: OperationLinks
|
OutputTable: IOOperationLink
|
EDIColumnMatch
|
{
|
InputColumn: DestGroupQuantity
|
OutputColumn: DestGroupQuantity
|
}
|
EDIColumnMatch
|
{
|
InputColumn: DestHasUserQuantity
|
OutputColumn: DestHasUserQuantity
|
}
|
EDIColumnMatch
|
{
|
InputColumn: DestQuantity
|
OutputColumn: DestQuantity
|
}
|
EDIColumnMatch
|
{
|
InputColumn: DestMinQuantity
|
OutputColumn: DestMinQuantity
|
}
|
EDIColumnMatch
|
{
|
InputColumn: SourceQuantity
|
OutputColumn: SourceQuantity
|
}
|
EDIColumnMatch
|
{
|
InputColumn: DestOperationID
|
OutputColumn: DestOperationID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: SourceGroupID
|
OutputColumn: SourceGroupID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: SourceOperationID
|
OutputColumn: SourceOperationID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: DestMaxQuantity
|
OutputColumn: DestMaxQuantity
|
}
|
EDIColumnMatch
|
{
|
InputColumn: DestGroupID
|
OutputColumn: DestGroupID
|
}
|
}
|
EDITableTransformation
|
{
|
InputTable: Operations
|
OutputTable: IOOperation
|
EDIColumnMatch { InputColumn: CO2Emission OutputColumn: CO2Emission }
|
EDIColumnMatch { InputColumn: HasUserLotSize OutputColumn: HasUserLotSize }
|
EDIColumnMatch { InputColumn: HasUserMaximumQuantity OutputColumn: HasUserMaximumQuantity }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: IsEnabled OutputColumn: IsEnabled }
|
EDIColumnMatch { InputColumn: LotSize OutputColumn: UserLotSize }
|
EDIColumnMatch { InputColumn: MaximumQuantity OutputColumn: UserMaximumQuantity }
|
EDIColumnMatch { InputColumn: MinimumQuantity OutputColumn: UserMinimumQuantity }
|
EDIColumnMatch { InputColumn: RoutingID OutputColumn: RoutingID }
|
EDIColumnMatch { InputColumn: RoutingStepName OutputColumn: RoutingStepName }
|
EDIColumnMatch
|
{
|
InputColumn: StandardDeviationLeadTimeOperation
|
OutputColumn: StandardDeviationLeadTimeOperation
|
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: Throughput OutputColumn: Throughput }
|
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: RoutingConfiguratorViews
|
OutputTable: IORoutingConfiguratorView
|
EDIColumnMatch { InputColumn: EdgeThickness OutputColumn: EdgeThickness }
|
EDIColumnMatch { InputColumn: FontName OutputColumn: FontName }
|
EDIColumnMatch { InputColumn: FontSize OutputColumn: FontSize }
|
EDIColumnMatch { InputColumn: GridHeight OutputColumn: GridHeight }
|
EDIColumnMatch { InputColumn: GridPointDistance OutputColumn: GridPointDistance }
|
EDIColumnMatch { InputColumn: GridWidth OutputColumn: GridWidth }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: IsCompactMode OutputColumn: IsCompactMode }
|
EDIColumnMatch { InputColumn: IsGridVisible OutputColumn: IsGridVisible }
|
EDIColumnMatch { InputColumn: OffsetX OutputColumn: OffsetX }
|
EDIColumnMatch { InputColumn: OffsetY OutputColumn: OffsetY }
|
EDIColumnMatch { InputColumn: OperationHeight OutputColumn: OperationHeight }
|
EDIColumnMatch { InputColumn: OperationInputOutputWidth OutputColumn: OperationInputOutputWidth }
|
EDIColumnMatch { InputColumn: OperationOffsetX OutputColumn: OperationOffsetX }
|
EDIColumnMatch { InputColumn: OperationOffsetY OutputColumn: OperationOffsetY }
|
EDIColumnMatch { InputColumn: OperationWidth OutputColumn: OperationWidth }
|
EDIColumnMatch { InputColumn: PISPHeight OutputColumn: PISPHeight }
|
EDIColumnMatch { InputColumn: PISPWidth OutputColumn: PISPWidth }
|
EDIColumnMatch { InputColumn: Padding OutputColumn: Padding }
|
EDIColumnMatch { InputColumn: RoutingStepDistance OutputColumn: RoutingStepDistance }
|
EDIColumnMatch { InputColumn: RoutingStepMinimumHeight OutputColumn: RoutingStepMinimumHeight }
|
EDIColumnMatch { InputColumn: RoutingStepMinimumWidth OutputColumn: RoutingStepMinimumWidth }
|
EDIColumnMatch { InputColumn: User OutputColumn: User }
|
EDIColumnMatch { InputColumn: UserOperationInputOutputHeight OutputColumn: UserOperationInputOutputHeight }
|
}
|
EDITableTransformation
|
{
|
InputTable: RoutingSteps
|
OutputTable: IORoutingStep
|
EDIColumnMatch
|
{
|
InputColumn: Name
|
OutputColumn: Name
|
}
|
EDIColumnMatch
|
{
|
InputColumn: RoutingID
|
OutputColumn: RoutingID
|
}
|
EDIColumnMatch { InputColumn: SequenceNumber OutputColumn: SequenceNumberForExcel }
|
EDIColumnMatch { InputColumn: Tool OutputColumn: Tool }
|
}
|
EDITableTransformation
|
{
|
InputTable: Routings
|
OutputTable: IORouting
|
EDIColumnMatch { InputColumn: AllowWIPInventory OutputColumn: AllowWIPInventory }
|
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: IsEnabled OutputColumn: IsEnabled }
|
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: Name
|
OutputColumn: Name
|
}
|
EDIColumnMatch
|
{
|
InputColumn: ID
|
OutputColumn: ID
|
}
|
}
|
}
|
}
|
