Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MPSync_ImportEntitiesCostsFromDBBroker
|
{
|
MDSDefinition: MPSync
|
EDIModelLink.Destination MPSync_DestinationEntitiesCostsForImport
|
{
|
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 }
|
}
|
}
|
EDIODBCLink.Source MPSync_SourceEntitiesCostsForImport
|
{
|
DataIntegrityStrategy: 'Disabled'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.syncobject'
|
EDIODBCLinkTable LaneCosts
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn AccountName
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Cost
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn CostDriver
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn LaneID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn LengthOfTime
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn Start
|
{
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn TimeUnit
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable LaneLegCosts
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn AccountName
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Cost
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn CostDriver
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DestinationStockingPointID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn LaneID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn LengthOfTime
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn OriginStockingPointID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Start
|
{
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn TimeUnit
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable OperationCosts
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn AccountName
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Cost
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn CostDriver
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn LengthOfTime
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn OperationID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Start
|
{
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn TimeUnit
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable ProductValueAndCosts
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: ID
|
PrimaryKeyColumns: ProductID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn AccountName
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Cost
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn CostDriver
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ProductID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Start
|
{
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
}
|
EDIODBCLinkTable StockingPointCosts
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn AccountName
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Cost
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn CostDriver
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn LengthOfTime
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn Start
|
{
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn StockingPointID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn TimeUnit
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable UnitCosts
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: ID
|
PrimaryKeyColumns: UnitID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn AccountName
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Cost
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn CostDriver
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn LengthOfTime
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn Start
|
{
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn TimeUnit
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UnitID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
}
|
EDITransformation.Transformation MPSync_TransformationEntitiesCostsForImport
|
{
|
EDITableTransformation
|
{
|
InputTable: LaneCosts
|
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
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<DateTimeToDate xmlns="http://www.quintiq.com/GEB/DateTimeToDate" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
</DateTimeToDate>
|
*]
|
}
|
}
|
EDIColumnMatch { InputColumn: TimeUnit OutputColumn: TimeUnit }
|
}
|
EDITableTransformation
|
{
|
InputTable: LaneLegCosts
|
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
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<DateTimeToDate xmlns="http://www.quintiq.com/GEB/DateTimeToDate" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
</DateTimeToDate>
|
*]
|
}
|
}
|
EDIColumnMatch { InputColumn: TimeUnit OutputColumn: TimeUnit }
|
}
|
EDITableTransformation
|
{
|
InputTable: OperationCosts
|
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
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<DateTimeToDate xmlns="http://www.quintiq.com/GEB/DateTimeToDate" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
</DateTimeToDate>
|
*]
|
}
|
}
|
EDIColumnMatch { InputColumn: TimeUnit OutputColumn: TimeUnit }
|
}
|
EDITableTransformation
|
{
|
InputTable: ProductValueAndCosts
|
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
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<DateTimeToDate xmlns="http://www.quintiq.com/GEB/DateTimeToDate" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
</DateTimeToDate>
|
*]
|
}
|
}
|
}
|
EDITableTransformation
|
{
|
InputTable: StockingPointCosts
|
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
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<DateTimeToDate xmlns="http://www.quintiq.com/GEB/DateTimeToDate" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
</DateTimeToDate>
|
*]
|
}
|
}
|
EDIColumnMatch { InputColumn: StockingPointID OutputColumn: StockingPointID }
|
EDIColumnMatch { InputColumn: TimeUnit OutputColumn: TimeUnit }
|
}
|
EDITableTransformation
|
{
|
InputTable: UnitCosts
|
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
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<DateTimeToDate xmlns="http://www.quintiq.com/GEB/DateTimeToDate" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
</DateTimeToDate>
|
*]
|
}
|
}
|
EDIColumnMatch { InputColumn: TimeUnit OutputColumn: TimeUnit }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
}
|
}
|
}
|
