From fa4de0163affd02dd0731ccad53244b357796678 Mon Sep 17 00:00:00 2001 From: yanweiyuan3 <yanweiyuan3@gmail.com> Date: 星期三, 09 八月 2023 18:06:33 +0800 Subject: [PATCH] Add output data broker --- _Main/metadata.properties | 2 _Main/BL/EDI/Broker_SRMHeaderOutputToDB.qbl | 736 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 2 files changed, 737 insertions(+), 1 deletions(-) diff --git a/_Main/BL/EDI/Broker_SRMHeaderOutputToDB.qbl b/_Main/BL/EDI/Broker_SRMHeaderOutputToDB.qbl new file mode 100644 index 0000000..3040f87 --- /dev/null +++ b/_Main/BL/EDI/Broker_SRMHeaderOutputToDB.qbl @@ -0,0 +1,736 @@ +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 + } + } +} diff --git a/_Main/metadata.properties b/_Main/metadata.properties index 4030ae4..907c0c2 100644 --- a/_Main/metadata.properties +++ b/_Main/metadata.properties @@ -1,6 +1,6 @@ component=submodel kind=Quintiq Metadata File name=MacroPlanner -version.component=2022.3.0.345 +version.component=2022.3.0.346 version.fileformat=2 version.quintiq=6.3.3.0 , build 248673 -- Gitblit v1.9.3