Quintiq file version 2.0
|
#parent: #root
|
EDIBroker SRMHeaderOutputToDB
|
{
|
MDSDefinition: MacroPlan
|
TimeZone: 'ACT'
|
UseOSTimeZone: false
|
EDIModelLink.Source Source
|
{
|
EDIMLTable Product_MP
|
{
|
PrimaryKeyColumns: ID
|
TargetType: Product_MP
|
TypeIndex: ProductTypeIndex
|
EDIMLColumn CanBeExported { Attribute: CanBeExported ValueType: Boolean }
|
EDIMLColumn DisplayIndex { Attribute: DisplayIndex ValueType: Number }
|
EDIMLColumn DisplayIndexForExcel { Attribute: DisplayIndexForExcel ValueType: Number }
|
EDIMLColumn ExpiredInPeriodShelfLifeSupplyQuantityInDefaultUOM { Attribute: ExpiredInPeriodShelfLifeSupplyQuantityInDefaultUOM ValueType: Real }
|
EDIMLColumn HasConversionFactor { Attribute: HasConversionFactor ValueType: Boolean }
|
EDIMLColumn HasMaturation { Attribute: HasMaturation ValueType: Boolean }
|
EDIMLColumn HasParent { Attribute: HasParent ValueType: Boolean }
|
EDIMLColumn HasPlanning { Attribute: HasPlanning ValueType: Boolean }
|
EDIMLColumn HasRecipe { Attribute: HasRecipe ValueType: Boolean }
|
EDIMLColumn HasShelfLife { Attribute: HasShelfLife ValueType: Boolean }
|
EDIMLColumn HasShelfLifeOrMaturation { Attribute: HasShelfLifeOrMaturation ValueType: Boolean }
|
EDIMLColumn HasValidProductLevel { Attribute: HasValidProductLevel ValueType: Boolean }
|
EDIMLColumn ID { Attribute: ID ValueType: String }
|
EDIMLColumn IconName { Attribute: IconName ValueType: String }
|
EDIMLColumn IndentationSymbol { Attribute: IndentationSymbol ValueType: String }
|
EDIMLColumn IsByProduct { Attribute: IsByProduct ValueType: Boolean }
|
EDIMLColumn IsDerivedByProduct { Attribute: IsDerivedByProduct ValueType: Boolean }
|
EDIMLColumn IsDerivedExcludeFromFulfillmentKPI { Attribute: IsDerivedExcludeFromFulfillmentKPI ValueType: Boolean }
|
EDIMLColumn IsExcludedFromFulfillmentKPI { Attribute: IsExcludedFromFulfillmentKPI ValueType: Boolean }
|
EDIMLColumn IsExcludedFromOptimization { Attribute: IsExcludedFromOptimization ValueType: Boolean }
|
EDIMLColumn IsImbalance { Attribute: IsImbalance ValueType: Boolean }
|
EDIMLColumn IsInOptimizerPuzzle { Attribute: IsInOptimizerPuzzle ValueType: Boolean }
|
EDIMLColumn IsInRectangleMetaOptimizer { Attribute: IsInRectangleMetaOptimizer ValueType: Boolean }
|
EDIMLColumn IsIncludedInBalancing { Attribute: IsIncludedInBalancing ValueType: Boolean }
|
EDIMLColumn IsLeaf { Attribute: IsLeaf ValueType: Boolean }
|
EDIMLColumn IsManuallyConfigured { Attribute: IsManuallyConfigured ValueType: Boolean }
|
EDIMLColumn IsPlannedAfterOptimization { Attribute: IsPlannedAfterOptimization ValueType: Boolean }
|
EDIMLColumn IsProductCategory { Attribute: IsProductCategory ValueType: Boolean }
|
EDIMLColumn IsRegularProductForOptimizer { Attribute: IsRegularProductForOptimizer ValueType: Boolean }
|
EDIMLColumn IsSoftDeleted { Attribute: IsSoftDeleted ValueType: Boolean }
|
EDIMLColumn IsSystem { Attribute: IsSystem ValueType: Boolean }
|
EDIMLColumn IsUsed { Attribute: IsUsed ValueType: Boolean }
|
EDIMLColumn IsUsedInProcess { Attribute: IsUsedInProcess ValueType: Boolean }
|
EDIMLColumn IsValidData { Attribute: IsValidData ValueType: Boolean }
|
EDIMLColumn KPIBalanceViolationMeta { Attribute: KPIBalanceViolationMeta ValueType: Real }
|
EDIMLColumn KPIMaximumInventory { Attribute: KPIMaximumInventory ValueType: Real }
|
EDIMLColumn KPIMinimumInventory { Attribute: KPIMinimumInventory ValueType: Real }
|
EDIMLColumn KPITargetInventory { Attribute: KPITargetInventory ValueType: Real }
|
EDIMLColumn Level { Attribute: Level ValueType: Number }
|
EDIMLColumn MaturationDays { Attribute: MaturationDays ValueType: Real }
|
EDIMLColumn MaxSalesDemandQuantity { Attribute: MaxSalesDemandQuantity ValueType: Real }
|
EDIMLColumn MinSalesDemandQuantity { Attribute: MinSalesDemandQuantity ValueType: Real }
|
EDIMLColumn Name { Attribute: Name ValueType: String }
|
EDIMLColumn Notes { Attribute: Notes ValueType: String }
|
EDIMLColumn NumberOfProductInStockingPoint { Attribute: NumberOfProductInStockingPoint ValueType: Number }
|
EDIMLColumn NumberOfShelfLifeViolations { Attribute: NumberOfShelfLifeViolations ValueType: Number }
|
EDIMLColumn ParentID { Attribute: ParentID ValueType: String }
|
EDIMLColumn PriorityMetaOptimizerSelector { Attribute: PriorityMetaOptimizerSelector ValueType: Real }
|
EDIMLColumn SanityCheckDataMostSevere { Attribute: SanityCheckDataMostSevere ValueType: String }
|
EDIMLColumn SanityCheckDataMostSevereCount { Attribute: SanityCheckDataMostSevereCount ValueType: Number }
|
EDIMLColumn SanityCheckDataTotalViolationCount { Attribute: SanityCheckDataTotalViolationCount ValueType: Number }
|
EDIMLColumn ShelfLife { Attribute: ShelfLife ValueType: Real }
|
EDIMLColumn TotalInventoryLevels { Attribute: TotalInventoryLevels ValueType: Real }
|
EDIMLColumn TotalInventorySupply { Attribute: TotalInventorySupply ValueType: Real }
|
EDIMLColumn TotalSalesDemand { Attribute: TotalSalesDemand ValueType: Real }
|
EDIMLColumn UnitOfMeasureName { Attribute: UnitOfMeasureName ValueType: String }
|
}
|
}
|
EDIODBCLink.Destination Destination1
|
{
|
DataIntegrityStrategy: 'Disabled'
|
SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.oracle'
|
EDIODBCLinkTable MID_SRMHEADERRESULT
|
{
|
MayCreateTable: true
|
MayDeleteRow: true
|
MayDropTable: true
|
MayFlushTable: true
|
MayInsertRow: true
|
Parameters: '/owner="TIANMA"'
|
RecordModificationHintStrategy: 'None'
|
EDIODBCLinkColumn ATTRIBUTE_1
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ATTRIBUTE_10
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ATTRIBUTE_11
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ATTRIBUTE_12
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ATTRIBUTE_13
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ATTRIBUTE_14
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ATTRIBUTE_15
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ATTRIBUTE_2
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ATTRIBUTE_3
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ATTRIBUTE_4
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ATTRIBUTE_5
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ATTRIBUTE_6
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ATTRIBUTE_7
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ATTRIBUTE_8
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ATTRIBUTE_9
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ATTRIBUTE_CATEGORY
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn BUSINESS_TYPE
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn CREATED_BY
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn CREATION_DATE
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DATA_TYPE
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_1
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_10
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_11
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_12
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_13
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_14
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_15
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_16
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_17
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_18
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_19
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_2
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_20
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_21
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_22
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_23
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_24
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_25
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_26
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_27
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_28
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_29
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_3
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_30
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_31
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_32
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_33
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_34
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_35
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_36
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_37
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_38
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_39
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_4
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_40
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_41
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_42
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_43
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_44
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_45
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_46
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_47
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_48
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_49
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_5
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_50
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_51
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_52
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_53
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_54
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_55
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_56
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_57
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_58
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_59
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_6
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_60
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_61
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_62
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_63
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_64
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_65
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_66
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_67
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_68
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_69
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_7
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_70
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_71
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_72
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_73
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_74
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_75
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_76
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_77
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_78
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_79
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_8
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_80
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_81
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_82
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_83
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_84
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_85
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_86
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_87
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_88
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_89
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_9
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn DAY_90
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn EXTEND_1
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn EXTEND_10
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn EXTEND_2
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn EXTEND_3
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn EXTEND_4
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn EXTEND_5
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn EXTEND_6
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn EXTEND_7
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn EXTEND_8
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn EXTEND_9
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn IMPORT_DATE
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn LAST_UPDATED_BY
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn LAST_UPDATE_DATE
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn LAST_UPDATE_LOGIN
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ORGANIZATION_CODE
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn ORGANIZATION_ID
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn SCHEDULE_DATE_ID
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
EDIODBCLinkColumn VER_NO
|
{
|
MayUpdateColumn: true
|
ValueType: String
|
}
|
}
|
}
|
EDITransformation.Transformation Transformation0
|
{
|
EDITableTransformation
|
{
|
InputTable: Product_MP
|
OutputTable: MID_SRMHEADERRESULT
|
}
|
}
|
}
|
