Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MP_ImportStockingPointCapacitiesBroker
|
{
|
MDSDefinition: MacroPlan
|
EDIModelLink.Destination OutputStockingPointCapacitiesToModel
|
{
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.outputstockingpointcapacitiestomodel'
|
EDIMLTable StockingPointCapacity
|
{
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: StockingPointID
|
TargetType: StockingPointCapacity
|
TypeIndex: StockingPointCapacityTypeIndex
|
EDIMLColumn MaxCapacity { Attribute: MaxCapacity ValueType: Real }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
|
EDIMLTableOwner
|
{
|
TargetType: StockingPoint_MP
|
TypeIndex: StockingPointTypeIndex
|
EDIMLForeignKeyColumn
|
{
|
Column: StockingPointID
|
TypeIndexAttribute: ID
|
}
|
}
|
}
|
}
|
EDITransformation.Transformation TransformStockingPointCapacitiesForImport
|
{
|
EDITableTransformation
|
{
|
InputTable: StockingPointCapacities_MP
|
OutputTable: StockingPointCapacity
|
EDIColumnMatch
|
{
|
InputColumn: MaxCapacity
|
OutputColumn: MaxCapacity
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Start
|
OutputColumn: Start
|
}
|
EDIColumnMatch
|
{
|
InputColumn: StockingPointID
|
OutputColumn: StockingPointID
|
}
|
}
|
}
|
EDIXLSLink.Source InputStockingPointCapacitiesFromExcel
|
{
|
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 }
|
]
|
}
|
}
|
}
|
