Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MPSync_ImportStockingPointCapacitiesFromExcelBroker
|
{
|
MDSDefinition: MPSync
|
EDIModelLink.Destination MPSync_DestinationStockingPointCapacitiesForExcelImport
|
{
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.outputstockingpointcapacitiestomodel'
|
EDIMLTable IOStockingPointCapacity
|
{
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: StockingPointID
|
TargetType: IOStockingPointCapacity
|
TypeIndex: IOStockingPointCapacityTypeIndex
|
EDIMLColumn MaxCapacity { Attribute: MaxCapacity ValueType: Real }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
|
}
|
}
|
EDITransformation.Transformation MPSync_TransformationStockingPointCapacitiesForExcelImport
|
{
|
EDITableTransformation
|
{
|
InputTable: StockingPointCapacities_MP
|
OutputTable: IOStockingPointCapacity
|
EDIColumnMatch { InputColumn: MaxCapacity OutputColumn: MaxCapacity }
|
EDIColumnMatch { InputColumn: Start OutputColumn: Start }
|
EDIColumnMatch { InputColumn: StockingPointID OutputColumn: StockingPointID }
|
}
|
}
|
EDIXLSLink.Source MPSync_SourceStockingPointCapacitiesForExcelImport
|
{
|
FileName: 'MP_StockingPointCapacities.xlsx'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.inputstockingpointcapacitiesfromexcel'
|
EDIXLSLinkTable StockingPointCapacities_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn MaxCapacity { ValueType: Real }
|
EDIXLSLinkColumn Start { ValueType: Date }
|
EDIXLSLinkColumn StockingPointID { ValueType: String }
|
]
|
}
|
}
|
}
|
