From 2ebe2029a22cb2901325b83ed075ed0a44237d5e Mon Sep 17 00:00:00 2001
From: hongjli <3117313295@qq.com>
Date: 星期三, 20 九月 2023 10:35:30 +0800
Subject: [PATCH] 全局数据优化

---
 /dev/null                                                                                                   |   57 ----------------------------
 _Main/BL/Type_GlobalDTOTable/StaticMethod_SynchronizationAllMappingBrokerAndAPI.qbl                         |   18 ++++----
 _Main/BL/Type_Global_MappingActualProductInStockingPointInPeriod/TypeIndex_MappingActualPISPIPTypeIndex.qbl |    2 
 3 files changed, 10 insertions(+), 67 deletions(-)

diff --git a/_Main/BL/EDI/Broker_GlobalOTDTable_AIPISPIP.qbl b/_Main/BL/EDI/Broker_GlobalOTDTable_AIPISPIP.qbl
deleted file mode 100644
index 94044c4..0000000
--- a/_Main/BL/EDI/Broker_GlobalOTDTable_AIPISPIP.qbl
+++ /dev/null
@@ -1,156 +0,0 @@
-Quintiq file version 2.0
-#parent: #root
-EDIBroker GlobalOTDTable_AIPISPIP
-{
-  MDSDefinition: GlobalOTDTable
-  TimeZone: 'ACT'
-  UseOSTimeZone: false
-  EDIModelLink.Destination Destination8
-  {
-    EDIMLTable Global_MappingActualProductInStockingPointInPeriod
-    {
-      PrimaryKeyColumns: Date
-      PrimaryKeyColumns: ProductID
-      PrimaryKeyColumns: StockingPointID
-      TargetType: Global_MappingActualProductInStockingPointInPeriod
-      TypeIndex: TypeIndex
-      EDIMLColumn ActualInventoryLevelEnd { Attribute: ActualInventoryLevelEnd ValueType: Real }
-      EDIMLColumn Date { Attribute: Date ValueType: Date }
-      EDIMLColumn Description { Attribute: Description ValueType: String }
-      EDIMLColumn IsAvailable { Attribute: IsAvailable ValueType: Boolean }
-      EDIMLColumn ManufacturedDate { Attribute: ManufacturedDate ValueType: Date }
-      EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
-      EDIMLColumn StockType { Attribute: StockType ValueType: String }
-      EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
-    }
-  }
-  EDIODBCLink.Source Source7
-  {
-    DataIntegrityStrategy: 'Disabled'
-    SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.oracle'
-    EDIODBCLinkTable MID_ACTUALPISPIP
-    {
-      OthersMayCreateTable: true
-      OthersMayDeleteRow: true
-      OthersMayDropTable: true
-      OthersMayFlushTable: true
-      OthersMayInsertRow: true
-      Parameters: '/owner="OTD"'
-      PrimaryKeyColumns: DATE
-      PrimaryKeyColumns: PRODUCTID
-      PrimaryKeyColumns: STOCKINGPOINTID
-      RecordModificationHintStrategy: 'None'
-      EDIODBCLinkColumn ACTUALLINVENTORYLEVELEND
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn DATE
-      {
-        OthersMayUpdateColumn: true
-        ValueType: DateTime
-      }
-      EDIODBCLinkColumn DESCRIPTION
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn ISAVAILABLE
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn MANUFACTUREDDATE
-      {
-        OthersMayUpdateColumn: true
-        ValueType: DateTime
-      }
-      EDIODBCLinkColumn PRODUCTID
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn STOCKINGPOINTID
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn STOCKTYPE
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-    }
-  }
-  EDITransformation.Transformation Transformation7
-  {
-    EDITableTransformation
-    {
-      InputTable: MID_ACTUALPISPIP
-      OutputTable: Global_MappingActualProductInStockingPointInPeriod
-      EDIColumnMatch
-      {
-        InputColumn: ACTUALLINVENTORYLEVELEND
-        OutputColumn: ActualInventoryLevelEnd
-        Converter
-        {
-          XMLDefinition:
-          [*
-            <?xml version="1.0" encoding="UTF-16"?>
-            <StringToReal xmlns="http://www.quintiq.com/GEB/StringToReal" Key="@1">
-              <IsStandard>true</IsStandard>
-              <IsISO>false</IsISO>
-              <IsCustom>false</IsCustom>
-              <ConversionType>0</ConversionType>
-              <NumericFormatString>Standard</NumericFormatString>
-              <LocaleString>Chinese (China)</LocaleString>
-              <CurrencyString></CurrencyString>
-              <CustomFormatString></CustomFormatString>
-            </StringToReal>
-          *]
-        }
-      }
-      EDIColumnMatch
-      {
-        InputColumn: DATE
-        OutputColumn: Date
-        Converter
-        {
-          XMLDefinition:
-          [*
-            <?xml version="1.0" encoding="UTF-16"?>
-            <DateTimeToDate xmlns="http://www.quintiq.com/GEB/DateTimeToDate" Key="@1">
-              <IsStandard>true</IsStandard>
-              <IsISO>false</IsISO>
-              <IsCustom>false</IsCustom>
-              <ConversionType>0</ConversionType>
-            </DateTimeToDate>
-          *]
-        }
-      }
-      EDIColumnMatch { InputColumn: DESCRIPTION OutputColumn: Description }
-      EDIColumnMatch { InputColumn: ISAVAILABLE OutputColumn: IsAvailable }
-      EDIColumnMatch
-      {
-        InputColumn: MANUFACTUREDDATE
-        OutputColumn: ManufacturedDate
-        Converter
-        {
-          XMLDefinition:
-          [*
-            <?xml version="1.0" encoding="UTF-16"?>
-            <DateTimeToDate xmlns="http://www.quintiq.com/GEB/DateTimeToDate" Key="@1">
-              <IsStandard>true</IsStandard>
-              <IsISO>false</IsISO>
-              <IsCustom>false</IsCustom>
-              <ConversionType>0</ConversionType>
-            </DateTimeToDate>
-          *]
-        }
-      }
-      EDIColumnMatch { InputColumn: PRODUCTID OutputColumn: ProductID }
-      EDIColumnMatch { InputColumn: STOCKINGPOINTID OutputColumn: StockingPointID }
-      EDIColumnMatch { InputColumn: STOCKTYPE OutputColumn: StockType }
-    }
-  }
-}
diff --git a/_Main/BL/EDI/Broker_GlobalOTDTable_ConversionFactor.qbl b/_Main/BL/EDI/Broker_GlobalOTDTable_ConversionFactor.qbl
deleted file mode 100644
index a3d464b..0000000
--- a/_Main/BL/EDI/Broker_GlobalOTDTable_ConversionFactor.qbl
+++ /dev/null
@@ -1,78 +0,0 @@
-Quintiq file version 2.0
-#parent: #root
-EDIBroker GlobalOTDTable_ConversionFactor
-{
-  MDSDefinition: GlobalOTDTable
-  TimeZone: 'ACT'
-  UseOSTimeZone: false
-  EDIModelLink.Destination Destination4
-  {
-    EDIMLTable Global_MappingConversionFactor
-    {
-      PrimaryKeyColumns: IsEnabled
-      PrimaryKeyColumns: ProductID
-      PrimaryKeyColumns: SourceUnitOfMeasureName
-      PrimaryKeyColumns: TargetUnitOfMeasureName
-      TargetType: Global_MappingConversionFactor
-      TypeIndex: TypeIndex
-      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 }
-    }
-  }
-  EDIODBCLink.Source Source3
-  {
-    DataIntegrityStrategy: 'Disabled'
-    SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.oracle'
-    EDIODBCLinkTable MID_BASECONVERSIONFACTORS
-    {
-      OthersMayCreateTable: true
-      OthersMayDeleteRow: true
-      OthersMayDropTable: true
-      OthersMayFlushTable: true
-      OthersMayInsertRow: true
-      Parameters: '/owner="OTD"'
-      RecordModificationHintStrategy: 'None'
-      EDIODBCLinkColumn FACTOR
-      {
-        OthersMayUpdateColumn: true
-        ValueType: Real
-      }
-      EDIODBCLinkColumn ISENABLED
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn PRODUCTID
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn SOURCEUNITOFMEASURENAME
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn TARGETUNITOFMEASURENAME
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-    }
-  }
-  EDITransformation.Transformation Transformation3
-  {
-    EDITableTransformation
-    {
-      InputTable: MID_BASECONVERSIONFACTORS
-      OutputTable: Global_MappingConversionFactor
-      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 }
-    }
-  }
-}
diff --git a/_Main/BL/EDI/Broker_GlobalOTDTable_CustomOrder.qbl b/_Main/BL/EDI/Broker_GlobalOTDTable_CustomOrder.qbl
deleted file mode 100644
index 21b4fca..0000000
--- a/_Main/BL/EDI/Broker_GlobalOTDTable_CustomOrder.qbl
+++ /dev/null
@@ -1,197 +0,0 @@
-Quintiq file version 2.0
-#parent: #root
-EDIBroker GlobalOTDTable_CustomOrder
-{
-  MDSDefinition: GlobalOTDTable
-  TimeZone: 'ACT'
-  UseOSTimeZone: false
-  EDIModelLink.Destination Destination13
-  {
-    EDIMLTable Global_MappingCustomOrder
-    {
-      PrimaryKeyColumns: ID
-      TargetType: Global_MappingCustomOrder
-      TypeIndex: TypeIndex
-      EDIMLColumn BusinessType { Attribute: BusinessType ValueType: String }
-      EDIMLColumn CurrencyID { Attribute: CurrencyID ValueType: String }
-      EDIMLColumn Customer { Attribute: Customer ValueType: String }
-      EDIMLColumn CustomerID { Attribute: CustomerID ValueType: String }
-      EDIMLColumn ID { Attribute: ID ValueType: String }
-      EDIMLColumn IsAvailable { Attribute: IsAvailable ValueType: Boolean }
-      EDIMLColumn OrderDate { Attribute: OrderDate ValueType: Date }
-      EDIMLColumn OrderID { Attribute: OrderID ValueType: String }
-      EDIMLColumn OrderLineID { Attribute: OrderLineID ValueType: String }
-      EDIMLColumn OrderType { Attribute: OrderType 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 StockingPointID { Attribute: StockingPointID ValueType: String }
-      EDIMLColumn UnitOfMeasureName { Attribute: UnitOfMeasureName ValueType: String }
-    }
-  }
-  EDIODBCLink.Source Source12
-  {
-    DataIntegrityStrategy: 'Disabled'
-    SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.oracle'
-    EDIODBCLinkTable MID_CUSTOMERORDER
-    {
-      OthersMayCreateTable: true
-      OthersMayDeleteRow: true
-      OthersMayDropTable: true
-      OthersMayFlushTable: true
-      OthersMayInsertRow: true
-      Parameters: '/owner="OTD"'
-      PrimaryKeyColumns: ID
-      RecordModificationHintStrategy: 'None'
-      EDIODBCLinkColumn BUSINESSTYPE
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn CURRENCYID
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn CUSTOMER
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn CUSTOMERID
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn ID
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn ISAVAILABLE
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn ORDERDATE
-      {
-        OthersMayUpdateColumn: true
-        ValueType: DateTime
-      }
-      EDIODBCLinkColumn ORDERID
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn ORDERLINEID
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn ORDERTIME
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn ORDERTYPE
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn PRICE
-      {
-        OthersMayUpdateColumn: true
-        ValueType: Real
-      }
-      EDIODBCLinkColumn PRIORITYNAME
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn PRODUCTGRADE
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn PRODUCTID
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn QUANTITY
-      {
-        OthersMayUpdateColumn: true
-        ValueType: Real
-      }
-      EDIODBCLinkColumn SALESEGMENTNAME
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn SEGMENTPRIORITY
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn SHEETPROFITABILITY
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn STOCKINGPOINTID
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn UNITOFMEASURENAME
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-    }
-  }
-  EDITransformation.Transformation Transformation12
-  {
-    EDITableTransformation
-    {
-      InputTable: MID_CUSTOMERORDER
-      OutputTable: Global_MappingCustomOrder
-      EDIColumnMatch { InputColumn: BUSINESSTYPE OutputColumn: BusinessType }
-      EDIColumnMatch { InputColumn: CURRENCYID OutputColumn: CurrencyID }
-      EDIColumnMatch { InputColumn: CUSTOMER OutputColumn: Customer }
-      EDIColumnMatch { InputColumn: CUSTOMERID OutputColumn: CustomerID }
-      EDIColumnMatch { InputColumn: ID OutputColumn: ID }
-      EDIColumnMatch { InputColumn: ISAVAILABLE OutputColumn: IsAvailable }
-      EDIColumnMatch
-      {
-        InputColumn: ORDERDATE
-        OutputColumn: OrderDate
-        Converter
-        {
-          XMLDefinition:
-          [*
-            <?xml version="1.0" encoding="UTF-16"?>
-            <DateTimeToDate xmlns="http://www.quintiq.com/GEB/DateTimeToDate" Key="@1">
-              <IsStandard>true</IsStandard>
-              <IsISO>false</IsISO>
-              <IsCustom>false</IsCustom>
-              <ConversionType>0</ConversionType>
-            </DateTimeToDate>
-          *]
-        }
-      }
-      EDIColumnMatch { InputColumn: ORDERID OutputColumn: OrderID }
-      EDIColumnMatch { InputColumn: ORDERLINEID OutputColumn: OrderLineID }
-      EDIColumnMatch { InputColumn: ORDERTIME OutputColumn: OrderType }
-      EDIColumnMatch { InputColumn: PRICE OutputColumn: Price }
-      EDIColumnMatch { InputColumn: PRIORITYNAME OutputColumn: PriorityName }
-      EDIColumnMatch { InputColumn: PRODUCTID OutputColumn: ProductID }
-      EDIColumnMatch { InputColumn: QUANTITY OutputColumn: Quantity }
-      EDIColumnMatch { InputColumn: SALESEGMENTNAME OutputColumn: SalesSegmentName }
-      EDIColumnMatch { InputColumn: STOCKINGPOINTID OutputColumn: StockingPointID }
-      EDIColumnMatch { InputColumn: UNITOFMEASURENAME OutputColumn: UnitOfMeasureName }
-    }
-  }
-}
diff --git a/_Main/BL/EDI/Broker_GlobalOTDTable_Forecast.qbl b/_Main/BL/EDI/Broker_GlobalOTDTable_Forecast.qbl
deleted file mode 100644
index 35e5dd8..0000000
--- a/_Main/BL/EDI/Broker_GlobalOTDTable_Forecast.qbl
+++ /dev/null
@@ -1,174 +0,0 @@
-Quintiq file version 2.0
-#parent: #root
-EDIBroker GlobalOTDTable_Forecast
-{
-  MDSDefinition: GlobalOTDTable
-  TimeZone: 'ACT'
-  UseOSTimeZone: false
-  EDIModelLink.Destination Destination12
-  {
-    EDIMLTable Global_MappingForecast
-    {
-      PrimaryKeyColumns: ID
-      TargetType: Global_MappingForecast
-      TypeIndex: TypeIndex
-      EDIMLColumn BusinessType { Attribute: BusinessType ValueType: String }
-      EDIMLColumn CurrencyID { Attribute: CurrencyID ValueType: String }
-      EDIMLColumn EndDate { Attribute: EndDate ValueType: Date }
-      EDIMLColumn ID { Attribute: ID 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 }
-    }
-  }
-  EDIODBCLink.Source Source11
-  {
-    DataIntegrityStrategy: 'Disabled'
-    SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.oracle'
-    EDIODBCLinkTable MID_FORECAST
-    {
-      OthersMayCreateTable: true
-      OthersMayDeleteRow: true
-      OthersMayDropTable: true
-      OthersMayFlushTable: true
-      OthersMayInsertRow: true
-      Parameters: '/owner="OTD"'
-      PrimaryKeyColumns: ID
-      RecordModificationHintStrategy: 'None'
-      EDIODBCLinkColumn BUSINESSTYPE
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn CURRENCYID
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn ENDDATE
-      {
-        OthersMayUpdateColumn: true
-        ValueType: DateTime
-      }
-      EDIODBCLinkColumn ID
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn PRICE
-      {
-        OthersMayUpdateColumn: true
-        ValueType: Real
-      }
-      EDIODBCLinkColumn PRIORITYNAME
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn PRODUCTGRADE
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn PRODUCTID
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn QUANTITY
-      {
-        OthersMayUpdateColumn: true
-        ValueType: Real
-      }
-      EDIODBCLinkColumn SALESEGMENTNAME
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn SEGMENTPRIORITY
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn SHEETPROFITABILITY
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn STARTDATE
-      {
-        OthersMayUpdateColumn: true
-        ValueType: DateTime
-      }
-      EDIODBCLinkColumn STOCKINGPOINTID
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn UNITOFMEASURENAME
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-    }
-  }
-  EDITransformation.Transformation Transformation11
-  {
-    EDITableTransformation
-    {
-      InputTable: MID_FORECAST
-      OutputTable: Global_MappingForecast
-      EDIColumnMatch { InputColumn: BUSINESSTYPE OutputColumn: BusinessType }
-      EDIColumnMatch { InputColumn: CURRENCYID OutputColumn: CurrencyID }
-      EDIColumnMatch
-      {
-        InputColumn: ENDDATE
-        OutputColumn: EndDate
-        Converter
-        {
-          XMLDefinition:
-          [*
-            <?xml version="1.0" encoding="UTF-16"?>
-            <DateTimeToDate xmlns="http://www.quintiq.com/GEB/DateTimeToDate" Key="@1">
-              <IsStandard>true</IsStandard>
-              <IsISO>false</IsISO>
-              <IsCustom>false</IsCustom>
-              <ConversionType>0</ConversionType>
-            </DateTimeToDate>
-          *]
-        }
-      }
-      EDIColumnMatch { InputColumn: ID OutputColumn: ID }
-      EDIColumnMatch { InputColumn: PRICE OutputColumn: Price }
-      EDIColumnMatch { InputColumn: PRIORITYNAME OutputColumn: PriorityName }
-      EDIColumnMatch { InputColumn: PRODUCTID OutputColumn: ProductID }
-      EDIColumnMatch { InputColumn: QUANTITY OutputColumn: Quantity }
-      EDIColumnMatch { InputColumn: SALESEGMENTNAME OutputColumn: SalesSegmentName }
-      EDIColumnMatch
-      {
-        InputColumn: STARTDATE
-        OutputColumn: StartDate
-        Converter
-        {
-          XMLDefinition:
-          [*
-            <?xml version="1.0" encoding="UTF-16"?>
-            <DateTimeToDate xmlns="http://www.quintiq.com/GEB/DateTimeToDate" Key="@1">
-              <IsStandard>true</IsStandard>
-              <IsISO>false</IsISO>
-              <IsCustom>false</IsCustom>
-              <ConversionType>0</ConversionType>
-            </DateTimeToDate>
-          *]
-        }
-      }
-      EDIColumnMatch { InputColumn: STOCKINGPOINTID OutputColumn: StockingPointID }
-      EDIColumnMatch { InputColumn: UNITOFMEASURENAME OutputColumn: UnitOfMeasureName }
-    }
-  }
-}
diff --git a/_Main/BL/EDI/Broker_GlobalOTDTable_InventorySupply.qbl b/_Main/BL/EDI/Broker_GlobalOTDTable_InventorySupply.qbl
deleted file mode 100644
index 60277b7..0000000
--- a/_Main/BL/EDI/Broker_GlobalOTDTable_InventorySupply.qbl
+++ /dev/null
@@ -1,152 +0,0 @@
-Quintiq file version 2.0
-#parent: #root
-EDIBroker GlobalOTDTable_InventorySupply
-{
-  MDSDefinition: GlobalOTDTable
-  TimeZone: 'ACT'
-  UseOSTimeZone: false
-  EDIModelLink.Destination Destination9
-  {
-    EDIMLTable Global_MappingInventorySupply
-    {
-      PrimaryKeyColumns: ID
-      TargetType: Global_MappingInventorySupply
-      TypeIndex: TypeIndex
-      EDIMLColumn Date { Attribute: Date ValueType: Date }
-      EDIMLColumn Description { Attribute: Description ValueType: String }
-      EDIMLColumn ID { Attribute: ID ValueType: String }
-      EDIMLColumn ManufacturedDate { Attribute: ManufacturedDate ValueType: Date }
-      EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
-      EDIMLColumn StockingPointID { Attribute: StockingPointID ValueType: String }
-      EDIMLColumn SupplyType { Attribute: SupplyType ValueType: String }
-      EDIMLColumn UserQuantity { Attribute: UserQuantity ValueType: Real }
-    }
-  }
-  EDIODBCLink.Source Source8
-  {
-    DataIntegrityStrategy: 'Disabled'
-    SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.oracle'
-    EDIODBCLinkTable MID_EXTERNALSUPPLY
-    {
-      OthersMayCreateTable: true
-      OthersMayDeleteRow: true
-      OthersMayDropTable: true
-      OthersMayFlushTable: true
-      OthersMayInsertRow: true
-      Parameters: '/owner="OTD"'
-      PrimaryKeyColumns: ID
-      RecordModificationHintStrategy: 'None'
-      EDIODBCLinkColumn DATE
-      {
-        OthersMayUpdateColumn: true
-        ValueType: DateTime
-      }
-      EDIODBCLinkColumn DESCRIPTION
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn ID
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn MANUFACTUREDDATE
-      {
-        OthersMayUpdateColumn: true
-        ValueType: DateTime
-      }
-      EDIODBCLinkColumn PRODUCTID
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn STOCKINGPOINTID
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn SUPPLYTYPE
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn USERQUANTITY
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-    }
-  }
-  EDITransformation.Transformation Transformation8
-  {
-    EDITableTransformation
-    {
-      InputTable: MID_EXTERNALSUPPLY
-      OutputTable: Global_MappingInventorySupply
-      EDIColumnMatch
-      {
-        InputColumn: DATE
-        OutputColumn: Date
-        Converter
-        {
-          XMLDefinition:
-          [*
-            <?xml version="1.0" encoding="UTF-16"?>
-            <DateTimeToDate xmlns="http://www.quintiq.com/GEB/DateTimeToDate" Key="@1">
-              <IsStandard>true</IsStandard>
-              <IsISO>false</IsISO>
-              <IsCustom>false</IsCustom>
-              <ConversionType>0</ConversionType>
-            </DateTimeToDate>
-          *]
-        }
-      }
-      EDIColumnMatch { InputColumn: DESCRIPTION OutputColumn: Description }
-      EDIColumnMatch { InputColumn: ID OutputColumn: ID }
-      EDIColumnMatch
-      {
-        InputColumn: MANUFACTUREDDATE
-        OutputColumn: ManufacturedDate
-        Converter
-        {
-          XMLDefinition:
-          [*
-            <?xml version="1.0" encoding="UTF-16"?>
-            <DateTimeToDate xmlns="http://www.quintiq.com/GEB/DateTimeToDate" Key="@1">
-              <IsStandard>true</IsStandard>
-              <IsISO>false</IsISO>
-              <IsCustom>false</IsCustom>
-              <ConversionType>0</ConversionType>
-            </DateTimeToDate>
-          *]
-        }
-      }
-      EDIColumnMatch { InputColumn: PRODUCTID OutputColumn: ProductID }
-      EDIColumnMatch { InputColumn: STOCKINGPOINTID OutputColumn: StockingPointID }
-      EDIColumnMatch { InputColumn: SUPPLYTYPE OutputColumn: SupplyType }
-      EDIColumnMatch
-      {
-        InputColumn: USERQUANTITY
-        OutputColumn: UserQuantity
-        Converter
-        {
-          XMLDefinition:
-          [*
-            <?xml version="1.0" encoding="UTF-16"?>
-            <StringToReal xmlns="http://www.quintiq.com/GEB/StringToReal" Key="@1">
-              <IsStandard>true</IsStandard>
-              <IsISO>false</IsISO>
-              <IsCustom>false</IsCustom>
-              <ConversionType>0</ConversionType>
-              <NumericFormatString>Standard</NumericFormatString>
-              <LocaleString>Chinese (China)</LocaleString>
-              <CurrencyString></CurrencyString>
-              <CustomFormatString></CustomFormatString>
-            </StringToReal>
-          *]
-        }
-      }
-    }
-  }
-}
diff --git a/_Main/BL/EDI/Broker_GlobalOTDTable_Operation.qbl b/_Main/BL/EDI/Broker_GlobalOTDTable_Operation.qbl
deleted file mode 100644
index a0a76df..0000000
--- a/_Main/BL/EDI/Broker_GlobalOTDTable_Operation.qbl
+++ /dev/null
@@ -1,200 +0,0 @@
-Quintiq file version 2.0
-#parent: #root
-EDIBroker GlobalOTDTable_Operation
-{
-  MDSDefinition: GlobalOTDTable
-  TimeZone: 'ACT'
-  UseOSTimeZone: false
-  EDIModelLink.Destination Destination5
-  {
-    EDIMLTable Global_MappingOperation
-    {
-      PrimaryKeyColumns: BusinessType
-      PrimaryKeyColumns: Line
-      PrimaryKeyColumns: OrganCode
-      PrimaryKeyColumns: PlantName
-      PrimaryKeyColumns: ProcessSection
-      PrimaryKeyColumns: ProductID
-      PrimaryKeyColumns: SequenceNumber
-      TargetType: Global_MappingOperation
-      TypeIndex: NewTypeIndex
-      EDIMLColumn ActualCapacity { Attribute: ActualCapacity ValueType: Real }
-      EDIMLColumn BusinessType { Attribute: BusinessType ValueType: String }
-      EDIMLColumn Line { Attribute: Line ValueType: String }
-      EDIMLColumn MaximumQuantity { Attribute: MaximumQuantity ValueType: Number }
-      EDIMLColumn MinimumQuantity { Attribute: MinimumQuantity ValueType: Number }
-      EDIMLColumn OrganCode { Attribute: OrganCode ValueType: String }
-      EDIMLColumn OrganName { Attribute: OrganName ValueType: String }
-      EDIMLColumn PlantName { Attribute: PlantName ValueType: String }
-      EDIMLColumn ProcessSection { Attribute: ProcessSection ValueType: String }
-      EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
-      EDIMLColumn SequenceNumber { Attribute: SequenceNumber ValueType: Number }
-      EDIMLColumn UnitOfMeasureName { Attribute: UnitOfMeasureName ValueType: String }
-      EDIMLColumn UserLeadTime { Attribute: UserLeadTime ValueType: Real }
-    }
-  }
-  EDIODBCLink.Source Source4
-  {
-    DataIntegrityStrategy: 'Disabled'
-    SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.oracle'
-    EDIODBCLinkTable MID_OPERATION
-    {
-      OthersMayCreateTable: true
-      OthersMayDeleteRow: true
-      OthersMayDropTable: true
-      OthersMayFlushTable: true
-      OthersMayInsertRow: true
-      Parameters: '/owner="OTD"'
-      RecordModificationHintStrategy: 'None'
-      EDIODBCLinkColumn ACTUALCAPACITY
-      {
-        OthersMayUpdateColumn: true
-        ValueType: Real
-      }
-      EDIODBCLinkColumn BUSINESSTYPE
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn LINE
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn MAXIMUMQUANTITY
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn MINIMUMQUANTITY
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn ORGANCODE
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn ORGANNAME
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn PLANTNAME
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn PROCESSSECTION
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn PRODUCTID
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn SEQUENCENUMBER
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn UNITOFMEASURENAME
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn USERLEADTIME
-      {
-        OthersMayUpdateColumn: true
-        ValueType: Real
-      }
-    }
-  }
-  EDITransformation.Transformation Transformation4
-  {
-    EDITableTransformation
-    {
-      InputTable: MID_OPERATION
-      OutputTable: Global_MappingOperation
-      EDIColumnMatch { InputColumn: ACTUALCAPACITY OutputColumn: ActualCapacity }
-      EDIColumnMatch { InputColumn: BUSINESSTYPE OutputColumn: BusinessType }
-      EDIColumnMatch { InputColumn: LINE OutputColumn: Line }
-      EDIColumnMatch
-      {
-        InputColumn: MAXIMUMQUANTITY
-        OutputColumn: MaximumQuantity
-        Converter
-        {
-          XMLDefinition:
-          [*
-            <?xml version="1.0" encoding="UTF-16"?>
-            <StringToNumber xmlns="http://www.quintiq.com/GEB/StringToNumber" Key="@1">
-              <IsStandard>true</IsStandard>
-              <IsISO>false</IsISO>
-              <IsCustom>false</IsCustom>
-              <ConversionType>0</ConversionType>
-              <NumericFormatString>Standard</NumericFormatString>
-              <LocaleString>Chinese (China)</LocaleString>
-              <CurrencyString></CurrencyString>
-              <CustomFormatString></CustomFormatString>
-            </StringToNumber>
-          *]
-        }
-      }
-      EDIColumnMatch
-      {
-        InputColumn: MINIMUMQUANTITY
-        OutputColumn: MinimumQuantity
-        Converter
-        {
-          XMLDefinition:
-          [*
-            <?xml version="1.0" encoding="UTF-16"?>
-            <StringToNumber xmlns="http://www.quintiq.com/GEB/StringToNumber" Key="@1">
-              <IsStandard>true</IsStandard>
-              <IsISO>false</IsISO>
-              <IsCustom>false</IsCustom>
-              <ConversionType>0</ConversionType>
-              <NumericFormatString>Standard</NumericFormatString>
-              <LocaleString>Chinese (China)</LocaleString>
-              <CurrencyString></CurrencyString>
-              <CustomFormatString></CustomFormatString>
-            </StringToNumber>
-          *]
-        }
-      }
-      EDIColumnMatch { InputColumn: ORGANCODE OutputColumn: OrganCode }
-      EDIColumnMatch { InputColumn: ORGANNAME OutputColumn: OrganName }
-      EDIColumnMatch { InputColumn: PLANTNAME OutputColumn: PlantName }
-      EDIColumnMatch { InputColumn: PROCESSSECTION OutputColumn: ProcessSection }
-      EDIColumnMatch { InputColumn: PRODUCTID OutputColumn: ProductID }
-      EDIColumnMatch
-      {
-        InputColumn: SEQUENCENUMBER
-        OutputColumn: SequenceNumber
-        Converter
-        {
-          XMLDefinition:
-          [*
-            <?xml version="1.0" encoding="UTF-16"?>
-            <StringToNumber xmlns="http://www.quintiq.com/GEB/StringToNumber" Key="@1">
-              <IsStandard>true</IsStandard>
-              <IsISO>false</IsISO>
-              <IsCustom>false</IsCustom>
-              <ConversionType>0</ConversionType>
-              <NumericFormatString>Standard</NumericFormatString>
-              <LocaleString>Chinese (China)</LocaleString>
-              <CurrencyString></CurrencyString>
-              <CustomFormatString></CustomFormatString>
-            </StringToNumber>
-          *]
-        }
-      }
-      EDIColumnMatch { InputColumn: UNITOFMEASURENAME OutputColumn: UnitOfMeasureName }
-      EDIColumnMatch { InputColumn: USERLEADTIME OutputColumn: UserLeadTime }
-    }
-  }
-}
diff --git a/_Main/BL/EDI/Broker_GlobalOTDTable_OperationBOM.qbl b/_Main/BL/EDI/Broker_GlobalOTDTable_OperationBOM.qbl
deleted file mode 100644
index 36bfcee..0000000
--- a/_Main/BL/EDI/Broker_GlobalOTDTable_OperationBOM.qbl
+++ /dev/null
@@ -1,208 +0,0 @@
-Quintiq file version 2.0
-#parent: #root
-EDIBroker GlobalOTDTable_OperationBOM
-{
-  MDSDefinition: GlobalOTDTable
-  TimeZone: 'ACT'
-  UseOSTimeZone: false
-  EDIModelLink.Destination Destination6
-  {
-    EDIMLTable Global_MappingOperationBOM
-    {
-      PrimaryKeyColumns: AlternativeMaterialCode
-      PrimaryKeyColumns: BusinessType
-      PrimaryKeyColumns: ComponentCode
-      PrimaryKeyColumns: ComponentType
-      PrimaryKeyColumns: ComponentUnit
-      PrimaryKeyColumns: OrganCode
-      PrimaryKeyColumns: ProcessSection
-      PrimaryKeyColumns: ProductCode
-      TargetType: Global_MappingOperationBOM
-      TypeIndex: TypeIndex
-      EDIMLColumn AlternativeMaterialCode { Attribute: AlternativeMaterialCode ValueType: String }
-      EDIMLColumn AlternativeMaterialType { Attribute: AlternativeMaterialType ValueType: String }
-      EDIMLColumn AlternativeMaterialUnit { Attribute: AlternativeMaterialUnit ValueType: String }
-      EDIMLColumn AlternativeRate { Attribute: AlternativeRate ValueType: Real }
-      EDIMLColumn BusinessType { Attribute: BusinessType ValueType: String }
-      EDIMLColumn ComponentCode { Attribute: ComponentCode ValueType: String }
-      EDIMLColumn ComponentDescription { Attribute: ComponentDescription ValueType: String }
-      EDIMLColumn ComponentOutputRate { Attribute: ComponentOutputRate ValueType: Real }
-      EDIMLColumn ComponentType { Attribute: ComponentType ValueType: String }
-      EDIMLColumn ComponentUnit { Attribute: ComponentUnit ValueType: String }
-      EDIMLColumn ComponentUnitDescription { Attribute: ComponentUnitDescription ValueType: String }
-      EDIMLColumn DescriptionOfAlternativeMaterial { Attribute: DescriptionOfAlternativeMaterial ValueType: String }
-      EDIMLColumn DescriptionOfAlternativeMaterialUnits { Attribute: DescriptionOfAlternativeMaterialUnits ValueType: String }
-      EDIMLColumn MaterialSystem { Attribute: MaterialSystem ValueType: String }
-      EDIMLColumn OrganCode { Attribute: OrganCode ValueType: String }
-      EDIMLColumn ProcessSection { Attribute: ProcessSection ValueType: String }
-      EDIMLColumn ProductCode { Attribute: ProductCode ValueType: String }
-      EDIMLColumn ProductDescribe { Attribute: ProductDescribe ValueType: String }
-      EDIMLColumn ProductType { Attribute: ProductType ValueType: String }
-      EDIMLColumn ProductUnitDescription { Attribute: ProductUnitDescription ValueType: String }
-      EDIMLColumn SubstitutionRelationship { Attribute: SubstitutionRelationship ValueType: String }
-      EDIMLColumn UnitOfMeasureName { Attribute: UnitOfMeasureName ValueType: String }
-      EDIMLColumn UnitUsageOfComponents { Attribute: UnitUsageOfComponents ValueType: Real }
-    }
-  }
-  EDIODBCLink.Source Source5
-  {
-    DataIntegrityStrategy: 'Disabled'
-    SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.oracle'
-    EDIODBCLinkTable MID_BOM
-    {
-      OthersMayCreateTable: true
-      OthersMayDeleteRow: true
-      OthersMayDropTable: true
-      OthersMayFlushTable: true
-      OthersMayInsertRow: true
-      Parameters: '/owner="OTD"'
-      RecordModificationHintStrategy: 'None'
-      EDIODBCLinkColumn ALTERNATIVEMATERIALCODE
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn ALTERNATIVEMATERIALTYPE
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn ALTERNATIVEMATERIALUNIT
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn ALTERNATIVERATE
-      {
-        OthersMayUpdateColumn: true
-        ValueType: Real
-      }
-      EDIODBCLinkColumn BUSINESSTYPE
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn COMPONENTCODE
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn COMPONENTDESCRIPTION
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn COMPONENTOUTPUTRATE
-      {
-        OthersMayUpdateColumn: true
-        ValueType: Real
-      }
-      EDIODBCLinkColumn COMPONENTTYPE
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn COMPONENTUNIT
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn COMPONENTUNITDESCRIPTION
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn DESCRIPTIONOFALTERNATIVEMATERIAL
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn DESCRIPTIONOFALTERNATIVEMATERIALUNIT
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn MATERIALSYSTEM
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn ORGANCODE
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn PROCESSSECTION
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn PRODUCTCODE
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn PRODUCTDESCRIBE
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn PRODUCTTYPE
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn PRODUCTUNITDESCRIPTION
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn SUBSTITUTIONRELATIONSHIP
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn UNITOFMEASURENAME
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn UNITUSAGEOFCOMPENENT
-      {
-        OthersMayUpdateColumn: true
-        ValueType: Real
-      }
-    }
-  }
-  EDITransformation.Transformation Transformation5
-  {
-    EDITableTransformation
-    {
-      InputTable: MID_BOM
-      OutputTable: Global_MappingOperationBOM
-      EDIColumnMatch { InputColumn: ALTERNATIVEMATERIALCODE OutputColumn: AlternativeMaterialCode }
-      EDIColumnMatch { InputColumn: ALTERNATIVEMATERIALTYPE OutputColumn: AlternativeMaterialType }
-      EDIColumnMatch { InputColumn: ALTERNATIVEMATERIALUNIT OutputColumn: AlternativeMaterialUnit }
-      EDIColumnMatch { InputColumn: ALTERNATIVERATE OutputColumn: AlternativeRate }
-      EDIColumnMatch { InputColumn: BUSINESSTYPE OutputColumn: BusinessType }
-      EDIColumnMatch { InputColumn: COMPONENTCODE OutputColumn: ComponentCode }
-      EDIColumnMatch { InputColumn: COMPONENTDESCRIPTION OutputColumn: ComponentDescription }
-      EDIColumnMatch { InputColumn: COMPONENTOUTPUTRATE OutputColumn: ComponentOutputRate }
-      EDIColumnMatch { InputColumn: COMPONENTTYPE OutputColumn: ComponentType }
-      EDIColumnMatch { InputColumn: COMPONENTUNIT OutputColumn: ComponentUnit }
-      EDIColumnMatch { InputColumn: COMPONENTUNITDESCRIPTION OutputColumn: ComponentUnitDescription }
-      EDIColumnMatch { InputColumn: DESCRIPTIONOFALTERNATIVEMATERIAL OutputColumn: DescriptionOfAlternativeMaterial }
-      EDIColumnMatch { InputColumn: DESCRIPTIONOFALTERNATIVEMATERIALUNIT OutputColumn: DescriptionOfAlternativeMaterialUnits }
-      EDIColumnMatch { InputColumn: MATERIALSYSTEM OutputColumn: MaterialSystem }
-      EDIColumnMatch { InputColumn: ORGANCODE OutputColumn: OrganCode }
-      EDIColumnMatch { InputColumn: PROCESSSECTION OutputColumn: ProcessSection }
-      EDIColumnMatch { InputColumn: PRODUCTCODE OutputColumn: ProductCode }
-      EDIColumnMatch { InputColumn: PRODUCTDESCRIBE OutputColumn: ProductDescribe }
-      EDIColumnMatch { InputColumn: PRODUCTTYPE OutputColumn: ProductType }
-      EDIColumnMatch { InputColumn: PRODUCTUNITDESCRIPTION OutputColumn: ProductUnitDescription }
-      EDIColumnMatch { InputColumn: SUBSTITUTIONRELATIONSHIP OutputColumn: SubstitutionRelationship }
-      EDIColumnMatch { InputColumn: UNITOFMEASURENAME OutputColumn: UnitOfMeasureName }
-      EDIColumnMatch { InputColumn: UNITUSAGEOFCOMPENENT OutputColumn: UnitUsageOfComponents }
-    }
-  }
-}
diff --git a/_Main/BL/EDI/Broker_GlobalOTDTable_ProductInLane.qbl b/_Main/BL/EDI/Broker_GlobalOTDTable_ProductInLane.qbl
deleted file mode 100644
index 5edb9d7..0000000
--- a/_Main/BL/EDI/Broker_GlobalOTDTable_ProductInLane.qbl
+++ /dev/null
@@ -1,57 +0,0 @@
-Quintiq file version 2.0
-#parent: #root
-EDIBroker GlobalOTDTable_ProductInLane
-{
-  MDSDefinition: GlobalOTDTable
-  TimeZone: 'ACT'
-  UseOSTimeZone: false
-  EDIModelLink.Destination Destination7
-  {
-    EDIMLTable Global_MappingProductInLane
-    {
-      PrimaryKeyColumns: LineID
-      PrimaryKeyColumns: ProductID
-      TargetType: Global_MappingProductInLane
-      TypeIndex: TypeIndex
-      EDIMLColumn LineID { Attribute: LineID ValueType: String }
-      EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
-    }
-  }
-  EDIODBCLink.Source Source6
-  {
-    DataIntegrityStrategy: 'Disabled'
-    SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.oracle'
-    EDIODBCLinkTable MID_PRODUCTINLINES
-    {
-      OthersMayCreateTable: true
-      OthersMayDeleteRow: true
-      OthersMayDropTable: true
-      OthersMayFlushTable: true
-      OthersMayInsertRow: true
-      Parameters: '/owner="OTD"'
-      PrimaryKeyColumns: LINEID
-      PrimaryKeyColumns: PRODUCTID
-      RecordModificationHintStrategy: 'None'
-      EDIODBCLinkColumn LINEID
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-      EDIODBCLinkColumn PRODUCTID
-      {
-        OthersMayUpdateColumn: true
-        ValueType: String
-      }
-    }
-  }
-  EDITransformation.Transformation Transformation6
-  {
-    EDITableTransformation
-    {
-      InputTable: MID_PRODUCTINLINES
-      OutputTable: Global_MappingProductInLane
-      EDIColumnMatch { InputColumn: LINEID OutputColumn: LineID }
-      EDIColumnMatch { InputColumn: PRODUCTID OutputColumn: ProductID }
-    }
-  }
-}
diff --git a/_Main/BL/Type_GlobalDTOTable/StaticMethod_SynchronizationAllMappingBrokerAndAPI.qbl b/_Main/BL/Type_GlobalDTOTable/StaticMethod_SynchronizationAllMappingBrokerAndAPI.qbl
index a365d78..46883f2 100644
--- a/_Main/BL/Type_GlobalDTOTable/StaticMethod_SynchronizationAllMappingBrokerAndAPI.qbl
+++ b/_Main/BL/Type_GlobalDTOTable/StaticMethod_SynchronizationAllMappingBrokerAndAPI.qbl
@@ -32,17 +32,17 @@
     //Global_MappingCurrency_MP::CreateByAPI( globalOTDTable );鍚庨潰琛�
     //Global_MappingCurrencyRate_MP::CreateByAPI( globalOTDTable );鍚庨潰琛�
     //globalOTDTable.GlobalOTDTable_Product_MP().AsyncExecute();
-    globalOTDTable.GlobalOTDTable_ConversionFactor().AsyncExecute();
-    globalOTDTable.GlobalOTDTable_Operation().AsyncExecute();
-    globalOTDTable.GlobalOTDTable_OperationBOM().AsyncExecute();
+    //globalOTDTable.GlobalOTDTable_ConversionFactor().AsyncExecute()寮傚父;
+    //globalOTDTable.GlobalOTDTable_Operation().AsyncExecute();寮傚父
+    //globalOTDTable.GlobalOTDTable_OperationBOM().AsyncExecute();寮傚父
     //Global_MappingLane::CreateByAPI( globalOTDTable );
     //Global_MappingLaneLeg::CreateByAPI( globalOTDTable );
-    globalOTDTable.GlobalOTDTable_ProductInLane().AsyncExecute();
-    globalOTDTable.GlobalOTDTable_AIPISPIP().AsyncExecute();
-    globalOTDTable.GlobalOTDTable_InventorySupply().AsyncExecute();
-    globalOTDTable.GlobalOTDTable_StockingPointCost().AsyncExecute();
-    globalOTDTable.GlobalOTDTable_OperationCost().AsyncExecute();
-    globalOTDTable.GlobalOTDTable_Forecast().AsyncExecute();
+    //globalOTDTable.GlobalOTDTable_ProductInLane().AsyncExecute();寮傚父
+    //globalOTDTable.GlobalOTDTable_AIPISPIP().AsyncExecute();寮傚父
+    //globalOTDTable.GlobalOTDTable_InventorySupply().AsyncExecute();寮傚父
+    //globalOTDTable.GlobalOTDTable_StockingPointCost().AsyncExecute();寮傚父
+    //globalOTDTable.GlobalOTDTable_OperationCost().AsyncExecute();寮傚父
+    //globalOTDTable.GlobalOTDTable_Forecast().AsyncExecute();寮傚父
     //globalOTDTable.GlobalOTDTable_CustomOrder().AsyncExecute();
   *]
 }
diff --git a/_Main/BL/Type_Global_MappingActualProductInStockingPointInPeriod/TypeIndex_TypeIndex.qbl b/_Main/BL/Type_Global_MappingActualProductInStockingPointInPeriod/TypeIndex_MappingActualPISPIPTypeIndex.qbl
similarity index 86%
rename from _Main/BL/Type_Global_MappingActualProductInStockingPointInPeriod/TypeIndex_TypeIndex.qbl
rename to _Main/BL/Type_Global_MappingActualProductInStockingPointInPeriod/TypeIndex_MappingActualPISPIPTypeIndex.qbl
index ca6828a..da6905e 100644
--- a/_Main/BL/Type_Global_MappingActualProductInStockingPointInPeriod/TypeIndex_TypeIndex.qbl
+++ b/_Main/BL/Type_Global_MappingActualProductInStockingPointInPeriod/TypeIndex_MappingActualPISPIPTypeIndex.qbl
@@ -1,6 +1,6 @@
 Quintiq file version 2.0
 #parent: #root
-TypeIndex TypeIndex
+TypeIndex MappingActualPISPIPTypeIndex
 {
   Attributes:
   [

--
Gitblit v1.9.3