Startseite Erkunden Hilfe
Registrieren Anmelden
AnalytikDataPRiME
/
GeMIS_WEB
3
0
Fork 0
Dateien Issues 0 Pull-Requests 0 Wiki
Branch: master
Branches Tags
GeMIS_WEB
/
GUI
/
incl
/
cocacola_ds.i

cocacola_ds.i 5.7 KB
Permalink Verlauf Originalformat

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191 
  1. 

  2. DEFINE TEMP-TABLE Payload NO-UNDO
    3. 

  3. 	FIELD StructureVersion AS CHARACTER 
    4. 

  4. 		XML-NODE-TYPE "ATTRIBUTE" 
    5. 

  5. 	FIELD Comments AS CHARACTER 
    6. 

  6. 		XML-NODE-TYPE "ATTRIBUTE" 
    7. 

  7. 	FIELD WholesalerID AS CHARACTER 
    8. 

  8. 		XML-NODE-TYPE "ATTRIBUTE" 
    9. 

  9. 	FIELD Payload_id AS RECID 
    10. 

  10. 		XML-NODE-TYPE "HIDDEN" .
    11. 

  11. 

  12. DEFINE TEMP-TABLE Period NO-UNDO
    13. 

  13. 	FIELD PeriodType AS CHARACTER 
    14. 

  14. 		XML-NODE-TYPE "ATTRIBUTE" 
    15. 

  15. 	FIELD DateFrom AS CHAR
    16. 

  16. 		XML-NODE-TYPE "ATTRIBUTE" 
    17. 

  17. 	FIELD DateTo AS CHAR 
    18. 

  18. 		XML-NODE-TYPE "ATTRIBUTE" 
    19. 

  19. 	FIELD TotalRecordsCount AS DECIMAL 
    20. 

  20. 		DECIMALS 0 
    21. 

  21. 		XML-DATA-TYPE "integer" XML-NODE-TYPE "ATTRIBUTE" 
    22. 

  22. 	FIELD TotalVolume AS DECIMAL 
    23. 

  23. 		XML-NODE-TYPE "ATTRIBUTE" 
    24. 

  24. 	FIELD PeriodNumber AS DECIMAL 
    25. 

  25. 		DECIMALS 0 
    26. 

  26. 		XML-DATA-TYPE "integer" XML-NODE-TYPE "ATTRIBUTE" 
    27. 

  27. 	FIELD Comments AS CHARACTER 
    28. 

  28. 		XML-NODE-TYPE "ATTRIBUTE" 
    29. 

  29. 	FIELD Payload_id AS RECID 
    30. 

  30. 		XML-NODE-TYPE "HIDDEN" 
    31. 

  31. 	FIELD Period_id AS RECID 
    32. 

  32. 		XML-NODE-TYPE "HIDDEN" .
    33. 

  33. 

  34. DEFINE TEMP-TABLE Outlets NO-UNDO
    35. 

  35. 	FIELD Comments AS CHARACTER 
    36. 

  36. 		XML-NODE-TYPE "HIDDEN" 
    37. 

  37. 	FIELD Payload_id AS RECID 
    38. 

  38. 		XML-NODE-TYPE "HIDDEN" 
    39. 

  39. 	FIELD Period_id AS RECID 
    40. 

  40. 		XML-NODE-TYPE "HIDDEN" 
    41. 

  41. 	FIELD Outlets_id AS RECID 
    42. 

  42. 		XML-NODE-TYPE "HIDDEN" .
    43. 

  43. 

  44. DEFINE TEMP-TABLE OutletEntry NO-UNDO
    45. 

  45. 	FIELD Comments AS CHARACTER 
    46. 

  46. 		XML-NODE-TYPE "HIDDEN" 
    47. 

  47. 	FIELD Outlets_id AS RECID 
    48. 

  48. 		XML-NODE-TYPE "HIDDEN"
    49. 

  49. 	FIELD OutletEntry_id AS RECID 
    50. 

  50. 		XML-NODE-TYPE "HIDDEN" .
    51. 

  51. 

  52. DEFINE TEMP-TABLE DeliverTo NO-UNDO
    53. 

  53. 	FIELD OutletNumber AS CHARACTER 
    54. 

  54. 	FIELD Name1 AS CHARACTER 
    55. 

  55. 	FIELD Name2 AS CHARACTER 
    56. 

  56. 	FIELD ContactPerson AS CHARACTER 
    57. 

  57. 	FIELD Address1 AS CHARACTER 
    58. 

  58. 	FIELD Address2 AS CHARACTER 
    59. 

  59. 	FIELD PostalCode AS CHARACTER 
    60. 

  60. 	FIELD City AS CHARACTER 
    61. 

  61. 	FIELD Telephone1 AS CHARACTER 
    62. 

  62. 	FIELD Telephone2 AS CHARACTER 
    63. 

  63. 	FIELD Fax AS CHARACTER 
    64. 

  64. 	FIELD Email AS CHARACTER 
    65. 

  65. 	FIELD VatNumber AS CHARACTER 
    66. 

  66. 	FIELD KeyAccount AS CHARACTER 
    67. 

  67. 	FIELD Channel AS CHARACTER 
    68. 

  68. 	FIELD OutletEntry_id AS RECID 
    69. 

  69. 		XML-NODE-TYPE "HIDDEN"
    70. 

  70. 	FIELD DeliverTo_Id AS RECID 
    71. 

  71. 		XML-NODE-TYPE "HIDDEN"
    72. 

  72. 		
    73. 

  73.        INDEX DeliverTo-k1 IS PRIMARY
    74. 

  74.             OutletNumber.
    75. 

  75. 

  76. DEFINE TEMP-TABLE BillTo NO-UNDO
    77. 

  77. 	FIELD OutletNumber AS CHARACTER 
    78. 

  78. 	FIELD Name1 AS CHARACTER 
    79. 

  79. 	FIELD Name2 AS CHARACTER 
    80. 

  80. 	FIELD ContactPerson AS CHARACTER 
    81. 

  81. 	FIELD Address1 AS CHARACTER 
    82. 

  82. 	FIELD Address2 AS CHARACTER 
    83. 

  83. 	FIELD PostalCode AS CHARACTER 
    84. 

  84. 	FIELD City AS CHARACTER 
    85. 

  85. 	FIELD Telephone1 AS CHARACTER 
    86. 

  86. 	FIELD Telephone2 AS CHARACTER 
    87. 

  87. 	FIELD Fax AS CHARACTER 
    88. 

  88. 	FIELD Email AS CHARACTER 
    89. 

  89. 	FIELD VatNumber AS CHARACTER 
    90. 

  90. 	FIELD KeyAccount AS CHARACTER 
    91. 

  91. 	FIELD Channel AS CHARACTER 
    92. 

  92. 	FIELD DeliverTo_id AS RECID 
    93. 

  93. 		XML-NODE-TYPE "HIDDEN" 
    94. 

  94. 	FIELD OutletEntry_id AS RECID 
    95. 

  95. 		XML-NODE-TYPE "HIDDEN" .
    96. 

  96. 

  97. DEFINE TEMP-TABLE Sales NO-UNDO
    98. 

  98. 	FIELD TransactionType AS CHARACTER 
    99. 

  99. 		XML-NODE-TYPE "ATTRIBUTE" 
    100. 

  100. 	FIELD Period_id AS RECID 
    101. 

  101. 		XML-NODE-TYPE "HIDDEN" 
    102. 

  102. 	FIELD Sales_id AS RECID 
    103. 

  103. 		XML-NODE-TYPE "HIDDEN" .
    104. 

  104. 

  105. DEFINE TEMP-TABLE Transaction1 NO-UNDO
    106. 

  106. 	XML-NODE-NAME "Transaction" 
    107. 

  107. 	FIELD Comments AS CHARACTER 
    108. 

  108. 		XML-NODE-TYPE "ATTRIBUTE" 
    109. 

  109. 	FIELD OutletNumber AS CHARACTER 
    110. 

  110. 	FIELD DeliveryDate AS CHAR 
    111. 

  111. 	FIELD OrderNumberHbc AS CHARACTER 
    112. 

  112. 	FIELD InvoiceNumber AS CHARACTER 
    113. 

  113. 	FIELD Sales_id AS RECID 
    114. 

  114. 		XML-NODE-TYPE "HIDDEN" 
    115. 

  115. 	FIELD Transaction_id AS RECID 
    116. 

  116. 		XML-NODE-TYPE "HIDDEN" .
    117. 

  117. 

  118. DEFINE TEMP-TABLE TransactionDetails NO-UNDO
    119. 

  119. 	FIELD ProductNumber AS CHARACTER 
    120. 

  120. 	FIELD Quantity AS DECIMAL 
    121. 

  121. 	FIELD Price AS DECIMAL 
    122. 

  122. 	FIELD Transaction_id AS RECID 
    123. 

  123. 		XML-NODE-TYPE "HIDDEN" 
    124. 

  124. 	FIELD TransactionDetails_id AS RECID 
    125. 

  125. 		XML-NODE-TYPE "HIDDEN" .
    126. 

  126. 

  127. DEFINE TEMP-TABLE Products NO-UNDO
    128. 

  128. 	FIELD Period_id AS RECID 
    129. 

  129. 		XML-NODE-TYPE "HIDDEN" 
    130. 

  130. 	FIELD Products_id AS RECID 
    131. 

  131. 		XML-NODE-TYPE "HIDDEN" .
    132. 

  132. 

  133. DEFINE TEMP-TABLE ProductEntry NO-UNDO
    134. 

  134. 	FIELD Comments AS CHARACTER 
    135. 

  135. 		XML-NODE-TYPE "ATTRIBUTE" 
    136. 

  136. 	FIELD ProductNumber AS CHARACTER 
    137. 

  137. 	FIELD ProductName AS CHARACTER 
    138. 

  138. 	FIELD UnitOfQuantity AS CHARACTER 
    139. 

  139. 	FIELD ArticleNameHbc AS CHARACTER 
    140. 

  140. 	FIELD ArticleNumberHbc AS CHARACTER 
    141. 

  141. 	FIELD EanConsumerUnit AS CHARACTER 
    142. 

  142. 	FIELD EanMultipack AS CHARACTER 
    143. 

  143. 	FIELD EanTradeUnit AS CHARACTER 
    144. 

  144. 	FIELD ProductRemarks AS CHARACTER 
    145. 

  145. 	FIELD PurchasePrice AS DECIMAL 
    146. 

  146. 	FIELD PackageSizeLitres AS DECIMAL 
    147. 

  147. 	FIELD SalesUnit AS CHARACTER 
    148. 

  148. 	FIELD PackageType AS CHARACTER 
    149. 

  149. 	FIELD Subunits AS CHARACTER 
    150. 

  150. 	FIELD Products_id AS RECID 
    151. 

  151. 		XML-NODE-TYPE "HIDDEN" 
    152. 

  152. 	FIELD ProductEntry_id AS RECID 
    153. 

  153. 		XML-NODE-TYPE "HIDDEN" .
    154. 

  154. 

  155. DEFINE DATASET PayloadDS  
    156. 

  156. /* 	FOR Payload, Period, Outlets, OutletEntry, DeliverTo, BillTo, Products, ProductEntry, Sales, Transaction1, TransactionDetails */
    157. 

  157. 	FOR Payload, Period, Outlets, OutletEntry, DeliverTo, Products, ProductEntry, Sales, Transaction1, TransactionDetails
    158. 

  158. 	
    159. 

  159. 	DATA-RELATION RELATION1 FOR Payload, Period
    160. 

  160. 		RELATION-FIELDS (Payload_id, Payload_id) NESTED
    161. 

  161. 		
    162. 

  162. 	DATA-RELATION RELATION2 FOR Period, Outlets
    163. 

  163. 		RELATION-FIELDS (Payload_id,Payload_id, Period_id, Period_id) NESTED
    164. 

  164. 		
    165. 

  165. 	DATA-RELATION RELATION3 FOR Outlets, OutletEntry
    166. 

  166. 		RELATION-FIELDS (Outlets_id, Outlets_id) NESTED
    167. 

  167. 		
    168. 

  168. 	DATA-RELATION RELATION4 FOR OutletEntry, DeliverTo
    169. 

  169. 		RELATION-FIELDS (OutletEntry_Id, OutletEntry_id) NESTED
    170. 

  170. 		
    171. 

  171. /* 	DATA-RELATION RELATION5 FOR OutletEntry, BillTo */
    172. 

  172. /* 		RELATION-FIELDS  (OutletEntry_Id, OutletEntry_id) */
    173. 

  173. /* 	DATA-RELATION RELATION5 FOR DeliverTo, BillTo */
    174. 

  174. /* 		RELATION-FIELDS  (OutletEntry_Id, OutletEntry_id, DeliverTo_Id, DeliverTo_Id ) NESTED */
    175. 

  175. 		
    176. 

  176. 	DATA-RELATION RELATION6 FOR Period, Sales
    177. 

  177. 		RELATION-FIELDS (Period_id, Period_id) NESTED
    178. 

  178. 		
    179. 

  179. 	DATA-RELATION RELATION7 FOR Sales, Transaction1
    180. 

  180. 		RELATION-FIELDS (Sales_Id, Sales_id) NESTED
    181. 

  181. 		
    182. 

  182. 	DATA-RELATION RELATION8 FOR Transaction1, TransactionDetails
    183. 

  183. 		RELATION-FIELDS (Transaction_id, Transaction_id) NESTED
    184. 

  184. 		
    185. 

  185. 	DATA-RELATION RELATION9 FOR Period, Products
    186. 

  186. 		RELATION-FIELDS (Period_id, Period_id) NESTED
    187. 

  187. 

  188. 	DATA-RELATION RELATION10 FOR Products, ProductEntry
    189. 

  189. 		RELATION-FIELDS (Products_id, Products_id) NESTED.
    190. 

  190. 		
    191. 

  191. 		
    192.