Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MPSync_ImportUnitOfMeasuresFromDBBroker
|
{
|
MDSDefinition: MPSync
|
EDIModelLink.Destination MPSync_DestinationUOMForImport
|
{
|
EDIMLTable IOBaseConversionFactor
|
{
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: SourceUnitOfMeasureName
|
PrimaryKeyColumns: TargetUnitOfMeasureName
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IOBaseConversionFactor
|
TypeIndex: IOBaseConversionFactorTypeIndex
|
WithSoftDelete: true
|
EDIMLColumn IsEnabled { Attribute: IsEnabled ValueType: Boolean }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn SourceUnitOfMeasureName { Attribute: SourceUnitOfMeasureName ValueType: String }
|
EDIMLColumn TargetUnitOfMeasureName { Attribute: TargetUnitOfMeasureName ValueType: String }
|
EDIMLColumn UserFactor { Attribute: UserFactor ValueType: Real }
|
}
|
EDIMLTable IOUnitOfMeasure_MP
|
{
|
PrimaryKeyColumns: Name
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IOUnitOfMeasure_MP
|
TypeIndex: IOUOMTypeIndex
|
WithSoftDelete: true
|
EDIMLColumn IsDefault { Attribute: IsDefault ValueType: Boolean }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
}
|
}
|
EDIODBCLink.Source MPSync_SourceUOMForImport
|
{
|
DataIntegrityStrategy: 'Disabled'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.syncobject'
|
EDIODBCLinkTable BaseConversionFactors
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: SourceUnitOfMeasureName
|
PrimaryKeyColumns: TargetUnitOfMeasureName
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn Factor
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn IsEnabled
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn ProductID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn SourceUnitOfMeasureName
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn TargetUnitOfMeasureName
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable UnitOfMeasures
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: Name
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn IsDefault
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn Name
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
}
|
EDITransformation.Transformation MPSync_TransformationUOMForImport
|
{
|
EDITableTransformation
|
{
|
InputTable: BaseConversionFactors
|
OutputTable: IOBaseConversionFactor
|
EDIColumnMatch { InputColumn: IsEnabled OutputColumn: IsEnabled }
|
EDIColumnMatch
|
{
|
InputColumn: TargetUnitOfMeasureName
|
OutputColumn: TargetUnitOfMeasureName
|
}
|
EDIColumnMatch
|
{
|
InputColumn: SourceUnitOfMeasureName
|
OutputColumn: SourceUnitOfMeasureName
|
}
|
EDIColumnMatch
|
{
|
InputColumn: ProductID
|
OutputColumn: ProductID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Factor
|
OutputColumn: UserFactor
|
}
|
}
|
EDITableTransformation
|
{
|
InputTable: UnitOfMeasures
|
OutputTable: IOUnitOfMeasure_MP
|
EDIColumnMatch { InputColumn: IsDefault OutputColumn: IsDefault }
|
EDIColumnMatch
|
{
|
InputColumn: Name
|
OutputColumn: Name
|
}
|
}
|
}
|
}
|
