Quintiq file version 2.0
|
#parent: #root
|
EDIBroker MP_MPSyncExportAll
|
{
|
MDSDefinition: MacroPlan
|
TimeZone: 'ACT'
|
UseOSTimeZone: false
|
EDIModelLink.Source SourceMPSyncExportAll
|
{
|
EDIMLTable ActualProductInStockingPointInPeriod
|
{
|
PrimaryKeyColumns: Date
|
PrimaryKeyColumns: ManufacturedDate
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: StockingPointID
|
TargetType: ActualProductInStockingPointInPeriod
|
TypeIndex: ActualProductInStockingPointInPeriodTypeIndex
|
EDIMLColumn ActualInventoryLevelEnd { Attribute: ActualInventoryLevelEnd ValueType: Real }
|
EDIMLColumn Date { Attribute: Date ValueType: Date }
|
EDIMLColumn Description { Attribute: Description ValueType: String }
|
EDIMLColumn ManufacturedDate { Attribute: ManufacturedDate ValueType: Date }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
|
}
|
EDIMLTable ActualUnitPeriod
|
{
|
PrimaryKeyColumns: Date
|
PrimaryKeyColumns: UnitID
|
TargetType: ActualUnitPeriod
|
TypeIndex: ActualUnitPeriodTypeIndex
|
EDIMLColumn ActualTotalAvailableDuration { Attribute: ActualTotalAvailableDuration ValueType: Duration }
|
EDIMLColumn ActualTotalAvailableQuantity { Attribute: ActualTotalAvailableQuantity ValueType: Real }
|
EDIMLColumn ActualUtilizationPercentage { Attribute: ActualUtilizationPercentage ValueType: Real }
|
EDIMLColumn Date { Attribute: Date ValueType: Date }
|
EDIMLColumn Description { Attribute: Description ValueType: String }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
}
|
EDIMLTable BaseConversionFactor
|
{
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: SourceUnitOfMeasureName
|
PrimaryKeyColumns: TargetUnitOfMeasureName
|
TargetType: BaseConversionFactor
|
TypeIndex: BaseConversionFactorTypeIndex
|
EDIMLColumn Factor { Attribute: Factor ValueType: Real }
|
EDIMLColumn IsEnabled { Attribute: IsEnabled ValueType: Boolean }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn SourceUnitOfMeasureName { Attribute: SourceUnitOfMeasureName ValueType: String }
|
EDIMLColumn TargetUnitOfMeasureName { Attribute: TargetUnitOfMeasureName ValueType: String }
|
}
|
EDIMLTable CampaignType_MP
|
{
|
PrimaryKeyColumns: Name
|
PrimaryKeyColumns: UnitID
|
TargetType: CampaignType_MP
|
TypeIndex: CampaignTypeTypeIndex
|
EDIMLColumn Color { Attribute: Color ValueType: String }
|
EDIMLColumn DefaultMaxDuration { Attribute: DefaultMaxDuration ValueType: Duration }
|
EDIMLColumn DefaultMaxQuantity { Attribute: DefaultMaxQuantity ValueType: Real }
|
EDIMLColumn DefaultMinDuration { Attribute: DefaultMinDuration ValueType: Duration }
|
EDIMLColumn DefaultMinQuantity { Attribute: DefaultMinQuantity ValueType: Real }
|
EDIMLColumn HasInputMaxDuration { Attribute: HasInputMaxDuration ValueType: Boolean }
|
EDIMLColumn HasInputMaxQuantity { Attribute: HasInputMaxQuantity ValueType: Boolean }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
}
|
EDIMLTable Campaign_MP
|
{
|
PrimaryKeyColumns: CampaignID
|
PrimaryKeyColumns: UnitID
|
TargetType: Campaign_MP
|
TypeIndex: CampaignTypeIndex
|
EDIMLColumn CampaignID { Attribute: CampaignID ValueType: String }
|
EDIMLColumn CampaignTypeName { Attribute: CampaignTypeName ValueType: String }
|
EDIMLColumn Comment { Attribute: Comment ValueType: String }
|
EDIMLColumn Duration { Attribute: Duration ValueType: Duration }
|
EDIMLColumn EarliestStart { Attribute: EarliestStart ValueType: DateTime }
|
EDIMLColumn HasInputMaxDuration { Attribute: HasInputMaxDuration ValueType: Boolean }
|
EDIMLColumn HasInputMaxQuantity { Attribute: HasInputMaxQuantity ValueType: Boolean }
|
EDIMLColumn HasNextTransitionDurationByOpt { Attribute: HasNextTransitionDurationByOpt ValueType: Boolean }
|
EDIMLColumn MaxDuration { Attribute: MaxDuration ValueType: Duration }
|
EDIMLColumn MaxQuantity { Attribute: MaxQuantity ValueType: Real }
|
EDIMLColumn MinDuration { Attribute: MinDuration ValueType: Duration }
|
EDIMLColumn MinQuantity { Attribute: MinQuantity ValueType: Real }
|
EDIMLColumn NextTransitionDurationByOpt { Attribute: NextTransitionDurationByOpt ValueType: Duration }
|
EDIMLColumn OptNextCampaignTypeName { Attribute: OptNextCampaignTypeName ValueType: String }
|
EDIMLColumn SequenceNumber { Attribute: SequenceNumber ValueType: Number }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
}
|
EDIMLTable CurrencyRate_MP
|
{
|
PrimaryKeyColumns: CurrencyID
|
PrimaryKeyColumns: Start
|
TargetType: CurrencyRate_MP
|
TypeIndex: CurrencyRateTypeIndex
|
EDIMLColumn CurrencyID { Attribute: CurrencyID ValueType: String }
|
EDIMLColumn Rate { Attribute: Rate ValueType: Real }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
}
|
EDIMLTable Currency_MP
|
{
|
PrimaryKeyColumns: ID
|
TargetType: Currency_MP
|
TypeIndex: CurrencyTypeIndex
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn IsBase { Attribute: IsBase ValueType: Boolean }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn Symbol { Attribute: Symbol ValueType: String }
|
}
|
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 }
|
}
|
EDIMLTable DisaggregationFactor
|
{
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: StockingPointID
|
TargetType: DisaggregationFactor
|
TypeIndex: DisaggregationTypeIndex
|
EDIMLColumn Factor { Attribute: Factor ValueType: Real }
|
EDIMLColumn IsManuallyConfigured { Attribute: IsManuallyConfigured ValueType: Boolean }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
|
}
|
EDIMLTable FeedbackPeriodTaskOperation
|
{
|
PrimaryKeyColumns: ID
|
TargetType: FeedbackPeriodTaskOperation
|
TypeIndex: FeedbackPeriodTaskOperationTypeIndex
|
EDIMLColumn DateTime { Attribute: DateTime ValueType: DateTime }
|
EDIMLColumn Description { Attribute: Description ValueType: String }
|
EDIMLColumn FeedbackQuantity { Attribute: FeedbackQuantity ValueType: Real }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn IsLocked { Attribute: IsLocked ValueType: Boolean }
|
EDIMLColumn OperationID { Attribute: OperationID ValueType: String }
|
}
|
EDIMLTable FeedbackProductInTrip
|
{
|
PrimaryKeyColumns: ID
|
TargetType: FeedbackProductInTrip
|
TypeIndex: FeedbackProductInTripTypeIndex
|
EDIMLColumn Arrival { Attribute: Arrival ValueType: DateTime }
|
EDIMLColumn Description { Attribute: Description ValueType: String }
|
EDIMLColumn DestinationStockingPointID { Attribute: DestinationStockingPointID ValueType: String }
|
EDIMLColumn FeedbackQuantity { Attribute: FeedbackQuantity ValueType: Real }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn LaneID { Attribute: LaneID ValueType: String }
|
EDIMLColumn OriginStockingPointID { Attribute: OriginStockingPointID ValueType: String }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
}
|
EDIMLTable Forecast
|
{
|
PrimaryKeyColumns: ID
|
TargetType: Forecast
|
TypeIndex: SalesDemandIndex
|
EDIMLColumn CurrencyID { Attribute: CurrencyID ValueType: String }
|
EDIMLColumn DemandUncertaintyPercentage { Attribute: DemandUncertaintyPercentage ValueType: Real }
|
EDIMLColumn EndDate { Attribute: EndDate ValueType: Date }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn IsExcludedFromFulfillmentKPIUser { Attribute: IsExcludedFromFulfillmentKPIUser ValueType: Boolean }
|
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 }
|
}
|
EDIMLTable FulfillmentRestriction
|
{
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: SalesSegmentName
|
PrimaryKeyColumns: StartDate
|
TargetType: FulfillmentRestriction
|
TypeIndex: FulfillmentRestrictionTypeIndex
|
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 FulfillmentTarget
|
{
|
PrimaryKeyColumns: ID
|
TargetType: FulfillmentTarget
|
TypeIndex: FulfillmentTargetTypeIndex
|
EDIMLColumn End { Attribute: End ValueType: Date }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn IsEnabled { Attribute: IsEnabled ValueType: Boolean }
|
EDIMLColumn IsUsedForPlanningFulfillment { Attribute: IsUsedForPlanningFulfillment ValueType: Boolean }
|
EDIMLColumn IsUsedForSafetyStockCalculation { Attribute: IsUsedForSafetyStockCalculation ValueType: Boolean }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn SalesSegmentName { Attribute: SalesSegmentName ValueType: String }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
|
EDIMLColumn TargetPercentage { Attribute: TargetPercentage ValueType: Real }
|
}
|
EDIMLTable GlobalParameters_MP
|
{
|
PrimaryKeyColumns: ID
|
TargetType: GlobalParameters_MP
|
TypeIndex: GlobalParameterTypeIndex
|
EDIMLColumn AbsoluteLowerLimit { Attribute: AbsoluteLowerLimit ValueType: Real }
|
EDIMLColumn AbsoluteUpperLimit { Attribute: AbsoluteUpperLimit ValueType: Real }
|
EDIMLColumn AutoScalingFrequency { Attribute: AutoScalingFrequency ValueType: Duration }
|
EDIMLColumn BalanceTolerance { Attribute: BalanceTolerance ValueType: Real }
|
EDIMLColumn BaseCurrency { Attribute: BaseCurrency_DELETED_GA18 ValueType: String }
|
EDIMLColumn BaseCurrencySymbol { Attribute: BaseCurrencySymbol ValueType: String }
|
EDIMLColumn BiasTolerance { Attribute: BiasTolerance ValueType: Real }
|
EDIMLColumn BottleneckTolerance { Attribute: BottleneckTolerance ValueType: Real }
|
EDIMLColumn BottleneckWindowEnd { Attribute: BottleneckWindowEnd ValueType: Duration }
|
EDIMLColumn BottleneckWindowEndDate { Attribute: BottleneckWindowEndDate ValueType: Date }
|
EDIMLColumn BottleneckWindowStart { Attribute: BottleneckWindowStart ValueType: Duration }
|
EDIMLColumn BottleneckWindowStartDate { Attribute: BottleneckWindowStartDate ValueType: Date }
|
EDIMLColumn CO2ProcessUoM { Attribute: CO2ProcessUoM ValueType: String }
|
EDIMLColumn CO2UoM { Attribute: CO2UoM ValueType: String }
|
EDIMLColumn ChangeoverTime { Attribute: ChangeoverTime ValueType: Duration }
|
EDIMLColumn DefaultAbsoluteValueForInventoryHolding { Attribute: DefaultAbsoluteValueForInventoryHolding ValueType: Real }
|
EDIMLColumn DefaultAccountForInventoryHolding { Attribute: DefaultAccountForInventoryHolding ValueType: String }
|
EDIMLColumn DefaultAllocation { Attribute: DefaultAllocation ValueType: Real }
|
EDIMLColumn DefaultAnnualInterestRateForInventoryHolding { Attribute: DefaultAnnualInterestRateForInventoryHolding ValueType: Real }
|
EDIMLColumn DefaultDemandUncertainty { Attribute: DefaultDemandUncertainty ValueType: Real }
|
EDIMLColumn DefaultEfficiency { Attribute: DefaultEfficiency ValueType: Real }
|
EDIMLColumn DefaultMaxCapacityForStockingPoint { Attribute: DefaultMaxCapacityForStockingPoint ValueType: Real }
|
EDIMLColumn DefaultMaxCapacityPerDayForUnit { Attribute: DefaultMaxCapacityPerDayForUnit ValueType: Real }
|
EDIMLColumn DefaultMaxLoadPercentage { Attribute: DefaultMaxLoadPercentage ValueType: Real }
|
EDIMLColumn DefaultMinCapacityPerDayForUnit { Attribute: DefaultMinCapacityPerDayForUnit ValueType: Real }
|
EDIMLColumn DefaultNumberOfPeriodsForAvgDemand { Attribute: DefaultNumberOfPeriodsForAvgDemand ValueType: Number }
|
EDIMLColumn DefaultNumberOfUnits { Attribute: DefaultNumberOfUnits ValueType: Number }
|
EDIMLColumn DefaultOperationInputOutputQuantity { Attribute: DefaultOperationInputOutputQuantity ValueType: Real }
|
EDIMLColumn DefaultServiceLevel { Attribute: DefaultServiceLevel ValueType: Real }
|
EDIMLColumn DefaultShiftPatternName { Attribute: DefaultShiftPatternName ValueType: String }
|
EDIMLColumn DefaultSmartPlanStrategy { Attribute: DefaultSmartPlanStrategy ValueType: String }
|
EDIMLColumn DefaultUnitOfMeasure { Attribute: DefaultUnitOfMeasure_DELETED_GA18 ValueType: String }
|
EDIMLColumn DifferenceFactor1e3 { Attribute: DifferenceFactor1e3 ValueType: Real }
|
EDIMLColumn DifferenceFactor1e6 { Attribute: DifferenceFactor1e6 ValueType: Real }
|
EDIMLColumn DisaggregationRatio { Attribute: DisaggregationRatio ValueType: String }
|
EDIMLColumn DurationInventoryMixBalancingCheck { Attribute: DurationInventoryMixBalancingCheck ValueType: Duration }
|
EDIMLColumn DurationLotsizeHorizon { Attribute: DurationLotsizeHorizon ValueType: Duration }
|
EDIMLColumn EndOfKPIHorizon { Attribute: EndOfKPIHorizon ValueType: Date }
|
EDIMLColumn ForecastNettingRule { Attribute: ForecastNettingRule ValueType: String }
|
EDIMLColumn HasAbsoluteValueForInventoryHolding { Attribute: HasAbsoluteValueForInventoryHolding ValueType: Boolean }
|
EDIMLColumn HasDefaultInventoryHoldingCost { Attribute: HasDefaultInventoryHoldingCost ValueType: Boolean }
|
EDIMLColumn HasDemandDependentDisaggregationRatio { Attribute: HasDemandDependentDisaggregationRatio ValueType: Boolean }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn IsManuallyConfigured { Attribute: IsManuallyConfigured ValueType: Boolean }
|
EDIMLColumn IsPeggingRunAfterOptimization { Attribute: IsPeggingRunAfterOptimization ValueType: Boolean }
|
EDIMLColumn IsRunOptimizerSynchronously { Attribute: IsRunOptimizerSynchronously ValueType: Boolean }
|
EDIMLColumn IsSoftDeleted { Attribute: IsSoftDeleted ValueType: Boolean }
|
EDIMLColumn IsUsableIfExpiredWithinPeriod { Attribute: IsUsableIfExpiredWithinPeriod ValueType: Boolean }
|
EDIMLColumn IsUsableIfMatureWithinPeriod { Attribute: IsUsableIfMatureWithinPeriod ValueType: Boolean }
|
EDIMLColumn IsValidData { Attribute: IsValidData ValueType: Boolean }
|
EDIMLColumn LaneLeadTimeLogic { Attribute: LaneLeadTimeLogic ValueType: String }
|
EDIMLColumn LotSizeTolerance { Attribute: LotSizeTolerance ValueType: Real }
|
EDIMLColumn MinToKeepTripInUsedPercentage { Attribute: MinToKeepTripInUsedPercentage ValueType: Number }
|
EDIMLColumn MinimumSalesDemandQtyThreshold { Attribute: MinimumSalesDemandQtyThreshold ValueType: Real }
|
EDIMLColumn NoiseThresholdOptimizerOutput { Attribute: NoiseThresholdOptimizerOutput ValueType: Real }
|
EDIMLColumn NumberOfDecimals { Attribute: NumberOfDecimals ValueType: Number }
|
EDIMLColumn NumberOfPeriodsInWindow { Attribute: NumberOfPeriodsInWindow ValueType: Number }
|
EDIMLColumn NumberOfPeriodsPerSlide { Attribute: NumberOfPeriodsPerSlide ValueType: Number }
|
EDIMLColumn NumberOfPeriodsSmartPlan { Attribute: NumberOfPeriodsSmartPlan ValueType: Number }
|
EDIMLColumn OperationLeadTimeLogic { Attribute: OperationLeadTimeLogic ValueType: String }
|
EDIMLColumn OutlierTolerance { Attribute: OutlierTolerance ValueType: Real }
|
EDIMLColumn PeriodSpecificationForUnitActual { Attribute: PeriodSpecificationForUnitActual ValueType: String }
|
EDIMLColumn PeriodTaskValidity { Attribute: PeriodTaskValidity ValueType: Duration }
|
EDIMLColumn RunSmartPlanSynchronously { Attribute: RunSmartPlanSynchronously ValueType: Boolean }
|
EDIMLColumn SanityCheckDataMostSevere { Attribute: SanityCheckDataMostSevere ValueType: String }
|
EDIMLColumn SanityCheckDataMostSevereCount { Attribute: SanityCheckDataMostSevereCount ValueType: Number }
|
EDIMLColumn SanityCheckDataTotalViolationCount { Attribute: SanityCheckDataTotalViolationCount ValueType: Number }
|
EDIMLColumn SanityCheckLimit { Attribute: SanityCheckLimit ValueType: Number }
|
EDIMLColumn StartOfKPIHorizon { Attribute: StartOfKPIHorizon ValueType: Date }
|
EDIMLColumn StartOfLotsizeHorizon { Attribute: StartOfLotsizeHorizon ValueType: DateTime }
|
EDIMLColumn StockingPointBottleneckThreshold { Attribute: StockingPointBottleneckThreshold ValueType: Real }
|
EDIMLColumn UnitLowerBottleneckThreshold { Attribute: UnitLowerBottleneckThreshold ValueType: Real }
|
EDIMLColumn UnitUpperBottleneckThreshold { Attribute: UnitUpperBottleneckThreshold ValueType: Real }
|
EDIMLColumn UpdateKPIHorizonAtPeriodRoll { Attribute: UpdateKPIHorizonAtPeriodRoll ValueType: Boolean }
|
EDIMLColumn UseAuditTrail { Attribute: UseAuditTrail ValueType: Boolean }
|
EDIMLColumn UseDefaultDisplayIndex { Attribute: UseDefaultDisplayIndex ValueType: Boolean }
|
EDIMLColumn UseSingleEchelon { Attribute: UseSingleEchelon ValueType: Boolean }
|
EDIMLColumn UseSlidingWindowsApproach { Attribute: UseSlidingWindowsApproach ValueType: Boolean }
|
}
|
EDIMLTable Group
|
{
|
PrimaryKeyColumns: Name
|
TargetType: Group
|
TypeIndex: GroupTypeIndex
|
EDIMLColumn IconForStockingPoints { Attribute: IconForStockingPoints ValueType: String }
|
EDIMLColumn IconForUnits { Attribute: IconForUnits ValueType: String }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
}
|
EDIMLTable Ingredient
|
{
|
PrimaryKeyColumns: Name
|
TargetType: Ingredient
|
TypeIndex: IngredientTypeIndex
|
EDIMLColumn Description { Attribute: Description ValueType: String }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
}
|
EDIMLTable InventorySpecification
|
{
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: StockingPointID
|
TargetType: InventorySpecification
|
TypeIndex: InventorySpecificationTypeIndex
|
EDIMLColumn HasMaxLevel { Attribute: HasMaxLevel ValueType: Boolean }
|
EDIMLColumn HasMaxLevelInDays { Attribute: HasMaxLevelInDays ValueType: Boolean }
|
EDIMLColumn HasMinLevel { Attribute: HasMinLevel ValueType: Boolean }
|
EDIMLColumn HasMinLevelInDays { Attribute: HasMinLevelInDays ValueType: Boolean }
|
EDIMLColumn MaxLevelInDays { Attribute: MaxLevelInDays ValueType: Real }
|
EDIMLColumn MaxLevelInQuantity { Attribute: MaxLevelInQuantity ValueType: Real }
|
EDIMLColumn MinLevelInDays { Attribute: MinLevelInDays ValueType: Real }
|
EDIMLColumn MinLevelInQuantity { Attribute: MinLevelInQuantity ValueType: Real }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
|
}
|
EDIMLTable InventorySupply
|
{
|
PrimaryKeyColumns: ID
|
TargetType: InventorySupply
|
TypeIndex: InventorySupplyTypeIndex
|
EDIMLColumn Date { Attribute: Date ValueType: Date }
|
EDIMLColumn Description { Attribute: Description ValueType: String }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn ManufacturedDate { Attribute: ManufacturedDate ValueType: Date }
|
EDIMLColumn Quantity { Attribute: Quantity ValueType: Real }
|
EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
|
}
|
EDIMLTable InventorySupplyCost
|
{
|
PrimaryKeyColumns: ID
|
TargetType: InventorySupplyCost
|
TypeIndex: InventorySupplyCostTypeIndex
|
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 InventorySupplyID { Attribute: InventorySupplyID ValueType: String }
|
EDIMLColumn LengthOfTime { Attribute: LengthOfTime ValueType: Number }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn TimeUnit { Attribute: TimeUnit ValueType: String }
|
}
|
EDIMLTable InventoryValueAndCost
|
{
|
PrimaryKeyColumns: ID
|
TargetType: InventoryValueAndCost
|
TypeIndex: InventoryValueAndCostTypeIndex
|
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 ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
|
EDIMLColumn TimeUnit { Attribute: TimeUnit ValueType: String }
|
}
|
EDIMLTable Lane
|
{
|
PrimaryKeyColumns: ID
|
TargetType: Lane
|
TypeIndex: LaneTypeIndex
|
EDIMLColumn End { Attribute: End ValueType: Date }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn IsEnabled { Attribute: IsEnabled ValueType: Boolean }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn StandardDeviationLeadTimeLane { Attribute: StandardDeviationLeadTimeLane ValueType: Duration }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
EDIMLColumn UserLeadTime { Attribute: UserLeadTime ValueType: Duration }
|
}
|
EDIMLTable LaneCost
|
{
|
PrimaryKeyColumns: ID
|
TargetType: LaneCost
|
TypeIndex: LaneCostTypeIndex
|
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 LaneLeg
|
{
|
PrimaryKeyColumns: DestinationStockingPointID
|
PrimaryKeyColumns: LaneID
|
PrimaryKeyColumns: OriginStockingPointID
|
TargetType: LaneLeg
|
TypeIndex: LaneLegTypeIndex
|
EDIMLColumn CO2Emission { Attribute: CO2Emission ValueType: Real }
|
EDIMLColumn DestinationStockingPointID { Attribute: DestinationStockingPointID ValueType: String }
|
EDIMLColumn End { Attribute: End ValueType: Date }
|
EDIMLColumn HasStandardDeviationLeadTimeLaneLeg { Attribute: HasStandardDeviationLeadTimeLaneLeg ValueType: Boolean }
|
EDIMLColumn HasUserLeadTime { Attribute: HasUserLeadTime ValueType: Boolean }
|
EDIMLColumn IsEnabled { Attribute: IsEnabled ValueType: Boolean }
|
EDIMLColumn LaneID { Attribute: LaneID ValueType: String }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn OriginStockingPointID { Attribute: OriginStockingPointID ValueType: String }
|
EDIMLColumn StandardDeviationLeadTimeLaneLeg { Attribute: StandardDeviationLeadTimeLaneLeg ValueType: Duration }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn UserLeadTime { Attribute: UserLeadTime ValueType: Duration }
|
}
|
EDIMLTable LaneLegCost
|
{
|
PrimaryKeyColumns: ID
|
TargetType: LaneLegCost
|
TypeIndex: LaneLegCostTypeIndex
|
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 Operation
|
{
|
PrimaryKeyColumns: ID
|
TargetType: Operation
|
TypeIndex: OperationTypeIndex
|
EDIMLColumn CO2Emission { Attribute: CO2Emission ValueType: Real }
|
EDIMLColumn HasUserLotSize { Attribute: HasUserLotSize ValueType: Boolean }
|
EDIMLColumn HasUserMaximumQuantity { Attribute: HasUserMaximumQuantity ValueType: Boolean }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn IsEnabled { Attribute: IsEnabled ValueType: Boolean }
|
EDIMLColumn LotSize { Attribute: LotSize ValueType: Real }
|
EDIMLColumn MaximumQuantity { Attribute: MaximumQuantity ValueType: Real }
|
EDIMLColumn MinimumQuantity { Attribute: MinimumQuantity ValueType: Real }
|
EDIMLColumn RoutingID { Attribute: RoutingID ValueType: String }
|
EDIMLColumn RoutingStepName { Attribute: RoutingStepName ValueType: String }
|
EDIMLColumn StandardDeviationLeadTimeOperation { Attribute: StandardDeviationLeadTimeOperation ValueType: Duration }
|
EDIMLColumn Throughput { Attribute: Throughput ValueType: Real }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
EDIMLColumn UserLeadTime { Attribute: UserLeadTime ValueType: Duration }
|
}
|
EDIMLTable OperationBOM
|
{
|
PrimaryKeyColumns: IsInput
|
PrimaryKeyColumns: OperationID
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: StockingPointID
|
TargetType: OperationBOM
|
TypeIndex: OperationBOMTypeIndex
|
EDIMLColumn InputGroupID { Attribute: InputGroupID ValueType: Number }
|
EDIMLColumn IsExcluded { Attribute: IsExcluded ValueType: Boolean }
|
EDIMLColumn IsInput { Attribute: IsInput ValueType: Boolean }
|
EDIMLColumn MaxQuantityInGroupForExport { Attribute: MaxQuantityInGroupForExport ValueType: Real }
|
EDIMLColumn MinQuantityInGroupForExport { Attribute: MinQuantityInGroupForExport ValueType: Real }
|
EDIMLColumn OperationID { Attribute: OperationID ValueType: String }
|
EDIMLColumn OperationInputSetName { Attribute: OperationInputSetName ValueType: String }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn Quantity { Attribute: Quantity ValueType: Real }
|
EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
|
}
|
EDIMLTable OperationCost
|
{
|
PrimaryKeyColumns: ID
|
TargetType: OperationCost
|
TypeIndex: OperationCostTypeIndex
|
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 OperationInCampaignType
|
{
|
PrimaryKeyColumns: CampaignTypeName
|
PrimaryKeyColumns: OperationID
|
PrimaryKeyColumns: UnitID
|
TargetType: OperationInCampaignType
|
TypeIndex: OperationInCampaignTypeTypeIndex
|
EDIMLColumn CampaignTypeName { Attribute: CampaignTypeName ValueType: String }
|
EDIMLColumn OperationID { Attribute: OperationID ValueType: String }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
}
|
EDIMLTable OperationInTransitionType
|
{
|
PrimaryKeyColumns: OperationID
|
PrimaryKeyColumns: TransitionTypeName
|
PrimaryKeyColumns: UnitID
|
TargetType: OperationInTransitionType
|
TypeIndex: OperationInTransitionTypeTypeIndex
|
EDIMLColumn OperationID { Attribute: OperationID ValueType: String }
|
EDIMLColumn TransitionTypeName { Attribute: TransitionTypeName ValueType: String }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
}
|
EDIMLTable OperationInputGroup
|
{
|
PrimaryKeyColumns: InputGroupID
|
PrimaryKeyColumns: OperationID
|
TargetType: OperationInputGroup
|
TypeIndex: OperationInputGroupTypeIndex
|
EDIMLColumn InputGroupID { Attribute: InputGroupID ValueType: Number }
|
EDIMLColumn InputGroupQuantity { Attribute: InputGroupQuantity ValueType: Real }
|
EDIMLColumn OperationID { Attribute: OperationID ValueType: String }
|
}
|
EDIMLTable OperationInputSet
|
{
|
PrimaryKeyColumns: Name
|
PrimaryKeyColumns: OperationID
|
TargetType: OperationInputSet
|
TypeIndex: OperationInputSetTypeIndex
|
EDIMLColumn MaxQuantity { Attribute: MaxQuantity ValueType: Real }
|
EDIMLColumn MinQuantity { Attribute: MinQuantity ValueType: Real }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn OperationID { Attribute: OperationID ValueType: String }
|
}
|
EDIMLTable OperationLink
|
{
|
PrimaryKeyColumns: DestOperationID
|
PrimaryKeyColumns: SourceOperationID
|
TargetType: OperationLink
|
TypeIndex: OperationLinkTypeIndex
|
EDIMLColumn DestGroupID { Attribute: DestGroupID ValueType: Number }
|
EDIMLColumn DestGroupQuantity { Attribute: DestGroupQuantity ValueType: Real }
|
EDIMLColumn DestHasUserQuantity { Attribute: DestHasUserQuantity ValueType: Boolean }
|
EDIMLColumn DestMaxQuantityForExport { Attribute: DestMaxQuantityForExport ValueType: Real }
|
EDIMLColumn DestMinQuantityForExport { Attribute: DestMinQuantityForExport ValueType: Real }
|
EDIMLColumn DestOperationID { Attribute: DestOperationID ValueType: String }
|
EDIMLColumn DestQuantityForExport { Attribute: DestQuantityForExport ValueType: Real }
|
EDIMLColumn SourceGroupID { Attribute: SourceGroupID ValueType: Number }
|
EDIMLColumn SourceOperationID { Attribute: SourceOperationID ValueType: String }
|
EDIMLColumn SourceQuantity { Attribute: SourceQuantity ValueType: Real }
|
}
|
EDIMLTable PISPSpecification
|
{
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: StockingPointID
|
TargetType: PISPSpecification
|
TypeIndex: PISPSpecificationTypeIndex
|
EDIMLColumn HasUnitOfMeasure { Attribute: HasUnitOfMeasure ValueType: Boolean }
|
EDIMLColumn InputLotSize { Attribute: InputLotSize ValueType: Real }
|
EDIMLColumn IsExcludeShelfLifeAndMaturation { Attribute: IsExcludeShelfLifeAndMaturation ValueType: Boolean }
|
EDIMLColumn IsExcluded { Attribute: IsExcluded ValueType: Boolean }
|
EDIMLColumn IsExcludedFromBalancing { Attribute: IsExcludedFromBalancing ValueType: Boolean }
|
EDIMLColumn IsNegativeInventoryAllowed { Attribute: IsNegativeInventoryAllowed ValueType: Boolean }
|
EDIMLColumn IsSafetyStockKept { Attribute: IsSafetyStockKept ValueType: Boolean }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
|
EDIMLColumn UnitOfMeasureName { Attribute: UnitOfMeasureName ValueType: String }
|
}
|
EDIMLTable PeriodParameter_MP
|
{
|
PrimaryKeyColumns: ID
|
TargetType: PeriodParameter_MP
|
TypeIndex: PeriodParameterTypeIndex
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn StartOfPlanning { Attribute: StartOfPlanning ValueType: DateTime }
|
}
|
EDIMLTable PeriodSpecification_MP
|
{
|
PrimaryKeyColumns: ID
|
TargetType: PeriodSpecification_MP
|
TypeIndex: PeriodSpecificationTypeIndex
|
WithInstanceFilter: true
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn IsInHour { Attribute: IsInHour ValueType: Boolean }
|
EDIMLColumn IsUsedForPlanning { Attribute: IsUsedForPlanning ValueType: Boolean }
|
EDIMLColumn NrOfFuturePeriod { Attribute: NrOfFuturePeriod ValueType: Number }
|
EDIMLColumn NrOfHistoricalPeriod { Attribute: NrOfHistoricalPeriod ValueType: Number }
|
EDIMLColumn NrOfTimeUnit { Attribute: NrOfTimeUnit ValueType: Number }
|
EDIMLColumn PeriodAlignment { Attribute: PeriodAlignment ValueType: DateTime }
|
EDIMLColumn TimeUnit { Attribute: TimeUnit ValueType: String }
|
EDIMLInstanceFilter
|
{
|
ArgumentExpression: 'selectset( this, PeriodSpecification_MP, ps, not ps.IsDummyPlanningPeriod() )'
|
}
|
}
|
EDIMLTable PostponedSalesDemandCost
|
{
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: StockingPointID
|
TargetType: PostponedSalesDemandCost
|
TypeIndex: PostponedSalesDemandCostTypeIndex
|
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 PostponementSpecification
|
{
|
PrimaryKeyColumns: SalesSegmentName
|
TargetType: PostponementSpecification
|
TypeIndex: PostponementSpecificationTypeIndex
|
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 }
|
}
|
EDIMLTable Priority
|
{
|
PrimaryKeyColumns: Name
|
TargetType: Priority
|
TypeIndex: PriorityTypeIndex
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn Weight { Attribute: Weight ValueType: Real }
|
}
|
EDIMLTable ProductInLane
|
{
|
PrimaryKeyColumns: LaneID
|
PrimaryKeyColumns: ProductID
|
TargetType: ProductInLane
|
TypeIndex: ProductInLaneTypeIndex
|
EDIMLColumn IsExcluded { Attribute: IsExcluded ValueType: Boolean }
|
EDIMLColumn LaneID { Attribute: LaneID ValueType: String }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
}
|
EDIMLTable ProductLevel_MP
|
{
|
PrimaryKeyColumns: Name
|
TargetType: ProductLevel_MP
|
TypeIndex: ProductLevelTypeIndex
|
EDIMLColumn IsProductCategory { Attribute: IsProductCategory ValueType: Boolean }
|
EDIMLColumn Level { Attribute: Level ValueType: Number }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
}
|
EDIMLTable ProductValueAndCost
|
{
|
PrimaryKeyColumns: ID
|
TargetType: ProductValueAndCost
|
TypeIndex: ProductValueAndCostTypeIndex
|
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 Product_MP
|
{
|
PrimaryKeyColumns: ID
|
TargetType: Product_MP
|
TypeIndex: ProductTypeIndex
|
EDIMLColumn DisplayIndex { Attribute: DisplayIndex ValueType: Number }
|
EDIMLColumn HasShelfLife { Attribute: HasShelfLife ValueType: Boolean }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn HasMaturation { Attribute: HasMaturation ValueType: Boolean }
|
EDIMLColumn IconName { Attribute: IconName ValueType: String }
|
EDIMLColumn IsByProduct { Attribute: IsByProduct ValueType: Boolean }
|
EDIMLColumn IsExcludedFromFulfillmentKPI { Attribute: IsExcludedFromFulfillmentKPI ValueType: Boolean }
|
EDIMLColumn IsExcludedFromOptimization { Attribute: IsExcludedFromOptimization ValueType: Boolean }
|
EDIMLColumn IsPlannedAfterOptimization { Attribute: IsPlannedAfterOptimization ValueType: Boolean }
|
EDIMLColumn MaturationDays { Attribute: MaturationDays ValueType: Real }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn Notes { Attribute: Notes ValueType: String }
|
EDIMLColumn ParentID { Attribute: ParentID ValueType: String }
|
EDIMLColumn ShelfLife { Attribute: ShelfLife ValueType: Real }
|
EDIMLColumn UnitOfMeasureName { Attribute: UnitOfMeasureName ValueType: String }
|
}
|
EDIMLTable Recipe
|
{
|
PrimaryKeyColumns: Name
|
TargetType: Recipe
|
TypeIndex: RecipeTypeIndex
|
EDIMLColumn Description { Attribute: Description ValueType: String }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
}
|
EDIMLTable RecipeIngredient
|
{
|
PrimaryKeyColumns: IngredientName
|
PrimaryKeyColumns: RecipeName
|
TargetType: RecipeIngredient
|
TypeIndex: RecipeIngredientTypeIndex
|
EDIMLColumn IngredientName { Attribute: IngredientName ValueType: String }
|
EDIMLColumn Maximum { Attribute: Maximum ValueType: Real }
|
EDIMLColumn Minimum { Attribute: Minimum ValueType: Real }
|
EDIMLColumn Nominal { Attribute: Nominal ValueType: Real }
|
EDIMLColumn RecipeName { Attribute: RecipeName ValueType: String }
|
}
|
EDIMLTable RecipeWithEffectiveDate
|
{
|
PrimaryKeyColumns: EffectiveDate
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: RecipeName
|
TargetType: RecipeWithEffectiveDate
|
TypeIndex: RecipeWithEffectiveDateInProductTypeIndex
|
EDIMLColumn EffectiveDate { Attribute: EffectiveDate ValueType: Date }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn RecipeName { Attribute: RecipeName ValueType: String }
|
}
|
EDIMLTable Routing
|
{
|
PrimaryKeyColumns: ID
|
TargetType: Routing
|
TypeIndex: RoutingTypeIndex
|
EDIMLColumn AllowWIPInventory { Attribute: AllowWIPInventory ValueType: Boolean }
|
EDIMLColumn End { Attribute: End ValueType: Date }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn IsEnabled { Attribute: IsEnabled ValueType: Boolean }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
}
|
EDIMLTable RoutingConfiguratorView
|
{
|
PrimaryKeyColumns: ID
|
TargetType: RoutingConfiguratorView
|
TypeIndex: RoutingConfiguratorViewTypeIndex
|
EDIMLColumn EdgeThickness { Attribute: EdgeThickness ValueType: Number }
|
EDIMLColumn FontName { Attribute: FontName ValueType: String }
|
EDIMLColumn FontSize { Attribute: FontSize ValueType: Number }
|
EDIMLColumn GridHeight { Attribute: GridHeight ValueType: Number }
|
EDIMLColumn GridPointDistance { Attribute: GridPointDistance ValueType: Number }
|
EDIMLColumn GridWidth { Attribute: GridWidth ValueType: Number }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn IsCompactMode { Attribute: IsCompactMode ValueType: Boolean }
|
EDIMLColumn IsGridVisible { Attribute: IsGridVisible ValueType: Boolean }
|
EDIMLColumn OffsetX { Attribute: OffsetX ValueType: Number }
|
EDIMLColumn OffsetY { Attribute: OffsetY ValueType: Number }
|
EDIMLColumn OperationHeight { Attribute: OperationHeight ValueType: Number }
|
EDIMLColumn OperationInputOutputWidth { Attribute: OperationInputOutputWidth ValueType: Number }
|
EDIMLColumn OperationOffsetX { Attribute: OperationOffsetX ValueType: Number }
|
EDIMLColumn OperationOffsetY { Attribute: OperationOffsetY ValueType: Number }
|
EDIMLColumn OperationWidth { Attribute: OperationWidth ValueType: Number }
|
EDIMLColumn PISPHeight { Attribute: PISPHeight ValueType: Number }
|
EDIMLColumn PISPWidth { Attribute: PISPWidth ValueType: Number }
|
EDIMLColumn Padding { Attribute: Padding ValueType: Number }
|
EDIMLColumn RoutingStepDistance { Attribute: RoutingStepDistance ValueType: Number }
|
EDIMLColumn RoutingStepMinimumHeight { Attribute: RoutingStepMinimumHeight ValueType: Number }
|
EDIMLColumn RoutingStepMinimumWidth { Attribute: RoutingStepMinimumWidth ValueType: Number }
|
EDIMLColumn User { Attribute: User ValueType: String }
|
EDIMLColumn UserOperationInputOutputHeight { Attribute: UserOperationInputOutputHeight ValueType: Number }
|
}
|
EDIMLTable RoutingStep
|
{
|
PrimaryKeyColumns: Name
|
PrimaryKeyColumns: RoutingID
|
TargetType: RoutingStep
|
TypeIndex: RoutingStepTypeIndex
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn RoutingID { Attribute: RoutingID ValueType: String }
|
EDIMLColumn SequenceNumber { Attribute: SequenceNumber ValueType: Number }
|
EDIMLColumn Tool { Attribute: Tool ValueType: String }
|
}
|
EDIMLTable SafetyStock
|
{
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: StockingPointID
|
TargetType: SafetyStock
|
TypeIndex: TypeIndexSafetyStock
|
EDIMLColumn HasTargetInDays { Attribute: HasTargetInDays ValueType: Boolean }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
|
EDIMLColumn TargetInDays { Attribute: TargetInDays ValueType: Real }
|
EDIMLColumn TargetInQuantity { Attribute: TargetInQuantity ValueType: Real }
|
}
|
EDIMLTable SalesLevel_MP
|
{
|
PrimaryKeyColumns: Name
|
TargetType: SalesLevel_MP
|
TypeIndex: SalesLevelTypeIndex
|
EDIMLColumn Level { Attribute: Level ValueType: Number }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
}
|
EDIMLTable SalesSegment_MP
|
{
|
PrimaryKeyColumns: Name
|
TargetType: SalesSegment_MP
|
TypeIndex: SalesSegmentTypeIndex
|
EDIMLColumn DisplayIndex { Attribute: DisplayIndex ValueType: Number }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn ParentName { Attribute: ParentName ValueType: String }
|
}
|
EDIMLTable ServiceLevel
|
{
|
PrimaryKeyColumns: ID
|
TargetType: ServiceLevel
|
TypeIndex: ServiceLevelTypeIndex
|
EDIMLColumn End { Attribute: End ValueType: Date }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn IsEnabled { Attribute: IsEnabled ValueType: Boolean }
|
EDIMLColumn IsUsedForPlanningFulfillment { Attribute: IsUsedForPlanningFulfillment ValueType: Boolean }
|
EDIMLColumn IsUsedForSafetyStockCalculation { Attribute: IsUsedForSafetyStockCalculation ValueType: Boolean }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn SalesSegmentName { Attribute: SalesSegmentName ValueType: String }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
|
EDIMLColumn TargetPercentage { Attribute: TargetPercentage ValueType: Real }
|
}
|
EDIMLTable ShiftDay
|
{
|
PrimaryKeyColumns: ID
|
PrimaryKeyColumns: ShiftPatternName
|
TargetType: ShiftDay
|
TypeIndex: ShiftDayTypeIndex
|
EDIMLColumn Capacity { Attribute: Capacity ValueType: Duration }
|
EDIMLColumn Day { Attribute: Day ValueType: Number }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn ShiftPatternName { Attribute: ShiftPatternName ValueType: String }
|
}
|
EDIMLTable ShiftPattern
|
{
|
PrimaryKeyColumns: Name
|
TargetType: ShiftPattern
|
TypeIndex: ShiftPatternTypeIndex
|
EDIMLColumn MinimumDuration { Attribute: MinimumDuration ValueType: Duration }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
}
|
EDIMLTable StockingPointCapacity
|
{
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: StockingPointID
|
TargetType: StockingPointCapacity
|
TypeIndex: StockingPointCapacityTypeIndex
|
EDIMLColumn MaxCapacity { Attribute: MaxCapacity ValueType: Real }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
|
}
|
EDIMLTable StockingPointCost
|
{
|
PrimaryKeyColumns: ID
|
TargetType: StockingPointCost
|
TypeIndex: StockingPointCostTypeIndex
|
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 StockingPoint_MP
|
{
|
PrimaryKeyColumns: ID
|
TargetType: StockingPoint_MP
|
TypeIndex: StockingPointTypeIndex
|
EDIMLColumn CurrencyID { Attribute: CurrencyID ValueType: String }
|
EDIMLColumn DisplayIndex { Attribute: DisplayIndex ValueType: Number }
|
EDIMLColumn End { Attribute: End ValueType: Date }
|
EDIMLColumn GISCity { Attribute: GISCity ValueType: String }
|
EDIMLColumn GISCountryCode { Attribute: GISCountryCode ValueType: String }
|
EDIMLColumn GISPostalCode { Attribute: GISPostalCode ValueType: String }
|
EDIMLColumn GroupName { Attribute: GroupName ValueType: String }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn IconName { Attribute: IconName ValueType: String }
|
EDIMLColumn IsPlannedInfinite { Attribute: IsPlannedInfinite ValueType: Boolean }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn Notes { Attribute: Notes ValueType: String }
|
EDIMLColumn Start { Attribute: Start ValueType: Date }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
EDIMLColumn UnitOfMeasureName { Attribute: UnitOfMeasureName ValueType: String }
|
}
|
EDIMLTable SupplySpecification
|
{
|
PrimaryKeyColumns: End
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: UnitID
|
TargetType: SupplySpecification
|
TypeIndex: SupplySpecificationTypeIndex
|
EDIMLColumn End { Attribute: End ValueType: DateTime }
|
EDIMLColumn HasMaxQuantity { Attribute: HasMaxQuantity ValueType: Boolean }
|
EDIMLColumn MaxQuantity { Attribute: MaxQuantity ValueType: Real }
|
EDIMLColumn MinQuantity { Attribute: MinQuantity ValueType: Real }
|
EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
|
EDIMLColumn Start { Attribute: Start ValueType: DateTime }
|
EDIMLColumn TargetQuantity { Attribute: TargetQuantity ValueType: Real }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
}
|
EDIMLTable TransitionType_MP
|
{
|
PrimaryKeyColumns: Name
|
PrimaryKeyColumns: UnitID
|
TargetType: TransitionType_MP
|
TypeIndex: TransitionTypeTypeIndex
|
EDIMLColumn DefaultMaxDuration { Attribute: DefaultMaxDuration ValueType: Duration }
|
EDIMLColumn DefaultMaxQuantity { Attribute: DefaultMaxQuantity ValueType: Real }
|
EDIMLColumn DefaultMinDuration { Attribute: DefaultMinDuration ValueType: Duration }
|
EDIMLColumn DefaultMinQuantity { Attribute: DefaultMinQuantity ValueType: Real }
|
EDIMLColumn FromCampaignTypeName { Attribute: FromCampaignTypeName ValueType: String }
|
EDIMLColumn HasInputMaxDuration { Attribute: HasInputMaxDuration ValueType: Boolean }
|
EDIMLColumn HasInputMaxQuantity { Attribute: HasInputMaxQuantity ValueType: Boolean }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn ToCampaignTypeName { Attribute: ToCampaignTypeName ValueType: String }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
}
|
EDIMLTable TransportAvailability
|
{
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: UnitID
|
TargetType: TransportAvailability
|
TypeIndex: TransportAvailabilityTypeIndex
|
EDIMLColumn LotSize { Attribute: LotSize ValueType: Real }
|
EDIMLColumn Maintenance { Attribute: Maintenance ValueType: Duration }
|
EDIMLColumn MaximumQuantity { Attribute: MaximumQuantity ValueType: Real }
|
EDIMLColumn NumberOfUnit { Attribute: NumberOfUnit ValueType: Number }
|
EDIMLColumn ShiftPatternName { Attribute: ShiftPatternName ValueType: String }
|
EDIMLColumn Start { Attribute: Start ValueType: DateTime }
|
EDIMLColumn TimeUnit { Attribute: TimeUnit ValueType: String }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
}
|
EDIMLTable TransportCapacity
|
{
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: UnitID
|
TargetType: TransportCapacity
|
TypeIndex: TransportCapacityTypeIndex
|
EDIMLColumn HasSecondaryCapacity { Attribute: HasSecondaryCapacity ValueType: Boolean }
|
EDIMLColumn LotSize { Attribute: LotSize ValueType: Real }
|
EDIMLColumn MaximumCapacity { Attribute: MaximumCapacity ValueType: Real }
|
EDIMLColumn MinimumCapacity { Attribute: MinimumCapacity ValueType: Real }
|
EDIMLColumn SecondaryLotSize { Attribute: SecondaryLotSize ValueType: Real }
|
EDIMLColumn SecondaryMaximumCapacity { Attribute: SecondaryMaximumCapacity ValueType: Real }
|
EDIMLColumn SecondaryMinimumCapacity { Attribute: SecondaryMinimumCapacity ValueType: Real }
|
EDIMLColumn SecondaryUnitOfMeasureName { Attribute: SecondaryUnitOfMeasureName ValueType: String }
|
EDIMLColumn Start { Attribute: Start ValueType: DateTime }
|
EDIMLColumn TimeUnit { Attribute: TimeUnit ValueType: String }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
}
|
EDIMLTable Unit
|
{
|
PrimaryKeyColumns: ID
|
TargetType: Unit
|
TypeIndex: UnitTypeIndex
|
EDIMLColumn CampaignTypeDuration { Attribute: CampaignTypeDuration ValueType: Duration }
|
EDIMLColumn CapacitySmoothingPercentageDelta { Attribute: CapacitySmoothingPercentageDelta ValueType: Real }
|
EDIMLColumn CapacityType { Attribute: CapacityType ValueType: String }
|
EDIMLColumn CurrencyID { Attribute: CurrencyID ValueType: String }
|
EDIMLColumn DisplayIndex { Attribute: DisplayIndex ValueType: Number }
|
EDIMLColumn EndDate { Attribute: EndDate ValueType: Date }
|
EDIMLColumn GISCity { Attribute: GISCity ValueType: String }
|
EDIMLColumn GISCountryCode { Attribute: GISCountryCode ValueType: String }
|
EDIMLColumn GISPostalCode { Attribute: GISPostalCode ValueType: String }
|
EDIMLColumn GroupName { Attribute: GroupName ValueType: String }
|
EDIMLColumn HasCapacitySmoothing { Attribute: HasCapacitySmoothing ValueType: Boolean }
|
EDIMLColumn HasMaximumQuantity { Attribute: HasMaximumQuantity ValueType: Boolean }
|
EDIMLColumn HasUserFrozenFutureDuration { Attribute: HasUserFrozenFutureDuration ValueType: Boolean }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn IconName { Attribute: IconName ValueType: String }
|
EDIMLColumn IsIncludedInSupplySpecification { Attribute: IsIncludedInSupplySpecification ValueType: Boolean }
|
EDIMLColumn IsOverlapCapacitySmoothing { Attribute: IsOverlapCapacitySmoothing ValueType: Boolean }
|
EDIMLColumn IsPlannedInfinite { Attribute: IsPlannedInfinite ValueType: Boolean }
|
EDIMLColumn IsSmoothCapacityOverAllPeriods { Attribute: IsSmoothCapacityOverAllPeriods ValueType: Boolean }
|
EDIMLColumn LotSize { Attribute: LotSize ValueType: Real }
|
EDIMLColumn MaximumQuantity { Attribute: MaximumQuantity ValueType: Real }
|
EDIMLColumn IsSupplier { Attribute: IsSupplier ValueType: Boolean }
|
EDIMLColumn MinimumQuantity { Attribute: MinimumQuantity ValueType: Real }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn Notes { Attribute: Notes ValueType: String }
|
EDIMLColumn ParentUnitID { Attribute: ParentUnitID ValueType: String }
|
EDIMLColumn QuantityToProcess { Attribute: QuantityToProcess ValueType: String }
|
EDIMLColumn StartDate { Attribute: StartDate ValueType: Date }
|
EDIMLColumn UnitOfMeasureName { Attribute: UnitOfMeasureName ValueType: String }
|
EDIMLColumn UseShiftOptimization { Attribute: UseShiftOptimization ValueType: Boolean }
|
EDIMLColumn UserCapacitySmoothingLength { Attribute: UserCapacitySmoothingLength ValueType: Number }
|
EDIMLColumn UserFrozenFutureDuration { Attribute: UserFrozenFutureDuration ValueType: Duration }
|
}
|
EDIMLTable UnitAvailability
|
{
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: UnitID
|
TargetType: UnitAvailability
|
TypeIndex: UnitAvailabilityTypeIndex
|
EDIMLColumn Allocation { Attribute: Allocation ValueType: Real }
|
EDIMLColumn Efficiency { Attribute: Efficiency ValueType: Real }
|
EDIMLColumn Maintenance { Attribute: Maintenance ValueType: Duration }
|
EDIMLColumn MaximumLoadPercentage { Attribute: MaximumLoadPercentage ValueType: Real }
|
EDIMLColumn MinimumLoadThreshold { Attribute: MinimumLoadThreshold ValueType: Real }
|
EDIMLColumn NrOfUnitsOpen { Attribute: NrOfUnitsOpen ValueType: Number }
|
EDIMLColumn ShiftPatternName { Attribute: ShiftPatternName ValueType: String }
|
EDIMLColumn Start { Attribute: Start ValueType: DateTime }
|
EDIMLColumn TimeUnit { Attribute: TimeUnit ValueType: String }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
}
|
EDIMLTable UnitCalendarElement
|
{
|
PrimaryKeyColumns: End
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: UnitID
|
TargetType: UnitCalendarElement
|
TypeIndex: UnitCalendarElementTypeIndex
|
EDIMLColumn Capacity { Attribute: Capacity ValueType: Real }
|
EDIMLColumn Description { Attribute: Description ValueType: String }
|
EDIMLColumn End { Attribute: End ValueType: DateTime }
|
EDIMLColumn Start { Attribute: Start ValueType: DateTime }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
}
|
EDIMLTable UnitCapacity
|
{
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: UnitID
|
TargetType: UnitCapacity
|
TypeIndex: UnitCapacityTypeIndex
|
EDIMLColumn MaxCapacity { Attribute: MaxCapacity ValueType: Real }
|
EDIMLColumn MaximumLoadPercentage { Attribute: MaximumLoadPercentage ValueType: Real }
|
EDIMLColumn MinCapacity { Attribute: MinCapacity ValueType: Real }
|
EDIMLColumn NrOfUnitsOpen { Attribute: NrOfUnitsOpen ValueType: Number }
|
EDIMLColumn Start { Attribute: Start ValueType: DateTime }
|
EDIMLColumn TimeUnit { Attribute: TimeUnit ValueType: String }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
}
|
EDIMLTable UnitCost
|
{
|
PrimaryKeyColumns: ID
|
TargetType: UnitCost
|
TypeIndex: UnitCostTypeIndex
|
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 }
|
}
|
EDIMLTable UnitOfMeasure_MP
|
{
|
PrimaryKeyColumns: Name
|
TargetType: UnitOfMeasure_MP
|
TypeIndex: UnitOfMeasureTypeIndex
|
EDIMLColumn IsDefault { Attribute: IsDefault ValueType: Boolean }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
}
|
EDIMLTable UnitShiftPattern
|
{
|
PrimaryKeyColumns: ShiftPatternName
|
PrimaryKeyColumns: UnitID
|
TargetType: UnitShiftPattern
|
TypeIndex: UnitShiftPatternTypeIndex
|
EDIMLColumn IsAllowed { Attribute: IsAllowed ValueType: Boolean }
|
EDIMLColumn ShiftPatternName { Attribute: ShiftPatternName ValueType: String }
|
EDIMLColumn UnitID { Attribute: UnitID ValueType: String }
|
}
|
}
|
EDIODBCLink.Destination DestinationMPSyncExportAll
|
{
|
DataIntegrityStrategy: 'Disabled'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.syncobject'
|
EDIODBCLinkTable ActualProductInStockingPointInPeriods
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: Date
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: StockingPointID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn ActualInventoryLevelEnd
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn Date
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn Description
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ManufacturedDate
|
{
|
ValueType: Date
|
}
|
EDIODBCLinkColumn ProductID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn StockingPointID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable ActualUnitPeriods
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: Date
|
PrimaryKeyColumns: UnitID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn ActualTotalAvailableDuration
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn ActualTotalAvailableQuantity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn ActualUtilizationPercentage
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn Date
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn Description
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UnitID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable BaseConversionFactors
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: SourceUnitOfMeasureName
|
PrimaryKeyColumns: TargetUnitOfMeasureName
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn Factor
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn IsEnabled
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn ProductID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn SourceUnitOfMeasureName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn TargetUnitOfMeasureName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable CampaignTypes
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: Name
|
PrimaryKeyColumns: UnitID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn Color
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DefaultMaxDuration
|
{
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn DefaultMaxQuantity
|
{
|
ValueType: Real
|
}
|
EDIODBCLinkColumn DefaultMinDuration
|
{
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn DefaultMinQuantity
|
{
|
ValueType: Real
|
}
|
EDIODBCLinkColumn HasInputMaxDuration
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn HasInputMaxQuantity
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn Name
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UnitID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable Campaign_MP
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: CampaignID
|
PrimaryKeyColumns: UnitID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn CampaignID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn CampaignTypeName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Comment
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Duration
|
{
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn EarliestStart
|
{
|
MayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn HasInputMaxDuration
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn HasInputMaxQuantity
|
{
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn HasNextTransitionDurationByOpt
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn MaxDuration
|
{
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn MaxQuantity
|
{
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn MinDuration
|
{
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn MinQuantity
|
{
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn NextTransitionDurationByOpt
|
{
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn OptNextCampaignTypeName
|
{
|
ValueType: String
|
}
|
EDIODBCLinkColumn SequenceNumber
|
{
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn UnitID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable Currencies
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn ID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn IsBase
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn Name
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Symbol
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable CurrencyRates
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: CurrencyID
|
PrimaryKeyColumns: Start
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn CurrencyID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Rate
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn Start
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
}
|
EDIODBCLinkTable CustomerOrders
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn CurrencyID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn CustomerID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn CustomerName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn IsEligibleForNetting
|
{
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsExcludedFromFulfillmentKPIUser
|
{
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsFirmed
|
{
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn OrderDate
|
{
|
ValueType: Date
|
}
|
EDIODBCLinkColumn OrderID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn OrderLineID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Price
|
{
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn PriorityName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ProductID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Quantity
|
{
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn SalesSegmentName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn StockingPointID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UnitOfMeasureName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable DisaggregationFactors
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: StockingPointID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn Factor
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn IsManuallyConfigured
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn ProductID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Start
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn StockingPointID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable FeedbackPeriodTaskOperations
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn DateTime
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn Description
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn FeedbackQuantity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn ID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn IsLocked
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn OperationID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable FeedbackProductInTrips
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn Arrival
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn Description
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DestinationStockingPointID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn FeedbackQuantity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn ID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn LaneID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn OriginStockingPointID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ProductID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable Forecasts
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn CurrencyID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DemandUncertaintyPercentage
|
{
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn EndDate
|
{
|
MayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn ID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn IsExcludedFromFulfillmentKPIUser
|
{
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn Price
|
{
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn PriorityName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ProductID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Quantity
|
{
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn SalesSegmentName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn StartDate
|
{
|
MayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn StockingPointID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UnitOfMeasureName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable FulfillmentRestrictions
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: SalesSegmentName
|
PrimaryKeyColumns: StartDate
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn EndDate
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn ProductID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn SalesSegmentName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn StartDate
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
}
|
EDIODBCLinkTable FulfillmentTargets
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn End
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn ID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn IsEnabled
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsUsedForPlanningFulfillment
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsUsedForSafetyStockCalculation
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn Name
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ProductID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn SalesSegmentName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Start
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn StockingPointID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn TargetPercentage
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
}
|
EDIODBCLinkTable GlobalParameters
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn AbsoluteLowerLimit
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn AbsoluteUpperLimit
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn AutoScalingFrequency
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn BalanceTolerance
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn BaseCurrency
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn BaseCurrencySymbol
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn BiasTolerance
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn BottleneckTolerance
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn BottleneckWindowEnd
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn BottleneckWindowEndDate
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn BottleneckWindowStart
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn BottleneckWindowStartDate
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn CO2ProcessUoM
|
{
|
ValueType: String
|
}
|
EDIODBCLinkColumn CO2UoM
|
{
|
ValueType: String
|
}
|
EDIODBCLinkColumn ChangeoverTime
|
{
|
Length: 255
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn DefaultAbsoluteValueForInventoryHolding
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn DefaultAccountForInventoryHolding
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DefaultAllocation
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn DefaultAnnualInterestRateForInventoryHolding
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn DefaultDemandUncertainty
|
{
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn DefaultEfficiency
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn DefaultMaxCapacityForStockingPoint
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn DefaultMaxCapacityPerDayForUnit
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn DefaultMaxLoadPercentage
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn DefaultMinCapacityPerDayForUnit
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn DefaultNumberOfPeriodsForAvgDemand
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn DefaultNumberOfUnits
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn DefaultOperationInputOutputQuantity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn DefaultServiceLevel
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn DefaultShiftPatternName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DefaultSmartPlanStrategy
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DefaultUnitOfMeasure
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DifferenceFactor1e3
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn DifferenceFactor1e6
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn DisaggregationRatio
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DurationInventoryMixBalancingCheck
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn DurationLotsizeHorizon
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn EndOfKPIHorizon
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn ForecastNettingRule
|
{
|
Length: 255
|
ValueType: String
|
}
|
EDIODBCLinkColumn HasAbsoluteValueForInventoryHolding
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn HasDefaultInventoryHoldingCost
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn HasDemandDependentDisaggregationRatio
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn ID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn IsManuallyConfigured
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsPeggingRunAfterOptimization
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsRunOptimizerSynchronously
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsSoftDeleted
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsUsableIfExpiredWithinPeriod
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsUsableIfMatureWithinPeriod
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsValidData
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn LaneLeadTimeLogic
|
{
|
Length: 255
|
ValueType: String
|
}
|
EDIODBCLinkColumn LotSizeTolerance
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn MinToKeepTripInUsedPercentage
|
{
|
Length: 255
|
ValueType: Number
|
}
|
EDIODBCLinkColumn MinimumSalesDemandQtyThreshold
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn NoiseThresholdOptimizerOutput
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn NumberOfDecimals
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn NumberOfPeriodsInWindow
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn NumberOfPeriodsPerSlide
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn NumberOfPeriodsSmartPlan
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn OperationLeadTimeLogic
|
{
|
Length: 255
|
ValueType: String
|
}
|
EDIODBCLinkColumn OutlierTolerance
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn PeriodSpecificationForUnitActual
|
{
|
Length: 255
|
ValueType: String
|
}
|
EDIODBCLinkColumn PeriodTaskValidity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn RunSmartPlanSynchronously
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn SanityCheckDataMostSevere
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn SanityCheckDataMostSevereCount
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn SanityCheckDataTotalViolationCount
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn SanityCheckLimit
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn StartOfKPIHorizon
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn StartOfLotsizeHorizon
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn StockingPointBottleneckThreshold
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn UnitLowerBottleneckThreshold
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn UnitUpperBottleneckThreshold
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn UpdateKPIHorizonAtPeriodRoll
|
{
|
Length: 255
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn UseAuditTrail
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn UseDefaultDisplayIndex
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn UseSingleEchelon
|
{
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn UseSlidingWindowsApproach
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
}
|
EDIODBCLinkTable Groups
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: Name
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn IconForStockingPoints
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn IconForUnits
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Name
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable Ingredients
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: Name
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn Description
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Name
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable InventorySpecifications
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: StockingPointID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn HasMaxLevel
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn HasMaxLevelInDays
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn HasMinLevel
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn HasMinLevelInDays
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn MaxLevelInDays
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn MaxLevelInQuantity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn MinLevelInDays
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn MinLevelInQuantity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn ProductID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Start
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn StockingPointID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable ExternalSupplies
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn Date
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn Description
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ManufacturedDate
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn ProductID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Quantity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn StockingPointID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable InventorySupplyCosts
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn AccountName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Cost
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn CostDriver
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn InventorySupplyID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn LengthOfTime
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn Start
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn TimeUnit
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable InventoryValueAndCosts
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn AccountName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Cost
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn CostDriver
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn LengthOfTime
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn ProductID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Start
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn StockingPointID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn TimeUnit
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable LaneCosts
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn AccountName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Cost
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn CostDriver
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn LaneID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn LengthOfTime
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn Start
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn TimeUnit
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable LaneLegCosts
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn AccountName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Cost
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn CostDriver
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DestinationStockingPointID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn LaneID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn LengthOfTime
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn OriginStockingPointID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Start
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn TimeUnit
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable LaneLegs
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: DestinationStockingPointID
|
PrimaryKeyColumns: LaneID
|
PrimaryKeyColumns: OriginStockingPointID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn CO2Emission
|
{
|
ValueType: Real
|
}
|
EDIODBCLinkColumn DestinationStockingPointID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn End
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn HasStandardDeviationLeadTimeLaneLeg
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn HasUserLeadTime
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsEnabled
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn LaneID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Name
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn OriginStockingPointID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn StandardDeviationLeadTimeLaneLeg
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn Start
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn UserLeadTime
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Duration
|
}
|
}
|
EDIODBCLinkTable Lanes
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn End
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn ID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn IsEnabled
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn Name
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn StandardDeviationLeadTimeLane
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn Start
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn UnitID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UserLeadTime
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Duration
|
}
|
}
|
EDIODBCLinkTable OperationBOMs
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: IsInput
|
PrimaryKeyColumns: OperationID
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: StockingPointID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn InputGroupID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn IsExcluded
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsInput
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn MaxQuantityInGroup
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn MinQuantityInGroup
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn OperationID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn OperationInputSetName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ProductID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Quantity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn StockingPointID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable OperationCosts
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn AccountName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Cost
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn CostDriver
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn LengthOfTime
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn OperationID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Start
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn TimeUnit
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable OperationInCampaignTypes
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: CampaignTypeName
|
PrimaryKeyColumns: OperationID
|
PrimaryKeyColumns: UnitID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn CampaignTypeName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn OperationID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UnitID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable OperationInTransitionTypes
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: OperationID
|
PrimaryKeyColumns: TransitionTypeName
|
PrimaryKeyColumns: UnitID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn OperationID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn TransitionTypeName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UnitID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable OperationInputGroups
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: InputGroupID
|
PrimaryKeyColumns: OperationID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn InputGroupID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn InputGroupQuantity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn OperationID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable OperationInputSets
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: Name
|
PrimaryKeyColumns: OperationID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn MaxQuantity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn MinQuantity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn Name
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn OperationID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable OperationLinks
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: DestOperationID
|
PrimaryKeyColumns: SourceOperationID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn DestGroupID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn DestGroupQuantity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn DestHasUserQuantity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn DestMaxQuantity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn DestMinQuantity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn DestOperationID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DestQuantity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn SourceGroupID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn SourceOperationID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn SourceQuantity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
}
|
EDIODBCLinkTable Operations
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn CO2Emission
|
{
|
ValueType: Real
|
}
|
EDIODBCLinkColumn HasUserLotSize
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn HasUserMaximumQuantity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn ID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn IsEnabled
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn LotSize
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn MaximumQuantity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn MinimumQuantity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn RoutingID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn RoutingStepName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn StandardDeviationLeadTimeOperation
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn Throughput
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn UnitID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UserLeadTime
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Duration
|
}
|
}
|
EDIODBCLinkTable PISPSpecifications
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: StockingPointID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn HasUnitOfMeasure
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn InputLotSize
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn IsExcludeShelfLifeAndMaturation
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsExcluded
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsExcludedFromBalancing
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsNegativeInventoryAllowed
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsSafetyStockKept
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn ProductID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn StockingPointID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UnitOfMeasureName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable PeriodParameters
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn ID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn StartOfPlanning
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: DateTime
|
}
|
}
|
EDIODBCLinkTable PeriodSpecifications
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn ID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn IsInHour
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsUsedForPlanning
|
{
|
Length: 255
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn NrOfFuturePeriod
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn NrOfHistoricalPeriod
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn NrOfTimeUnit
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn PeriodAlignment
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn TimeUnit
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable PostponedSalesDemandCosts
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: StockingPointID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn Penalty
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn ProductID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Start
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn StockingPointID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable PostponementSpecifications
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: SalesSegmentName
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn HorizonNrOfTimeUnit
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn HorizonTimeUnit
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn MaxNrOfTimeUnit
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn MaxTimeUnit
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn SalesSegmentName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable Priorities
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: Name
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn Name
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Weight
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
}
|
EDIODBCLinkTable ProductInLanes
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: LaneID
|
PrimaryKeyColumns: ProductID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn IsExcluded
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn LaneID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ProductID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable ProductLevels
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
Parameters: '/owner="dbo"'
|
PrimaryKeyColumns: Name
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn IsProductCategory
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Level
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn Name
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable ProductValueAndCosts
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn AccountName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Cost
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn CostDriver
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ProductID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Start
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
}
|
EDIODBCLinkTable Products
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn DisplayIndex
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn HasMaturation
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn HasShelfLife
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn ID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn IconName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn IsByProduct
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsExcludedFromFulfillmentKPI
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn IsExcludedFromOptimization
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsPlannedAfterOptimization
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn MaturationDays
|
{
|
ValueType: Real
|
}
|
EDIODBCLinkColumn Name
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Notes
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ParentID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ShelfLife
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn UnitOfMeasureName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable RecipeIngredients
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: IngredientName
|
PrimaryKeyColumns: RecipeName
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn IngredientName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Maximum
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn Minimum
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn Nominal
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn RecipeName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable RecipeWithEffectiveDate
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: EffectiveDate
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: RecipeName
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn EffectiveDate
|
{
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn ProductID
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn RecipeName
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable Recipes
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: Name
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn Description
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Name
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable RoutingConfiguratorViews
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn EdgeThickness
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn FontName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn FontSize
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn GridHeight
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn GridPointDistance
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn GridWidth
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn ID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn IsCompactMode
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsGridVisible
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn OffsetX
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn OffsetY
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn OperationHeight
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn OperationInputOutputWidth
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn OperationOffsetX
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn OperationOffsetY
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn OperationWidth
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn PISPHeight
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn PISPWidth
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn Padding
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn RoutingStepDistance
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn RoutingStepMinimumHeight
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn RoutingStepMinimumWidth
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn User
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UserOperationInputOutputHeight
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
}
|
EDIODBCLinkTable RoutingSteps
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: Name
|
PrimaryKeyColumns: RoutingID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn Name
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn RoutingID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn SequenceNumber
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn Tool
|
{
|
Length: 255
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable Routings
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn AllowWIPInventory
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn End
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn ID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn IsEnabled
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn Name
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Start
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
}
|
EDIODBCLinkTable SafetyStocks
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: StockingPointID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn HasTargetInDays
|
{
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn ProductID
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Start
|
{
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn StockingPointID
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn TargetInDays
|
{
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn TargetInQuantity
|
{
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
}
|
EDIODBCLinkTable SalesLevels
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: Name
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn Level
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn Name
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable SalesSegments
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: Name
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn DisplayIndex
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn Name
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ParentName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable ServiceLevels
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn End
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn ID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn IsEnabled
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsUsedForPlanningFulfillment
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsUsedForSafetyStockCalculation
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn Name
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ProductID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn SalesSegmentName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Start
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn StockingPointID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn TargetPercentage
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
}
|
EDIODBCLinkTable ShiftDays
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: ID
|
PrimaryKeyColumns: ShiftPatternName
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn Capacity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn Day
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn ID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ShiftPatternName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable ShiftPatterns
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: Name
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn MinimumDuration
|
{
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn Name
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable StockingPointCapacities
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: StockingPointID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn MaxCapacity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn Start
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn StockingPointID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable StockingPointCosts
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn AccountName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Cost
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn CostDriver
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn LengthOfTime
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn Start
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn StockingPointID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn TimeUnit
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable StockingPoints
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn CurrencyID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DisplayIndex
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn End
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn GISCity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn GISCountryCode
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn GISPostalCode
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn GroupName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn IconName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn IsPlannedInfinite
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn Name
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Notes
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Start
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn UnitID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UnitOfMeasureName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable SupplySpecifications
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: End
|
PrimaryKeyColumns: ProductID
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: UnitID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn End
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn HasMaxQuantity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn MaxQuantity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn MinQuantity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn ProductID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Start
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn TargetQuantity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn UnitID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable TransitionTypes
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: Name
|
PrimaryKeyColumns: UnitID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn DefaultMaxDuration
|
{
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn DefaultMaxQuantity
|
{
|
ValueType: Real
|
}
|
EDIODBCLinkColumn DefaultMinDuration
|
{
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn DefaultMinQuantity
|
{
|
ValueType: Real
|
}
|
EDIODBCLinkColumn FromCampaignTypeName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn HasInputMaxDuration
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn HasInputMaxQuantity
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn Name
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ToCampaignTypeName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UnitID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable TransportAvailability
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: UnitID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn LotSize
|
{
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn Maintenance
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn MaximumQuantity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn NumberOfUnit
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn ShiftPatternName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Start
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn TimeUnit
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UnitID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable TransportCapacities
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: UnitID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn HasSecondaryCapacity
|
{
|
Length: 255
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn LotSize
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn MaximumCapacity
|
{
|
Length: 255
|
ValueType: Real
|
}
|
EDIODBCLinkColumn MinimumCapacity
|
{
|
Length: 255
|
ValueType: Real
|
}
|
EDIODBCLinkColumn SecondaryLotSize
|
{
|
Length: 255
|
ValueType: Real
|
}
|
EDIODBCLinkColumn SecondaryMaximumCapacity
|
{
|
Length: 255
|
ValueType: Real
|
}
|
EDIODBCLinkColumn SecondaryMinimumCapacity
|
{
|
Length: 255
|
ValueType: Real
|
}
|
EDIODBCLinkColumn SecondaryUnitOfMeasureName
|
{
|
Length: 255
|
ValueType: String
|
}
|
EDIODBCLinkColumn Start
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn TimeUnit
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UnitID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable UnitAvailabilities
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: UnitID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn Allocation
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn Efficiency
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn Maintenance
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn MaximumLoadPercentage
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn MinimumLoadThreshold
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn NrOfUnitsOpen
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn ShiftPatternName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Start
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn TimeUnit
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UnitID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable UnitCalendarElements
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: End
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: UnitID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn Capacity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn Description
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn End
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn Start
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn UnitID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable UnitCapacities
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: Start
|
PrimaryKeyColumns: UnitID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn MaxCapacity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn MaximumLoadPercentage
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn MinCapacity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn NrOfUnitsOpen
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn Start
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: DateTime
|
}
|
EDIODBCLinkColumn TimeUnit
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UnitID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable UnitCosts
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn AccountName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Cost
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn CostDriver
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn LengthOfTime
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn Start
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn TimeUnit
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UnitID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable UnitOfMeasures
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: Name
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn IsDefault
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn Name
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable UnitShiftPatterns
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: ShiftPatternName
|
PrimaryKeyColumns: UnitID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn IsAllowed
|
{
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn ShiftPatternName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UnitID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
EDIODBCLinkTable Units
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
PrimaryKeyColumns: ID
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn CampaignTypeDuration
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Duration
|
}
|
EDIODBCLinkColumn CapacitySmoothingPercentageDelta
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn CapacityType
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn CurrencyID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DisplayIndex
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Number
|
}
|
EDIODBCLinkColumn EndDate
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn GISCity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn GISCountryCode
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn GISPostalCode
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn GroupName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn HasCapacitySmoothing
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn HasMaximumQuantity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn HasUserFrozenFutureDuration
|
{
|
Length: 255
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn ID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn IconName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn IsIncludedInSupplySpecification
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsOverlapCapacitySmoothing
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsPlannedInfinite
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsSmoothCapacityOverAllPeriods
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn IsSupplier
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn LotSize
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn MaximumQuantity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn MinimumQuantity
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Real
|
}
|
EDIODBCLinkColumn Name
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn Notes
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ParentUnitID
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn QuantityToProcess
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn StartDate
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: Date
|
}
|
EDIODBCLinkColumn UnitOfMeasureName
|
{
|
Length: 255
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn UseShiftOptimization
|
{
|
ValueType: Boolean
|
}
|
EDIODBCLinkColumn UserCapacitySmoothingLength
|
{
|
Length: 255
|
ValueType: Number
|
}
|
EDIODBCLinkColumn UserFrozenFutureDuration
|
{
|
Length: 255
|
ValueType: Duration
|
}
|
}
|
}
|
EDITransformation.Transformation TransformationMPSyncExportAll
|
{
|
EDITableTransformation
|
{
|
InputTable: ActualProductInStockingPointInPeriod
|
OutputTable: ActualProductInStockingPointInPeriods
|
EDIColumnMatch { InputColumn: ActualInventoryLevelEnd OutputColumn: ActualInventoryLevelEnd }
|
EDIColumnMatch
|
{
|
InputColumn: Date
|
OutputColumn: Date
|
}
|
EDIColumnMatch { InputColumn: Description OutputColumn: Description }
|
EDIColumnMatch { InputColumn: ManufacturedDate OutputColumn: ManufacturedDate }
|
EDIColumnMatch { InputColumn: ProductID OutputColumn: ProductID }
|
EDIColumnMatch { InputColumn: StockingPointID OutputColumn: StockingPointID }
|
}
|
EDITableTransformation
|
{
|
InputTable: ActualUnitPeriod
|
OutputTable: ActualUnitPeriods
|
EDIColumnMatch
|
{
|
InputColumn: ActualTotalAvailableDuration
|
OutputColumn: ActualTotalAvailableDuration
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<DurationToReal xmlns="http://www.quintiq.com/GEB/DurationToReal" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<Conversion>DaysToReal</Conversion>
|
</DurationToReal>
|
*]
|
}
|
}
|
EDIColumnMatch { InputColumn: ActualTotalAvailableQuantity OutputColumn: ActualTotalAvailableQuantity }
|
EDIColumnMatch { InputColumn: ActualUtilizationPercentage OutputColumn: ActualUtilizationPercentage }
|
EDIColumnMatch
|
{
|
InputColumn: Date
|
OutputColumn: Date
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<DateToDateTime xmlns="http://www.quintiq.com/GEB/DateToDateTime" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
</DateToDateTime>
|
*]
|
}
|
}
|
EDIColumnMatch { InputColumn: Description OutputColumn: Description }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
}
|
EDITableTransformation
|
{
|
InputTable: BaseConversionFactor
|
OutputTable: BaseConversionFactors
|
EDIColumnMatch { InputColumn: Factor OutputColumn: Factor }
|
EDIColumnMatch { InputColumn: IsEnabled OutputColumn: IsEnabled }
|
EDIColumnMatch { InputColumn: ProductID OutputColumn: ProductID }
|
EDIColumnMatch { InputColumn: SourceUnitOfMeasureName OutputColumn: SourceUnitOfMeasureName }
|
EDIColumnMatch { InputColumn: TargetUnitOfMeasureName OutputColumn: TargetUnitOfMeasureName }
|
}
|
EDITableTransformation
|
{
|
InputTable: CampaignType_MP
|
OutputTable: CampaignTypes
|
EDIColumnMatch { InputColumn: Color OutputColumn: Color }
|
EDIColumnMatch { InputColumn: DefaultMaxDuration OutputColumn: DefaultMaxDuration }
|
EDIColumnMatch { InputColumn: DefaultMaxQuantity OutputColumn: DefaultMaxQuantity }
|
EDIColumnMatch { InputColumn: DefaultMinDuration OutputColumn: DefaultMinDuration }
|
EDIColumnMatch { InputColumn: DefaultMinQuantity OutputColumn: DefaultMinQuantity }
|
EDIColumnMatch { InputColumn: HasInputMaxDuration OutputColumn: HasInputMaxDuration }
|
EDIColumnMatch { InputColumn: HasInputMaxQuantity OutputColumn: HasInputMaxQuantity }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
}
|
EDITableTransformation
|
{
|
InputTable: Campaign_MP
|
OutputTable: Campaign_MP
|
EDIColumnMatch { InputColumn: CampaignID OutputColumn: CampaignID }
|
EDIColumnMatch { InputColumn: CampaignTypeName OutputColumn: CampaignTypeName }
|
EDIColumnMatch { InputColumn: Comment OutputColumn: Comment }
|
EDIColumnMatch
|
{
|
InputColumn: Duration
|
OutputColumn: Duration
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<DurationToReal xmlns="http://www.quintiq.com/GEB/DurationToReal" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
<Conversion>DaysToReal</Conversion>
|
</DurationToReal>
|
*]
|
}
|
}
|
EDIColumnMatch { InputColumn: EarliestStart OutputColumn: EarliestStart }
|
EDIColumnMatch { InputColumn: HasInputMaxDuration OutputColumn: HasInputMaxDuration }
|
EDIColumnMatch { InputColumn: HasInputMaxQuantity OutputColumn: HasInputMaxQuantity }
|
EDIColumnMatch { InputColumn: HasNextTransitionDurationByOpt OutputColumn: HasNextTransitionDurationByOpt }
|
EDIColumnMatch { InputColumn: MaxDuration OutputColumn: MaxDuration }
|
EDIColumnMatch { InputColumn: MaxQuantity OutputColumn: MaxQuantity }
|
EDIColumnMatch { InputColumn: MinDuration OutputColumn: MinDuration }
|
EDIColumnMatch { InputColumn: MinQuantity OutputColumn: MinQuantity }
|
EDIColumnMatch { InputColumn: NextTransitionDurationByOpt OutputColumn: NextTransitionDurationByOpt }
|
EDIColumnMatch { InputColumn: OptNextCampaignTypeName OutputColumn: OptNextCampaignTypeName }
|
EDIColumnMatch { InputColumn: SequenceNumber OutputColumn: SequenceNumber }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
}
|
EDITableTransformation
|
{
|
InputTable: CurrencyRate_MP
|
OutputTable: CurrencyRates
|
EDIColumnMatch { InputColumn: CurrencyID OutputColumn: CurrencyID }
|
EDIColumnMatch { InputColumn: Rate OutputColumn: Rate }
|
EDIColumnMatch { InputColumn: Start OutputColumn: Start }
|
}
|
EDITableTransformation
|
{
|
InputTable: Currency_MP
|
OutputTable: Currencies
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: IsBase OutputColumn: IsBase }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
EDIColumnMatch { InputColumn: Symbol OutputColumn: Symbol }
|
}
|
EDITableTransformation
|
{
|
InputTable: CustomerOrder
|
OutputTable: CustomerOrders
|
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: 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: StartDate OutputColumn: OrderDate }
|
EDIColumnMatch { InputColumn: StockingPointID OutputColumn: StockingPointID }
|
EDIColumnMatch { InputColumn: UnitOfMeasureName OutputColumn: UnitOfMeasureName }
|
}
|
EDITableTransformation
|
{
|
InputTable: DisaggregationFactor
|
OutputTable: DisaggregationFactors
|
EDIColumnMatch { InputColumn: Factor OutputColumn: Factor }
|
EDIColumnMatch { InputColumn: IsManuallyConfigured OutputColumn: IsManuallyConfigured }
|
EDIColumnMatch { InputColumn: ProductID OutputColumn: ProductID }
|
EDIColumnMatch { InputColumn: Start OutputColumn: Start }
|
EDIColumnMatch { InputColumn: StockingPointID OutputColumn: StockingPointID }
|
}
|
EDITableTransformation
|
{
|
InputTable: FeedbackPeriodTaskOperation
|
OutputTable: FeedbackPeriodTaskOperations
|
EDIColumnMatch { InputColumn: DateTime OutputColumn: DateTime }
|
EDIColumnMatch { InputColumn: Description OutputColumn: Description }
|
EDIColumnMatch { InputColumn: FeedbackQuantity OutputColumn: FeedbackQuantity }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: IsLocked OutputColumn: IsLocked }
|
EDIColumnMatch { InputColumn: OperationID OutputColumn: OperationID }
|
}
|
EDITableTransformation
|
{
|
InputTable: FeedbackProductInTrip
|
OutputTable: FeedbackProductInTrips
|
EDIColumnMatch { InputColumn: Arrival OutputColumn: Arrival }
|
EDIColumnMatch { InputColumn: Description OutputColumn: Description }
|
EDIColumnMatch { InputColumn: DestinationStockingPointID OutputColumn: DestinationStockingPointID }
|
EDIColumnMatch { InputColumn: FeedbackQuantity OutputColumn: FeedbackQuantity }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: LaneID OutputColumn: LaneID }
|
EDIColumnMatch { InputColumn: OriginStockingPointID OutputColumn: OriginStockingPointID }
|
EDIColumnMatch { InputColumn: ProductID OutputColumn: ProductID }
|
}
|
EDITableTransformation
|
{
|
InputTable: Forecast
|
OutputTable: Forecasts
|
EDIColumnMatch { InputColumn: CurrencyID OutputColumn: CurrencyID }
|
EDIColumnMatch { InputColumn: DemandUncertaintyPercentage OutputColumn: DemandUncertaintyPercentage }
|
EDIColumnMatch
|
{
|
InputColumn: EndDate
|
OutputColumn: EndDate
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<DateToDateTime xmlns="http://www.quintiq.com/GEB/DateToDateTime" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
</DateToDateTime>
|
*]
|
}
|
}
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: IsExcludedFromFulfillmentKPIUser OutputColumn: IsExcludedFromFulfillmentKPIUser }
|
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: StartDate
|
OutputColumn: StartDate
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<DateToDateTime xmlns="http://www.quintiq.com/GEB/DateToDateTime" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
</DateToDateTime>
|
*]
|
}
|
}
|
EDIColumnMatch { InputColumn: StockingPointID OutputColumn: StockingPointID }
|
EDIColumnMatch { InputColumn: UnitOfMeasureName OutputColumn: UnitOfMeasureName }
|
}
|
EDITableTransformation
|
{
|
InputTable: FulfillmentRestriction
|
OutputTable: FulfillmentRestrictions
|
EDIColumnMatch { InputColumn: EndDate OutputColumn: EndDate }
|
EDIColumnMatch { InputColumn: ProductID OutputColumn: ProductID }
|
EDIColumnMatch { InputColumn: SalesSegmentName OutputColumn: SalesSegmentName }
|
EDIColumnMatch { InputColumn: StartDate OutputColumn: StartDate }
|
}
|
EDITableTransformation
|
{
|
InputTable: FulfillmentTarget
|
OutputTable: FulfillmentTargets
|
EDIColumnMatch { InputColumn: End OutputColumn: End }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: IsEnabled OutputColumn: IsEnabled }
|
EDIColumnMatch { InputColumn: IsUsedForPlanningFulfillment OutputColumn: IsUsedForPlanningFulfillment }
|
EDIColumnMatch { InputColumn: IsUsedForSafetyStockCalculation OutputColumn: IsUsedForSafetyStockCalculation }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
EDIColumnMatch { InputColumn: ProductID OutputColumn: ProductID }
|
EDIColumnMatch { InputColumn: SalesSegmentName OutputColumn: SalesSegmentName }
|
EDIColumnMatch { InputColumn: Start OutputColumn: Start }
|
EDIColumnMatch { InputColumn: StockingPointID OutputColumn: StockingPointID }
|
EDIColumnMatch { InputColumn: TargetPercentage OutputColumn: TargetPercentage }
|
}
|
EDITableTransformation
|
{
|
InputTable: GlobalParameters_MP
|
OutputTable: GlobalParameters
|
EDIColumnMatch { InputColumn: AbsoluteLowerLimit OutputColumn: AbsoluteLowerLimit }
|
EDIColumnMatch { InputColumn: AbsoluteUpperLimit OutputColumn: AbsoluteUpperLimit }
|
EDIColumnMatch { InputColumn: AutoScalingFrequency OutputColumn: AutoScalingFrequency }
|
EDIColumnMatch { InputColumn: BalanceTolerance OutputColumn: BalanceTolerance }
|
EDIColumnMatch { InputColumn: BaseCurrency OutputColumn: BaseCurrency }
|
EDIColumnMatch { InputColumn: BaseCurrencySymbol OutputColumn: BaseCurrencySymbol }
|
EDIColumnMatch { InputColumn: BiasTolerance OutputColumn: BiasTolerance }
|
EDIColumnMatch { InputColumn: BottleneckTolerance OutputColumn: BottleneckTolerance }
|
EDIColumnMatch { InputColumn: BottleneckWindowEnd OutputColumn: BottleneckWindowEnd }
|
EDIColumnMatch { InputColumn: BottleneckWindowEndDate OutputColumn: BottleneckWindowEndDate }
|
EDIColumnMatch { InputColumn: BottleneckWindowStart OutputColumn: BottleneckWindowStart }
|
EDIColumnMatch { InputColumn: BottleneckWindowStartDate OutputColumn: BottleneckWindowStartDate }
|
EDIColumnMatch { InputColumn: CO2ProcessUoM OutputColumn: CO2ProcessUoM }
|
EDIColumnMatch { InputColumn: CO2UoM OutputColumn: CO2UoM }
|
EDIColumnMatch { InputColumn: ChangeoverTime OutputColumn: ChangeoverTime }
|
EDIColumnMatch { InputColumn: DefaultAbsoluteValueForInventoryHolding OutputColumn: DefaultAbsoluteValueForInventoryHolding }
|
EDIColumnMatch { InputColumn: DefaultAccountForInventoryHolding OutputColumn: DefaultAccountForInventoryHolding }
|
EDIColumnMatch { InputColumn: DefaultAllocation OutputColumn: DefaultAllocation }
|
EDIColumnMatch { InputColumn: DefaultAnnualInterestRateForInventoryHolding OutputColumn: DefaultAnnualInterestRateForInventoryHolding }
|
EDIColumnMatch { InputColumn: DefaultDemandUncertainty OutputColumn: DefaultDemandUncertainty }
|
EDIColumnMatch { InputColumn: DefaultEfficiency OutputColumn: DefaultEfficiency }
|
EDIColumnMatch { InputColumn: DefaultMaxCapacityForStockingPoint OutputColumn: DefaultMaxCapacityForStockingPoint }
|
EDIColumnMatch { InputColumn: DefaultMaxCapacityPerDayForUnit OutputColumn: DefaultMaxCapacityPerDayForUnit }
|
EDIColumnMatch { InputColumn: DefaultMaxLoadPercentage OutputColumn: DefaultMaxLoadPercentage }
|
EDIColumnMatch { InputColumn: DefaultMinCapacityPerDayForUnit OutputColumn: DefaultMinCapacityPerDayForUnit }
|
EDIColumnMatch { InputColumn: DefaultNumberOfPeriodsForAvgDemand OutputColumn: DefaultNumberOfPeriodsForAvgDemand }
|
EDIColumnMatch { InputColumn: DefaultNumberOfUnits OutputColumn: DefaultNumberOfUnits }
|
EDIColumnMatch { InputColumn: DefaultOperationInputOutputQuantity OutputColumn: DefaultOperationInputOutputQuantity }
|
EDIColumnMatch { InputColumn: DefaultServiceLevel OutputColumn: DefaultServiceLevel }
|
EDIColumnMatch { InputColumn: DefaultShiftPatternName OutputColumn: DefaultShiftPatternName }
|
EDIColumnMatch { InputColumn: DefaultSmartPlanStrategy OutputColumn: DefaultSmartPlanStrategy }
|
EDIColumnMatch { InputColumn: DefaultUnitOfMeasure OutputColumn: DefaultUnitOfMeasure }
|
EDIColumnMatch { InputColumn: DifferenceFactor1e3 OutputColumn: DifferenceFactor1e3 }
|
EDIColumnMatch { InputColumn: DifferenceFactor1e6 OutputColumn: DifferenceFactor1e6 }
|
EDIColumnMatch { InputColumn: DisaggregationRatio OutputColumn: DisaggregationRatio }
|
EDIColumnMatch { InputColumn: DurationInventoryMixBalancingCheck OutputColumn: DurationInventoryMixBalancingCheck }
|
EDIColumnMatch { InputColumn: DurationLotsizeHorizon OutputColumn: DurationLotsizeHorizon }
|
EDIColumnMatch { InputColumn: EndOfKPIHorizon OutputColumn: EndOfKPIHorizon }
|
EDIColumnMatch { InputColumn: ForecastNettingRule OutputColumn: ForecastNettingRule }
|
EDIColumnMatch { InputColumn: HasAbsoluteValueForInventoryHolding OutputColumn: HasAbsoluteValueForInventoryHolding }
|
EDIColumnMatch { InputColumn: HasDefaultInventoryHoldingCost OutputColumn: HasDefaultInventoryHoldingCost }
|
EDIColumnMatch { InputColumn: HasDemandDependentDisaggregationRatio OutputColumn: HasDemandDependentDisaggregationRatio }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: IsManuallyConfigured OutputColumn: IsManuallyConfigured }
|
EDIColumnMatch { InputColumn: IsPeggingRunAfterOptimization OutputColumn: IsPeggingRunAfterOptimization }
|
EDIColumnMatch { InputColumn: IsRunOptimizerSynchronously OutputColumn: IsRunOptimizerSynchronously }
|
EDIColumnMatch { InputColumn: IsSoftDeleted OutputColumn: IsSoftDeleted }
|
EDIColumnMatch { InputColumn: IsUsableIfExpiredWithinPeriod OutputColumn: IsUsableIfExpiredWithinPeriod }
|
EDIColumnMatch { InputColumn: IsUsableIfMatureWithinPeriod OutputColumn: IsUsableIfMatureWithinPeriod }
|
EDIColumnMatch { InputColumn: IsValidData OutputColumn: IsValidData }
|
EDIColumnMatch { InputColumn: LaneLeadTimeLogic OutputColumn: LaneLeadTimeLogic }
|
EDIColumnMatch { InputColumn: LotSizeTolerance OutputColumn: LotSizeTolerance }
|
EDIColumnMatch { InputColumn: MinToKeepTripInUsedPercentage OutputColumn: MinToKeepTripInUsedPercentage }
|
EDIColumnMatch { InputColumn: MinimumSalesDemandQtyThreshold OutputColumn: MinimumSalesDemandQtyThreshold }
|
EDIColumnMatch { InputColumn: NoiseThresholdOptimizerOutput OutputColumn: NoiseThresholdOptimizerOutput }
|
EDIColumnMatch { InputColumn: NumberOfDecimals OutputColumn: NumberOfDecimals }
|
EDIColumnMatch { InputColumn: NumberOfPeriodsInWindow OutputColumn: NumberOfPeriodsInWindow }
|
EDIColumnMatch { InputColumn: NumberOfPeriodsPerSlide OutputColumn: NumberOfPeriodsPerSlide }
|
EDIColumnMatch { InputColumn: NumberOfPeriodsSmartPlan OutputColumn: NumberOfPeriodsSmartPlan }
|
EDIColumnMatch { InputColumn: OperationLeadTimeLogic OutputColumn: OperationLeadTimeLogic }
|
EDIColumnMatch { InputColumn: OutlierTolerance OutputColumn: OutlierTolerance }
|
EDIColumnMatch { InputColumn: PeriodSpecificationForUnitActual OutputColumn: PeriodSpecificationForUnitActual }
|
EDIColumnMatch { InputColumn: PeriodTaskValidity OutputColumn: PeriodTaskValidity }
|
EDIColumnMatch { InputColumn: RunSmartPlanSynchronously OutputColumn: RunSmartPlanSynchronously }
|
EDIColumnMatch { InputColumn: SanityCheckDataMostSevere OutputColumn: SanityCheckDataMostSevere }
|
EDIColumnMatch { InputColumn: SanityCheckDataMostSevereCount OutputColumn: SanityCheckDataMostSevereCount }
|
EDIColumnMatch { InputColumn: SanityCheckDataTotalViolationCount OutputColumn: SanityCheckDataTotalViolationCount }
|
EDIColumnMatch { InputColumn: SanityCheckLimit OutputColumn: SanityCheckLimit }
|
EDIColumnMatch { InputColumn: StartOfKPIHorizon OutputColumn: StartOfKPIHorizon }
|
EDIColumnMatch { InputColumn: StartOfLotsizeHorizon OutputColumn: StartOfLotsizeHorizon }
|
EDIColumnMatch { InputColumn: StockingPointBottleneckThreshold OutputColumn: StockingPointBottleneckThreshold }
|
EDIColumnMatch { InputColumn: UnitLowerBottleneckThreshold OutputColumn: UnitLowerBottleneckThreshold }
|
EDIColumnMatch { InputColumn: UnitUpperBottleneckThreshold OutputColumn: UnitUpperBottleneckThreshold }
|
EDIColumnMatch { InputColumn: UpdateKPIHorizonAtPeriodRoll OutputColumn: UpdateKPIHorizonAtPeriodRoll }
|
EDIColumnMatch { InputColumn: UseAuditTrail OutputColumn: UseAuditTrail }
|
EDIColumnMatch { InputColumn: UseDefaultDisplayIndex OutputColumn: UseDefaultDisplayIndex }
|
EDIColumnMatch { InputColumn: UseSingleEchelon OutputColumn: UseSingleEchelon }
|
EDIColumnMatch { InputColumn: UseSlidingWindowsApproach OutputColumn: UseSlidingWindowsApproach }
|
}
|
EDITableTransformation
|
{
|
InputTable: Group
|
OutputTable: Groups
|
EDIColumnMatch { InputColumn: IconForStockingPoints OutputColumn: IconForStockingPoints }
|
EDIColumnMatch { InputColumn: IconForUnits OutputColumn: IconForUnits }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
}
|
EDITableTransformation
|
{
|
InputTable: Ingredient
|
OutputTable: Ingredients
|
EDIColumnMatch { InputColumn: Description OutputColumn: Description }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
}
|
EDITableTransformation
|
{
|
InputTable: InventorySpecification
|
OutputTable: InventorySpecifications
|
EDIColumnMatch { InputColumn: HasMaxLevel OutputColumn: HasMaxLevel }
|
EDIColumnMatch { InputColumn: HasMaxLevelInDays OutputColumn: HasMaxLevelInDays }
|
EDIColumnMatch { InputColumn: HasMinLevel OutputColumn: HasMinLevel }
|
EDIColumnMatch { InputColumn: HasMinLevelInDays OutputColumn: HasMinLevelInDays }
|
EDIColumnMatch { InputColumn: MaxLevelInDays OutputColumn: MaxLevelInDays }
|
EDIColumnMatch { InputColumn: MaxLevelInQuantity OutputColumn: MaxLevelInQuantity }
|
EDIColumnMatch { InputColumn: MinLevelInDays OutputColumn: MinLevelInDays }
|
EDIColumnMatch { InputColumn: MinLevelInQuantity OutputColumn: MinLevelInQuantity }
|
EDIColumnMatch { InputColumn: ProductID OutputColumn: ProductID }
|
EDIColumnMatch { InputColumn: Start OutputColumn: Start }
|
EDIColumnMatch { InputColumn: StockingPointID OutputColumn: StockingPointID }
|
}
|
EDITableTransformation
|
{
|
InputTable: InventorySupply
|
OutputTable: ExternalSupplies
|
EDIColumnMatch
|
{
|
InputColumn: Date
|
OutputColumn: Date
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<DateToDateTime xmlns="http://www.quintiq.com/GEB/DateToDateTime" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
</DateToDateTime>
|
*]
|
}
|
}
|
EDIColumnMatch { InputColumn: Description OutputColumn: Description }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch
|
{
|
InputColumn: ManufacturedDate
|
OutputColumn: ManufacturedDate
|
Converter
|
{
|
XMLDefinition:
|
[*
|
<?xml version="1.0" encoding="UTF-16"?>
|
<DateToDateTime xmlns="http://www.quintiq.com/GEB/DateToDateTime" Key="@1">
|
<IsStandard>true</IsStandard>
|
<IsISO>false</IsISO>
|
<IsCustom>false</IsCustom>
|
<ConversionType>0</ConversionType>
|
</DateToDateTime>
|
*]
|
}
|
}
|
EDIColumnMatch { InputColumn: ProductID OutputColumn: ProductID }
|
EDIColumnMatch { InputColumn: Quantity OutputColumn: Quantity }
|
EDIColumnMatch { InputColumn: StockingPointID OutputColumn: StockingPointID }
|
}
|
EDITableTransformation
|
{
|
InputTable: InventorySupplyCost
|
OutputTable: InventorySupplyCosts
|
EDIColumnMatch { InputColumn: AccountName OutputColumn: AccountName }
|
EDIColumnMatch { InputColumn: Cost OutputColumn: Cost }
|
EDIColumnMatch { InputColumn: CostDriver OutputColumn: CostDriver }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: InventorySupplyID OutputColumn: InventorySupplyID }
|
EDIColumnMatch { InputColumn: LengthOfTime OutputColumn: LengthOfTime }
|
EDIColumnMatch { InputColumn: Start OutputColumn: Start }
|
EDIColumnMatch { InputColumn: TimeUnit OutputColumn: TimeUnit }
|
}
|
EDITableTransformation
|
{
|
InputTable: InventoryValueAndCost
|
OutputTable: InventoryValueAndCosts
|
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: ProductID OutputColumn: ProductID }
|
EDIColumnMatch { InputColumn: Start OutputColumn: Start }
|
EDIColumnMatch { InputColumn: StockingPointID OutputColumn: StockingPointID }
|
EDIColumnMatch { InputColumn: TimeUnit OutputColumn: TimeUnit }
|
}
|
EDITableTransformation
|
{
|
InputTable: Lane
|
OutputTable: Lanes
|
EDIColumnMatch { InputColumn: End OutputColumn: End }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: IsEnabled OutputColumn: IsEnabled }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
EDIColumnMatch { InputColumn: StandardDeviationLeadTimeLane OutputColumn: StandardDeviationLeadTimeLane }
|
EDIColumnMatch { InputColumn: Start OutputColumn: Start }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
EDIColumnMatch { InputColumn: UserLeadTime OutputColumn: UserLeadTime }
|
}
|
EDITableTransformation
|
{
|
InputTable: LaneCost
|
OutputTable: LaneCosts
|
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 }
|
EDIColumnMatch { InputColumn: TimeUnit OutputColumn: TimeUnit }
|
}
|
EDITableTransformation
|
{
|
InputTable: LaneLeg
|
OutputTable: LaneLegs
|
EDIColumnMatch { InputColumn: CO2Emission OutputColumn: CO2Emission }
|
EDIColumnMatch { InputColumn: DestinationStockingPointID OutputColumn: DestinationStockingPointID }
|
EDIColumnMatch { InputColumn: End OutputColumn: End }
|
EDIColumnMatch { InputColumn: HasStandardDeviationLeadTimeLaneLeg OutputColumn: HasStandardDeviationLeadTimeLaneLeg }
|
EDIColumnMatch { InputColumn: HasUserLeadTime OutputColumn: HasUserLeadTime }
|
EDIColumnMatch { InputColumn: IsEnabled OutputColumn: IsEnabled }
|
EDIColumnMatch { InputColumn: LaneID OutputColumn: LaneID }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
EDIColumnMatch { InputColumn: OriginStockingPointID OutputColumn: OriginStockingPointID }
|
EDIColumnMatch { InputColumn: StandardDeviationLeadTimeLaneLeg OutputColumn: StandardDeviationLeadTimeLaneLeg }
|
EDIColumnMatch { InputColumn: Start OutputColumn: Start }
|
EDIColumnMatch { InputColumn: UserLeadTime OutputColumn: UserLeadTime }
|
}
|
EDITableTransformation
|
{
|
InputTable: LaneLegCost
|
OutputTable: LaneLegCosts
|
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 }
|
EDIColumnMatch { InputColumn: TimeUnit OutputColumn: TimeUnit }
|
}
|
EDITableTransformation
|
{
|
InputTable: Operation
|
OutputTable: Operations
|
EDIColumnMatch { InputColumn: CO2Emission OutputColumn: CO2Emission }
|
EDIColumnMatch { InputColumn: HasUserLotSize OutputColumn: HasUserLotSize }
|
EDIColumnMatch { InputColumn: HasUserMaximumQuantity OutputColumn: HasUserMaximumQuantity }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: IsEnabled OutputColumn: IsEnabled }
|
EDIColumnMatch { InputColumn: LotSize OutputColumn: LotSize }
|
EDIColumnMatch { InputColumn: MaximumQuantity OutputColumn: MaximumQuantity }
|
EDIColumnMatch { InputColumn: MinimumQuantity OutputColumn: MinimumQuantity }
|
EDIColumnMatch { InputColumn: RoutingID OutputColumn: RoutingID }
|
EDIColumnMatch { InputColumn: RoutingStepName OutputColumn: RoutingStepName }
|
EDIColumnMatch { InputColumn: StandardDeviationLeadTimeOperation OutputColumn: StandardDeviationLeadTimeOperation }
|
EDIColumnMatch { InputColumn: Throughput OutputColumn: Throughput }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
EDIColumnMatch { InputColumn: UserLeadTime OutputColumn: UserLeadTime }
|
}
|
EDITableTransformation
|
{
|
InputTable: OperationBOM
|
OutputTable: OperationBOMs
|
EDIColumnMatch { InputColumn: InputGroupID OutputColumn: InputGroupID }
|
EDIColumnMatch { InputColumn: IsExcluded OutputColumn: IsExcluded }
|
EDIColumnMatch { InputColumn: IsInput OutputColumn: IsInput }
|
EDIColumnMatch { InputColumn: MaxQuantityInGroupForExport OutputColumn: MaxQuantityInGroup }
|
EDIColumnMatch { InputColumn: MinQuantityInGroupForExport OutputColumn: MinQuantityInGroup }
|
EDIColumnMatch { InputColumn: OperationID OutputColumn: OperationID }
|
EDIColumnMatch { InputColumn: OperationInputSetName OutputColumn: OperationInputSetName }
|
EDIColumnMatch { InputColumn: ProductID OutputColumn: ProductID }
|
EDIColumnMatch { InputColumn: Quantity OutputColumn: Quantity }
|
EDIColumnMatch { InputColumn: StockingPointID OutputColumn: StockingPointID }
|
}
|
EDITableTransformation
|
{
|
InputTable: OperationCost
|
OutputTable: OperationCosts
|
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 }
|
EDIColumnMatch { InputColumn: TimeUnit OutputColumn: TimeUnit }
|
}
|
EDITableTransformation
|
{
|
InputTable: OperationInCampaignType
|
OutputTable: OperationInCampaignTypes
|
EDIColumnMatch { InputColumn: CampaignTypeName OutputColumn: CampaignTypeName }
|
EDIColumnMatch { InputColumn: OperationID OutputColumn: OperationID }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
}
|
EDITableTransformation
|
{
|
InputTable: OperationInTransitionType
|
OutputTable: OperationInTransitionTypes
|
EDIColumnMatch { InputColumn: OperationID OutputColumn: OperationID }
|
EDIColumnMatch { InputColumn: TransitionTypeName OutputColumn: TransitionTypeName }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
}
|
EDITableTransformation
|
{
|
InputTable: OperationInputGroup
|
OutputTable: OperationInputGroups
|
EDIColumnMatch { InputColumn: InputGroupID OutputColumn: InputGroupID }
|
EDIColumnMatch { InputColumn: InputGroupQuantity OutputColumn: InputGroupQuantity }
|
EDIColumnMatch { InputColumn: OperationID OutputColumn: OperationID }
|
}
|
EDITableTransformation
|
{
|
InputTable: OperationInputSet
|
OutputTable: OperationInputSets
|
EDIColumnMatch { InputColumn: MaxQuantity OutputColumn: MaxQuantity }
|
EDIColumnMatch { InputColumn: MinQuantity OutputColumn: MinQuantity }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
EDIColumnMatch { InputColumn: OperationID OutputColumn: OperationID }
|
}
|
EDITableTransformation
|
{
|
InputTable: OperationLink
|
OutputTable: OperationLinks
|
EDIColumnMatch { InputColumn: DestGroupID OutputColumn: DestGroupID }
|
EDIColumnMatch { InputColumn: DestGroupQuantity OutputColumn: DestGroupQuantity }
|
EDIColumnMatch { InputColumn: DestHasUserQuantity OutputColumn: DestHasUserQuantity }
|
EDIColumnMatch { InputColumn: DestMaxQuantityForExport OutputColumn: DestMaxQuantity }
|
EDIColumnMatch { InputColumn: DestMinQuantityForExport OutputColumn: DestMinQuantity }
|
EDIColumnMatch { InputColumn: DestOperationID OutputColumn: DestOperationID }
|
EDIColumnMatch { InputColumn: DestQuantityForExport OutputColumn: DestQuantity }
|
EDIColumnMatch { InputColumn: SourceGroupID OutputColumn: SourceGroupID }
|
EDIColumnMatch { InputColumn: SourceOperationID OutputColumn: SourceOperationID }
|
EDIColumnMatch { InputColumn: SourceQuantity OutputColumn: SourceQuantity }
|
}
|
EDITableTransformation
|
{
|
InputTable: PISPSpecification
|
OutputTable: PISPSpecifications
|
EDIColumnMatch { InputColumn: HasUnitOfMeasure OutputColumn: HasUnitOfMeasure }
|
EDIColumnMatch { InputColumn: InputLotSize OutputColumn: InputLotSize }
|
EDIColumnMatch { InputColumn: IsExcludeShelfLifeAndMaturation OutputColumn: IsExcludeShelfLifeAndMaturation }
|
EDIColumnMatch { InputColumn: IsExcluded OutputColumn: IsExcluded }
|
EDIColumnMatch { InputColumn: IsExcludedFromBalancing OutputColumn: IsExcludedFromBalancing }
|
EDIColumnMatch { InputColumn: IsNegativeInventoryAllowed OutputColumn: IsNegativeInventoryAllowed }
|
EDIColumnMatch { InputColumn: IsSafetyStockKept OutputColumn: IsSafetyStockKept }
|
EDIColumnMatch { InputColumn: ProductID OutputColumn: ProductID }
|
EDIColumnMatch { InputColumn: StockingPointID OutputColumn: StockingPointID }
|
EDIColumnMatch { InputColumn: UnitOfMeasureName OutputColumn: UnitOfMeasureName }
|
}
|
EDITableTransformation
|
{
|
InputTable: PeriodParameter_MP
|
OutputTable: PeriodParameters
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: StartOfPlanning OutputColumn: StartOfPlanning }
|
}
|
EDITableTransformation
|
{
|
InputTable: PeriodSpecification_MP
|
OutputTable: PeriodSpecifications
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: IsInHour OutputColumn: IsInHour }
|
EDIColumnMatch { InputColumn: IsUsedForPlanning OutputColumn: IsUsedForPlanning }
|
EDIColumnMatch { InputColumn: NrOfFuturePeriod OutputColumn: NrOfFuturePeriod }
|
EDIColumnMatch { InputColumn: NrOfHistoricalPeriod OutputColumn: NrOfHistoricalPeriod }
|
EDIColumnMatch { InputColumn: NrOfTimeUnit OutputColumn: NrOfTimeUnit }
|
EDIColumnMatch { InputColumn: PeriodAlignment OutputColumn: PeriodAlignment }
|
EDIColumnMatch { InputColumn: TimeUnit OutputColumn: TimeUnit }
|
}
|
EDITableTransformation
|
{
|
InputTable: PostponedSalesDemandCost
|
OutputTable: PostponedSalesDemandCosts
|
EDIColumnMatch { InputColumn: Penalty OutputColumn: Penalty }
|
EDIColumnMatch { InputColumn: ProductID OutputColumn: ProductID }
|
EDIColumnMatch { InputColumn: Start OutputColumn: Start }
|
EDIColumnMatch { InputColumn: StockingPointID OutputColumn: StockingPointID }
|
}
|
EDITableTransformation
|
{
|
InputTable: PostponementSpecification
|
OutputTable: PostponementSpecifications
|
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 }
|
}
|
EDITableTransformation
|
{
|
InputTable: Priority
|
OutputTable: Priorities
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
EDIColumnMatch { InputColumn: Weight OutputColumn: Weight }
|
}
|
EDITableTransformation
|
{
|
InputTable: ProductInLane
|
OutputTable: ProductInLanes
|
EDIColumnMatch { InputColumn: IsExcluded OutputColumn: IsExcluded }
|
EDIColumnMatch { InputColumn: LaneID OutputColumn: LaneID }
|
EDIColumnMatch { InputColumn: ProductID OutputColumn: ProductID }
|
}
|
EDITableTransformation
|
{
|
InputTable: ProductLevel_MP
|
OutputTable: ProductLevels
|
EDIColumnMatch { InputColumn: IsProductCategory OutputColumn: IsProductCategory }
|
EDIColumnMatch { InputColumn: Level OutputColumn: Level }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
}
|
EDITableTransformation
|
{
|
InputTable: ProductValueAndCost
|
OutputTable: ProductValueAndCosts
|
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 }
|
}
|
EDITableTransformation
|
{
|
InputTable: Product_MP
|
OutputTable: Products
|
EDIColumnMatch { InputColumn: DisplayIndex OutputColumn: DisplayIndex }
|
EDIColumnMatch { InputColumn: HasMaturation OutputColumn: HasMaturation }
|
EDIColumnMatch { InputColumn: HasShelfLife OutputColumn: HasShelfLife }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: IconName OutputColumn: IconName }
|
EDIColumnMatch { InputColumn: IsByProduct OutputColumn: IsByProduct }
|
EDIColumnMatch { InputColumn: IsExcludedFromFulfillmentKPI OutputColumn: IsExcludedFromFulfillmentKPI }
|
EDIColumnMatch { InputColumn: IsExcludedFromOptimization OutputColumn: IsExcludedFromOptimization }
|
EDIColumnMatch { InputColumn: IsPlannedAfterOptimization OutputColumn: IsPlannedAfterOptimization }
|
EDIColumnMatch { InputColumn: MaturationDays OutputColumn: MaturationDays }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
EDIColumnMatch { InputColumn: Notes OutputColumn: Notes }
|
EDIColumnMatch { InputColumn: ParentID OutputColumn: ParentID }
|
EDIColumnMatch { InputColumn: ShelfLife OutputColumn: ShelfLife }
|
EDIColumnMatch { InputColumn: UnitOfMeasureName OutputColumn: UnitOfMeasureName }
|
}
|
EDITableTransformation
|
{
|
InputTable: Recipe
|
OutputTable: Recipes
|
EDIColumnMatch { InputColumn: Description OutputColumn: Description }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
}
|
EDITableTransformation
|
{
|
InputTable: RecipeIngredient
|
OutputTable: RecipeIngredients
|
EDIColumnMatch { InputColumn: IngredientName OutputColumn: IngredientName }
|
EDIColumnMatch { InputColumn: Maximum OutputColumn: Maximum }
|
EDIColumnMatch { InputColumn: Minimum OutputColumn: Minimum }
|
EDIColumnMatch { InputColumn: Nominal OutputColumn: Nominal }
|
EDIColumnMatch { InputColumn: RecipeName OutputColumn: RecipeName }
|
}
|
EDITableTransformation
|
{
|
InputTable: RecipeWithEffectiveDate
|
OutputTable: RecipeWithEffectiveDate
|
EDIColumnMatch { InputColumn: EffectiveDate OutputColumn: EffectiveDate }
|
EDIColumnMatch { InputColumn: ProductID OutputColumn: ProductID }
|
EDIColumnMatch { InputColumn: RecipeName OutputColumn: RecipeName }
|
}
|
EDITableTransformation
|
{
|
InputTable: Routing
|
OutputTable: Routings
|
EDIColumnMatch { InputColumn: AllowWIPInventory OutputColumn: AllowWIPInventory }
|
EDIColumnMatch { InputColumn: End OutputColumn: End }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: IsEnabled OutputColumn: IsEnabled }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
EDIColumnMatch { InputColumn: Start OutputColumn: Start }
|
}
|
EDITableTransformation
|
{
|
InputTable: RoutingConfiguratorView
|
OutputTable: RoutingConfiguratorViews
|
EDIColumnMatch { InputColumn: EdgeThickness OutputColumn: EdgeThickness }
|
EDIColumnMatch { InputColumn: FontName OutputColumn: FontName }
|
EDIColumnMatch { InputColumn: FontSize OutputColumn: FontSize }
|
EDIColumnMatch { InputColumn: GridHeight OutputColumn: GridHeight }
|
EDIColumnMatch { InputColumn: GridPointDistance OutputColumn: GridPointDistance }
|
EDIColumnMatch { InputColumn: GridWidth OutputColumn: GridWidth }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: IsCompactMode OutputColumn: IsCompactMode }
|
EDIColumnMatch { InputColumn: IsGridVisible OutputColumn: IsGridVisible }
|
EDIColumnMatch { InputColumn: OffsetX OutputColumn: OffsetX }
|
EDIColumnMatch { InputColumn: OffsetY OutputColumn: OffsetY }
|
EDIColumnMatch { InputColumn: OperationHeight OutputColumn: OperationHeight }
|
EDIColumnMatch { InputColumn: OperationInputOutputWidth OutputColumn: OperationInputOutputWidth }
|
EDIColumnMatch { InputColumn: OperationOffsetX OutputColumn: OperationOffsetX }
|
EDIColumnMatch { InputColumn: OperationOffsetY OutputColumn: OperationOffsetY }
|
EDIColumnMatch { InputColumn: OperationWidth OutputColumn: OperationWidth }
|
EDIColumnMatch { InputColumn: PISPHeight OutputColumn: PISPHeight }
|
EDIColumnMatch { InputColumn: PISPWidth OutputColumn: PISPWidth }
|
EDIColumnMatch { InputColumn: Padding OutputColumn: Padding }
|
EDIColumnMatch { InputColumn: RoutingStepDistance OutputColumn: RoutingStepDistance }
|
EDIColumnMatch { InputColumn: RoutingStepMinimumHeight OutputColumn: RoutingStepMinimumHeight }
|
EDIColumnMatch { InputColumn: RoutingStepMinimumWidth OutputColumn: RoutingStepMinimumWidth }
|
EDIColumnMatch { InputColumn: User OutputColumn: User }
|
EDIColumnMatch { InputColumn: UserOperationInputOutputHeight OutputColumn: UserOperationInputOutputHeight }
|
}
|
EDITableTransformation
|
{
|
InputTable: RoutingStep
|
OutputTable: RoutingSteps
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
EDIColumnMatch { InputColumn: RoutingID OutputColumn: RoutingID }
|
EDIColumnMatch { InputColumn: SequenceNumber OutputColumn: SequenceNumber }
|
EDIColumnMatch { InputColumn: Tool OutputColumn: Tool }
|
}
|
EDITableTransformation
|
{
|
InputTable: SafetyStock
|
OutputTable: SafetyStocks
|
EDIColumnMatch { InputColumn: HasTargetInDays OutputColumn: HasTargetInDays }
|
EDIColumnMatch { InputColumn: ProductID OutputColumn: ProductID }
|
EDIColumnMatch { InputColumn: Start OutputColumn: Start }
|
EDIColumnMatch { InputColumn: StockingPointID OutputColumn: StockingPointID }
|
EDIColumnMatch { InputColumn: TargetInDays OutputColumn: TargetInDays }
|
EDIColumnMatch { InputColumn: TargetInQuantity OutputColumn: TargetInQuantity }
|
}
|
EDITableTransformation
|
{
|
InputTable: SalesLevel_MP
|
OutputTable: SalesLevels
|
EDIColumnMatch { InputColumn: Level OutputColumn: Level }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
}
|
EDITableTransformation
|
{
|
InputTable: SalesSegment_MP
|
OutputTable: SalesSegments
|
EDIColumnMatch { InputColumn: DisplayIndex OutputColumn: DisplayIndex }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
EDIColumnMatch { InputColumn: ParentName OutputColumn: ParentName }
|
}
|
EDITableTransformation
|
{
|
InputTable: ServiceLevel
|
OutputTable: ServiceLevels
|
EDIColumnMatch { InputColumn: End OutputColumn: End }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: IsEnabled OutputColumn: IsEnabled }
|
EDIColumnMatch { InputColumn: IsUsedForPlanningFulfillment OutputColumn: IsUsedForPlanningFulfillment }
|
EDIColumnMatch { InputColumn: IsUsedForSafetyStockCalculation OutputColumn: IsUsedForSafetyStockCalculation }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
EDIColumnMatch { InputColumn: ProductID OutputColumn: ProductID }
|
EDIColumnMatch { InputColumn: SalesSegmentName OutputColumn: SalesSegmentName }
|
EDIColumnMatch { InputColumn: Start OutputColumn: Start }
|
EDIColumnMatch { InputColumn: StockingPointID OutputColumn: StockingPointID }
|
EDIColumnMatch { InputColumn: TargetPercentage OutputColumn: TargetPercentage }
|
}
|
EDITableTransformation
|
{
|
InputTable: ShiftDay
|
OutputTable: ShiftDays
|
EDIColumnMatch { InputColumn: Capacity OutputColumn: Capacity }
|
EDIColumnMatch { InputColumn: Day OutputColumn: Day }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: ShiftPatternName OutputColumn: ShiftPatternName }
|
}
|
EDITableTransformation
|
{
|
InputTable: ShiftPattern
|
OutputTable: ShiftPatterns
|
EDIColumnMatch { InputColumn: MinimumDuration OutputColumn: MinimumDuration }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
}
|
EDITableTransformation
|
{
|
InputTable: StockingPointCapacity
|
OutputTable: StockingPointCapacities
|
EDIColumnMatch { InputColumn: MaxCapacity OutputColumn: MaxCapacity }
|
EDIColumnMatch { InputColumn: Start OutputColumn: Start }
|
EDIColumnMatch { InputColumn: StockingPointID OutputColumn: StockingPointID }
|
}
|
EDITableTransformation
|
{
|
InputTable: StockingPointCost
|
OutputTable: StockingPointCosts
|
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 }
|
EDIColumnMatch { InputColumn: StockingPointID OutputColumn: StockingPointID }
|
EDIColumnMatch { InputColumn: TimeUnit OutputColumn: TimeUnit }
|
}
|
EDITableTransformation
|
{
|
InputTable: StockingPoint_MP
|
OutputTable: StockingPoints
|
EDIColumnMatch { InputColumn: CurrencyID OutputColumn: CurrencyID }
|
EDIColumnMatch { InputColumn: DisplayIndex OutputColumn: DisplayIndex }
|
EDIColumnMatch { InputColumn: End OutputColumn: End }
|
EDIColumnMatch { InputColumn: GISCity OutputColumn: GISCity }
|
EDIColumnMatch { InputColumn: GISCountryCode OutputColumn: GISCountryCode }
|
EDIColumnMatch { InputColumn: GISPostalCode OutputColumn: GISPostalCode }
|
EDIColumnMatch { InputColumn: GroupName OutputColumn: GroupName }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: IconName OutputColumn: IconName }
|
EDIColumnMatch { InputColumn: IsPlannedInfinite OutputColumn: IsPlannedInfinite }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
EDIColumnMatch { InputColumn: Notes OutputColumn: Notes }
|
EDIColumnMatch { InputColumn: Start OutputColumn: Start }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
EDIColumnMatch { InputColumn: UnitOfMeasureName OutputColumn: UnitOfMeasureName }
|
}
|
EDITableTransformation
|
{
|
InputTable: SupplySpecification
|
OutputTable: SupplySpecifications
|
EDIColumnMatch { InputColumn: End OutputColumn: End }
|
EDIColumnMatch { InputColumn: HasMaxQuantity OutputColumn: HasMaxQuantity }
|
EDIColumnMatch { InputColumn: MaxQuantity OutputColumn: MaxQuantity }
|
EDIColumnMatch { InputColumn: MinQuantity OutputColumn: MinQuantity }
|
EDIColumnMatch { InputColumn: ProductID OutputColumn: ProductID }
|
EDIColumnMatch { InputColumn: Start OutputColumn: Start }
|
EDIColumnMatch { InputColumn: TargetQuantity OutputColumn: TargetQuantity }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
}
|
EDITableTransformation
|
{
|
InputTable: TransitionType_MP
|
OutputTable: TransitionTypes
|
EDIColumnMatch { InputColumn: DefaultMaxDuration OutputColumn: DefaultMaxDuration }
|
EDIColumnMatch { InputColumn: DefaultMaxQuantity OutputColumn: DefaultMaxQuantity }
|
EDIColumnMatch { InputColumn: DefaultMinDuration OutputColumn: DefaultMinDuration }
|
EDIColumnMatch { InputColumn: DefaultMinQuantity OutputColumn: DefaultMinQuantity }
|
EDIColumnMatch { InputColumn: FromCampaignTypeName OutputColumn: FromCampaignTypeName }
|
EDIColumnMatch { InputColumn: HasInputMaxDuration OutputColumn: HasInputMaxDuration }
|
EDIColumnMatch { InputColumn: HasInputMaxQuantity OutputColumn: HasInputMaxQuantity }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
EDIColumnMatch { InputColumn: ToCampaignTypeName OutputColumn: ToCampaignTypeName }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
}
|
EDITableTransformation
|
{
|
InputTable: TransportAvailability
|
OutputTable: TransportAvailability
|
EDIColumnMatch { InputColumn: LotSize OutputColumn: LotSize }
|
EDIColumnMatch { InputColumn: Maintenance OutputColumn: Maintenance }
|
EDIColumnMatch { InputColumn: MaximumQuantity OutputColumn: MaximumQuantity }
|
EDIColumnMatch { InputColumn: NumberOfUnit OutputColumn: NumberOfUnit }
|
EDIColumnMatch { InputColumn: ShiftPatternName OutputColumn: ShiftPatternName }
|
EDIColumnMatch { InputColumn: Start OutputColumn: Start }
|
EDIColumnMatch { InputColumn: TimeUnit OutputColumn: TimeUnit }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
}
|
EDITableTransformation
|
{
|
InputTable: TransportCapacity
|
OutputTable: TransportCapacities
|
EDIColumnMatch { InputColumn: HasSecondaryCapacity OutputColumn: HasSecondaryCapacity }
|
EDIColumnMatch { InputColumn: LotSize OutputColumn: LotSize }
|
EDIColumnMatch { InputColumn: MaximumCapacity OutputColumn: MaximumCapacity }
|
EDIColumnMatch { InputColumn: MinimumCapacity OutputColumn: MinimumCapacity }
|
EDIColumnMatch { InputColumn: SecondaryLotSize OutputColumn: SecondaryLotSize }
|
EDIColumnMatch { InputColumn: SecondaryMaximumCapacity OutputColumn: SecondaryMaximumCapacity }
|
EDIColumnMatch { InputColumn: SecondaryMinimumCapacity OutputColumn: SecondaryMinimumCapacity }
|
EDIColumnMatch { InputColumn: SecondaryUnitOfMeasureName OutputColumn: SecondaryUnitOfMeasureName }
|
EDIColumnMatch { InputColumn: Start OutputColumn: Start }
|
EDIColumnMatch { InputColumn: TimeUnit OutputColumn: TimeUnit }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
}
|
EDITableTransformation
|
{
|
InputTable: Unit
|
OutputTable: Units
|
EDIColumnMatch { InputColumn: CampaignTypeDuration OutputColumn: CampaignTypeDuration }
|
EDIColumnMatch { InputColumn: CapacitySmoothingPercentageDelta OutputColumn: CapacitySmoothingPercentageDelta }
|
EDIColumnMatch { InputColumn: CapacityType OutputColumn: CapacityType }
|
EDIColumnMatch { InputColumn: CurrencyID OutputColumn: CurrencyID }
|
EDIColumnMatch { InputColumn: DisplayIndex OutputColumn: DisplayIndex }
|
EDIColumnMatch { InputColumn: EndDate OutputColumn: EndDate }
|
EDIColumnMatch { InputColumn: GISCity OutputColumn: GISCity }
|
EDIColumnMatch { InputColumn: GISCountryCode OutputColumn: GISCountryCode }
|
EDIColumnMatch { InputColumn: GISPostalCode OutputColumn: GISPostalCode }
|
EDIColumnMatch { InputColumn: GroupName OutputColumn: GroupName }
|
EDIColumnMatch { InputColumn: HasCapacitySmoothing OutputColumn: HasCapacitySmoothing }
|
EDIColumnMatch { InputColumn: HasMaximumQuantity OutputColumn: HasMaximumQuantity }
|
EDIColumnMatch { InputColumn: HasUserFrozenFutureDuration OutputColumn: HasUserFrozenFutureDuration }
|
EDIColumnMatch { InputColumn: ID OutputColumn: ID }
|
EDIColumnMatch { InputColumn: IconName OutputColumn: IconName }
|
EDIColumnMatch { InputColumn: IsIncludedInSupplySpecification OutputColumn: IsIncludedInSupplySpecification }
|
EDIColumnMatch { InputColumn: IsOverlapCapacitySmoothing OutputColumn: IsOverlapCapacitySmoothing }
|
EDIColumnMatch { InputColumn: IsPlannedInfinite OutputColumn: IsPlannedInfinite }
|
EDIColumnMatch { InputColumn: IsSmoothCapacityOverAllPeriods OutputColumn: IsSmoothCapacityOverAllPeriods }
|
EDIColumnMatch { InputColumn: IsSupplier OutputColumn: IsSupplier }
|
EDIColumnMatch { InputColumn: LotSize OutputColumn: LotSize }
|
EDIColumnMatch { InputColumn: MaximumQuantity OutputColumn: MaximumQuantity }
|
EDIColumnMatch { InputColumn: MinimumQuantity OutputColumn: MinimumQuantity }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
EDIColumnMatch { InputColumn: Notes OutputColumn: Notes }
|
EDIColumnMatch { InputColumn: ParentUnitID OutputColumn: ParentUnitID }
|
EDIColumnMatch { InputColumn: QuantityToProcess OutputColumn: QuantityToProcess }
|
EDIColumnMatch { InputColumn: StartDate OutputColumn: StartDate }
|
EDIColumnMatch { InputColumn: UnitOfMeasureName OutputColumn: UnitOfMeasureName }
|
EDIColumnMatch { InputColumn: UseShiftOptimization OutputColumn: UseShiftOptimization }
|
EDIColumnMatch { InputColumn: UserCapacitySmoothingLength OutputColumn: UserCapacitySmoothingLength }
|
EDIColumnMatch { InputColumn: UserFrozenFutureDuration OutputColumn: UserFrozenFutureDuration }
|
}
|
EDITableTransformation
|
{
|
InputTable: UnitAvailability
|
OutputTable: UnitAvailabilities
|
EDIColumnMatch { InputColumn: Allocation OutputColumn: Allocation }
|
EDIColumnMatch { InputColumn: Efficiency OutputColumn: Efficiency }
|
EDIColumnMatch { InputColumn: Maintenance OutputColumn: Maintenance }
|
EDIColumnMatch { InputColumn: MaximumLoadPercentage OutputColumn: MaximumLoadPercentage }
|
EDIColumnMatch { InputColumn: MinimumLoadThreshold OutputColumn: MinimumLoadThreshold }
|
EDIColumnMatch { InputColumn: NrOfUnitsOpen OutputColumn: NrOfUnitsOpen }
|
EDIColumnMatch { InputColumn: ShiftPatternName OutputColumn: ShiftPatternName }
|
EDIColumnMatch { InputColumn: Start OutputColumn: Start }
|
EDIColumnMatch { InputColumn: TimeUnit OutputColumn: TimeUnit }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
}
|
EDITableTransformation
|
{
|
InputTable: UnitCalendarElement
|
OutputTable: UnitCalendarElements
|
EDIColumnMatch { InputColumn: Capacity OutputColumn: Capacity }
|
EDIColumnMatch { InputColumn: Description OutputColumn: Description }
|
EDIColumnMatch { InputColumn: End OutputColumn: End }
|
EDIColumnMatch { InputColumn: Start OutputColumn: Start }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
}
|
EDITableTransformation
|
{
|
InputTable: UnitCapacity
|
OutputTable: UnitCapacities
|
EDIColumnMatch { InputColumn: MaxCapacity OutputColumn: MaxCapacity }
|
EDIColumnMatch { InputColumn: MaximumLoadPercentage OutputColumn: MaximumLoadPercentage }
|
EDIColumnMatch { InputColumn: MinCapacity OutputColumn: MinCapacity }
|
EDIColumnMatch { InputColumn: NrOfUnitsOpen OutputColumn: NrOfUnitsOpen }
|
EDIColumnMatch { InputColumn: Start OutputColumn: Start }
|
EDIColumnMatch { InputColumn: TimeUnit OutputColumn: TimeUnit }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
}
|
EDITableTransformation
|
{
|
InputTable: UnitCost
|
OutputTable: UnitCosts
|
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 }
|
EDIColumnMatch { InputColumn: TimeUnit OutputColumn: TimeUnit }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
}
|
EDITableTransformation
|
{
|
InputTable: UnitOfMeasure_MP
|
OutputTable: UnitOfMeasures
|
EDIColumnMatch { InputColumn: IsDefault OutputColumn: IsDefault }
|
EDIColumnMatch { InputColumn: Name OutputColumn: Name }
|
}
|
EDITableTransformation
|
{
|
InputTable: UnitShiftPattern
|
OutputTable: UnitShiftPatterns
|
EDIColumnMatch { InputColumn: IsAllowed OutputColumn: IsAllowed }
|
EDIColumnMatch { InputColumn: ShiftPatternName OutputColumn: ShiftPatternName }
|
EDIColumnMatch { InputColumn: UnitID OutputColumn: UnitID }
|
}
|
}
|
}
|
