Kevin Kok Khah Whey
2023-10-12 e7c56c4676e153f0af05083b1f5ab0ed73d4b2c3
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
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 }
    }
  }
}