Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MPSync_ImportCustomerOrdersFromDBBroker
|
{
|
MDSDefinition: MPSync
|
EDIModelLink.Destination MPSync_DestinationCustomerOrdersBrokerForImport0
|
{
|
EDIMLTable IOCustomerOrder
|
{
|
PrimaryKeyColumns: ID
|
SoftDeleteAttribute: IsSoftDeleted
|
TargetType: IOCustomerOrder
|
TypeIndex: CustomerOrderIndex
|
WithSoftDelete: true
|
EDIMLColumn CurrencyID { Attribute: CurrencyID ValueType: String }
|
EDIMLColumn CustomerID { Attribute: CustomerID ValueType: String }
|
EDIMLColumn CustomerName { Attribute: CustomerName ValueType: String }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn IsEligibleForNetting { Attribute: IsEligibleForNetting ValueType: Boolean }
|
EDIMLColumn IsExcludedFromFulfillmentKPIUser { Attribute: IsExcludedFromFulfillmentKPIUser ValueType: Boolean }
|
EDIMLColumn IsFirmed { Attribute: IsFirmed ValueType: Boolean }
|
EDIMLColumn OrderID { Attribute: OrderID ValueType: String }
|
EDIMLColumn OrderLineID { Attribute: OrderLineID ValueType: String }
|
EDIMLColumn Price { Attribute: Price ValueType: Real }
|
EDIMLColumn PriorityName { Attribute: PriorityName ValueType: String }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn Quantity { Attribute: Quantity ValueType: Real }
|
EDIMLColumn SalesSegmentName { Attribute: SalesSegmentName ValueType: String }
|
EDIMLColumn StartDate { Attribute: StartDate ValueType: Date }
|
EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
|
EDIMLColumn UnitOfMeasureName { Attribute: UnitOfMeasureName ValueType: String }
|
}
|
}
|
EDIODBCLink.Source MPSync_SourceCustomerOrdersBrokerForImport0
|
{
|
DataIntegrityStrategy: 'Disabled'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.syncobject'
|
EDIODBCLinkTable CustomerOrders
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn CurrencyID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn CustomerID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn CustomerName
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn IsEligibleForNetting
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsExcludedFromFulfillmentKPIUser
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsFirmed
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn OrderDate
|
{
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn OrderID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn OrderLineID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Price
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn PriorityName
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ProductID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Quantity
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn SalesSegmentName
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn StockingPointID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UnitOfMeasureName
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
}
|
EDITransformation.Transformation MPSync_TransformationCustomerOrdersBrokerForImport0
|
{
|
EDITableTransformation
|
{
|
InputTable: CustomerOrders
|
OutputTable: IOCustomerOrder
|
EDIColumnMatch { InputColumn: CurrencyID OutputColumn: CurrencyID }
|
EDIColumnMatch { InputColumn: CustomerID OutputColumn: CustomerID }
|
EDIColumnMatch { InputColumn: CustomerName OutputColumn: CustomerName }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: IsEligibleForNetting OutputColumn: IsEligibleForNetting }
|
EDIColumnMatch { InputColumn: IsExcludedFromFulfillmentKPIUser OutputColumn: IsExcludedFromFulfillmentKPIUser }
|
EDIColumnMatch { InputColumn: IsFirmed OutputColumn: IsFirmed }
|
EDIColumnMatch
|
{
|
InputColumn: OrderDate
|
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>
|
*]
|
}
|
}
|
EDIColumnMatch { InputColumn: OrderID OutputColumn: OrderID }
|
EDIColumnMatch { InputColumn: OrderLineID OutputColumn: OrderLineID }
|
EDIColumnMatch { InputColumn: Price OutputColumn: Price }
|
EDIColumnMatch { InputColumn: PriorityName OutputColumn: PriorityName }
|
EDIColumnMatch { InputColumn: ProductID OutputColumn: ProductID }
|
EDIColumnMatch { InputColumn: Quantity OutputColumn: Quantity }
|
EDIColumnMatch { InputColumn: SalesSegmentName OutputColumn: SalesSegmentName }
|
EDIColumnMatch { InputColumn: StockingPointID OutputColumn: StockingPointID }
|
EDIColumnMatch { InputColumn: UnitOfMeasureName OutputColumn: UnitOfMeasureName }
|
}
|
}
|
}
|
