Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MPSync_ImportSupplySpecificationsFromDBBroker
|
{
|
MDSDefinition: MPSync
|
EDIModelLink.Destination MPSync_DestinationSupplySpecificationForImport
|
{
|
EDIMLTable IOSupplySpecification
|
{
|
PrimaryKeyColumns: End
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: UnitID
|
TargetType: IOSupplySpecification
|
TypeIndex: IOSupplySpecificationTypeIndex
|
EDIMLColumn End { Attribute: End ValueType: DateTime }
|
EDIMLColumn HasMaxQuantity { Attribute: HasMaxQuantity ValueType: Boolean }
|
EDIMLColumn MaxQuantity { Attribute: MaxQuantity ValueType: Real }
|
EDIMLColumn MinQuantity { Attribute: MinQuantity ValueType: Real }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn Start { Attribute: Start ValueType: DateTime }
|
EDIMLColumn TargetQuantity { Attribute: TargetQuantity ValueType: Real }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
}
|
}
|
EDIODBCLink.Source MPSync_SourceSupplySpecificationForImport
|
{
|
DataIntegrityStrategy: 'Disabled'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.syncobject'
|
EDIODBCLinkTable SupplySpecifications
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: End
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: UnitID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn End
|
{
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn HasMaxQuantity
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn MaxQuantity
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn MinQuantity
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn ProductID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Start
|
{
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn TargetQuantity
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn UnitID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
}
|
EDITransformation.Transformation MPSync_TransformationSupplySpecificationForImport
|
{
|
EDITableTransformation
|
{
|
InputTable: SupplySpecifications
|
OutputTable: IOSupplySpecification
|
EDIColumnMatch { InputColumn: End OutputColumn: End }
|
EDIColumnMatch { InputColumn: HasMaxQuantity OutputColumn: HasMaxQuantity }
|
EDIColumnMatch { InputColumn: MaxQuantity OutputColumn: MaxQuantity }
|
EDIColumnMatch { InputColumn: MinQuantity OutputColumn: MinQuantity }
|
EDIColumnMatch { InputColumn: ProductID OutputColumn: ProductID }
|
EDIColumnMatch { InputColumn: Start OutputColumn: Start }
|
EDIColumnMatch { InputColumn: TargetQuantity OutputColumn: TargetQuantity }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
}
|
}
|
}
|
