Quintiq file version 2.0
|
#parent: #root
|
EDIBroker Oracle
|
{
|
MDSDefinition: MacroPlan
|
TimeZone: 'ACT'
|
UseOSTimeZone: false
|
EDIModelLink.Destination Destination0
|
{
|
EDIMLTable Product_MP
|
{
|
PrimaryKeyColumns: ID
|
TargetType: Product_MP
|
TypeIndex: ProductTypeIndex
|
EDIMLColumn DisplayIndexForExcel { Attribute: DisplayIndexForExcel ValueType: Number }
|
EDIMLColumn HasMaturation { Attribute: HasMaturation ValueType: Boolean }
|
EDIMLColumn HasShelfLife { Attribute: HasShelfLife ValueType: Boolean }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn IconName { Attribute: IconName ValueType: String }
|
EDIMLColumn IsByProduct { Attribute: IsByProduct ValueType: Boolean }
|
EDIMLColumn IsExcludedFromFulfillmentKPI { Attribute: IsExcludedFromFulfillmentKPI ValueType: Boolean }
|
EDIMLColumn IsExcludedFromOptimization { Attribute: IsExcludedFromOptimization ValueType: Boolean }
|
EDIMLColumn IsInOptimizerPuzzle { Attribute: IsInOptimizerPuzzle ValueType: Boolean }
|
EDIMLColumn IsInRectangleMetaOptimizer { Attribute: IsInRectangleMetaOptimizer ValueType: Boolean }
|
EDIMLColumn IsManuallyConfigured { Attribute: IsManuallyConfigured ValueType: Boolean }
|
EDIMLColumn IsPlannedAfterOptimization { Attribute: IsPlannedAfterOptimization ValueType: Boolean }
|
EDIMLColumn IsSoftDeleted { Attribute: IsSoftDeleted ValueType: Boolean }
|
EDIMLColumn IsSystem { Attribute: IsSystem ValueType: Boolean }
|
EDIMLColumn MaturationDays { Attribute: MaturationDays ValueType: Real }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn Notes { Attribute: Notes ValueType: String }
|
EDIMLColumn ParentID { Attribute: ParentID ValueType: String }
|
EDIMLColumn PriorityMetaOptimizerSelector { Attribute: PriorityMetaOptimizerSelector ValueType: Real }
|
EDIMLColumn ShelfLife { Attribute: ShelfLife ValueType: Real }
|
EDIMLColumn UnitOfMeasureName { Attribute: UnitOfMeasureName ValueType: String }
|
}
|
}
|
EDIODBCLink.Source Source0
|
{
|
DataIntegrityStrategy: 'Disabled'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.oracle'
|
EDIODBCLinkTable MID_PRODUCT
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn BUSINESSTYPE
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn KEYPRODUCT
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn NAME
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn NOTE
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn PRODUCTMAJORTYPE
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn PRODUCTSUBCLASSTYPE
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn SHELFLIFE
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UNITOFMEAURENAME
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
}
|
EDITransformation.Transformation Transformation
|
{
|
EDITableTransformation
|
{
|
InputTable: MID_PRODUCT
|
OutputTable: Product_MP
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: NAME OutputColumn: Name }
|
EDIColumnMatch { InputColumn: NOTE OutputColumn: Notes }
|
EDIColumnMatch
|
{
|
InputColumn: SHELFLIFE
|
OutputColumn: ShelfLife
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToReal xmlns="http://www.quintiq.com/GEB/StringToReal" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<NumericFormatString>Standard</NumericFormatString>
|
<LocaleString>Chinese (China)</LocaleString>
|
<CurrencyString></CurrencyString>
|
<CustomFormatString></CustomFormatString>
|
</StringToReal>
|
*]
|
}
|
}
|
EDIColumnMatch { InputColumn: UNITOFMEAURENAME OutputColumn: UnitOfMeasureName }
|
}
|
}
|
}
|
