Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MPSync_ImportInventorySuppliesFromExcelBroker
|
{
|
MDSDefinition: MPSync
|
EDIModelLink.Destination MPSync_DestinationInventorySuppliesForExcelImport
|
{
|
EDIMLTable IOInventorySupply
|
{
|
PrimaryKeyColumns: ID
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IOInventorySupply
|
TypeIndex: IOInventorySupplyTypeIndex
|
WithSoftDelete: true
|
EDIMLColumn Date { Attribute: Date ValueType: Date }
|
EDIMLColumn Description { Attribute: Description ValueType: String }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn ManufacturedDate { Attribute: ManufacturedDate ValueType: Date }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
|
EDIMLColumn UserQuantity { Attribute: UserQuantity ValueType: Real }
|
}
|
EDIMLTable IOInventorySupplyCost
|
{
|
PrimaryKeyColumns: ID
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IOInventorySupplyCost
|
TypeIndex: IOInventorySupplyCostTypeIndex
|
WithSoftDelete: true
|
EDIMLColumn AccountName { Attribute: AccountName ValueType: String }
|
EDIMLColumn Cost { Attribute: Cost ValueType: Real }
|
EDIMLColumn CostDriver { Attribute: CostDriver ValueType: String }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn InventorySupplyID { Attribute: InventorySupplyID ValueType: String }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
}
|
}
|
EDITransformation.Transformation MPSync_TransformationInventorySuppliesForExcelImport
|
{
|
EDITableTransformation
|
{
|
InputTable: ExternalSupplies_MP
|
OutputTable: IOInventorySupply
|
EDIColumnMatch { InputColumn: Date OutputColumn: Date }
|
EDIColumnMatch { InputColumn: Description OutputColumn: Description }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: ManufacturedDate OutputColumn: ManufacturedDate }
|
EDIColumnMatch { InputColumn: ProductID OutputColumn: ProductID }
|
EDIColumnMatch { InputColumn: StockingPointID OutputColumn: StockingPointID }
|
EDIColumnMatch { InputColumn: UserQuantity OutputColumn: UserQuantity }
|
}
|
EDITableTransformation
|
{
|
InputTable: InventorySupplyCosts_MP
|
OutputTable: IOInventorySupplyCost
|
EDIColumnMatch { InputColumn: AccountName OutputColumn: AccountName }
|
EDIColumnMatch { InputColumn: Cost OutputColumn: Cost }
|
EDIColumnMatch { InputColumn: CostDriver OutputColumn: CostDriver }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: InventorySupplyID OutputColumn: InventorySupplyID }
|
EDIColumnMatch { InputColumn: Start OutputColumn: Start }
|
}
|
}
|
EDIXLSLink.Source MPSync_SourceInventorySuppliesForExcelImport
|
{
|
FileName: 'MP_ExternalSupplies.xlsx'
|
EDIXLSLinkTable ExternalSupplies_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn Date { ValueType: Date }
|
EDIXLSLinkColumn Description { ValueType: String }
|
EDIXLSLinkColumn ID { ValueType: String }
|
EDIXLSLinkColumn ProductID { ValueType: String }
|
EDIXLSLinkColumn StockingPointID { ValueType: String }
|
EDIXLSLinkColumn UserQuantity { ValueType: Real }
|
EDIXLSLinkColumn ManufacturedDate { ValueType: Date }
|
]
|
}
|
EDIXLSLinkTable InventorySupplyCosts_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn AccountName { ValueType: String }
|
EDIXLSLinkColumn Cost { ValueType: Real }
|
EDIXLSLinkColumn CostDriver { ValueType: String }
|
EDIXLSLinkColumn ID { ValueType: String }
|
EDIXLSLinkColumn InventorySupplyID { ValueType: String }
|
EDIXLSLinkColumn Start { ValueType: Date }
|
]
|
}
|
}
|
}
|