Quintiq file version 2.0
|
#parent: #root
|
EDIBroker Broker_DII_CIM_DB_Import_WorkOrder
|
{
|
MDSDefinition: LibDII_CIM_IntegrationDataset
|
TimeZone: 'ACT'
|
UseOSTimeZone: false
|
EDIModelLink.Destination Destination_DII_CIM_DB_Import_WorkOrder
|
{
|
EDIMLTable LibDII_CIM_CapableResource
|
{
|
PrimaryKeyColumns: EquipmentClassID
|
PrimaryKeyColumns: EquipmentID
|
PrimaryKeyColumns: OperationNumber
|
PrimaryKeyColumns: WorkOrderID
|
TargetType: LibDII_CIM_CapableResource
|
TypeIndex: LibDII_CIM_CapableResource_TypeIndex
|
EDIMLColumn EquipmentClassID { Attribute: EquipmentClassID ValueType: String }
|
EDIMLColumn EquipmentID { Attribute: EquipmentID ValueType: String }
|
EDIMLColumn IsOperativeTimeProportionalToQuantity { Attribute: IsOperativeTimeProportionalToQuantity ValueType: Boolean }
|
EDIMLColumn OperationNumber { Attribute: OperationNumber ValueType: Number }
|
EDIMLColumn OperativeTime { Attribute: OperativeTime ValueType: Duration }
|
EDIMLColumn PostprocessingTime { Attribute: PostprocessingTime ValueType: Duration }
|
EDIMLColumn PreparationTime { Attribute: PreparationTime ValueType: Duration }
|
EDIMLColumn PreprocessingTime { Attribute: PreprocessingTime ValueType: Duration }
|
EDIMLColumn SchedulingSpace { Attribute: SchedulingSpace ValueType: Duration }
|
EDIMLColumn WorkOrderID { Attribute: WorkOrderID ValueType: String }
|
}
|
EDIMLTable LibDII_CIM_TimeConstraint
|
{
|
PrimaryKeyColumns: ID
|
TargetType: LibDII_CIM_TimeConstraint
|
TypeIndex: LibDII_CIM_TimeConstraint_TypeIndex
|
EDIMLColumn DependencyType { Attribute: DependencyType ValueType: String }
|
EDIMLColumn FromOperationNumber { Attribute: FromOperationNumber ValueType: Number }
|
EDIMLColumn FromWorkOrderID { Attribute: FromWorkOrderID ValueType: String }
|
EDIMLColumn HasMaterialFlow { Attribute: HasMaterialFlow ValueType: Boolean }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn OffsetRelation { Attribute: OffsetRelation ValueType: String }
|
EDIMLColumn OffsetValue { Attribute: OffsetValue ValueType: Duration }
|
EDIMLColumn ToOperationNumber { Attribute: ToOperationNumber ValueType: Number }
|
EDIMLColumn ToWorkOrderId { Attribute: ToWorkOrderId ValueType: String }
|
}
|
EDIMLTable LibDII_CIM_WorkOrder
|
{
|
PrimaryKeyColumns: ID
|
TargetType: LibDII_CIM_WorkOrder
|
TypeIndex: LibDII_CIM_WorkOrder_TypeIndex
|
EDIMLColumn CreationDate { Attribute: CreationDate ValueType: DateTime }
|
EDIMLColumn DueDate { Attribute: DueDate ValueType: DateTime }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn ProductionPlanID { Attribute: ProductionPlanID ValueType: String }
|
EDIMLColumn Quantity { Attribute: Quantity ValueType: Real }
|
}
|
EDIMLTable LibDII_CIM_WorkOrderOperation
|
{
|
PrimaryKeyColumns: OperationNumber
|
PrimaryKeyColumns: WorkOrderID
|
TargetType: LibDII_CIM_WorkOrderOperation
|
TypeIndex: LibDII_CIM_WorkOrderOperation_TypeIndex
|
EDIMLColumn InputLotSize { Attribute: InputLotSize ValueType: Real }
|
EDIMLColumn IsRework { Attribute: IsRework ValueType: Boolean }
|
EDIMLColumn OperationNumber { Attribute: OperationNumber ValueType: Number }
|
EDIMLColumn OutputLotSize { Attribute: OutputLotSize ValueType: Real }
|
EDIMLColumn Practice { Attribute: Practice ValueType: String }
|
EDIMLColumn SetupGroup { Attribute: SetupGroup ValueType: String }
|
EDIMLColumn WorkOrderID { Attribute: WorkOrderID ValueType: String }
|
EDIMLColumn Yield { Attribute: Yield ValueType: Real }
|
}
|
}
|
EDIODBCLink.Source Source_DII_CIM_DB_Import_WorkOrder
|
{
|
DataIntegrityStrategy: 'Disabled'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.importcim'
|
EDIODBCLinkTable CapableResource
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
PrimaryKeyColumns: EquipmentClassID
|
PrimaryKeyColumns: EquipmentID
|
PrimaryKeyColumns: OperationNumber
|
PrimaryKeyColumns: WorkOrderID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn EquipmentClassID
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn EquipmentID
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn IsOperativeTimeProportionalToQuantity
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn OperationNumber
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn OperativeTime
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn PostprocessingTime
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn PreparationTime
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn PreprocessingTime
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn SchedulingSpace
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn WorkOrderID
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable TimeConstraint
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn DependencyType
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn FromOperationNumber
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn FromWorkOrderID
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn HasMaterialFlow
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn ID
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn OffsetRelation
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn OffsetValue
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn ToOperationNumber
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn ToWorkOrderId
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable WorkOrder
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn CreationDate
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn DueDate
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn ID
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ProductionPlanID
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Quantity
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
}
|
EDIODBCLinkTable WorkOrderOperation
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
PrimaryKeyColumns: OperationNumber
|
PrimaryKeyColumns: WorkOrderID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn InputLotSize
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn IsRework
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn OperationNumber
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn OutputLotSize
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn Practice
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn SetupGroup
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn WorkOrderID
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Yield
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
}
|
}
|
EDITransformation.Transformation Transformation_DII_CIM_DB_Import_WorkOrder
|
{
|
EDITableTransformation
|
{
|
InputTable: CapableResource
|
OutputTable: LibDII_CIM_CapableResource
|
EDIColumnMatch { InputColumn: EquipmentClassID OutputColumn: EquipmentClassID }
|
EDIColumnMatch { InputColumn: EquipmentID OutputColumn: EquipmentID }
|
EDIColumnMatch { InputColumn: IsOperativeTimeProportionalToQuantity OutputColumn: IsOperativeTimeProportionalToQuantity }
|
EDIColumnMatch { InputColumn: OperationNumber OutputColumn: OperationNumber }
|
EDIColumnMatch { InputColumn: OperativeTime OutputColumn: OperativeTime }
|
EDIColumnMatch { InputColumn: PostprocessingTime OutputColumn: PostprocessingTime }
|
EDIColumnMatch { InputColumn: PreparationTime OutputColumn: PreparationTime }
|
EDIColumnMatch { InputColumn: PreprocessingTime OutputColumn: PreprocessingTime }
|
EDIColumnMatch { InputColumn: SchedulingSpace OutputColumn: SchedulingSpace }
|
EDIColumnMatch { InputColumn: WorkOrderID OutputColumn: WorkOrderID }
|
}
|
EDITableTransformation
|
{
|
InputTable: TimeConstraint
|
OutputTable: LibDII_CIM_TimeConstraint
|
EDIColumnMatch { InputColumn: DependencyType OutputColumn: DependencyType }
|
EDIColumnMatch { InputColumn: FromOperationNumber OutputColumn: FromOperationNumber }
|
EDIColumnMatch { InputColumn: FromWorkOrderID OutputColumn: FromWorkOrderID }
|
EDIColumnMatch { InputColumn: HasMaterialFlow OutputColumn: HasMaterialFlow }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: OffsetRelation OutputColumn: OffsetRelation }
|
EDIColumnMatch { InputColumn: OffsetValue OutputColumn: OffsetValue }
|
EDIColumnMatch { InputColumn: ToOperationNumber OutputColumn: ToOperationNumber }
|
EDIColumnMatch { InputColumn: ToWorkOrderId OutputColumn: ToWorkOrderId }
|
}
|
EDITableTransformation
|
{
|
InputTable: WorkOrder
|
OutputTable: LibDII_CIM_WorkOrder
|
EDIColumnMatch { InputColumn: CreationDate OutputColumn: CreationDate }
|
EDIColumnMatch { InputColumn: DueDate OutputColumn: DueDate }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: ProductionPlanID OutputColumn: ProductionPlanID }
|
EDIColumnMatch { InputColumn: Quantity OutputColumn: Quantity }
|
}
|
EDITableTransformation
|
{
|
InputTable: WorkOrderOperation
|
OutputTable: LibDII_CIM_WorkOrderOperation
|
EDIColumnMatch { InputColumn: InputLotSize OutputColumn: InputLotSize }
|
EDIColumnMatch { InputColumn: IsRework OutputColumn: IsRework }
|
EDIColumnMatch { InputColumn: OperationNumber OutputColumn: OperationNumber }
|
EDIColumnMatch { InputColumn: OutputLotSize OutputColumn: OutputLotSize }
|
EDIColumnMatch { InputColumn: Practice OutputColumn: Practice }
|
EDIColumnMatch { InputColumn: SetupGroup OutputColumn: SetupGroup }
|
EDIColumnMatch { InputColumn: WorkOrderID OutputColumn: WorkOrderID }
|
EDIColumnMatch { InputColumn: Yield OutputColumn: Yield }
|
}
|
}
|
}
|
