Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MPSync_ImportProductsFromDBBroker
|
{
|
MDSDefinition: MPSync
|
EDIModelLink.Destination MPSync_DestinationProductsForImport
|
{
|
EDIMLTable IOPISPSpecification
|
{
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: StockingPointID
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IOPISPSpecification
|
TypeIndex: IOPISPSpecificationTypeIndex
|
WithSoftDelete: true
|
EDIMLColumn HasUserUnitOfMeasurement { Attribute: HasUserUnitOfMeasurement ValueType: Boolean }
|
EDIMLColumn InputLotSize { Attribute: InputLotSize ValueType: Real }
|
EDIMLColumn IsExcludeShelfLifeAndMaturation { Attribute: IsExcludeShelfLifeAndMaturation ValueType: Boolean }
|
EDIMLColumn IsExcluded { Attribute: IsExcluded ValueType: Boolean }
|
EDIMLColumn IsExcludedFromBalancing { Attribute: IsExcludedFromBalancing ValueType: Boolean }
|
EDIMLColumn IsNegativeInventoryAllowed { Attribute: IsNegativeInventoryAllowed ValueType: Boolean }
|
EDIMLColumn IsSafetyStockKept { Attribute: IsSafetyStockKept ValueType: Boolean }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
|
EDIMLColumn UnitOfMeasurementName { Attribute: UnitOfMeasurementName ValueType: String }
|
}
|
EDIMLTable IOProductLevel_MP
|
{
|
PrimaryKeyColumns: Name
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IOProductLevel_MP
|
TypeIndex: IOProductLevelTypeIndex
|
WithSoftDelete: true
|
EDIMLColumn IsProductCategory { Attribute: IsProductCategory ValueType: Boolean }
|
EDIMLColumn Level { Attribute: Level ValueType: Number }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
}
|
EDIMLTable IOProduct_MP
|
{
|
PrimaryKeyColumns: ID
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IOProduct_MP
|
TypeIndex: IOProductTypeIndex
|
WithSoftDelete: true
|
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 IsByProduct { Attribute: IsByProduct ValueType: Boolean }
|
EDIMLColumn IsExcludedFromFulfillmentKPI { Attribute: IsExcludedFromFulfillmentKPI ValueType: Boolean }
|
EDIMLColumn IsExcludedFromOptimization { Attribute: IsExcludedFromOptimization ValueType: Boolean }
|
EDIMLColumn IsPlannedAfterOptimization { Attribute: IsPlannedAfterOptimization 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 ShelfLife { Attribute: ShelfLife ValueType: Real }
|
EDIMLColumn UOMName { Attribute: UOMName ValueType: String }
|
}
|
}
|
EDIODBCLink.Source MPSync_SourceProductsForImport
|
{
|
DataIntegrityStrategy: 'Disabled'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.syncobject'
|
EDIODBCLinkTable PISPSpecifications
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: StockingPointID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn HasUnitOfMeasure
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn InputLotSize
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn IsExcludeShelfLifeAndMaturation
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsExcluded
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsExcludedFromBalancing
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsNegativeInventoryAllowed
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsSafetyStockKept
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn ProductID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn StockingPointID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UnitOfMeasureName
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable ProductLevels
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: Name
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn IsProductCategory
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn Level
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn Name
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable Products
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn DisplayIndex
|
{
|
ValueType: Number
|
}
|
EDIODBCLinkColumn IsByProduct
|
{
|
ValueType: String
|
}
|
EDIODBCLinkColumn IsExcludedFromFulfillmentKPI
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsExcludedFromOptimization
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn HasShelfLife
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsPlannedAfterOptimization
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn MaturationDays
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn HasMaturation
|
{
|
ValueType: String
|
}
|
EDIODBCLinkColumn ID
|
{
|
ValueType: String
|
}
|
EDIODBCLinkColumn IconName
|
{
|
ValueType: String
|
}
|
EDIODBCLinkColumn ParentID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Name
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Notes
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ShelfLife
|
{
|
ValueType: Real
|
}
|
EDIODBCLinkColumn UnitOfMeasureName
|
{
|
ValueType: String
|
}
|
}
|
}
|
EDITransformation.Transformation MPSync_TransformationProductsForImport
|
{
|
EDITableTransformation
|
{
|
InputTable: PISPSpecifications
|
OutputTable: IOPISPSpecification
|
EDIColumnMatch { InputColumn: HasUnitOfMeasure OutputColumn: HasUserUnitOfMeasurement }
|
EDIColumnMatch { InputColumn: InputLotSize OutputColumn: InputLotSize }
|
EDIColumnMatch { InputColumn: IsExcludeShelfLifeAndMaturation OutputColumn: IsExcludeShelfLifeAndMaturation }
|
EDIColumnMatch { InputColumn: IsExcluded OutputColumn: IsExcluded }
|
EDIColumnMatch { InputColumn: IsExcludedFromBalancing OutputColumn: IsExcludedFromBalancing }
|
EDIColumnMatch { InputColumn: IsNegativeInventoryAllowed OutputColumn: IsNegativeInventoryAllowed }
|
EDIColumnMatch { InputColumn: IsSafetyStockKept OutputColumn: IsSafetyStockKept }
|
EDIColumnMatch { InputColumn: ProductID OutputColumn: ProductID }
|
EDIColumnMatch { InputColumn: StockingPointID OutputColumn: StockingPointID }
|
EDIColumnMatch { InputColumn: UnitOfMeasureName OutputColumn: UnitOfMeasurementName }
|
}
|
EDITableTransformation
|
{
|
InputTable: ProductLevels
|
OutputTable: IOProductLevel_MP
|
EDIColumnMatch { InputColumn: IsProductCategory OutputColumn: IsProductCategory }
|
EDIColumnMatch { InputColumn: Level OutputColumn: Level }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
}
|
EDITableTransformation
|
{
|
InputTable: Products
|
OutputTable: IOProduct_MP
|
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: IsByProduct OutputColumn: IsByProduct }
|
EDIColumnMatch { InputColumn: IsExcludedFromFulfillmentKPI OutputColumn: IsExcludedFromFulfillmentKPI }
|
EDIColumnMatch { InputColumn: IsExcludedFromOptimization OutputColumn: IsExcludedFromOptimization }
|
EDIColumnMatch { InputColumn: IsPlannedAfterOptimization OutputColumn: IsPlannedAfterOptimization }
|
EDIColumnMatch { InputColumn: MaturationDays OutputColumn: MaturationDays }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
EDIColumnMatch { InputColumn: Notes OutputColumn: Notes }
|
EDIColumnMatch { InputColumn: ParentID OutputColumn: ParentID }
|
EDIColumnMatch { InputColumn: ShelfLife OutputColumn: ShelfLife }
|
EDIColumnMatch { InputColumn: UnitOfMeasureName OutputColumn: UOMName }
|
}
|
}
|
}
|
