Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MP_ImportSupplySpecificationsBroker
|
{
|
MDSDefinition: MacroPlan
|
EDIModelLink.Destination OutputSupplySpecificationsToModel
|
{
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.outputsupplyspecificationstomodel'
|
EDIMLTable SupplySpecification
|
{
|
PrimaryKeyColumns: End
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: UnitID
|
TargetType: SupplySpecification
|
TypeIndex: SupplySpecificationTypeIndex
|
EDIMLColumn End { Attribute: End ValueType: DateTime }
|
EDIMLColumn HasMaxQuantity { Attribute: HasMaxQuantity ValueType: Boolean }
|
EDIMLColumn MaxQuantity { Attribute: MaxQuantity ValueType: Real }
|
EDIMLColumn MinQuantity { Attribute: MinQuantity ValueType: Real }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn Start { Attribute: Start ValueType: DateTime }
|
EDIMLColumn TargetQuantity { Attribute: TargetQuantity ValueType: Real }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
EDIMLTableOwner
|
{
|
TargetType: Unit
|
TypeIndex: UnitTypeIndex
|
EDIMLForeignKeyColumn
|
{
|
Column: UnitID
|
TypeIndexAttribute: ID
|
}
|
}
|
}
|
}
|
EDITransformation.Transformation TransformSupplySpecificationsForImport
|
{
|
EDITableTransformation
|
{
|
InputTable: SupplySpecifications_MP
|
OutputTable: SupplySpecification
|
EDIColumnMatch
|
{
|
InputColumn: MinQuantity
|
OutputColumn: MinQuantity
|
}
|
EDIColumnMatch
|
{
|
InputColumn: MaxQuantity
|
OutputColumn: MaxQuantity
|
}
|
EDIColumnMatch
|
{
|
InputColumn: UnitID
|
OutputColumn: UnitID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Start
|
OutputColumn: Start
|
}
|
EDIColumnMatch
|
{
|
InputColumn: End
|
OutputColumn: End
|
}
|
EDIColumnMatch
|
{
|
InputColumn: ProductID
|
OutputColumn: ProductID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: HasMaxQuantity
|
OutputColumn: HasMaxQuantity
|
}
|
EDIColumnMatch
|
{
|
InputColumn: TargetQuantity
|
OutputColumn: TargetQuantity
|
}
|
}
|
}
|
EDIXLSLink.Source InputSupplySpecificationsFromExcel
|
{
|
FileName: 'MP_SupplySpecifications.xlsx'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.inputsupplyspecificationsfromexcel'
|
EDIXLSLinkTable SupplySpecifications_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn End { ValueType: DateTime }
|
EDIXLSLinkColumn HasMaxQuantity { ValueType: Boolean }
|
EDIXLSLinkColumn MaxQuantity { ValueType: Real }
|
EDIXLSLinkColumn MinQuantity { ValueType: Real }
|
EDIXLSLinkColumn ProductID { ValueType: String }
|
EDIXLSLinkColumn Start { ValueType: DateTime }
|
EDIXLSLinkColumn TargetQuantity { ValueType: Real }
|
EDIXLSLinkColumn UnitID { ValueType: String }
|
]
|
}
|
}
|
}
|
