Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MP_ImportProductsBroker
|
{
|
MDSDefinition: MacroPlan
|
EDIModelLink.Destination OutputProductsToModel
|
{
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.outputproductstomodel'
|
EDIMLTable DisaggregationFactor
|
{
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: StockingPointID
|
TargetType: DisaggregationFactor
|
TypeIndex: DisaggregationTypeIndex
|
EDIMLColumn Factor { Attribute: Factor ValueType: Real }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
|
EDIMLTableOwner
|
{
|
TargetType: Product_MP
|
TypeIndex: ProductTypeIndex
|
EDIMLForeignKeyColumn
|
{
|
Column: ProductID
|
TypeIndexAttribute: ID
|
}
|
}
|
}
|
EDIMLTable PISPSpecification
|
{
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: StockingPointID
|
TargetType: PISPSpecification
|
TypeIndex: PISPSpecificationTypeIndex
|
EDIMLColumn HasUnitOfMeasure { Attribute: HasUnitOfMeasure 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 UnitOfMeasureName { Attribute: UnitOfMeasureName ValueType: String }
|
EDIMLTableOwner
|
{
|
TargetType: Product_MP
|
TypeIndex: ProductTypeIndex
|
EDIMLForeignKeyColumn
|
{
|
Column: ProductID
|
TypeIndexAttribute: ID
|
}
|
}
|
}
|
EDIMLTable ProductLevel_MP
|
{
|
PrimaryKeyColumns: Name
|
TargetType: ProductLevel_MP
|
TypeIndex: ProductLevelTypeIndex
|
EDIMLColumn IsProductCategory { Attribute: IsProductCategory ValueType: Boolean }
|
EDIMLColumn LevelForExcel { Attribute: LevelForExcel ValueType: Number }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
}
|
EDIMLTable Product_MP
|
{
|
PrimaryKeyColumns: ID
|
TargetType: Product_MP
|
TypeIndex: ProductTypeIndex
|
EDIMLColumn DisplayIndexForExcel { Attribute: DisplayIndexForExcel 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 UnitOfMeasureName { Attribute: UnitOfMeasureName ValueType: String }
|
}
|
}
|
EDITransformation.Transformation TransformProductsForImport
|
{
|
EDITableTransformation
|
{
|
InputTable: DisaggregationFactors_MP
|
OutputTable: DisaggregationFactor
|
EDIColumnMatch { InputColumn: Factor OutputColumn: Factor }
|
EDIColumnMatch { InputColumn: ProductID OutputColumn: ProductID }
|
EDIColumnMatch { InputColumn: Start OutputColumn: Start }
|
EDIColumnMatch { InputColumn: StockingPointID OutputColumn: StockingPointID }
|
}
|
EDITableTransformation
|
{
|
InputTable: PISPSpecifications_MP
|
OutputTable: PISPSpecification
|
EDIColumnMatch
|
{
|
InputColumn: InputLotSize
|
OutputColumn: InputLotSize
|
}
|
EDIColumnMatch { InputColumn: IsExcludeShelfLifeAndMaturation OutputColumn: IsExcludeShelfLifeAndMaturation }
|
EDIColumnMatch
|
{
|
InputColumn: IsExcludedFromBalancing
|
OutputColumn: IsExcludedFromBalancing
|
}
|
EDIColumnMatch
|
{
|
InputColumn: IsNegativeInventoryAllowed
|
OutputColumn: IsNegativeInventoryAllowed
|
}
|
EDIColumnMatch
|
{
|
InputColumn: HasUnitOfMeasure
|
OutputColumn: HasUnitOfMeasure
|
}
|
EDIColumnMatch
|
{
|
InputColumn: IsSafetyStockKept
|
OutputColumn: IsSafetyStockKept
|
}
|
EDIColumnMatch
|
{
|
InputColumn: StockingPointID
|
OutputColumn: StockingPointID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: ProductID
|
OutputColumn: ProductID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: IsExcluded
|
OutputColumn: IsExcluded
|
}
|
EDIColumnMatch
|
{
|
InputColumn: UnitOfMeasureName
|
OutputColumn: UnitOfMeasureName
|
}
|
}
|
EDITableTransformation
|
{
|
InputTable: ProductLevels_MP
|
OutputTable: ProductLevel_MP
|
EDIColumnMatch
|
{
|
InputColumn: IsProductCategory
|
OutputColumn: IsProductCategory
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Name
|
OutputColumn: Name
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Level
|
OutputColumn: LevelForExcel
|
}
|
}
|
EDITableTransformation
|
{
|
InputTable: Products_MP
|
OutputTable: Product_MP
|
EDIColumnMatch { InputColumn: HasMaturation OutputColumn: HasMaturation }
|
EDIColumnMatch { InputColumn: IsExcludedFromFulfillmentKPI OutputColumn: IsExcludedFromFulfillmentKPI }
|
EDIColumnMatch
|
{
|
InputColumn: IsExcludedFromOptimization
|
OutputColumn: IsExcludedFromOptimization
|
}
|
EDIColumnMatch
|
{
|
InputColumn: IsPlannedAfterOptimization
|
OutputColumn: IsPlannedAfterOptimization
|
}
|
EDIColumnMatch { InputColumn: MaturationDays OutputColumn: MaturationDays }
|
EDIColumnMatch
|
{
|
InputColumn: ShelfLife
|
OutputColumn: ShelfLife
|
}
|
EDIColumnMatch
|
{
|
InputColumn: HasShelfLife
|
OutputColumn: HasShelfLife
|
}
|
EDIColumnMatch
|
{
|
InputColumn: UnitOfMeasureName
|
OutputColumn: UnitOfMeasureName
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Notes
|
OutputColumn: Notes
|
}
|
EDIColumnMatch
|
{
|
InputColumn: ParentID
|
OutputColumn: ParentID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Name
|
OutputColumn: Name
|
}
|
EDIColumnMatch
|
{
|
InputColumn: IconName
|
OutputColumn: IconName
|
}
|
EDIColumnMatch
|
{
|
InputColumn: ID
|
OutputColumn: ID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: IsByProduct
|
OutputColumn: IsByProduct
|
}
|
EDIColumnMatch
|
{
|
InputColumn: DisplayIndex
|
OutputColumn: DisplayIndexForExcel
|
}
|
}
|
}
|
EDIXLSLink.Source InputProductsFromExcel
|
{
|
FileName: 'MP_Products.xlsx'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.inputproductsfromexcel'
|
EDIXLSLinkTable DisaggregationFactors_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn Factor { ValueType: Real }
|
EDIXLSLinkColumn ProductID { ValueType: String }
|
EDIXLSLinkColumn Start { ValueType: Date }
|
EDIXLSLinkColumn StockingPointID { ValueType: String }
|
]
|
}
|
EDIXLSLinkTable PISPSpecifications_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn HasUnitOfMeasure { ValueType: Boolean }
|
EDIXLSLinkColumn InputLotSize { ValueType: Real }
|
EDIXLSLinkColumn IsExcluded { ValueType: Boolean }
|
EDIXLSLinkColumn IsExcludedFromBalancing { ValueType: Boolean }
|
EDIXLSLinkColumn IsNegativeInventoryAllowed { ValueType: Boolean }
|
EDIXLSLinkColumn IsSafetyStockKept { ValueType: Boolean }
|
EDIXLSLinkColumn ProductID { ValueType: String }
|
EDIXLSLinkColumn StockingPointID { ValueType: String }
|
EDIXLSLinkColumn UnitOfMeasureName { ValueType: String }
|
EDIXLSLinkColumn IsExcludeShelfLifeAndMaturation { ValueType: Boolean }
|
]
|
}
|
EDIXLSLinkTable ProductLevels_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn IsProductCategory { ValueType: Boolean }
|
EDIXLSLinkColumn Level { ValueType: Number }
|
EDIXLSLinkColumn Name { ValueType: String }
|
]
|
}
|
EDIXLSLinkTable Products_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn DisplayIndex { ValueType: Number }
|
EDIXLSLinkColumn HasMaturation { ValueType: Boolean }
|
EDIXLSLinkColumn HasShelfLife { ValueType: Boolean }
|
EDIXLSLinkColumn IconName { ValueType: String }
|
EDIXLSLinkColumn ID { ValueType: String }
|
EDIXLSLinkColumn IsByProduct { ValueType: Boolean }
|
EDIXLSLinkColumn IsExcludedFromOptimization { ValueType: Boolean }
|
EDIXLSLinkColumn IsPlannedAfterOptimization { ValueType: Boolean }
|
EDIXLSLinkColumn MaturationDays { ValueType: Real }
|
EDIXLSLinkColumn Name { ValueType: String }
|
EDIXLSLinkColumn Notes { ValueType: String }
|
EDIXLSLinkColumn ParentID { ValueType: String }
|
EDIXLSLinkColumn ShelfLife { ValueType: Real }
|
EDIXLSLinkColumn UnitOfMeasureName { ValueType: String }
|
EDIXLSLinkColumn IsExcludedFromFulfillmentKPI { ValueType: Boolean }
|
]
|
}
|
}
|
}
|
