Quintiq file version 2.0
|
#parent: #root
|
EDIBroker Broker_OTD_Unit
|
{
|
MDSDefinition: MPSync
|
TimeZone: 'ACT'
|
UseOSTimeZone: false
|
EDIModelLink.Destination Des_Unit
|
{
|
EDIMLTable MappingUnit
|
{
|
PrimaryKeyColumns: EquipmentID
|
PrimaryKeyColumns: OperationType
|
PrimaryKeyColumns: OrganCode
|
PrimaryKeyColumns: PlantName
|
TargetType: MappingUnit
|
TypeIndex: MappingUnitTypeIndex
|
EDIMLColumn Equipment { Attribute: Equipment ValueType: String }
|
EDIMLColumn EquipmentID { Attribute: EquipmentID ValueType: String }
|
EDIMLColumn OperationType { Attribute: OperationType ValueType: String }
|
EDIMLColumn OrganCode { Attribute: OrganCode ValueType: String }
|
EDIMLColumn OrganName { Attribute: OrganName ValueType: String }
|
EDIMLColumn PlantName { Attribute: PlantName ValueType: String }
|
}
|
}
|
EDIODBCLink.Source MID_UNIT
|
{
|
DataIntegrityStrategy: 'Disabled'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.oracle'
|
EDIODBCLinkTable MID_UNIT
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="TIANMA"'
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn EQUIPMENT
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn EQUIPMENTID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn OPERATIONTYPE
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ORGANCODE
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ORGANNAME
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn PLANTNAME
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
}
|
EDITransformation.Transformation TransformationUnit
|
{
|
EDITableTransformation
|
{
|
InputTable: MID_UNIT
|
OutputTable: MappingUnit
|
EDIColumnMatch { InputColumn: EQUIPMENT OutputColumn: Equipment }
|
EDIColumnMatch { InputColumn: EQUIPMENTID OutputColumn: EquipmentID }
|
EDIColumnMatch { InputColumn: OPERATIONTYPE OutputColumn: OperationType }
|
EDIColumnMatch { InputColumn: ORGANCODE OutputColumn: OrganCode }
|
EDIColumnMatch { InputColumn: ORGANNAME OutputColumn: OrganName }
|
EDIColumnMatch { InputColumn: PLANTNAME OutputColumn: PlantName }
|
}
|
}
|
}
|
