Quintiq file version 2.0
|
#parent: #root
|
EDIBroker Broker_OTD_BaseConversionFactor
|
{
|
MDSDefinition: MacroPlan
|
TimeZone: 'ACT'
|
UseOSTimeZone: false
|
EDIModelLink.Destination Des_BaseConversionFactor
|
{
|
EDIMLTable MappingBaseConversionFactor
|
{
|
PrimaryKeyColumns: IsEnabled
|
PrimaryKeyColumns: ProductId
|
PrimaryKeyColumns: SourceUnitOfMeasureName
|
PrimaryKeyColumns: TargetUnitOfMeasureName
|
TargetType: MappingBaseConversionFactor
|
TypeIndex: MappingBaseConversionFactorTypeIndex
|
EDIMLColumn Factor { Attribute: Factor ValueType: Real }
|
EDIMLColumn IsEnabled { Attribute: IsEnabled ValueType: Boolean }
|
EDIMLColumn ProductId { Attribute: ProductId ValueType: String }
|
EDIMLColumn SourceUnitOfMeasureName { Attribute: SourceUnitOfMeasureName ValueType: String }
|
EDIMLColumn TargetUnitOfMeasureName { Attribute: TargetUnitOfMeasureName ValueType: String }
|
}
|
}
|
EDIODBCLink.Source MID_BaseConversionFactor
|
{
|
DataIntegrityStrategy: 'Disabled'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.oracle'
|
EDIODBCLinkTable MID_BASECONVERSIONFACTORS
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="YUXTEST"'
|
PrimaryKeyColumns: ISENABLED
|
PrimaryKeyColumns: PRODUCTID
|
PrimaryKeyColumns: SOURCEUNITOFMEASURENAME
|
PrimaryKeyColumns: TARGETUNITOFMEASURENAME
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn FACTOR
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn ISENABLED
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn PRODUCTID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn SOURCEUNITOFMEASURENAME
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn TARGETUNITOFMEASURENAME
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
}
|
EDITransformation.Transformation TransformationBaseConversionFactor
|
{
|
EDITableTransformation
|
{
|
InputTable: MID_BASECONVERSIONFACTORS
|
OutputTable: MappingBaseConversionFactor
|
EDIColumnMatch { InputColumn: FACTOR OutputColumn: Factor }
|
EDIColumnMatch { InputColumn: ISENABLED OutputColumn: IsEnabled }
|
EDIColumnMatch { InputColumn: PRODUCTID OutputColumn: ProductId }
|
EDIColumnMatch { InputColumn: SOURCEUNITOFMEASURENAME OutputColumn: SourceUnitOfMeasureName }
|
EDIColumnMatch { InputColumn: TARGETUNITOFMEASURENAME OutputColumn: TargetUnitOfMeasureName }
|
}
|
}
|
}
|
