Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MPSync_ImportProductsFromExcelBroker
|
{
|
MDSDefinition: MPSync
|
EDIModelLink.Destination MPSync_DestinationProductsForExcelImport
|
{
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.outputproductstomodel'
|
EDIMLTable IODisaggregationFactor
|
{
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: StockingPointID
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IODisaggregationFactor
|
TypeIndex: IODisaggregationTypeIndex
|
WithSoftDelete: true
|
EDIMLColumn Factor { Attribute: Factor ValueType: Real }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
|
}
|
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 }
|
}
|
}
|
EDITransformation.Transformation MPSync_TransformationProductsForExcelImport
|
{
|
EDITableTransformation
|
{
|
InputTable: DisaggregationFactors_MP
|
OutputTable: IODisaggregationFactor
|
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: IOPISPSpecification
|
EDIColumnMatch { InputColumn: HasUnitOfMeasure OutputColumn: HasUserUnitOfMeasurement }
|
EDIColumnMatch
|
{
|
InputColumn: InputLotSize
|
OutputColumn: InputLotSize
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<StringToReal xmlns="http://www.quintiq.com/GEB/StringToReal" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<NumericFormatString>Standard</NumericFormatString>
|
<LocaleString>English (United States)</LocaleString>
|
<CurrencyString></CurrencyString>
|
<CustomFormatString></CustomFormatString>
|
</StringToReal>
|
*]
|
}
|
}
|
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_MP
|
OutputTable: IOProductLevel_MP
|
EDIColumnMatch { InputColumn: IsProductCategory OutputColumn: IsProductCategory }
|
EDIColumnMatch { InputColumn: Level OutputColumn: Level }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
}
|
EDITableTransformation
|
{
|
InputTable: Products_MP
|
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 }
|
}
|
}
|
EDIXLSLink.Source MPSync_SourceProductsForExcelImport
|
{
|
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 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 InputLotSize { 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 ID { ValueType: String }
|
EDIXLSLinkColumn IconName { ValueType: String }
|
EDIXLSLinkColumn IsByProduct { ValueType: Boolean }
|
EDIXLSLinkColumn Name { ValueType: String }
|
EDIXLSLinkColumn Notes { ValueType: String }
|
EDIXLSLinkColumn ParentID { ValueType: String }
|
EDIXLSLinkColumn HasShelfLife { ValueType: Boolean }
|
EDIXLSLinkColumn ShelfLife { ValueType: Real }
|
EDIXLSLinkColumn UnitOfMeasureName { ValueType: String }
|
EDIXLSLinkColumn IsExcludedFromOptimization { ValueType: Boolean }
|
EDIXLSLinkColumn IsPlannedAfterOptimization { ValueType: Boolean }
|
EDIXLSLinkColumn HasMaturation { ValueType: String }
|
EDIXLSLinkColumn MaturationDays { ValueType: Real }
|
EDIXLSLinkColumn IsExcludedFromFulfillmentKPI { ValueType: Boolean }
|
]
|
}
|
}
|
}
|
