数据湖数据全局化

hongjli

2023-09-20 33fd779be01627f7b1bf2373fd553767ecbbb838

数据湖数据全局化

 _Main/BL/EDI/Broker_GlobalOTDTable_AIPISPIP.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,151 @@
Quintiq file version 2.0
#parent: #root
EDIBroker GlobalOTDTable_AIPISPIP
{
  MDSDefinition: GlobalOTDTable
  EDIModelLink.Destination Des_ActualPISPIP0
  {
    EDIMLTable Global_MappingActualProductInStockingPointInPeriod
    {
      PrimaryKeyColumns: Date
      PrimaryKeyColumns: ProductID
      PrimaryKeyColumns: StockingPointID
      TargetType: Global_MappingActualProductInStockingPointInPeriod
      TypeIndex: GlobalOTDTable_AIPISPIPTypeIndex
      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 MID_ActualPISPIP0
  {
    DataIntegrityStrategy: 'Disabled'
    SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.oracle'
    EDIODBCLinkTable MID_ACTUALPISPIP
    {
      OthersMayCreateTable: true
      OthersMayDeleteRow: true
      OthersMayDropTable: true
      OthersMayFlushTable: true
      OthersMayInsertRow: true
      Parameters: '/owner="TIANMA"'
      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 TransformationActualPISPIP0
  {
    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 }
    }
  }
}

 _Main/BL/EDI/Broker_GlobalOTDTable_ConversionFactor.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,82 @@
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: Global_MappingConversionFactorTypeIndex
      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"'
      PrimaryKeyColumns: ISENABLED
      PrimaryKeyColumns: PRODUCTID
      PrimaryKeyColumns: SOURCEUNITOFMEASURENAME
      PrimaryKeyColumns: TARGETUNITOFMEASURENAME
      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 }
    }
  }
}

 _Main/BL/EDI/Broker_GlobalOTDTable_CustomOrder.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,197 @@
Quintiq file version 2.0
#parent: #root
EDIBroker GlobalOTDTable_CustomOrder
{
  MDSDefinition: GlobalOTDTable
  TimeZone: 'ACT'
  UseOSTimeZone: false
  EDIModelLink.Destination Destination9
  {
    EDIMLTable Global_MappingCustomOrder
    {
      PrimaryKeyColumns: ID
      TargetType: Global_MappingCustomOrder
      TypeIndex: GlobalOTDTable_CustomOrderTypeIndex
      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 Source8
  {
    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 Transformation8
  {
    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 }
    }
  }
}

 _Main/BL/EDI/Broker_GlobalOTDTable_Forecast.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,174 @@
Quintiq file version 2.0
#parent: #root
EDIBroker GlobalOTDTable_Forecast
{
  MDSDefinition: GlobalOTDTable
  TimeZone: 'ACT'
  UseOSTimeZone: false
  EDIModelLink.Destination Destination8
  {
    EDIMLTable Global_MappingForecast
    {
      PrimaryKeyColumns: ID
      TargetType: Global_MappingForecast
      TypeIndex: GlobalOTDTable_ForecastTypeIndex
      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 Source7
  {
    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 Transformation7
  {
    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 }
    }
  }
}

 _Main/BL/EDI/Broker_GlobalOTDTable_InventorySupply.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,152 @@
Quintiq file version 2.0
#parent: #root
EDIBroker GlobalOTDTable_InventorySupply
{
  MDSDefinition: GlobalOTDTable
  TimeZone: 'ACT'
  UseOSTimeZone: false
  EDIModelLink.Destination Destination7
  {
    EDIMLTable Global_MappingInventorySupply
    {
      PrimaryKeyColumns: ID
      TargetType: Global_MappingInventorySupply
      TypeIndex: GlobalOTDTable_InventorySupplyTypeIndex
      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 Source6
  {
    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 Transformation6
  {
    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>
          *]
        }
      }
    }
  }
}

 _Main/BL/EDI/Broker_GlobalOTDTable_Operation.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,200 @@
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: GlobalOTDTable_OperationTypeIndex
      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 }
    }
  }
}

 _Main/BL/EDI/Broker_GlobalOTDTable_OperationBOM.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,208 @@
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: GlobalOTDTable_OperationBOMTypeIndex
      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 }
    }
  }
}

 _Main/BL/EDI/Broker_GlobalOTDTable_OperationCost.qbl

@@ -11,7 +11,7 @@
    {
      PrimaryKeyColumns: ID
      TargetType: Global_MappingOperationCost
      TypeIndex: TypeIndex
      TypeIndex: GlobalOTDTable_OperationCostTypeIndex
      EDIMLColumn AccountName { Attribute: AccountName ValueType: String }
      EDIMLColumn Cost { Attribute: Cost ValueType: Real }
      EDIMLColumn CostDriver { Attribute: CostDriver ValueType: String }

 _Main/BL/EDI/Broker_GlobalOTDTable_ProductInLane.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,55 @@
Quintiq file version 2.0
#parent: #root
EDIBroker GlobalOTDTable_ProductInLane
{
  MDSDefinition: GlobalOTDTable
  EDIModelLink.Destination Des_MappingProductInLane0
  {
    EDIMLTable Global_MappingProductInLane
    {
      PrimaryKeyColumns: LineID
      PrimaryKeyColumns: ProductID
      TargetType: Global_MappingProductInLane
      TypeIndex: GlobalOTDTable_ProductInLaneTypeIndex
      EDIMLColumn LineID { Attribute: LineID ValueType: String }
      EDIMLColumn ProductID { Attribute: ProductID ValueType: String }
    }
  }
  EDIODBCLink.Source MID_PRODUCTINLINES0
  {
    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 TransformationProductInLane0
  {
    EDITableTransformation
    {
      InputTable: MID_PRODUCTINLINES
      OutputTable: Global_MappingProductInLane
      EDIColumnMatch { InputColumn: LINEID OutputColumn: LineID }
      EDIColumnMatch { InputColumn: PRODUCTID OutputColumn: ProductID }
    }
  }
}

 _Main/BL/EDI/Broker_GlobalOTDTable_StockingPointCost.qbl

@@ -11,7 +11,7 @@
    {
      PrimaryKeyColumns: ID
      TargetType: Global_MappingStockingPointCost
      TypeIndex: NewTypeIndex
      TypeIndex: GlobalOTDTable_StockingPointCostTypeIndex
      EDIMLColumn AccountName { Attribute: AccountName ValueType: String }
      EDIMLColumn Cost { Attribute: Cost ValueType: Real }
      EDIMLColumn CostDriver { Attribute: CostDriver ValueType: String }

 _Main/BL/Type_GlobalDTOTable/Attribute_NumberOfBrokersExecuting.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,7 @@
Quintiq file version 2.0
#parent: #root
Attribute NumberOfBrokersExecuting
{
  #keys: '3[414702.0.318091378][414702.0.318091377][414702.0.318091379]'
  ValueType: Number
}

 _Main/BL/Type_GlobalDTOTable/Method_OnAsyncExecuteFailure_GlobalOTDTable_Forecast.qbl

@@ -5,5 +5,16 @@
  String errorMessage
)
{
  TextBody: 'info( "错误号：", errorNo, "errorNo误信息：", errorMessage );'
  TextBody:
  [*
    this.Global_BrokerExecuteLog( relnew,
                                  BrokerName    := "GlobalOTDTable_Forecast",
                                  ElementTotal  := 0,
                                  ErrorMessage  := errorMessage,
                                  IsSuccess     := false,
                                  Name          := "预测数据",
                                  ErrorNo       := errorNo,
                                  ErrorDateTime := DateTime::ActualTime().Format( "Y-M-D H2:m:s" )
                                 );
  *]
}

 _Main/BL/Type_GlobalDTOTable/Method_OnAsyncExecuteFailure_GlobalOTDTable_OperationBOM.qbl

@@ -8,11 +8,11 @@
  TextBody:
  [*
    this.Global_BrokerExecuteLog( relnew,
                                  BrokerName    := "GlobalOTDTable_Operation",
                                  BrokerName    := "GlobalOTDTable_OperationBOM",
                                  ElementTotal  := 0,
                                  ErrorMessage  := errorMessage,
                                  IsSuccess     := false,
                                  Name          := "操作数据",
                                  Name          := "操作BOM数据",
                                  ErrorNo       := errorNo,
                                  ErrorDateTime := DateTime::ActualTime().Format( "Y-M-D H2:m:s" )
                                 );

 _Main/BL/Type_GlobalDTOTable/Method_OnAsyncExecute_GlobalOTDTable_Forecast.qbl

@@ -2,4 +2,16 @@
#parent: #root
Method OnAsyncExecute_GlobalOTDTable_Forecast
{
  TextBody:
  [*
    this.Global_BrokerExecuteLog( relnew,
                                  BrokerName      := "GlobalOTDTable_Forecast",
                                  ElementTotal    := this.Global_MappingForecast( relsize ),
                                  ErrorMessage    := "",
                                  IsSuccess       := true,
                                  Name            := "预测数据",
                                  SuccessDateTime := DateTime::ActualTime().Format( "Y-M-D H2:m:s" ),
                                  ErrorNo         := 0
                                 );
  *]
}

 _Main/BL/Type_GlobalDTOTable/Method_OnAsyncExecute_GlobalOTDTable_OperationBOM.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,17 @@
Quintiq file version 2.0
#parent: #root
Method OnAsyncExecute_GlobalOTDTable_OperationBOM
{
  TextBody:
  [*
    this.Global_BrokerExecuteLog( relnew,
                                  BrokerName      := "GlobalOTDTable_OperationBOM",
                                  ElementTotal    := this.Global_MappingOperationBOM( relsize ),
                                  ErrorMessage    := "",
                                  IsSuccess       := true,
                                  Name            := "操作BOM数据",
                                  SuccessDateTime := DateTime::ActualTime().Format( "Y-M-D H2:m:s" ),
                                  ErrorNo         := 0
                                 );
  *]
}

 _Main/BL/Type_GlobalDTOTable/Method_OnException.qbl

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,20 @@
Quintiq file version 2.0
#parent: #root
Method OnException (
  Exception e,
  GlobalOTDTable globalOTDTable
)
{
  TextBody:
  [*
    this.Global_BrokerExecuteLog( relnew,
                                  BrokerName    := "",
                                  ElementTotal  := 0,
                                  ErrorMessage  := e.Message(),
                                  IsSuccess     := false,
                                  Name          := "接口调用失败",
                                  ErrorNo       := e.ErrorNumber(),
                                  ErrorDateTime := DateTime::ActualTime().Format( "Y-M-D H2:m:s" )
                                 );
  *]
}

 _Main/BL/Type_GlobalDTOTable/StaticMethod_SynchronizationAllMappingBrokerAndAPI.qbl

@@ -26,23 +26,23 @@
    globalOTDTable.Global_MappingForecast( relflush );
    globalOTDTable.Global_MappingCustomOrder( relflush );
    
    //globalOTDTable.GlobalOTDTable_UnitOfMeasure_MP().AsyncExecute();
    //globalOTDTable.GlobalOTDTable_SalesSegment_MP().AsyncExecute();
    //Global_MappingStockingPoint_MP::CreateByAPI( globalOTDTable );后面补
    //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();异常
    //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_CustomOrder().AsyncExecute();
    globalOTDTable.GlobalOTDTable_UnitOfMeasure_MP().AsyncExecute();
    globalOTDTable.GlobalOTDTable_SalesSegment_MP().AsyncExecute();
    globalOTDTable -> OnException( globalOTDTable -> Global_MappingStockingPoint_MP::CreateByAPI() -> Exception(), globalOTDTable );
    globalOTDTable -> OnException( globalOTDTable -> Global_MappingCurrency_MP::CreateByAPI() -> Exception(), globalOTDTable );
    globalOTDTable -> OnException( globalOTDTable -> Global_MappingCurrencyRate_MP::CreateByAPI() -> Exception(), globalOTDTable );
    globalOTDTable.GlobalOTDTable_Product_MP().AsyncExecute();
    globalOTDTable.GlobalOTDTable_ConversionFactor().AsyncExecute();
    globalOTDTable.GlobalOTDTable_Operation().AsyncExecute();
    globalOTDTable.GlobalOTDTable_OperationBOM().AsyncExecute();
    globalOTDTable -> OnException( globalOTDTable -> Global_MappingLane::CreateByAPI() -> Exception(), globalOTDTable );
    globalOTDTable -> OnException( globalOTDTable -> Global_MappingLaneLeg::CreateByAPI() -> Exception(), 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_CustomOrder().AsyncExecute();
  *]
}

 _Main/BL/Type_Global_MappingActualProductInStockingPointInPeriod/TypeIndex_GlobalOTDTable_AIPISPIPTypeIndex.qbl

ÎļþÃû´Ó _Main/BL/Type_Global_MappingActualProductInStockingPointInPeriod/TypeIndex_MappingActualPISPIPTypeIndex.qbl ÐÞ¸Ä
@@ -1,6 +1,6 @@
Quintiq file version 2.0
#parent: #root
TypeIndex MappingActualPISPIPTypeIndex
TypeIndex GlobalOTDTable_AIPISPIPTypeIndex
{
  Attributes:
  [

 _Main/BL/Type_Global_MappingConversionFactor/TypeIndex_Global_MappingConversionFactorTypeIndex#123.qbl

ÎļþÃû´Ó _Main/BL/Type_Global_MappingConversionFactor/TypeIndex_TypeIndex.qbl ÐÞ¸Ä
@@ -1,6 +1,6 @@
Quintiq file version 2.0
#parent: #root
TypeIndex TypeIndex
TypeIndex Global_MappingConversionFactorTypeIndex
{
  Attributes:
  [

 _Main/BL/Type_Global_MappingCurrencyRate_MP/StaticMethod_CreateByAPI.qbl

@@ -37,5 +37,15 @@
                                                    Start      := guard( cnv2.Convert( datalist.Get( j ).Get( "start" ).GetString() ), Date::MinDate() )
                                                   );
    }
    
    globalOTDTable.Global_BrokerExecuteLog( relnew,
                                            BrokerName      := "",
                                            ElementTotal    := globalOTDTable.Global_MappingCurrencyRate_MP( relsize ),
                                            ErrorMessage    := "",
                                            IsSuccess       := true,
                                            Name            := "接口数据（货币汇率）",
                                            SuccessDateTime := DateTime::ActualTime().Format( "Y-M-D H2:m:s" ),
                                            ErrorNo         := 0
                                           );
  *]
}

 _Main/BL/Type_Global_MappingCurrency_MP/StaticMethod_CreateByAPI.qbl

@@ -34,5 +34,15 @@
                                                IsBase := guard( datalist.Get( j ).Get( "isbase" ).GetBoolean(), false )
                                               );
    }
    
    globalOTDTable.Global_BrokerExecuteLog( relnew,
                                            BrokerName      := "",
                                            ElementTotal    := globalOTDTable.Global_MappingCurrency_MP( relsize ),
                                            ErrorMessage    := "",
                                            IsSuccess       := true,
                                            Name            := "接口数据（货币）",
                                            SuccessDateTime := DateTime::ActualTime().Format( "Y-M-D H2:m:s" ),
                                            ErrorNo         := 0
                                           );
  *]
}

 _Main/BL/Type_Global_MappingCustomOrder/TypeIndex_GlobalOTDTable_CustomOrderTypeIndex.qbl

ÎļþÃû´Ó _Main/BL/Type_Global_MappingStockingPointCost/TypeIndex_NewTypeIndex.qbl ÐÞ¸Ä
@@ -1,6 +1,6 @@
Quintiq file version 2.0
#parent: #root
TypeIndex NewTypeIndex
TypeIndex GlobalOTDTable_CustomOrderTypeIndex
{
  Attributes:
  [

 _Main/BL/Type_Global_MappingCustomOrder/TypeIndex_TypeIndex.qbl

ÎļþÒÑɾ³ý

 _Main/BL/Type_Global_MappingForecast/TypeIndex_GlobalOTDTable_ForecastTypeIndex.qbl

ÎļþÃû´Ó _Main/BL/Type_Global_MappingForecast/TypeIndex_TypeIndex.qbl ÐÞ¸Ä
@@ -1,6 +1,6 @@
Quintiq file version 2.0
#parent: #root
TypeIndex TypeIndex
TypeIndex GlobalOTDTable_ForecastTypeIndex
{
  Attributes:
  [

 _Main/BL/Type_Global_MappingInventorySupply/TypeIndex_GlobalOTDTable_InventorySupplyTypeIndex.qbl

ÎļþÃû´Ó _Main/BL/Type_Global_MappingInventorySupply/TypeIndex_TypeIndex.qbl ÐÞ¸Ä
@@ -1,6 +1,6 @@
Quintiq file version 2.0
#parent: #root
TypeIndex TypeIndex
TypeIndex GlobalOTDTable_InventorySupplyTypeIndex
{
  Attributes:
  [

 _Main/BL/Type_Global_MappingLane/StaticMethod_CreateByAPI.qbl

@@ -35,5 +35,15 @@
                                         UserLeadTime := guard( datalist.Get( j ).Get( "userleadtime" ).GetString(), "" )
                                        );
    }
    
    globalOTDTable.Global_BrokerExecuteLog( relnew,
                                            BrokerName      := "",
                                            ElementTotal    := globalOTDTable.Global_MappingLane( relsize ),
                                            ErrorMessage    := "",
                                            IsSuccess       := true,
                                            Name            := "接口数据（车道）",
                                            SuccessDateTime := DateTime::ActualTime().Format( "Y-M-D H2:m:s" ),
                                            ErrorNo         := 0
                                           );
  *]
}

 _Main/BL/Type_Global_MappingLaneLeg/StaticMethod_CreateByAPI.qbl

@@ -36,5 +36,15 @@
                                            UserLeadTime               := guard( datalist.Get( j ).Get( "userleadtime" ).GetString(), "" )
                                           );
    }
    
    globalOTDTable.Global_BrokerExecuteLog( relnew,
                                            BrokerName      := "",
                                            ElementTotal    := globalOTDTable.Global_MappingLaneLeg( relsize ),
                                            ErrorMessage    := "",
                                            IsSuccess       := true,
                                            Name            := "接口数据（车道支架）",
                                            SuccessDateTime := DateTime::ActualTime().Format( "Y-M-D H2:m:s" ),
                                            ErrorNo         := 0
                                           );
  *]
}

 _Main/BL/Type_Global_MappingOperation/TypeIndex_GlobalOTDTable_OperationTypeIndex.qbl

ÎļþÃû´Ó _Main/BL/Type_Global_MappingOperation/TypeIndex_NewTypeIndex.qbl ÐÞ¸Ä
@@ -1,6 +1,6 @@
Quintiq file version 2.0
#parent: #root
TypeIndex NewTypeIndex
TypeIndex GlobalOTDTable_OperationTypeIndex
{
  Attributes:
  [

 _Main/BL/Type_Global_MappingOperationBOM/TypeIndex_GlobalOTDTable_OperationBOMTypeIndex.qbl

ÎļþÃû´Ó _Main/BL/Type_Global_MappingOperationBOM/TypeIndex_TypeIndex.qbl ÐÞ¸Ä
@@ -1,6 +1,6 @@
Quintiq file version 2.0
#parent: #root
TypeIndex TypeIndex
TypeIndex GlobalOTDTable_OperationBOMTypeIndex
{
  Attributes:
  [

 _Main/BL/Type_Global_MappingProductInLane/TypeIndex_GlobalOTDTable_ProductInLaneTypeIndex.qbl

ÎļþÃû´Ó _Main/BL/Type_Global_MappingProductInLane/TypeIndex_TypeIndex.qbl ÐÞ¸Ä
@@ -1,6 +1,6 @@
Quintiq file version 2.0
#parent: #root
TypeIndex TypeIndex
TypeIndex GlobalOTDTable_ProductInLaneTypeIndex
{
  Attributes:
  [

 _Main/BL/Type_Global_MappingStockingPointCost/TypeIndex_GlobalOTDTable_StockingPointCostTypeIndex.qbl

copy from _Main/BL/Type_Global_MappingStockingPointCost/TypeIndex_NewTypeIndex.qbl
copy to _Main/BL/Type_Global_MappingStockingPointCost/TypeIndex_GlobalOTDTable_StockingPointCostTypeIndex.qbl
Îļþ´Ó _Main/BL/Type_Global_MappingStockingPointCost/TypeIndex_NewTypeIndex.qbl ¸´ÖÆ
@@ -1,6 +1,6 @@
Quintiq file version 2.0
#parent: #root
TypeIndex NewTypeIndex
TypeIndex GlobalOTDTable_StockingPointCostTypeIndex
{
  Attributes:
  [

 _Main/BL/Type_Global_MappingStockingPoint_MP/StaticMethod_CreateByAPI.qbl

@@ -34,5 +34,15 @@
                                                     UnitID := guard( datalist.Get( j ).Get( "unitid" ).GetString(), "" )
                                                    );
    }
    
    globalOTDTable.Global_BrokerExecuteLog( relnew,
                                            BrokerName      := "",
                                            ElementTotal    := globalOTDTable.Global_MappingStockingPoint_MP( relsize ),
                                            ErrorMessage    := "",
                                            IsSuccess       := true,
                                            Name            := "接口数据（库存点）",
                                            SuccessDateTime := DateTime::ActualTime().Format( "Y-M-D H2:m:s" ),
                                            ErrorNo         := 0
                                           );
  *]
}

 _Main/BL/Type_Global_MappingUnitCost/TypeIndex_GlobalOTDTable_OperationCostTypeIndex.qbl

copy from _Main/BL/Type_Global_MappingStockingPointCost/TypeIndex_NewTypeIndex.qbl
copy to _Main/BL/Type_Global_MappingUnitCost/TypeIndex_GlobalOTDTable_OperationCostTypeIndex.qbl
Îļþ´Ó _Main/BL/Type_Global_MappingStockingPointCost/TypeIndex_NewTypeIndex.qbl ¸´ÖÆ
@@ -1,6 +1,6 @@
Quintiq file version 2.0
#parent: #root
TypeIndex NewTypeIndex
TypeIndex GlobalOTDTable_OperationCostTypeIndex
{
  Attributes:
  [

 _Main/BL/Type_Global_MappingUnitCost/TypeIndex_TypeIndex.qbl

ÎļþÒÑɾ³ý