Quintiq file version 2.0
|
#parent: #root
|
EDIBroker Converter_Q1Q2_ImportInventoryValue
|
{
|
MDSDefinition: MacroPlan
|
EDIModelLink.Destination DestinationConverterInventoryValue
|
{
|
EDIMLTable Converter_InventoryValue
|
{
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: StockingPointID
|
TargetType: Converter_InventoryValue
|
TypeIndex: IVTypeIndex
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
|
EDIMLColumn Value { Attribute: Value ValueType: Real }
|
}
|
}
|
EDITransformation.Transformation TransformationConverterInventoryValue
|
{
|
EDITableTransformation
|
{
|
InputTable: InventoryValues_MP
|
OutputTable: Converter_InventoryValue
|
EDIColumnMatch
|
{
|
InputColumn: StockingPointID
|
OutputColumn: StockingPointID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Start
|
OutputColumn: Start
|
}
|
EDIColumnMatch
|
{
|
InputColumn: ProductID
|
OutputColumn: ProductID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Value
|
OutputColumn: Value
|
}
|
}
|
}
|
EDIXLSLink.Source SourceConverterInventoryValue
|
{
|
FileName: 'MP_InventoryValues.xlsx'
|
MDSDependent: true
|
EDIXLSLinkTable InventoryValues_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn ProductID { ValueType: String }
|
EDIXLSLinkColumn Start { ValueType: Date }
|
EDIXLSLinkColumn StockingPointID { ValueType: String }
|
EDIXLSLinkColumn Value { ValueType: Real }
|
]
|
}
|
}
|
}
|
