Quintiq file version 2.0
|
#parent: #root
|
EDIBroker Broker_OTD_OperationCost
|
{
|
MDSDefinition: MacroPlan
|
TimeZone: 'ACT'
|
UseOSTimeZone: false
|
EDIModelLink.Destination Des_MappingOperationCost
|
{
|
EDIMLTable MappingOperationCost
|
{
|
PrimaryKeyColumns: ID
|
TargetType: MappingOperationCost
|
TypeIndex: MappingOperationCostTypeIndex
|
EDIMLColumn AccountName { Attribute: AccountName ValueType: String }
|
EDIMLColumn Cost { Attribute: Cost ValueType: Real }
|
EDIMLColumn CostDriver { Attribute: CostDriver ValueType: String }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn LengthOfTime { Attribute: LengthOfTime ValueType: Number }
|
EDIMLColumn OrgCode { Attribute: OrgCode ValueType: String }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn TimeUnit { Attribute: TimeUnit ValueType: String }
|
}
|
}
|
EDIODBCLink.Source MID_OPERATIONCOST
|
{
|
DataIntegrityStrategy: 'Disabled'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.oracle'
|
EDIODBCLinkTable MID_OPERATIONCOST
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="TIANMA"'
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn ACCOUNTNAME
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn COST
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn COSTDRIVER
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn LENGTHOFTIME
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ORGCODE
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn PRODUCTID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn START
|
{
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn TIMEUNIT
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
}
|
EDITransformation.Transformation TransformationOperationCost
|
{
|
EDITableTransformation
|
{
|
InputTable: MID_OPERATIONCOST
|
OutputTable: MappingOperationCost
|
EDIColumnMatch { InputColumn: ACCOUNTNAME OutputColumn: AccountName }
|
EDIColumnMatch { InputColumn: COST OutputColumn: Cost }
|
EDIColumnMatch { InputColumn: COSTDRIVER OutputColumn: CostDriver }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch
|
{
|
InputColumn: LENGTHOFTIME
|
OutputColumn: LengthOfTime
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToNumber xmlns="http://www.quintiq.com/GEB/StringToNumber" 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>
|
</StringToNumber>
|
*]
|
}
|
}
|
EDIColumnMatch { InputColumn: ORGCODE OutputColumn: OrgCode }
|
EDIColumnMatch { InputColumn: PRODUCTID OutputColumn: ProductID }
|
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: TIMEUNIT OutputColumn: TimeUnit }
|
}
|
}
|
}
|
