yanweiyuan3
2023-08-09 588bc7829387dfc761cc25f06f77d4c81818bd10
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
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
Quintiq file version 2.0
#parent: #root
EDIBroker MPSync_ImportCurrenciesFromDBBroker
{
  MDSDefinition: MPSync
  EDIModelLink.Destination MPSync_DestinationCurrenciesForImport
  {
    EDIMLTable IOCurrencyRate_MP
    {
      PrimaryKeyColumns: CurrencyID
      PrimaryKeyColumns: Start
      SoftDeleteAttribute: IsSoftDeleted
      TargetType: IOCurrencyRate_MP
      TypeIndex: IOCurrencyRateTypeIndex
      WithSoftDelete: true
      EDIMLColumn CurrencyID { Attribute: CurrencyID ValueType: String }
      EDIMLColumn Rate { Attribute: Rate ValueType: Real }
      EDIMLColumn Start { Attribute: Start ValueType: Date }
    }
    EDIMLTable IOCurrency_MP
    {
      PrimaryKeyColumns: ID
      SoftDeleteAttribute: IsSoftDeleted
      TargetType: IOCurrency_MP
      TypeIndex: IOCurrencyTypeIndex
      WithSoftDelete: true
      EDIMLColumn ID { Attribute: ID ValueType: String }
      EDIMLColumn IsBase { Attribute: IsBase ValueType: Boolean }
      EDIMLColumn Name { Attribute: Name ValueType: String }
      EDIMLColumn Symbol { Attribute: Symbol ValueType: String }
    }
  }
  EDIODBCLink.Source MPSync_SourceCurrenciesForImport
  {
    DataIntegrityStrategy: 'Disabled'
    SettingsEngineLink: 'domainmodel.ediremotedatasourcedefinition.remotestorage.syncobject'
    EDIODBCLinkTable Currencies
    {
      OthersMayCreateTable: true
      OthersMayDeleteRow: true
      OthersMayDropTable: true
      OthersMayFlushTable: true
      OthersMayInsertRow: true
      Parameters: '/owner="dbo"'
      PrimaryKeyColumns: ID
      RecordModificationHintStrategy: 'None'
      EDIODBCLinkColumn ID
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn IsBase
      {
        ValueType: Boolean
      }
      EDIODBCLinkColumn Name
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn Symbol
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
    }
    EDIODBCLinkTable CurrencyRates
    {
      OthersMayCreateTable: true
      OthersMayDeleteRow: true
      OthersMayDropTable: true
      OthersMayFlushTable: true
      OthersMayInsertRow: true
      Parameters: '/owner="dbo"'
      PrimaryKeyColumns: CurrencyID
      PrimaryKeyColumns: Start
      RecordModificationHintStrategy: 'None'
      EDIODBCLinkColumn CurrencyID
      {
        OthersMayUpdateColumn: true
        ValueType: String
      }
      EDIODBCLinkColumn Rate
      {
        OthersMayUpdateColumn: true
        ValueType: Real
      }
      EDIODBCLinkColumn Start
      {
        OthersMayUpdateColumn: true
        ValueType: DateTime
      }
    }
  }
  EDITransformation.Transformation MPSync_TransformationCurrenciesForImport
  {
    EDITableTransformation
    {
      InputTable: Currencies
      OutputTable: IOCurrency_MP
      EDIColumnMatch { InputColumn: IsBase OutputColumn: IsBase }
      EDIColumnMatch
      {
        InputColumn: Name
        OutputColumn: Name
      }
      EDIColumnMatch
      {
        InputColumn: ID
        OutputColumn: ID
      }
      EDIColumnMatch
      {
        InputColumn: Symbol
        OutputColumn: Symbol
      }
    }
    EDITableTransformation
    {
      InputTable: CurrencyRates
      OutputTable: IOCurrencyRate_MP
      EDIColumnMatch
      {
        InputColumn: CurrencyID
        OutputColumn: CurrencyID
      }
      EDIColumnMatch
      {
        InputColumn: Start
        OutputColumn: Start
        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: Rate
        OutputColumn: Rate
      }
    }
  }
}