Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MP_ImportCustomerOrderBroker
|
{
|
MDSDefinition: MacroPlan
|
TimeZone: 'ACT'
|
UseOSTimeZone: false
|
EDIModelLink.Destination OutputCustomerOrderToModel
|
{
|
EDIMLTable CustomerOrder
|
{
|
PrimaryKeyColumns: ID
|
TargetType: CustomerOrder
|
TypeIndex: CustomerOrderTypeIndex
|
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 }
|
EDIMLTableOwner
|
{
|
TargetType: Product_MP
|
TypeIndex: ProductTypeIndex
|
EDIMLForeignKeyColumn
|
{
|
Column: ProductID
|
TypeIndexAttribute: ID
|
}
|
}
|
}
|
}
|
EDITransformation.Transformation TransformationCustomerOrderForImport
|
{
|
EDITableTransformation
|
{
|
InputTable: CustomerOrders_MP
|
OutputTable: CustomerOrder
|
EDIColumnMatch { InputColumn: CurrencyID OutputColumn: CurrencyID }
|
EDIColumnMatch { InputColumn: Customer OutputColumn: CustomerName }
|
EDIColumnMatch { InputColumn: CustomerID OutputColumn: CustomerID }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: IsEligibleForNetting OutputColumn: IsEligibleForNetting }
|
EDIColumnMatch { InputColumn: IsExcludedFromFulfillmentKPIUser OutputColumn: IsExcludedFromFulfillmentKPIUser }
|
EDIColumnMatch { InputColumn: OrderDate OutputColumn: StartDate }
|
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: IsFirmed OutputColumn: IsFirmed }
|
EDIColumnMatch { InputColumn: StockingPointID OutputColumn: StockingPointID }
|
EDIColumnMatch { InputColumn: UnitOfMeasureName OutputColumn: UnitOfMeasureName }
|
}
|
}
|
EDIXLSLink.Source InputCustomerOrderFromExcel
|
{
|
FileName: 'MP_CustomerOrders.xlsx'
|
EDIXLSLinkTable CustomerOrders_MP
|
{
|
Columns:
|
[
|
EDIXLSLinkColumn CurrencyID { ValueType: String }
|
EDIXLSLinkColumn CustomerID { ValueType: String }
|
EDIXLSLinkColumn Customer { ValueType: String }
|
EDIXLSLinkColumn ID { ValueType: String }
|
EDIXLSLinkColumn IsEligibleForNetting { ValueType: Boolean }
|
EDIXLSLinkColumn IsExcludedFromFulfillmentKPIUser { ValueType: Boolean }
|
EDIXLSLinkColumn OrderID { ValueType: String }
|
EDIXLSLinkColumn OrderLineID { ValueType: String }
|
EDIXLSLinkColumn Price { ValueType: Real }
|
EDIXLSLinkColumn PriorityName { ValueType: String }
|
EDIXLSLinkColumn ProductID { ValueType: String }
|
EDIXLSLinkColumn Quantity { ValueType: Real }
|
EDIXLSLinkColumn SalesSegmentName { ValueType: String }
|
EDIXLSLinkColumn OrderDate { ValueType: Date }
|
EDIXLSLinkColumn IsFirmed { ValueType: Boolean }
|
EDIXLSLinkColumn StockingPointID { ValueType: String }
|
EDIXLSLinkColumn UnitOfMeasureName { ValueType: String }
|
]
|
}
|
}
|
}
|
