Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MPSync_ImportPostponementsAndFulfillmentsFromDBBroker
|
{
|
MDSDefinition: MPSync
|
EDIModelLink.Destination MPSync_DestinationPostponementsAndFulfillmentsBrokerForImport
|
{
|
EDIMLTable IOFulfillmentRestriction
|
{
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: SalesSegmentName
|
PrimaryKeyColumns: StartDate
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IOFulfillmentRestriction
|
TypeIndex: IOFulfillmentRestrictionTypeIndex
|
WithSoftDelete: true
|
EDIMLColumn EndDate { Attribute: EndDate ValueType: Date }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn SalesSegmentName { Attribute: SalesSegmentName ValueType: String }
|
EDIMLColumn StartDate { Attribute: StartDate ValueType: Date }
|
}
|
EDIMLTable IOPostponedSalesDemandCost
|
{
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: StockingPointID
|
TargetType: IOPostponedSalesDemandCost
|
TypeIndex: IOPostponedSalesDemandCostTypeIndex
|
EDIMLColumn Penalty { Attribute: Penalty ValueType: Real }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
|
}
|
EDIMLTable IOPostponementSpecification
|
{
|
PrimaryKeyColumns: SalesSegmentName
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IOPostponementSpecification
|
TypeIndex: IOPostponementSpecificationTypeIndex
|
WithSoftDelete: true
|
EDIMLColumn HorizonNrOfTimeUnit { Attribute: HorizonNrOfTimeUnit ValueType: Number }
|
EDIMLColumn HorizonTimeUnit { Attribute: HorizonTimeUnit ValueType: String }
|
EDIMLColumn MaxNrOfTimeUnit { Attribute: MaxNrOfTimeUnit ValueType: Number }
|
EDIMLColumn MaxTimeUnit { Attribute: MaxTimeUnit ValueType: String }
|
EDIMLColumn SalesSegmentName { Attribute: SalesSegmentName ValueType: String }
|
}
|
}
|
EDIODBCLink.Source MPSync_SourcePostponementsAndFulfillmentsBrokerForImport
|
{
|
DataIntegrityStrategy: 'Disabled'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.syncobject'
|
EDIODBCLinkTable FulfillmentRestrictions
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: SalesSegmentName
|
PrimaryKeyColumns: StartDate
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn EndDate
|
{
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn ProductID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn SalesSegmentName
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn StartDate
|
{
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
}
|
EDIODBCLinkTable PostponedSalesDemandCosts
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: StockingPointID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn Penalty
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn ProductID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Start
|
{
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn StockingPointID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable PostponementSpecifications
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: SalesSegmentName
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn HorizonNrOfTimeUnit
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn HorizonTimeUnit
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MaxNrOfTimeUnit
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn MaxTimeUnit
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn SalesSegmentName
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
}
|
EDITransformation.Transformation MPSync_TransformationPostponementsAndFulfillmentsBrokerForImport
|
{
|
EDITableTransformation
|
{
|
InputTable: FulfillmentRestrictions
|
OutputTable: IOFulfillmentRestriction
|
EDIColumnMatch
|
{
|
InputColumn: EndDate
|
OutputColumn: EndDate
|
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: ProductID
|
OutputColumn: ProductID
|
}
|
EDIColumnMatch
|
{
|
InputColumn: SalesSegmentName
|
OutputColumn: SalesSegmentName
|
}
|
EDIColumnMatch
|
{
|
InputColumn: StartDate
|
OutputColumn: StartDate
|
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: PostponedSalesDemandCosts
|
OutputTable: IOPostponedSalesDemandCost
|
EDIColumnMatch { InputColumn: Penalty OutputColumn: Penalty }
|
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>
|
*]
|
}
|
}
|
EDIColumnMatch { InputColumn: StockingPointID OutputColumn: StockingPointID }
|
}
|
EDITableTransformation
|
{
|
InputTable: PostponementSpecifications
|
OutputTable: IOPostponementSpecification
|
EDIColumnMatch { InputColumn: HorizonNrOfTimeUnit OutputColumn: HorizonNrOfTimeUnit }
|
EDIColumnMatch { InputColumn: HorizonTimeUnit OutputColumn: HorizonTimeUnit }
|
EDIColumnMatch { InputColumn: MaxNrOfTimeUnit OutputColumn: MaxNrOfTimeUnit }
|
EDIColumnMatch { InputColumn: MaxTimeUnit OutputColumn: MaxTimeUnit }
|
EDIColumnMatch { InputColumn: SalesSegmentName OutputColumn: SalesSegmentName }
|
}
|
}
|
}
|
