Quintiq file version 2.0
|
#parent: #root
|
EDIBroker Broker_DII_CIM_DB_Import_ManufacturingItem
|
{
|
MDSDefinition: LibDII_CIM_IntegrationDataset
|
TimeZone: 'ACT'
|
UseOSTimeZone: false
|
EDIModelLink.Destination Destination_DII_CIM_DB_Import_ManufacturingItem
|
{
|
EDIMLTable LibDII_CIM_ManufacturingItem
|
{
|
PrimaryKeyColumns: ID
|
TargetType: LibDII_CIM_ManufacturingItem
|
TypeIndex: LibDII_CIM_ManufacturingItem_TypeIndex
|
EDIMLColumn DisplayIndex { Attribute: DisplayIndex 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 IsActive { Attribute: IsActive ValueType: Boolean }
|
EDIMLColumn IsByProduct { Attribute: IsByProduct ValueType: Boolean }
|
EDIMLColumn ItemGroup { Attribute: ItemGroup ValueType: String }
|
EDIMLColumn MaturationDays { Attribute: MaturationDays ValueType: Real }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn ShelfLifeDays { Attribute: ShelfLifeDays ValueType: Real }
|
EDIMLColumn UnitOfMeasurementID { Attribute: UnitOfMeasurementID ValueType: String }
|
}
|
EDIMLTable LibDII_CIM_StockingPoint
|
{
|
PrimaryKeyColumns: ID
|
TargetType: LibDII_CIM_StockingPoint
|
TypeIndex: LibDII_CIM_StockingPoint_TypeIndex
|
EDIMLColumn DisplayIndex { Attribute: DisplayIndex ValueType: Number }
|
EDIMLColumn EffectiveEnd { Attribute: EffectiveEnd ValueType: Date }
|
EDIMLColumn EffectiveStart { Attribute: EffectiveStart ValueType: Date }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn IsDecouplingPoint { Attribute: IsDecouplingPoint ValueType: Boolean }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn OrganizationID { Attribute: OrganizationID ValueType: String }
|
EDIMLColumn UnitOfMeasurementID { Attribute: UnitOfMeasurementID ValueType: String }
|
}
|
EDIMLTable LibDII_CIM_UnitOfMeasurement
|
{
|
PrimaryKeyColumns: ID
|
TargetType: LibDII_CIM_UnitOfMeasurement
|
TypeIndex: LibDII_CIM_UnitOfMeasurement_TypeIndex
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
}
|
}
|
EDIODBCLink.Source Source_DII_CIM_DB_Import_ManufacturingItem
|
{
|
DataIntegrityStrategy: 'Disabled'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.importcim'
|
EDIODBCLinkTable ManufacturingItem
|
{
|
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 DisplayIndex
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn HasMaturation
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn HasShelfLife
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn ID
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn IconName
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn IsActive
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsByProduct
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn ItemGroup
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MaturationDays
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn Name
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ShelfLifeDays
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn UnitOfMeasurementID
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable StockingPoint
|
{
|
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 DisplayIndex
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn EffectiveEnd
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn EffectiveStart
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn ID
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn IsDecouplingPoint
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn Name
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn OrganizationID
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UnitOfMeasurementID
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable UnitOfMeasurement
|
{
|
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 ID
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Name
|
{
|
MayUpdateColumn: true
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
}
|
EDITransformation.Transformation Transformation_DII_CIM_DB_Import_ManufacturingItem
|
{
|
EDITableTransformation
|
{
|
InputTable: ManufacturingItem
|
OutputTable: LibDII_CIM_ManufacturingItem
|
EDIColumnMatch { InputColumn: DisplayIndex OutputColumn: DisplayIndex }
|
EDIColumnMatch { InputColumn: HasMaturation OutputColumn: HasMaturation }
|
EDIColumnMatch { InputColumn: HasShelfLife OutputColumn: HasShelfLife }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: IconName OutputColumn: IconName }
|
EDIColumnMatch { InputColumn: IsActive OutputColumn: IsActive }
|
EDIColumnMatch { InputColumn: IsByProduct OutputColumn: IsByProduct }
|
EDIColumnMatch { InputColumn: ItemGroup OutputColumn: ItemGroup }
|
EDIColumnMatch { InputColumn: MaturationDays OutputColumn: MaturationDays }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
EDIColumnMatch { InputColumn: ShelfLifeDays OutputColumn: ShelfLifeDays }
|
EDIColumnMatch { InputColumn: UnitOfMeasurementID OutputColumn: UnitOfMeasurementID }
|
}
|
EDITableTransformation
|
{
|
InputTable: StockingPoint
|
OutputTable: LibDII_CIM_StockingPoint
|
EDIColumnMatch { InputColumn: DisplayIndex OutputColumn: DisplayIndex }
|
EDIColumnMatch
|
{
|
InputColumn: EffectiveEnd
|
OutputColumn: EffectiveEnd
|
}
|
EDIColumnMatch
|
{
|
InputColumn: EffectiveStart
|
OutputColumn: EffectiveStart
|
}
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: IsDecouplingPoint OutputColumn: IsDecouplingPoint }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
EDIColumnMatch { InputColumn: OrganizationID OutputColumn: OrganizationID }
|
EDIColumnMatch { InputColumn: UnitOfMeasurementID OutputColumn: UnitOfMeasurementID }
|
}
|
EDITableTransformation
|
{
|
InputTable: UnitOfMeasurement
|
OutputTable: LibDII_CIM_UnitOfMeasurement
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
}
|
}
|
}
|
