冲减

yunchai

2023-09-18 a279329b095994eaa37a40ff075d927777a18c64

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
Quintiq file version 2.0
#parent: #root
EDIBroker Broker_OTD_BaseConversionFactor
{
  MDSDefinition: MacroPlan
  TimeZone: 'ACT'
  UseOSTimeZone: false
  EDIModelLink.Destination Des_BaseConversionFactor
  {
    EDIMLTable MappingBaseConversionFactor
    {
      PrimaryKeyColumns: IsEnabled
      PrimaryKeyColumns: ProductId
      PrimaryKeyColumns: SourceUnitOfMeasureName
      PrimaryKeyColumns: TargetUnitOfMeasureName
      TargetType: MappingBaseConversionFactor
      TypeIndex: MappingBaseConversionFactorTypeIndex
      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 MID_BaseConversionFactor
  {
    DataIntegrityStrategy: 'Disabled'
    SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.oracle'
    EDIODBCLinkTable MID_BASECONVERSIONFACTORS
    {
      OthersMayCreateTable: true
      OthersMayDeleteRow: true
      OthersMayDropTable: true
      OthersMayFlushTable: true
      OthersMayInsertRow: true
      Parameters: '/owner="YUXTEST"'
      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 TransformationBaseConversionFactor
  {
    EDITableTransformation
    {
      InputTable: MID_BASECONVERSIONFACTORS
      OutputTable: MappingBaseConversionFactor
      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 }
    }
  }
}