Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MPSync_ImportStockingPointsFromExcelBroker
|
{
|
MDSDefinition: MPSync
|
EDIModelLink.Destination MPSync_DestinationStockingPointsForExcelImport
|
{
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.outputstockingpointstomodel'
|
EDIMLTable IOStockingPoint_MP
|
{
|
PrimaryKeyColumns: ID
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IOStockingPoint_MP
|
TypeIndex: IOStockingPointTypeIndex
|
WithSoftDelete: true
|
EDIMLColumn CurrencyID { Attribute: CurrencyID ValueType: String }
|
EDIMLColumn DisplayIndex { Attribute: DisplayIndex ValueType: Number }
|
EDIMLColumn End { Attribute: End ValueType: Date }
|
EDIMLColumn GISCity { Attribute: GISCity ValueType: String }
|
EDIMLColumn GISCountryCode { Attribute: GISCountryCode ValueType: String }
|
EDIMLColumn GISPostalCode { Attribute: GISPostalCode ValueType: String }
|
EDIMLColumn GroupName { Attribute: GroupName ValueType: String }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn IconName { Attribute: IconName ValueType: String }
|
EDIMLColumn IsPlannedInfinite { Attribute: IsPlannedInfinite ValueType: Boolean }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn Notes { Attribute: Notes ValueType: String }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
EDIMLColumn UnitOfMeasureName { Attribute: UnitOfMeasureName ValueType: String }
|
}
|
}
|
EDITransformation.Transformation MPSync_TransformationStockingPointsForExcelImport
|
{
|
EDITableTransformation
|
{
|
InputTable: StockingPoints_MP
|
OutputTable: IOStockingPoint_MP
|
EDIColumnMatch { InputColumn: CurrencyID OutputColumn: CurrencyID }
|
EDIColumnMatch { InputColumn: DisplayIndex OutputColumn: DisplayIndex }
|
EDIColumnMatch { InputColumn: End OutputColumn: End }
|
EDIColumnMatch { InputColumn: GISCity OutputColumn: GISCity }
|
EDIColumnMatch { InputColumn: GISCountryCode OutputColumn: GISCountryCode }
|
EDIColumnMatch { InputColumn: GISPostalCode OutputColumn: GISPostalCode }
|
EDIColumnMatch { InputColumn: GroupName OutputColumn: GroupName }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: IconName OutputColumn: IconName }
|
EDIColumnMatch { InputColumn: IsPlannedInfinite OutputColumn: IsPlannedInfinite }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
EDIColumnMatch { InputColumn: Notes OutputColumn: Notes }
|
EDIColumnMatch { InputColumn: Start OutputColumn: Start }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
EDIColumnMatch { InputColumn: UnitOfMeasureName OutputColumn: UnitOfMeasureName }
|
}
|
}
|
EDIXLSLink.Source MPSync_SourceStockingPointsForExcelImport
|
{
|
FileName: 'MP_StockingPoints.xlsx'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.inputstockingpointsfromexcel'
|
EDIXLSLinkTable StockingPoints_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn CurrencyID { ValueType: String }
|
EDIXLSLinkColumn End { ValueType: Date }
|
EDIXLSLinkColumn GISCity { ValueType: String }
|
EDIXLSLinkColumn GISCountryCode { ValueType: String }
|
EDIXLSLinkColumn GISPostalCode { ValueType: String }
|
EDIXLSLinkColumn GroupName { ValueType: String }
|
EDIXLSLinkColumn IconName { ValueType: String }
|
EDIXLSLinkColumn ID { ValueType: String }
|
EDIXLSLinkColumn IsPlannedInfinite { ValueType: Boolean }
|
EDIXLSLinkColumn Name { ValueType: String }
|
EDIXLSLinkColumn Notes { ValueType: String }
|
EDIXLSLinkColumn Start { ValueType: Date }
|
EDIXLSLinkColumn UnitID { ValueType: String }
|
EDIXLSLinkColumn UnitOfMeasureName { ValueType: String }
|
EDIXLSLinkColumn DisplayIndex { ValueType: Number }
|
]
|
}
|
}
|
}
|
