Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MPSync_ImportEntityCostsFromExcelBroker
|
{
|
MDSDefinition: MPSync
|
EDIModelLink.Destination MPSync_DestinationEntityCostsForExcelImport
|
{
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.outputentitycoststomodel'
|
EDIMLTable IOInventoryValueAndCost
|
{
|
PrimaryKeyColumns: ID
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IOInventoryValueAndCost
|
TypeIndex: IOInventoryValueAndCostTypeIndex
|
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 ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
|
}
|
EDIMLTable IOLaneCost
|
{
|
PrimaryKeyColumns: ID
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IOLaneCost
|
TypeIndex: IOLaneCostTypeIndex
|
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 LaneID { Attribute: LaneID ValueType: String }
|
EDIMLColumn LengthOfTime { Attribute: LengthOfTime ValueType: Number }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn TimeUnit { Attribute: TimeUnit ValueType: String }
|
}
|
EDIMLTable IOLaneLegCost
|
{
|
PrimaryKeyColumns: ID
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IOLaneLegCost
|
TypeIndex: IOLaneLegCostTypeIndex
|
WithSoftDelete: true
|
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 }
|
}
|
EDIMLTable IOOperationCost
|
{
|
PrimaryKeyColumns: ID
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IOOperationCost
|
TypeIndex: IOOperationCostTypeIndex
|
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 LengthOfTime { Attribute: LengthOfTime ValueType: Number }
|
EDIMLColumn OperationID { Attribute: OperationID ValueType: String }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn TimeUnit { Attribute: TimeUnit ValueType: String }
|
}
|
EDIMLTable IOProductValueAndCost
|
{
|
PrimaryKeyColumns: ID
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IOProductValueAndCost
|
TypeIndex: IOProductValueAndCostTypeIndex
|
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 ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
}
|
EDIMLTable IOStockingPointCost
|
{
|
PrimaryKeyColumns: ID
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IOStockingPointCost
|
TypeIndex: IOStockingPointCostTypeIndex
|
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 LengthOfTime { Attribute: LengthOfTime ValueType: Number }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
|
EDIMLColumn TimeUnit { Attribute: TimeUnit ValueType: String }
|
}
|
EDIMLTable IOUnitCost
|
{
|
PrimaryKeyColumns: ID
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IOUnitCost
|
TypeIndex: IOUnitCostTypeIndex
|
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 LengthOfTime { Attribute: LengthOfTime ValueType: Number }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn TimeUnit { Attribute: TimeUnit ValueType: String }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
}
|
}
|
EDITransformation.Transformation MPSync_TransformationEntityCostsForExcelImport
|
{
|
EDITableTransformation
|
{
|
InputTable: InventoryValueAndCosts_MP
|
OutputTable: IOInventoryValueAndCost
|
EDIColumnMatch { InputColumn: AccountName OutputColumn: AccountName }
|
EDIColumnMatch { InputColumn: Cost OutputColumn: Cost }
|
EDIColumnMatch { InputColumn: CostDriver OutputColumn: CostDriver }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: ProductID OutputColumn: ProductID }
|
EDIColumnMatch { InputColumn: Start OutputColumn: Start }
|
EDIColumnMatch { InputColumn: StockingPointID OutputColumn: StockingPointID }
|
}
|
EDITableTransformation
|
{
|
InputTable: LaneCosts_MP
|
OutputTable: IOLaneCost
|
EDIColumnMatch { InputColumn: AccountName OutputColumn: AccountName }
|
EDIColumnMatch { InputColumn: Cost OutputColumn: Cost }
|
EDIColumnMatch { InputColumn: CostDriver OutputColumn: CostDriver }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: LaneID OutputColumn: LaneID }
|
EDIColumnMatch { InputColumn: LengthOfTime OutputColumn: LengthOfTime }
|
EDIColumnMatch { InputColumn: Start OutputColumn: Start }
|
EDIColumnMatch { InputColumn: TimeUnit OutputColumn: TimeUnit }
|
}
|
EDITableTransformation
|
{
|
InputTable: LaneLegCosts_MP
|
OutputTable: IOLaneLegCost
|
EDIColumnMatch { InputColumn: AccountName OutputColumn: AccountName }
|
EDIColumnMatch { InputColumn: Cost OutputColumn: Cost }
|
EDIColumnMatch { InputColumn: CostDriver OutputColumn: CostDriver }
|
EDIColumnMatch { InputColumn: DestinationStockingPointID OutputColumn: DestinationStockingPointID }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: LaneID OutputColumn: LaneID }
|
EDIColumnMatch { InputColumn: LengthOfTime OutputColumn: LengthOfTime }
|
EDIColumnMatch { InputColumn: OriginStockingPointID OutputColumn: OriginStockingPointID }
|
EDIColumnMatch { InputColumn: Start OutputColumn: Start }
|
EDIColumnMatch { InputColumn: TimeUnit OutputColumn: TimeUnit }
|
}
|
EDITableTransformation
|
{
|
InputTable: OperationCosts_MP
|
OutputTable: IOOperationCost
|
EDIColumnMatch { InputColumn: AccountName OutputColumn: AccountName }
|
EDIColumnMatch { InputColumn: Cost OutputColumn: Cost }
|
EDIColumnMatch { InputColumn: CostDriver OutputColumn: CostDriver }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: LengthOfTime OutputColumn: LengthOfTime }
|
EDIColumnMatch { InputColumn: OperationID OutputColumn: OperationID }
|
EDIColumnMatch { InputColumn: Start OutputColumn: Start }
|
EDIColumnMatch { InputColumn: TimeUnit OutputColumn: TimeUnit }
|
}
|
EDITableTransformation
|
{
|
InputTable: ProductValueAndCosts_MP
|
OutputTable: IOProductValueAndCost
|
EDIColumnMatch { InputColumn: AccountName OutputColumn: AccountName }
|
EDIColumnMatch { InputColumn: Cost OutputColumn: Cost }
|
EDIColumnMatch { InputColumn: CostDriver OutputColumn: CostDriver }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: ProductID OutputColumn: ProductID }
|
EDIColumnMatch { InputColumn: Start OutputColumn: Start }
|
}
|
EDITableTransformation
|
{
|
InputTable: StockingPointCosts_MP
|
OutputTable: IOStockingPointCost
|
EDIColumnMatch { InputColumn: AccountName OutputColumn: AccountName }
|
EDIColumnMatch { InputColumn: Cost OutputColumn: Cost }
|
EDIColumnMatch { InputColumn: CostDriver OutputColumn: CostDriver }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: LengthOfTime OutputColumn: LengthOfTime }
|
EDIColumnMatch { InputColumn: Start OutputColumn: Start }
|
EDIColumnMatch { InputColumn: StockingPointID OutputColumn: StockingPointID }
|
EDIColumnMatch { InputColumn: TimeUnit OutputColumn: TimeUnit }
|
}
|
EDITableTransformation
|
{
|
InputTable: UnitCosts_MP
|
OutputTable: IOUnitCost
|
EDIColumnMatch { InputColumn: AccountName OutputColumn: AccountName }
|
EDIColumnMatch { InputColumn: Cost OutputColumn: Cost }
|
EDIColumnMatch { InputColumn: CostDriver OutputColumn: CostDriver }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: LengthOfTime OutputColumn: LengthOfTime }
|
EDIColumnMatch { InputColumn: Start OutputColumn: Start }
|
EDIColumnMatch { InputColumn: TimeUnit OutputColumn: TimeUnit }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
}
|
}
|
EDIXLSLink.Source MPSync_SourceEntityCostsForExcelImport
|
{
|
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 AccountName { ValueType: String }
|
EDIXLSLinkColumn Cost { ValueType: Real }
|
EDIXLSLinkColumn CostDriver { ValueType: String }
|
EDIXLSLinkColumn ID { ValueType: String }
|
EDIXLSLinkColumn LaneID { ValueType: String }
|
EDIXLSLinkColumn LengthOfTime { ValueType: Number }
|
EDIXLSLinkColumn Start { ValueType: Date }
|
EDIXLSLinkColumn TimeUnit { ValueType: String }
|
]
|
}
|
EDIXLSLinkTable LaneLegCosts_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn AccountName { ValueType: String }
|
EDIXLSLinkColumn Cost { ValueType: Real }
|
EDIXLSLinkColumn CostDriver { ValueType: String }
|
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 }
|
]
|
}
|
EDIXLSLinkTable OperationCosts_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn AccountName { ValueType: String }
|
EDIXLSLinkColumn Cost { ValueType: Real }
|
EDIXLSLinkColumn CostDriver { ValueType: String }
|
EDIXLSLinkColumn ID { ValueType: String }
|
EDIXLSLinkColumn LengthOfTime { ValueType: Number }
|
EDIXLSLinkColumn OperationID { ValueType: String }
|
EDIXLSLinkColumn Start { ValueType: Date }
|
EDIXLSLinkColumn TimeUnit { ValueType: String }
|
]
|
}
|
EDIXLSLinkTable ProductValueAndCosts_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 }
|
]
|
}
|
EDIXLSLinkTable StockingPointCosts_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn AccountName { ValueType: String }
|
EDIXLSLinkColumn Cost { ValueType: Real }
|
EDIXLSLinkColumn CostDriver { ValueType: String }
|
EDIXLSLinkColumn ID { ValueType: String }
|
EDIXLSLinkColumn LengthOfTime { ValueType: Number }
|
EDIXLSLinkColumn Start { ValueType: Date }
|
EDIXLSLinkColumn StockingPointID { ValueType: String }
|
EDIXLSLinkColumn TimeUnit { 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 }
|
]
|
}
|
}
|
}
|
