Version 19.1 by Robin Huisman on 2024/04/03 17:39

Show last authors
1 = Creating a Delivery file and binding them to a customer =
2
3 This chapter contains the information needed to understand the lab delivery file. A Lab delivery file only has to be updated when there are changes. Otherwise TerraIndex will always show the last imported file.
4
5 {{warning}}
6 Latest version can be found here: [[https:~~/~~/www.sikb.nl/datastandaarden/sikb0101-bodembeheer>>url:https://www.sikb.nl/datastandaarden/sikb0101-bodembeheer]]
7 {{/warning}}
8
9 == What is a lab delivery file ==
10
11 A lab delivery file contains the Customer code of the customer that will be sending the lab assignment. It also contains the analyses that can be requested from the a lab by the customer. A Lab delivery file needs to be custom for every user and needs to be a XML file
12
13 **Example files**:  [[attach:Labdeliveryfile.xml||rel=" noopener noreferrer" target="_blank"]]
14
15 **XSD**:  [[attach:LabDelivery_v14.8.0.xsd||rel=" noopener noreferrer" target="_blank"]]
16
17 **Domaintable files**:  [[immetingen lookup v14.8.0.xml>>url:https://wiki.terraindex.com/bin/download/Implementation%20documentation/Setting%20up%20Lab%20communication%20by%20REST%20services%20with%20TerraIndex/Lab%20assignment%20file/WebHome/immetingen%20lookup%20v14.8.0.xml?rev=1.2]]   [[imsikb0101 lookup v14.8.0.xml>>url:https://wiki.terraindex.com/bin/download/Implementation%20documentation/Setting%20up%20Lab%20communication%20by%20REST%20services%20with%20TerraIndex/Lab%20assignment%20file/WebHome/imsikb0101%20lookup%20v14.8.0.xml?rev=1.1]]
18 extracted from: **[[https:~~/~~/codes.sikb.nl>>url:https://codes.sikb.nl/]] **
19
20
21 == File structure ==
22
23 In the image below the main structure of the XML file is shown. Every table is described in more detail later on in this chapter.
24 [[image:1712157446270-966.png]]
25
26 (% class="table-hover" %)
27 |(% colspan="1" rowspan="1" %)**Attribute name**|(% colspan="1" rowspan="1" %)**Description**|(% colspan="1" rowspan="1" %)**Unit**
28 |(% colspan="1" rowspan="1" %)**version**|(% colspan="1" rowspan="1" %)SIKB version. This must be: **14.8.0**|(% colspan="1" rowspan="1" %)string
29 |(% colspan="1" %)**versionDeliveryData**|(% colspan="1" %)A lab indication of the version of the delivered data for this user. Could be a generation date with version: '12-7-2024' or a version 'v12.1'|(% colspan="1" %)string
30 |(% colspan="1" rowspan="1" %)**laboratory**|(% colspan="1" rowspan="1" %)A number given by SIKB/TerraIndex to the lab when requesting to connect to TerraIndex
31 [[Domaintable: Meetinstantie>>https://codes.sikb.nl/tablet/domain-table-details/4e270f0a-cefe-446e-9d4d-6666c91180a8]]|(% colspan="1" rowspan="1" %)integer
32 |(% colspan="1" rowspan="1" %)**language**|(% colspan="1" rowspan="1" %)(((
33 The language of the Delivery file content, like the package names, urgencies etc, in a three-letter ISO-639-2 code:
34
35 - dut = Dutch
36 - eng = English
37 - fra = French
38 - spa = Spanish
39 - ita = Italian
40 - deu = German
41 )))|(% colspan="1" rowspan="1" %)string
42 |(% colspan="1" rowspan="1" %)**Links**|(% colspan="1" rowspan="1" %)A table to connect the “AnalysisSet” and the “Clients”|(% colspan="1" rowspan="1" %)-
43 |(% colspan="1" rowspan="1" %)**AnalysisSets**|(% colspan="1" rowspan="1" %)A table containing the name and lab code of analysis set|(% colspan="1" rowspan="1" %)-
44 |(% colspan="1" rowspan="1" %)**Categories**|(% colspan="1" rowspan="1" %)A table containing all the possible lab categories|(% colspan="1" rowspan="1" %)-
45 |(% colspan="1" rowspan="1" %)**AnalysisLinks**|(% colspan="1" rowspan="1" %)A table containing all the analyses for an analysis set|(% colspan="1" rowspan="1" %)-
46 |(% colspan="1" rowspan="1" %)**Clients**|(% colspan="1" rowspan="1" %)A table of all the customer codes that are available for the company|(% colspan="1" rowspan="1" %)-
47 |(% colspan="1" rowspan="1" %)**LabSampleMatrices**|(% colspan="1" rowspan="1" %)A table of all the Lab sample Matrices a lab would like to have selectable.|(% colspan="1" rowspan="1" %)-
48 |(% colspan="1" rowspan="1" %)**SpecialAppointments**|(% colspan="1" rowspan="1" %)A table of all the special price agreements besides the default quote.|(% colspan="1" %)-
49 |(% colspan="1" rowspan="1" %)**Urgencies**|(% colspan="1" rowspan="1" %)A table containing a list of time frames in which the lab results need to be returned|(% colspan="1" %)-
50 |(% colspan="1" rowspan="1" %)StoragePeriods|(% colspan="1" rowspan="1" %)-not in use-|(% colspan="1" rowspan="1" %)
51 |(% colspan="1" rowspan="1" %)Reports|(% colspan="1" rowspan="1" %)-not in use-|(% colspan="1" rowspan="1" %)
52 |(% colspan="1" rowspan="1" %)FractionLinks|(% colspan="1" rowspan="1" %)-not in use-|(% colspan="1" rowspan="1" %)
53
54 == Structure explanation analysepakketten ==
55
56 This table contains all the analyses packages that your lab supports. The “analysepakketcode” is your own identification code for the analysis packages.
57
58 (% style="text-align:center" %)
59 [[image:1637578642613-182.png]]
60
61 (% class="table-hover" %)
62 |(% colspan="1" rowspan="1" %)**Attribute name**|(% colspan="1" rowspan="1" %)**Description**|(% colspan="1" rowspan="1" %)**Unit**
63 |(% colspan="1" rowspan="1" %)**analysepakketcode**|(% colspan="1" rowspan="1" %)The identification code of the lab for their analysis package code|(% colspan="1" rowspan="1" %)string
64 |(% colspan="1" rowspan="1" %)**omschrijving**|(% colspan="1" rowspan="1" %)The name/description of the analysis package (This will also be shown in the user interface)|(% colspan="1" rowspan="1" %)string
65 |(% colspan="1" rowspan="1" %)**volgorde**|(% colspan="1" rowspan="1" %)Field is redundant and does not have to be filled in|(% colspan="1" rowspan="1" %)string
66
67 == Structure explanation categorieen ==
68
69 “Categorie” does not need a lot of explanation. A category is a group defined by the lab where certain values in the “koppeltabel” can be grouped under. A category is determined by the lab and can be used in the “koppeltabel”
70
71 (% style="text-align:center" %)
72 [[image:1637578815582-615.png]]
73
74 (% class="table-hover" %)
75 |(% colspan="1" rowspan="1" %)**Attribute name**|(% colspan="1" rowspan="1" %)**Description**|(% colspan="1" rowspan="1" %)**Unit**
76 |(% colspan="1" rowspan="1" %)**Categoriecode**|(% colspan="1" rowspan="1" %)The category code of the category of the lab|(% colspan="1" rowspan="1" %)string
77 |(% colspan="1" rowspan="1" %)**Omschrijving**|(% colspan="1" rowspan="1" %)The name/description of the category (This will also be shown in the user interface)|(% colspan="1" rowspan="1" %)string
78 |(% colspan="1" rowspan="1" %)**volgorde**|(% colspan="1" rowspan="1" %)Field is redundant and does not have to be filled in|(% colspan="1" rowspan="1" %)integer
79
80 == Analysetabel ==
81
82 This table contains all the analyses that a analyses package can contain. Be sure the “analysepakketcode” corresponds to a code in the table: “analysepakketten”. The analysecode is your own identification code for the analyses.
83
84 (% style="text-align:center" %)
85 [[image:1637578915565-695.png]]
86
87 (% class="table-hover" %)
88 |(% colspan="1" rowspan="1" %)**Attribute name**|(% colspan="1" rowspan="1" %)**Description**|(% colspan="1" rowspan="1" %)**Unit**
89 |(% colspan="1" rowspan="1" %)**Analysepakketcode**|(% colspan="1" rowspan="1" %)The analyse package code that corresponds to a code in the “//analysepakketten//”|(% colspan="1" rowspan="1" %)string
90 |(% colspan="1" rowspan="1" %)**Analyse**|(% colspan="1" rowspan="1" %)A table containing ale the analyses that should be in this analysis package|(% colspan="1" rowspan="1" %)-
91 |(% colspan="1" rowspan="1" %)**Analyse > analysecode**|(% colspan="1" rowspan="1" %)The identification code of the lab for the analyses|(% colspan="1" rowspan="1" %)string
92 |(% colspan="1" rowspan="1" %)**Analyse > omschrijving**|(% colspan="1" rowspan="1" %)The name\description of the analysis (This will also be shown in the user interface)|(% colspan="1" rowspan="1" %)string
93
94 == Structure explanation debiteurtabel ==
95
96 A customer can have multiple “debiteuren”. There always needs to be one “debiteur” so that a lab assignment can be send. But for example when there is a price agreement for a certain project a new “debiteur” can be added. Or when a company has multiple offices every office can have its own “debiteur”
97
98 (% style="text-align:center" %)
99 [[image:1637578988501-147.png]]
100
101 |(% colspan="1" rowspan="1" %)**Attribute name**|(% colspan="1" rowspan="1" %)**Description**|(% colspan="1" rowspan="1" %)**Unit**
102 |(% colspan="1" rowspan="1" %)**klantcode**|(% colspan="1" rowspan="1" %)The customer code(s) for the company|(% colspan="1" rowspan="1" %)string
103 |(% colspan="1" rowspan="1" %)**omschrijving**|(% colspan="1" rowspan="1" %)De name\description of the customer code|(% colspan="1" rowspan="1" %)string
104
105 == Structure explanation koppeltabel ==
106
107 The “koppeltabel” is one of the most important sections of the XML. The “koppeltabel” defines the combination of Analysespackages, custeromcode, categories and sampletype. Without a combination in this table a customer will not be able to send in lab assignments to the laboratory.
108
109 (% style="text-align:center" %)
110 [[image:1637579085996-197.png]]
111
112 (% class="table-hover" %)
113 |(% colspan="1" rowspan="1" %)**Attribute name**|(% colspan="1" rowspan="1" %)**Description**|(% colspan="1" rowspan="1" %)**unit**
114 |(% colspan="1" rowspan="1" %)**Analysepakketcode**|(% colspan="1" rowspan="1" %)The analysepackagecode that corresponds to a code in the analysepakket|(% colspan="1" rowspan="1" %)string
115 |(% colspan="1" rowspan="1" %)**klantcode**|(% colspan="1" rowspan="1" %)A code that corresponds to a code in debiteuren|(% colspan="1" rowspan="1" %)string
116 |(% colspan="1" rowspan="1" %)**monstersoort**|(% colspan="1" rowspan="1" %)An SIKB code that determins to which matrix the analyses belongs. Sampletype
117 Codegroup 51 in the Attachments for all possible codes|(% colspan="1" rowspan="1" %)(((
118 integer
119
120
121 )))
122 |(% colspan="1" rowspan="1" %)**categoriecode**|(% colspan="1" rowspan="1" %)A code that corresponds to a category code in “//categorie//”|(% colspan="1" rowspan="1" %)string
123
124 == Structure explanation urgentietabel ==
125
126 This table contains a list with different delivery times for analyses results. For example 5 work days, overnight, within 48 hours and so on. The “urgentie code” is a code given by the lab.
127
128 (% style="text-align:center" %)
129 [[image:1637579214994-369.png]]
130
131 (% class="table-hover" %)
132 |(% colspan="1" rowspan="1" %)**Attribute name**|(% colspan="1" rowspan="1" %)**Description**|(% colspan="1" rowspan="1" %)**Unit**
133 |(% colspan="1" rowspan="1" %)**urgentiecode**|(% colspan="1" rowspan="1" %)The code of the lab for when the analysis results need to be returned to the customer|(% colspan="1" rowspan="1" %)string
134 |(% colspan="1" rowspan="1" %)**omschrijving**|(% colspan="1" rowspan="1" %)The name/ description of the urgentie|(% colspan="1" rowspan="1" %)string
135
136 == Column mapping from Dutch to English ==
137
138 In the table below all the keys in the example XML with are shown their English counterparts from the XSD. The colours correspond to the parent. For example. DeliveryData has children that is why this one is coloured dark red in the English column and also coloured dark red in the left column.
139
140 (% cellpadding="1" cellspacing="0" style="page-break-before:always; width:374px" %)
141 |(% style="background-color:#70ad47; background:#70ad47" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**Parent English**|(% style="background-color:#70ad47; background:#70ad47" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**Dutch**|(% style="background-color:#70ad47; background:#70ad47" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**English**
142 |(% style="background-color:#e2efd9; background:#e2efd9" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**-**|(% style="background-color:#e2efd9; background:#e2efd9" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)labaanlevering|(% style="background-color:#c00000; background:#c00000" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**DeliveryData**
143 |(% style="background-color:#c00000; background:#c00000" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**DeliveryData**|(% style="border-style:none; padding:0in" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)versie|(% style="border-style:none; padding:0in" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)Version
144 |(% style="background-color:#c00000; background:#c00000" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**DeliveryData**|(% style="background-color:#e2efd9; background:#e2efd9" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)kenmerk|(% style="background-color:#e2efd9; background:#e2efd9" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)versionDeliveryData
145 |(% style="background-color:#c00000; background:#c00000" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**DeliveryData**|(% style="border-style:none; padding:0in" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)laboratorium|(% style="background-color:#ffffff; background:#ffffff" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)Laboratory
146 |(% style="background-color:#c00000; background:#c00000" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**DeliveryData**|(% style="background-color:#e2efd9; background:#e2efd9" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)taal|(% style="background-color:#e2efd9; background:#e2efd9" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)Language
147 |(% style="background-color:#c00000; background:#c00000" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**DeliveryData**|(% style="border-style:none; padding:0in" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)koppeltabel|(% style="background-color:#ed7d31; background:#ed7d31" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**Links**
148 |(% style="background-color:#c00000; background:#c00000" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**DeliveryData**|(% style="background-color:#e2efd9; background:#e2efd9" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)analysepakketten|(% style="background-color:#ed7d31; background:#ed7d31" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**analysesSets**
149 |(% style="background-color:#c00000; background:#c00000" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**DeliveryData**|(% style="border-style:none; padding:0in" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)Categorieen|(% style="background-color:#ed7d31; background:#ed7d31" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**Categories**
150 |(% style="background-color:#c00000; background:#c00000" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**DeliveryData**|(% style="background-color:#e2efd9; background:#e2efd9" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)Analysetabel|(% style="background-color:#ed7d31; background:#ed7d31" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**AnalysisSets**
151 |(% style="background-color:#c00000; background:#c00000" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**DeliveryData**|(% style="border-style:none; padding:0in" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)Debiteurtabel|(% style="background-color:#ed7d31; background:#ed7d31" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**Clients**
152 |(% style="background-color:#c00000; background:#c00000" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**DeliveryData**|(% style="background-color:#e2efd9; background:#e2efd9" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)urgentietabel|(% style="background-color:#ed7d31; background:#ed7d31" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**urgencies**
153 |(% style="background-color:#ed7d31; background:#ed7d31" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**Links**|(% style="border-style:none; padding:0in" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)Koppeling|(% style="background-color:#ffe7e7; background:#ffe7e7" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**Link**
154 |(% style="background-color:#ffe7e7; background:#ffe7e7" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**Link**|(% style="background-color:#e2efd9; background:#e2efd9" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)Analysepakket|(% style="background-color:#e2efd9; background:#e2efd9" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)AnalysisSetId
155 |(% style="background-color:#ffe7e7; background:#ffe7e7" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**Link**|(% style="border-style:none; padding:0in" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)Klantcode|(% style="border-style:none; padding:0in" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)ClientId
156 |(% style="background-color:#ffe7e7; background:#ffe7e7" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**Link**|(% style="background-color:#e2efd9; background:#e2efd9" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)Monstersoort|(% style="background-color:#e2efd9; background:#e2efd9" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)SampleKind
157 |(% style="background-color:#ffe7e7; background:#ffe7e7" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**Link**|(% style="border-style:none; padding:0in" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)categoriecode|(% style="border-style:none; padding:0in" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)CategoryId
158 |(% style="background-color:#ed7d31; background:#ed7d31" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**AnalysisSets**|(% style="background-color:#e2efd9; background:#e2efd9" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)Analysepakket|(% style="background-color:#ffc000; background:#ffc000" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**AnalysisSet**
159 |(% style="background-color:#ffc000; background:#ffc000" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**AnalysisSet**|(% style="border-style:none; padding:0in" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)Analysepakketcode|(% style="border-style:none; padding:0in" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)AnalysisSetId
160 |(% style="background-color:#ffc000; background:#ffc000" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**AnalysisSet**|(% style="background-color:#e2efd9; background:#e2efd9" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)Omschrijving|(% style="background-color:#e2efd9; background:#e2efd9" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)Description
161 |(% style="background-color:#ffc000; background:#ffc000" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**AnalysisSet**|(% style="border-style:none; padding:0in" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)volgorde|(% style="border-style:none; padding:0in" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)Sequence
162 |(% style="background-color:#ed7d31; background:#ed7d31" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**Categories**|(% style="background-color:#e2efd9; background:#e2efd9" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)Categorie|(% style="background-color:#ffffdd; background:#ffffdd" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**category**
163 |(% style="background-color:#ffffdd; background:#ffffdd" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**Category**|(% style="border-style:none; padding:0in" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)Categoriecode|(% style="border-style:none; padding:0in" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)CategoryId
164 |(% style="background-color:#ffffdd; background:#ffffdd" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**Category**|(% style="background-color:#e2efd9; background:#e2efd9" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)omschrijving|(% style="background-color:#e2efd9; background:#e2efd9" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)Description
165 |(% style="background-color:#ffffdd; background:#ffffdd" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**Category**|(% style="border-style:none; padding:0in" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)volgorde|(% style="border-style:none; padding:0in" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)Sequence
166 |(% style="background-color:#ed7d31; background:#ed7d31" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**AnalysesLinks**|(% style="background-color:#e2efd9; background:#e2efd9" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)Pakket|(% style="background-color:#92d050; background:#92d050" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**AnalysisLink**
167 |(% style="background-color:#92d050; background:#92d050" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**AnalysisLink**|(% style="border-style:none; padding:0in" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)Analysepakketcode|(% style="border-style:none; padding:0in" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)AnalysisSetId
168 |(% style="background-color:#92d050; background:#92d050" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**AnalysisLink**|(% style="background-color:#e2efd9; background:#e2efd9" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)Analyse|(% style="background-color:#00b050; background:#00b050" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**Analysis**
169 |(% style="background-color:#00b050; background:#00b050" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**Analysis**|(% style="border-style:none; padding:0in" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)Analysecode|(% style="border-style:none; padding:0in" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)AnalysisId
170 |(% style="background-color:#00b050; background:#00b050" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**Analysis**|(% style="background-color:#e2efd9; background:#e2efd9" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)omschrijving|(% style="background-color:#e2efd9; background:#e2efd9" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)Description
171 |(% style="background-color:#ed7d31; background:#ed7d31" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**Clients**|(% style="border-style:none; padding:0in" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)debiteur|(% style="background-color:#00b0f0; background:#00b0f0" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**Client**
172 |(% style="background-color:#00b0f0; background:#00b0f0" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**Client**|(% style="background-color:#e2efd9; background:#e2efd9" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)Klantcode|(% style="background-color:#e2efd9; background:#e2efd9" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)ClientId
173 |(% style="background-color:#00b0f0; background:#00b0f0" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**Client**|(% style="border-style:none; padding:0in" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)Omschrijving|(% style="border-style:none; padding:0in" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)Description
174 |(% style="background-color:#ed7d31; background:#ed7d31" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**Urgencies**|(% style="background-color:#e2efd9; background:#e2efd9" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)Urgentie|(% style="background-color:#0070c0; background:#0070c0" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**Urgency**
175 |(% style="background-color:#0070c0; background:#0070c0" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**Urgency**|(% style="border-style:none; padding:0in" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)Urgentiecode|(% style="border-style:none; padding:0in" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)UrgencyId
176 |(% style="background-color:#0070c0; background:#0070c0" width="105" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)**Urgency**|(% style="background-color:#e2efd9; background:#e2efd9" width="127" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)omschrijving|(% style="background-color:#e2efd9; background:#e2efd9" width="136" %)(% style="font-family:Times New Roman,serif; font-size:1em" %)Description
177
178