Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MP_ImportEntityCostsBroker
|
{
|
MDSDefinition: MacroPlan
|
EDIModelLink.Destination OutputEntityCostsToModel
|
{
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.outputentitycoststomodel'
|
EDIMLTable InventoryValueAndCost
|
{
|
PrimaryKeyColumns: ID
|
TargetType: InventoryValueAndCost
|
TypeIndex: InventoryValueAndCostTypeIndex
|
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 ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
|
EDIMLTableOwner
|
{
|
TargetType: Product_MP
|
TypeIndex: ProductTypeIndex
|
EDIMLForeignKeyColumn
|
{
|
Column: ProductID
|
TypeIndexAttribute: ID
|
}
|
}
|
}
|
EDIMLTable LaneCost
|
{
|
PrimaryKeyColumns: ID
|
TargetType: LaneCost
|
TypeIndex: LaneCostTypeIndex
|
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 LaneID { Attribute: LaneID ValueType: String }
|
EDIMLColumn LengthOfTime { Attribute: LengthOfTime ValueType: Number }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn TimeUnit { Attribute: TimeUnit ValueType: String }
|
EDIMLTableOwner
|
{
|
TargetType: Lane
|
TypeIndex: LaneTypeIndex
|
EDIMLForeignKeyColumn
|
{
|
Column: LaneID
|
TypeIndexAttribute: ID
|
}
|
}
|
}
|
EDIMLTable LaneLegCost
|
{
|
PrimaryKeyColumns: ID
|
TargetType: LaneLegCost
|
TypeIndex: LaneLegCostTypeIndex
|
EDIMLColumn AccountName { Attribute: AccountName ValueType: String }
|
EDIMLColumn Cost { Attribute: Cost ValueType: Real }
|
EDIMLColumn CostDriver { Attribute: CostDriver ValueType: String }
|
EDIMLColumn DestinationStockingPointID { Attribute: DestinationStockingPointID ValueType: String }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn LaneID { Attribute: LaneID ValueType: String }
|
EDIMLColumn LengthOfTime { Attribute: LengthOfTime ValueType: Number }
|
EDIMLColumn OriginStockingPointID { Attribute: OriginStockingPointID ValueType: String }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn TimeUnit { Attribute: TimeUnit ValueType: String }
|
EDIMLTableOwner
|
{
|
TargetType: LaneLeg
|
TypeIndex: LaneLegTypeIndex
|
EDIMLForeignKeyColumn
|
{
|
Column: LaneID
|
TypeIndexAttribute: LaneID
|
}
|
EDIMLForeignKeyColumn
|
{
|
Column: OriginStockingPointID
|
TypeIndexAttribute: OriginStockingPointID
|
}
|
EDIMLForeignKeyColumn
|
{
|
Column: DestinationStockingPointID
|
TypeIndexAttribute: DestinationStockingPointID
|
}
|
}
|
}
|
EDIMLTable OperationCost
|
{
|
PrimaryKeyColumns: ID
|
TargetType: OperationCost
|
TypeIndex: OperationCostTypeIndex
|
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 LengthOfTime { Attribute: LengthOfTime ValueType: Number }
|
EDIMLColumn OperationID { Attribute: OperationID ValueType: String }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn TimeUnit { Attribute: TimeUnit ValueType: String }
|
EDIMLTableOwner
|
{
|
TargetType: Operation
|
TypeIndex: OperationTypeIndex
|
EDIMLForeignKeyColumn
|
{
|
Column: OperationID
|
TypeIndexAttribute: ID
|
}
|
}
|
}
|
EDIMLTable ProductValueAndCost
|
{
|
PrimaryKeyColumns: ID
|
TargetType: ProductValueAndCost
|
TypeIndex: ProductValueAndCostTypeIndex
|
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 ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLTableOwner
|
{
|
TargetType: Product_MP
|
TypeIndex: ProductTypeIndex
|
EDIMLForeignKeyColumn
|
{
|
Column: ProductID
|
TypeIndexAttribute: ID
|
}
|
}
|
}
|
EDIMLTable StockingPointCost
|
{
|
PrimaryKeyColumns: ID
|
TargetType: StockingPointCost
|
TypeIndex: StockingPointCostTypeIndex
|
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 LengthOfTime { Attribute: LengthOfTime ValueType: Number }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
|
EDIMLColumn TimeUnit { Attribute: TimeUnit ValueType: String }
|
EDIMLTableOwner
|
{
|
TargetType: StockingPoint_MP
|
TypeIndex: StockingPointTypeIndex
|
EDIMLForeignKeyColumn
|
{
|
Column: StockingPointID
|
TypeIndexAttribute: ID
|
}
|
}
|
}
|
EDIMLTable UnitCost
|
{
|
PrimaryKeyColumns: ID
|
TargetType: UnitCost
|
TypeIndex: UnitCostTypeIndex
|
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 LengthOfTime { Attribute: LengthOfTime ValueType: Number }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn TimeUnit { Attribute: TimeUnit ValueType: String }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
EDIMLTableOwner
|
{
|
TargetType: Unit
|
TypeIndex: UnitTypeIndex
|
EDIMLForeignKeyColumn
|
{
|
Column: UnitID
|
TypeIndexAttribute: ID
|
}
|
}
|
}
|
}
|
EDITransformation.Transformation TransformEntityCostsForImport
|
{
|
EDITableTransformation
|
{
|
InputTable: InventoryValueAndCosts_MP
|
OutputTable: InventoryValueAndCost
|
EDIColumnMatch
|
{
|
InputColumn: ProductID
|
OutputColumn: ProductID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Start
|
OutputColumn: Start
|
}
|
EDIColumnMatch
|
{
|
InputColumn: StockingPointID
|
OutputColumn: StockingPointID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: ID
|
OutputColumn: ID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: AccountName
|
OutputColumn: AccountName
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Cost
|
OutputColumn: Cost
|
}
|
EDIColumnMatch
|
{
|
InputColumn: CostDriver
|
OutputColumn: CostDriver
|
}
|
}
|
EDITableTransformation
|
{
|
InputTable: LaneCosts_MP
|
OutputTable: LaneCost
|
EDIColumnMatch
|
{
|
InputColumn: AccountName
|
OutputColumn: AccountName
|
}
|
EDIColumnMatch
|
{
|
InputColumn: LaneID
|
OutputColumn: LaneID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: ID
|
OutputColumn: ID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: TimeUnit
|
OutputColumn: TimeUnit
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Cost
|
OutputColumn: Cost
|
}
|
EDIColumnMatch
|
{
|
InputColumn: LengthOfTime
|
OutputColumn: LengthOfTime
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Start
|
OutputColumn: Start
|
}
|
EDIColumnMatch
|
{
|
InputColumn: CostDriver
|
OutputColumn: CostDriver
|
}
|
}
|
EDITableTransformation
|
{
|
InputTable: LaneLegCosts_MP
|
OutputTable: LaneLegCost
|
EDIColumnMatch
|
{
|
InputColumn: AccountName
|
OutputColumn: AccountName
|
}
|
EDIColumnMatch
|
{
|
InputColumn: DestinationStockingPointID
|
OutputColumn: DestinationStockingPointID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: LaneID
|
OutputColumn: LaneID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: TimeUnit
|
OutputColumn: TimeUnit
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Start
|
OutputColumn: Start
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Cost
|
OutputColumn: Cost
|
}
|
EDIColumnMatch
|
{
|
InputColumn: ID
|
OutputColumn: ID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: LengthOfTime
|
OutputColumn: LengthOfTime
|
}
|
EDIColumnMatch
|
{
|
InputColumn: OriginStockingPointID
|
OutputColumn: OriginStockingPointID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: CostDriver
|
OutputColumn: CostDriver
|
}
|
}
|
EDITableTransformation
|
{
|
InputTable: OperationCosts_MP
|
OutputTable: OperationCost
|
EDIColumnMatch
|
{
|
InputColumn: AccountName
|
OutputColumn: AccountName
|
}
|
EDIColumnMatch
|
{
|
InputColumn: OperationID
|
OutputColumn: OperationID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: ID
|
OutputColumn: ID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: TimeUnit
|
OutputColumn: TimeUnit
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Cost
|
OutputColumn: Cost
|
}
|
EDIColumnMatch
|
{
|
InputColumn: LengthOfTime
|
OutputColumn: LengthOfTime
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Start
|
OutputColumn: Start
|
}
|
EDIColumnMatch
|
{
|
InputColumn: CostDriver
|
OutputColumn: CostDriver
|
}
|
}
|
EDITableTransformation
|
{
|
InputTable: ProductValueAndCosts_MP
|
OutputTable: ProductValueAndCost
|
EDIColumnMatch
|
{
|
InputColumn: Start
|
OutputColumn: Start
|
}
|
EDIColumnMatch
|
{
|
InputColumn: ID
|
OutputColumn: ID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: CostDriver
|
OutputColumn: CostDriver
|
}
|
EDIColumnMatch
|
{
|
InputColumn: AccountName
|
OutputColumn: AccountName
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Cost
|
OutputColumn: Cost
|
}
|
EDIColumnMatch
|
{
|
InputColumn: ProductID
|
OutputColumn: ProductID
|
}
|
}
|
EDITableTransformation
|
{
|
InputTable: StockingPointCosts_MP
|
OutputTable: StockingPointCost
|
EDIColumnMatch
|
{
|
InputColumn: CostDriver
|
OutputColumn: CostDriver
|
}
|
EDIColumnMatch
|
{
|
InputColumn: StockingPointID
|
OutputColumn: StockingPointID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: ID
|
OutputColumn: ID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: TimeUnit
|
OutputColumn: TimeUnit
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Cost
|
OutputColumn: Cost
|
}
|
EDIColumnMatch
|
{
|
InputColumn: LengthOfTime
|
OutputColumn: LengthOfTime
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Start
|
OutputColumn: Start
|
}
|
EDIColumnMatch
|
{
|
InputColumn: AccountName
|
OutputColumn: AccountName
|
}
|
}
|
EDITableTransformation
|
{
|
InputTable: UnitCosts_MP
|
OutputTable: UnitCost
|
EDIColumnMatch
|
{
|
InputColumn: AccountName
|
OutputColumn: AccountName
|
}
|
EDIColumnMatch
|
{
|
InputColumn: UnitID
|
OutputColumn: UnitID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: ID
|
OutputColumn: ID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: TimeUnit
|
OutputColumn: TimeUnit
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Cost
|
OutputColumn: Cost
|
}
|
EDIColumnMatch
|
{
|
InputColumn: LengthOfTime
|
OutputColumn: LengthOfTime
|
}
|
EDIColumnMatch
|
{
|
InputColumn: Start
|
OutputColumn: Start
|
}
|
EDIColumnMatch
|
{
|
InputColumn: CostDriver
|
OutputColumn: CostDriver
|
}
|
}
|
}
|
EDIXLSLink.Source InputEntityCostsFromExcel
|
{
|
FileName: 'MP_EntityCosts.xlsx'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.inputentitycostsfromexcel'
|
EDIXLSLinkTable InventoryValueAndCosts_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn AccountName { ValueType: String }
|
EDIXLSLinkColumn Cost { ValueType: Real }
|
EDIXLSLinkColumn CostDriver { ValueType: String }
|
EDIXLSLinkColumn ID { ValueType: String }
|
EDIXLSLinkColumn ProductID { ValueType: String }
|
EDIXLSLinkColumn Start { ValueType: Date }
|
EDIXLSLinkColumn StockingPointID { ValueType: String }
|
]
|
}
|
EDIXLSLinkTable LaneCosts_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn Cost { ValueType: Real }
|
EDIXLSLinkColumn ID { ValueType: String }
|
EDIXLSLinkColumn LaneID { ValueType: String }
|
EDIXLSLinkColumn LengthOfTime { ValueType: Number }
|
EDIXLSLinkColumn Start { ValueType: Date }
|
EDIXLSLinkColumn TimeUnit { ValueType: String }
|
EDIXLSLinkColumn AccountName { ValueType: String }
|
EDIXLSLinkColumn CostDriver { ValueType: String }
|
]
|
}
|
EDIXLSLinkTable LaneLegCosts_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn Cost { ValueType: Real }
|
EDIXLSLinkColumn DestinationStockingPointID { ValueType: String }
|
EDIXLSLinkColumn ID { ValueType: String }
|
EDIXLSLinkColumn LaneID { ValueType: String }
|
EDIXLSLinkColumn LengthOfTime { ValueType: Number }
|
EDIXLSLinkColumn OriginStockingPointID { ValueType: String }
|
EDIXLSLinkColumn Start { ValueType: Date }
|
EDIXLSLinkColumn TimeUnit { ValueType: String }
|
EDIXLSLinkColumn AccountName { ValueType: String }
|
EDIXLSLinkColumn CostDriver { ValueType: String }
|
]
|
}
|
EDIXLSLinkTable OperationCosts_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn Cost { ValueType: Real }
|
EDIXLSLinkColumn ID { ValueType: String }
|
EDIXLSLinkColumn LengthOfTime { ValueType: Number }
|
EDIXLSLinkColumn OperationID { ValueType: String }
|
EDIXLSLinkColumn Start { ValueType: Date }
|
EDIXLSLinkColumn TimeUnit { ValueType: String }
|
EDIXLSLinkColumn AccountName { ValueType: String }
|
EDIXLSLinkColumn CostDriver { ValueType: String }
|
]
|
}
|
EDIXLSLinkTable ProductValueAndCosts_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn AccountName { ValueType: String }
|
EDIXLSLinkColumn Cost { ValueType: Real }
|
EDIXLSLinkColumn CostDriver { ValueType: String }
|
EDIXLSLinkColumn ID { ValueType: String }
|
EDIXLSLinkColumn Start { ValueType: Date }
|
EDIXLSLinkColumn ProductID { ValueType: String }
|
]
|
}
|
EDIXLSLinkTable StockingPointCosts_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn Cost { ValueType: Real }
|
EDIXLSLinkColumn ID { ValueType: String }
|
EDIXLSLinkColumn LengthOfTime { ValueType: Number }
|
EDIXLSLinkColumn Start { ValueType: Date }
|
EDIXLSLinkColumn StockingPointID { ValueType: String }
|
EDIXLSLinkColumn TimeUnit { ValueType: String }
|
EDIXLSLinkColumn AccountName { ValueType: String }
|
EDIXLSLinkColumn CostDriver { ValueType: String }
|
]
|
}
|
EDIXLSLinkTable UnitCosts_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn Cost { ValueType: Real }
|
EDIXLSLinkColumn ID { ValueType: String }
|
EDIXLSLinkColumn LengthOfTime { ValueType: Number }
|
EDIXLSLinkColumn Start { ValueType: Date }
|
EDIXLSLinkColumn TimeUnit { ValueType: String }
|
EDIXLSLinkColumn UnitID { ValueType: String }
|
EDIXLSLinkColumn AccountName { ValueType: String }
|
EDIXLSLinkColumn CostDriver { ValueType: String }
|
]
|
}
|
}
|
}
|
