Quintiq file version 2.0
|
#parent: #root
|
EDIBroker AES_TemporaryDemandData
|
{
|
MDSDefinition: ArchiveExecutionStatus
|
TimeZone: 'ACT'
|
UseOSTimeZone: false
|
EDIModelLink.Destination Destination0
|
{
|
EDIMLTable TemporaryDemandData
|
{
|
PrimaryKeyColumns: ID
|
TargetType: TemporaryDemandData
|
TypeIndex: TemporaryDemandDataTypeIndex
|
EDIMLColumn CurrencyID { Attribute: CurrencyID ValueType: String }
|
EDIMLColumn DemandUncertaintyPercentage { Attribute: DemandUncertaintyPercentage ValueType: Number }
|
EDIMLColumn EndDate { Attribute: EndDate ValueType: Date }
|
EDIMLColumn ID { Attribute: ID ValueType: Number }
|
EDIMLColumn Origin { Attribute: Origin ValueType: String }
|
EDIMLColumn Price { Attribute: Price ValueType: Number }
|
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 dbTemporaryDemandData
|
{
|
DataIntegrityStrategy: 'Disabled'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.vwed'
|
EDIODBCLinkTable A_Forecasts
|
{
|
OthersMayCreateTable: true
|
OthersMayDeleteRow: true
|
OthersMayDropTable: true
|
OthersMayFlushTable: true
|
OthersMayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn CURRENCY_ID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DEMAND_UNCERTAINTY_PERCENTAGE
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn END_DATE
|
{
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn ID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn IS_EXCLUDED_FROM_FULFILLMENT_KPI_USER
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn ORIGIN
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn PRICE
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn PRIORITY_NAME
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn PRODUCT_ID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn QUANTITY
|
{
|
OthersMayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn SALES_SEGMENT_NAME
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn START_DATE
|
{
|
OthersMayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn STOCKING_POINT_ID
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UNIT_OF_MEASURE_NAME
|
{
|
OthersMayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
}
|
EDITransformation.Transformation Transformation
|
{
|
EDITableTransformation
|
{
|
InputTable: A_Forecasts
|
OutputTable: TemporaryDemandData
|
EDIColumnMatch { InputColumn: CURRENCY_ID OutputColumn: CurrencyID }
|
EDIColumnMatch { InputColumn: DEMAND_UNCERTAINTY_PERCENTAGE OutputColumn: DemandUncertaintyPercentage }
|
EDIColumnMatch
|
{
|
InputColumn: END_DATE
|
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: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: ORIGIN OutputColumn: Origin }
|
EDIColumnMatch { InputColumn: PRICE OutputColumn: Price }
|
EDIColumnMatch { InputColumn: PRIORITY_NAME OutputColumn: PriorityName }
|
EDIColumnMatch { InputColumn: PRODUCT_ID OutputColumn: ProductID }
|
EDIColumnMatch { InputColumn: QUANTITY OutputColumn: Quantity }
|
EDIColumnMatch { InputColumn: SALES_SEGMENT_NAME OutputColumn: SalesSegmentName }
|
EDIColumnMatch
|
{
|
InputColumn: START_DATE
|
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: STOCKING_POINT_ID OutputColumn: StockingPointID }
|
EDIColumnMatch { InputColumn: UNIT_OF_MEASURE_NAME OutputColumn: UnitOfMeasureName }
|
}
|
}
|
}
|
