Skip to content

Data Profile: kna1

Generated: 2025-11-25 01:59:29.813701 Schema: raw.kna1 Total Rows: 304,648 Columns: 273 Completeness: 58.65%

Source Files

File Rows Size
20251105001448_kna1_6120.csv 304,648 1101.4 MB
Total 304,648 1101.4 MB

Column Summary

# Column Type PostgreSQL Nullable Nulls Unique
1 MANDT integer INTEGER No 0.00% 0
2 KUNNR string VARCHAR(15) No 0.00% 0
3 LAND1 string VARCHAR(4) No 0.00% 0
4 NAME1 string VARCHAR(52) No 0.00% 0
5 NAME2 string VARCHAR(52) No 0.00% 0
6 ORT01 string VARCHAR(52) No 0.00% 0
7 PSTLZ string VARCHAR(15) No 0.00% 0
8 REGIO string VARCHAR(4) Yes 0.69% 0
9 SORTL string VARCHAR(15) No 0.00% 0
10 STRAS string VARCHAR(52) No 0.00% 0
11 TELF1 string VARCHAR(24) No 0.00% 0
12 TELFX string VARCHAR(46) No 0.00% 0
13 XCPDK string VARCHAR(1) Yes 100.00% 0
14 ADRNR string VARCHAR(15) No 0.00% 0
15 MCOD1 string VARCHAR(37) No 0.00% 0
16 MCOD2 string VARCHAR(37) No 0.00% 0
17 MCOD3 string VARCHAR(37) No 0.00% 0
18 ANRED string VARCHAR(22) No 0.00% 0
19 AUFSD string VARCHAR(3) Yes 99.07% 0
20 BAHNE string VARCHAR(37) No 0.00% 0
21 BAHNS string VARCHAR(37) No 0.00% 0
22 BBBNR string VARCHAR(10) No 0.00% 0
23 BBSNR string VARCHAR(7) No 0.00% 0
24 BEGRU string VARCHAR(6) No 0.00% 0
25 BRSCH string VARCHAR(6) No 0.00% 0
26 BUBKZ integer INTEGER No 0.00% 0
27 DATLT string VARCHAR(21) No 0.00% 0
28 ERDAT integer INTEGER No 0.00% 0
29 ERNAM string VARCHAR(18) No 0.00% 0
30 EXABL string VARCHAR(1) Yes 100.00% 0
31 FAKSD string VARCHAR(3) Yes 100.00% 0
32 FISKN string VARCHAR(15) No 0.00% 0
33 KNAZK string VARCHAR(1) Yes 100.00% 0
34 KNRZA string VARCHAR(15) No 0.00% 0
35 KONZS string VARCHAR(15) No 0.00% 0
36 KTOKD string VARCHAR(6) No 0.00% 0
37 KUKLA string VARCHAR(3) Yes 45.48% 0
38 LIFNR string VARCHAR(15) No 0.00% 0
39 LIFSD string VARCHAR(3) Yes 99.99% 0
40 LOCCO string VARCHAR(15) No 0.00% 0
41 LOEVM string VARCHAR(1) Yes 65.81% 0
42 NAME3 string VARCHAR(52) No 0.00% 0
43 NAME4 string VARCHAR(52) No 0.00% 0
44 NIELS string VARCHAR(1) Yes 100.00% 0
45 ORT02 string VARCHAR(52) No 0.00% 0
46 PFACH string VARCHAR(15) No 0.00% 0
47 PSTL2 string VARCHAR(15) No 0.00% 0
48 COUNC string VARCHAR(1) Yes 100.00% 0
49 CITYC string VARCHAR(6) No 0.00% 0
50 RPMKR string VARCHAR(7) No 0.00% 0
51 SPERR string VARCHAR(1) Yes 99.62% 0
52 SPRAS string VARCHAR(1) No 0.00% 0
53 STCD1 string VARCHAR(24) No 0.00% 0
54 STCD2 string VARCHAR(16) No 0.00% 0
55 STKZA string VARCHAR(1) Yes 100.00% 0
56 STKZU string VARCHAR(1) Yes 100.00% 0
57 TELBX string VARCHAR(22) No 0.00% 0
58 TELF2 string VARCHAR(24) No 0.00% 0
59 TELTX string VARCHAR(45) No 0.00% 0
60 TELX1 string VARCHAR(45) No 0.00% 0
61 LZONE string VARCHAR(15) No 0.00% 0
62 XZEMP string VARCHAR(1) Yes 100.00% 0
63 VBUND string VARCHAR(9) No 0.00% 0
64 STCEG string VARCHAR(30) No 0.00% 0
65 DEAR1 string VARCHAR(1) Yes 99.02% 0
66 DEAR2 string VARCHAR(1) Yes 100.00% 0
67 DEAR3 string VARCHAR(1) Yes 87.54% 0
68 DEAR4 string VARCHAR(1) Yes 100.00% 0
69 DEAR5 string VARCHAR(1) Yes 100.00% 0
70 GFORM string VARCHAR(3) Yes 100.00% 0
71 BRAN1 string VARCHAR(15) No 0.00% 0
72 BRAN2 string VARCHAR(15) No 0.00% 0
73 BRAN3 string VARCHAR(15) No 0.00% 0
74 BRAN4 string VARCHAR(15) No 0.00% 0
75 BRAN5 string VARCHAR(15) No 0.00% 0
76 EKONT string VARCHAR(15) No 0.00% 0
77 UMSAT numeric NUMERIC(12,2) No 0.00% 0
78 UMJAH string VARCHAR(6) No 0.00% 0
79 UWAER string VARCHAR(7) No 0.00% 0
80 JMZAH string VARCHAR(9) No 0.00% 0
81 JMJAH string VARCHAR(6) No 0.00% 0
82 KATR1 string VARCHAR(3) Yes 82.91% 0
83 KATR2 string VARCHAR(3) Yes 72.71% 0
84 KATR3 string VARCHAR(3) Yes 74.18% 0
85 KATR4 string VARCHAR(3) Yes 73.48% 0
86 KATR5 string VARCHAR(3) Yes 82.53% 0
87 KATR6 string VARCHAR(4) Yes 73.57% 0
88 KATR7 string VARCHAR(4) Yes 75.02% 0
89 KATR8 string VARCHAR(4) Yes 82.81% 0
90 KATR9 string VARCHAR(4) Yes 82.83% 0
91 KATR10 string VARCHAR(4) Yes 82.86% 0
92 STKZN string VARCHAR(1) Yes 100.00% 0
93 UMSA1 numeric NUMERIC(12,2) No 0.00% 0
94 TXJCD string VARCHAR(22) No 0.00% 0
95 PERIV string VARCHAR(1) Yes 100.00% 0
96 ABRVW string VARCHAR(1) Yes 100.00% 0
97 INSPBYDEBI string VARCHAR(1) Yes 100.00% 0
98 INSPATDEBI string VARCHAR(1) Yes 100.00% 0
99 KTOCD string VARCHAR(6) No 0.00% 0
100 PFORT string VARCHAR(52) No 0.00% 0
101 WERKS string VARCHAR(6) No 0.00% 0
102 DTAMS string VARCHAR(1) Yes 100.00% 0
103 DTAWS string VARCHAR(1) Yes 100.00% 0
104 DUEFL string VARCHAR(1) No 0.00% 0
105 HZUOR string VARCHAR(3) No 0.00% 0
106 SPERZ string VARCHAR(1) Yes 100.00% 0
107 ETIKG string VARCHAR(15) No 0.00% 0
108 CIVVE string VARCHAR(1) Yes 100.00% 0
109 MILVE string VARCHAR(1) Yes 100.00% 0
110 KDKG1 string VARCHAR(1) Yes 100.00% 0
111 KDKG2 string VARCHAR(1) Yes 100.00% 0
112 KDKG3 string VARCHAR(1) Yes 100.00% 0
113 KDKG4 string VARCHAR(1) Yes 100.00% 0
114 KDKG5 string VARCHAR(1) Yes 100.00% 0
115 XKNZA string VARCHAR(1) Yes 100.00% 0
116 FITYP string VARCHAR(1) Yes 100.00% 0
117 STCDT string VARCHAR(1) Yes 100.00% 0
118 STCD3 string VARCHAR(27) No 0.00% 0
119 STCD4 string VARCHAR(27) No 0.00% 0
120 STCD5 string VARCHAR(90) No 0.00% 0
121 STCD6 string VARCHAR(30) No 0.00% 0
122 XICMS string VARCHAR(1) Yes 100.00% 0
123 XXIPI string VARCHAR(1) Yes 100.00% 0
124 XSUBT string VARCHAR(1) Yes 100.00% 0
125 CFOPC string VARCHAR(1) Yes 100.00% 0
126 TXLW1 string VARCHAR(1) Yes 100.00% 0
127 TXLW2 string VARCHAR(1) Yes 100.00% 0
128 CCC01 string VARCHAR(1) Yes 100.00% 0
129 CCC02 string VARCHAR(1) Yes 100.00% 0
130 CCC03 string VARCHAR(1) Yes 100.00% 0
131 CCC04 string VARCHAR(1) Yes 100.00% 0
132 BONDED_AREA_CONFIRM string VARCHAR(1) Yes 100.00% 0
133 DONATE_MARK string VARCHAR(1) Yes 100.00% 0
134 CONSOLIDATE_INVOICE string VARCHAR(1) Yes 100.00% 0
135 ALLOWANCE_TYPE string VARCHAR(1) Yes 100.00% 0
136 EINVOICE_MODE string VARCHAR(1) Yes 100.00% 0
137 CASSD string VARCHAR(3) Yes 99.99% 0
138 KNURL string VARCHAR(198) No 0.00% 0
139 J_1KFREPRE string VARCHAR(15) No 0.00% 0
140 J_1KFTBUS string VARCHAR(45) No 0.00% 0
141 J_1KFTIND string VARCHAR(45) No 0.00% 0
142 CONFS string VARCHAR(1) Yes 100.00% 0
143 UPDAT string VARCHAR(12) No 0.00% 0
144 UPTIM string VARCHAR(9) No 0.00% 0
145 NODEL string VARCHAR(1) Yes 99.68% 0
146 DEAR6 string VARCHAR(1) Yes 100.00% 0
147 DELIVERY_DATE_RULE string VARCHAR(1) Yes 100.00% 0
148 CVP_XBLCK string VARCHAR(1) Yes 100.00% 0
149 SUFRAMA string VARCHAR(13) No 0.00% 0
150 RG string VARCHAR(16) No 0.00% 0
151 EXP string VARCHAR(1) Yes 100.00% 0
152 UF string VARCHAR(1) Yes 100.00% 0
153 RGDATE string VARCHAR(12) No 0.00% 0
154 RIC string VARCHAR(16) No 0.00% 0
155 RNE string VARCHAR(15) No 0.00% 0
156 RNEDATE string VARCHAR(12) No 0.00% 0
157 CNAE string VARCHAR(10) No 0.00% 0
158 LEGALNAT string VARCHAR(6) No 0.00% 0
159 CRTN string VARCHAR(1) Yes 100.00% 0
160 ICMSTAXPAY string VARCHAR(1) Yes 100.00% 0
161 INDTYP string VARCHAR(1) Yes 100.00% 0
162 TDT string VARCHAR(1) Yes 100.00% 0
163 COMSIZE string VARCHAR(1) Yes 100.00% 0
164 DECREGPC string VARCHAR(1) Yes 100.00% 0
165 PH_BIZ_STYLE string VARCHAR(210) No 0.00% 0
166 PAYTRSN string VARCHAR(6) No 0.00% 0
167 KNA1_EEW_CUST string VARCHAR(1) Yes 100.00% 0
168 RULE_EXCLUSION string VARCHAR(1) Yes 100.00% 0
169 KNA1_ADDR_EEW_CUST string VARCHAR(1) Yes 100.00% 0
170 /VSO/R_PALHGT numeric NUMERIC(12,2) No 0.00% 0
171 /VSO/R_PAL_UL string VARCHAR(1) Yes 100.00% 0
172 /VSO/R_PK_MAT string VARCHAR(1) Yes 100.00% 0
173 /VSO/R_MATPAL string VARCHAR(60) No 0.00% 0
174 /VSO/R_I_NO_LYR string VARCHAR(3) No 0.00% 0
175 /VSO/R_ONE_MAT string VARCHAR(1) Yes 100.00% 0
176 /VSO/R_ONE_SORT string VARCHAR(1) Yes 100.00% 0
177 /VSO/R_ULD_SIDE integer INTEGER No 0.00% 0
178 /VSO/R_LOAD_PREF integer INTEGER No 0.00% 0
179 /VSO/R_DPOINT string VARCHAR(15) No 0.00% 0
180 ALC string VARCHAR(12) No 0.00% 0
181 PMT_OFFICE string VARCHAR(7) No 0.00% 0
182 FEE_SCHEDULE string VARCHAR(6) No 0.00% 0
183 DUNS string VARCHAR(13) No 0.00% 0
184 DUNS4 string VARCHAR(6) No 0.00% 0
185 SAM_UE_ID string VARCHAR(18) No 0.00% 0
186 SAM_EFT_IND string VARCHAR(6) No 0.00% 0
187 PSOFG string VARCHAR(15) No 0.00% 0
188 PSOIS string VARCHAR(30) No 0.00% 0
189 PSON1 string VARCHAR(52) No 0.00% 0
190 PSON2 string VARCHAR(52) No 0.00% 0
191 PSON3 string VARCHAR(52) No 0.00% 0
192 PSOVN string VARCHAR(52) No 0.00% 0
193 PSOTL string VARCHAR(30) No 0.00% 0
194 PSOHS string VARCHAR(9) No 0.00% 0
195 PSOST string VARCHAR(42) No 0.00% 0
196 PSOO1 string VARCHAR(75) No 0.00% 0
197 PSOO2 string VARCHAR(75) No 0.00% 0
198 PSOO3 string VARCHAR(75) No 0.00% 0
199 PSOO4 string VARCHAR(75) No 0.00% 0
200 PSOO5 string VARCHAR(75) No 0.00% 0
201 J_1IEXCD string VARCHAR(60) No 0.00% 0
202 J_1IEXRN string VARCHAR(60) No 0.00% 0
203 J_1IEXRG string VARCHAR(90) No 0.00% 0
204 J_1IEXDI string VARCHAR(90) No 0.00% 0
205 J_1IEXCO string VARCHAR(90) No 0.00% 0
206 J_1ICSTNO string VARCHAR(60) No 0.00% 0
207 J_1ILSTNO string VARCHAR(60) No 0.00% 0
208 J_1IPANNO string VARCHAR(60) No 0.00% 0
209 J_1IEXCICU string VARCHAR(1) Yes 100.00% 0
210 AEDAT string VARCHAR(12) No 0.00% 0
211 USNAM string VARCHAR(18) No 0.00% 0
212 J_1ISERN string VARCHAR(60) No 0.00% 0
213 J_1IPANREF string VARCHAR(60) No 0.00% 0
214 GST_TDS string VARCHAR(27) No 0.00% 0
215 J_3GETYP string VARCHAR(1) Yes 100.00% 0
216 J_3GREFTYP string VARCHAR(1) Yes 100.00% 0
217 PSPNR string VARCHAR(12) No 0.00% 0
218 COAUFNR string VARCHAR(18) No 0.00% 0
219 J_3GAGEXT string VARCHAR(15) No 0.00% 0
220 J_3GAGINT string VARCHAR(15) No 0.00% 0
221 J_3GAGDUMI string VARCHAR(15) No 0.00% 0
222 J_3GAGSTDI string VARCHAR(15) No 0.00% 0
223 LGORT string VARCHAR(6) No 0.00% 0
224 KOKRS string VARCHAR(6) No 0.00% 0
225 KOSTL string VARCHAR(15) No 0.00% 0
226 J_3GABGLG string VARCHAR(1) Yes 100.00% 0
227 J_3GABGVG string VARCHAR(1) Yes 100.00% 0
228 J_3GABRART string VARCHAR(1) Yes 100.00% 0
229 J_3GSTDMON numeric NUMERIC(12,2) No 0.00% 0
230 J_3GSTDTAG numeric NUMERIC(12,2) No 0.00% 0
231 J_3GTAGMON numeric NUMERIC(12,2) No 0.00% 0
232 J_3GZUGTAG string VARCHAR(1) Yes 100.00% 0
233 J_3GMASCHB string VARCHAR(1) Yes 100.00% 0
234 J_3GMEINSA string VARCHAR(1) Yes 100.00% 0
235 J_3GKEINSA string VARCHAR(1) Yes 100.00% 0
236 J_3GBLSPER string VARCHAR(1) Yes 100.00% 0
237 J_3GKLEIVO string VARCHAR(1) Yes 100.00% 0
238 J_3GCALID string VARCHAR(1) Yes 100.00% 0
239 J_3GVMONAT integer INTEGER No 0.00% 0
240 J_3GABRKEN string VARCHAR(1) Yes 100.00% 0
241 J_3GLABRECH string VARCHAR(12) No 0.00% 0
242 J_3GAABRECH string VARCHAR(12) No 0.00% 0
243 J_3GZUTVHLG string VARCHAR(1) Yes 100.00% 0
244 J_3GNEGMEN string VARCHAR(1) Yes 100.00% 0
245 J_3GFRISTLO string VARCHAR(1) Yes 100.00% 0
246 J_3GEMINBE string VARCHAR(7) No 0.00% 0
247 J_3GFMGUE string VARCHAR(7) No 0.00% 0
248 J_3GZUSCHUE string VARCHAR(7) No 0.00% 0
249 J_3GSCHPRS string VARCHAR(1) Yes 100.00% 0
250 J_3GINVSTA string VARCHAR(1) Yes 100.00% 0
251 /SAPCEM/DBER string VARCHAR(12) No 0.00% 0
252 /SAPCEM/KVMEQ string VARCHAR(1) Yes 100.00% 0
253 ZZ_ABC_H string VARCHAR(1) Yes 100.00% 0
254 ZZ_ABC_N string VARCHAR(1) Yes 100.00% 0
255 ZZ_ABC_V string VARCHAR(1) Yes 100.00% 0
256 ZZKUNDENSEGMENT string VARCHAR(15) No 0.00% 0
257 ZZCRM_ID string VARCHAR(75) No 0.00% 0
258 ZZMAKTIVG string VARCHAR(1) Yes 98.79% 0
259 ZZVSART string VARCHAR(3) Yes 99.97% 0
260 ZZKWM_KW integer INTEGER Yes 78.16% 0
261 ZZKWM_UMS integer INTEGER Yes 78.16% 0
262 ZZKWM_DB integer INTEGER Yes 78.16% 0
263 ZZKWM_LZ integer INTEGER Yes 78.16% 0
264 ZZKWM_POT string VARCHAR(3) Yes 98.00% 0
265 ZZKONZNR string VARCHAR(15) No 0.00% 0
266 ZZENAW string VARCHAR(1) Yes 99.98% 0
267 ZZNOGA string VARCHAR(15) No 0.00% 0
268 ZZAZDIRECT string VARCHAR(15) No 0.00% 0
269 ZZMARKTPARTNERSEGMENT string VARCHAR(15) No 0.00% 0
270 ZZMARKTSEGMENT string VARCHAR(15) No 0.00% 0
271 ZZBESITZSTATUS string VARCHAR(15) No 0.00% 0
272 ZZMARKT_MITBEWERBER string VARCHAR(1) Yes 99.99% 0
273 ZZBIOGASWUNSCH string VARCHAR(6) Yes 99.96% 0

Detailed Column Profiles

1. MANDT

Type: integer → INTEGER
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

100

2. KUNNR

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

0001087315, 0001105076, 0001099980, 0001074678, 0001090667

3. LAND1

Type: string → VARCHAR(4)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 3
Avg Length 0.0
Buffered Length 4 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

CH , DE , AT , LI , FR

4. NAME1

Type: string → VARCHAR(52)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 35
Avg Length 0.0
Buffered Length 52 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

Müller                             , Meier                              , Keller                             , Weber                              , Brunner

5. NAME2

Type: string → VARCHAR(52)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 35
Avg Length 0.0
Buffered Length 52 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

                                   , Peter                              , Hans                               , Thomas                             , Walter

6. ORT01

Type: string → VARCHAR(52)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 35
Avg Length 0.0
Buffered Length 52 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

Zürich                             , Stäfa                              , Meilen                             , Adliswil                           , Volketswil

7. PSTLZ

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

8004      , 8003      , 8032      , 8006      , 8008

8. REGIO

Type: string → VARCHAR(4)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 302,552 (99.3%)
Null 2,096 (0.69%)
Unique 0 (0.0%)
Min Length 0
Max Length 3
Avg Length 0.0
Buffered Length 4 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

 Z ,  0 , X  ,  A , ZH

9. SORTL

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

          , LÖSCHVERME, STOCKWERKE, 1.        , BAUGENOSSE

10. STRAS

Type: string → VARCHAR(52)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 35
Avg Length 0.0
Buffered Length 52 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

                                   , Schmiedweg 20                      , Hinterbüelstrasse 30               , Grätzlistrasse 48                  , Im Aegelsee 4

11. TELF1

Type: string → VARCHAR(24)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 16
Avg Length 0.0
Buffered Length 24 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

                , 052 343 37 35   , 031 305 46 10   , 079 303 39 52   , 044 915 21 88

12. TELFX

Type: string → VARCHAR(46)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 31
Avg Length 0.0
Buffered Length 46 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

                               , 0                              , 043 931 40 61                  , 044 391 53 17                  , 044 926 79 26

13. XCPDK

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 1 (0.0%)
Null 304,647 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 1
Avg Length 0.0
Buffered Length 1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

X

14. ADRNR

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

0000977782, 0001101532, 0001053332, 0001046305, 0002333585

15. MCOD1

Type: string → VARCHAR(37)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 25
Avg Length 0.0
Buffered Length 37 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

MÜLLER                   , MEIER                    , PFISTER                  , BRUNNER                  , STEINER

16. MCOD2

Type: string → VARCHAR(37)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 25
Avg Length 0.0
Buffered Length 37 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

                         , PETER                    , HANS                     , THOMAS                   , DANIEL

17. MCOD3

Type: string → VARCHAR(37)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 25
Avg Length 0.0
Buffered Length 37 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

ZÜRICH                   , STÄFA                    , MEILEN                   , ADLISWIL                 , VOLKETSWIL

18. ANRED

Type: string → VARCHAR(22)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 15
Avg Length 0.0
Buffered Length 22 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

Herr           ,                , Frau           , Herr und Frau  , Herren

19. AUFSD

Type: string → VARCHAR(3)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 2,833 (0.9%)
Null 301,815 (99.07%)
Unique 0 (0.0%)
Min Length 0
Max Length 2
Avg Length 0.0
Buffered Length 3 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

99, 11, 10, 01, 12

20. BAHNE

Type: string → VARCHAR(37)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 25
Avg Length 0.0
Buffered Length 37 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

21. BAHNS

Type: string → VARCHAR(37)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 25
Avg Length 0.0
Buffered Length 37 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

22. BBBNR

Type: string → VARCHAR(10)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 7
Avg Length 0.0
Buffered Length 10 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

0000000

23. BBSNR

Type: string → VARCHAR(7)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 5
Avg Length 0.0
Buffered Length 7 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

00000

24. BEGRU

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 4
Avg Length 0.0
Buffered Length 6 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

25. BRSCH

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 4
Avg Length 0.0
Buffered Length 6 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

PI  , ZZ  , BB  , GH  , DI

26. BUBKZ

Type: integer → INTEGER
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

0

27. DATLT

Type: string → VARCHAR(21)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 14
Avg Length 0.0
Buffered Length 21 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

              , t

28. ERDAT

Type: integer → INTEGER
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

19980303, 19981018, 19980304, 19980424, 19981017

29. ERNAM

Type: string → VARCHAR(18)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 12
Avg Length 0.0
Buffered Length 18 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

FISCHERN    , JOBADMIN    , BÄCHLER     , FINK        , VOGEL

30. EXABL

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

31. FAKSD

Type: string → VARCHAR(3)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 5 (0.0%)
Null 304,643 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 2
Avg Length 0.0
Buffered Length 3 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

04, 01

32. FISKN

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

33. KNAZK

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

34. KNRZA

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

35. KONZS

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

          , 9016281   , 1052752   , 1111751   , 1068583

36. KTOKD

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 4
Avg Length 0.0
Buffered Length 6 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

Z001, 0001, Z002, 0005, Z011

37. KUKLA

Type: string → VARCHAR(3)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 166,093 (54.5%)
Null 138,555 (45.48%)
Unique 0 (0.0%)
Min Length 0
Max Length 2
Avg Length 0.0
Buffered Length 3 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

C , B , A

38. LIFNR

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

39. LIFSD

Type: string → VARCHAR(3)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 19 (0.0%)
Null 304,629 (99.99%)
Unique 0 (0.0%)
Min Length 0
Max Length 2
Avg Length 0.0
Buffered Length 3 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

01

40. LOCCO

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

          , $

41. LOEVM

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 104,174 (34.2%)
Null 200,474 (65.81%)
Unique 0 (0.0%)
Min Length 0
Max Length 1
Avg Length 0.0
Buffered Length 1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

X

42. NAME3

Type: string → VARCHAR(52)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 35
Avg Length 0.0
Buffered Length 52 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

                                   , Dr.                                , Dr. med.                           , Prof. Dr.                          , Prof.

43. NAME4

Type: string → VARCHAR(52)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 35
Avg Length 0.0
Buffered Length 52 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

                                   , Architekturbüro                    , Architekt                          , und Mitbeteiligte                  , Hauswart

44. NIELS

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

45. ORT02

Type: string → VARCHAR(52)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 35
Avg Length 0.0
Buffered Length 52 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

46. PFACH

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

          , 805       , 161       , 373       , 205

47. PSTL2

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

          , 8021      , 8022      , 8010      , 8032

48. COUNC

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

49. CITYC

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 4
Avg Length 0.0
Buffered Length 6 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

50. RPMKR

Type: string → VARCHAR(7)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 5
Avg Length 0.0
Buffered Length 7 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

51. SPERR

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 1,150 (0.4%)
Null 303,498 (99.62%)
Unique 0 (0.0%)
Min Length 0
Max Length 1
Avg Length 0.0
Buffered Length 1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

X

52. SPRAS

Type: string → VARCHAR(1)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 1
Avg Length 0.0
Buffered Length 1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

D, F, I, E, B

53. STCD1

Type: string → VARCHAR(24)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 16
Avg Length 0.0
Buffered Length 24 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

54. STCD2

Type: string → VARCHAR(16)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 11
Avg Length 0.0
Buffered Length 16 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

55. STKZA

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

56. STKZU

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

57. TELBX

Type: string → VARCHAR(22)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 15
Avg Length 0.0
Buffered Length 22 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

58. TELF2

Type: string → VARCHAR(24)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 16
Avg Length 0.0
Buffered Length 24 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

                , +41 76 383 68 33, 079 542 54 36   , 079 960 60 10   , 079 425 56 73

59. TELTX

Type: string → VARCHAR(45)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 30
Avg Length 0.0
Buffered Length 45 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

                              , 01 809 56 28                  , [email protected]             , info@trunz-wirth              , 01 365 28 60

60. TELX1

Type: string → VARCHAR(45)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 30
Avg Length 0.0
Buffered Length 45 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

                              , 079 355 15 36                 , 079 404 27 27                 , 079 216 56 15                 , 052 319 24 40

61. LZONE

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

          , 0000000001

62. XZEMP

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 3 (0.0%)
Null 304,645 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 1
Avg Length 0.0
Buffered Length 1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

X

63. VBUND

Type: string → VARCHAR(9)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 6
Avg Length 0.0
Buffered Length 9 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

      , 000001, G0300

64. STCEG

Type: string → VARCHAR(30)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

                    , DK28113951

65. DEAR1

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 2,986 (1.0%)
Null 301,662 (99.02%)
Unique 0 (0.0%)
Min Length 0
Max Length 1
Avg Length 0.0
Buffered Length 1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

X

66. DEAR2

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 5 (0.0%)
Null 304,643 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 1
Avg Length 0.0
Buffered Length 1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

X

67. DEAR3

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 37,948 (12.5%)
Null 266,700 (87.54%)
Unique 0 (0.0%)
Min Length 0
Max Length 1
Avg Length 0.0
Buffered Length 1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

X

68. DEAR4

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

69. DEAR5

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

70. GFORM

Type: string → VARCHAR(3)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 2 (0.0%)
Null 304,646 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 2
Avg Length 0.0
Buffered Length 3 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

AG, GH

71. BRAN1

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

PI 0605   , PI 0600   , ZZ 9999   , PI 0210   , PI 0754

72. BRAN2

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

          , BB 0551   , PI 0605   , LP 2060   , BB 0004

73. BRAN3

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

          , LP 2060   , BB 0551   , DI 1051   , PI 0605

74. BRAN4

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

75. BRAN5

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

76. EKONT

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

77. UMSAT

Type: numeric → NUMERIC(12,2)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

0.0

78. UMJAH

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 4
Avg Length 0.0
Buffered Length 6 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

0000

79. UWAER

Type: string → VARCHAR(7)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 5
Avg Length 0.0
Buffered Length 7 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

80. JMZAH

Type: string → VARCHAR(9)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 6
Avg Length 0.0
Buffered Length 9 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

000000

81. JMJAH

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 4
Avg Length 0.0
Buffered Length 6 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

0000

82. KATR1

Type: string → VARCHAR(3)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 52,068 (17.1%)
Null 252,580 (82.91%)
Unique 0 (0.0%)
Min Length 0
Max Length 2
Avg Length 0.0
Buffered Length 3 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

00, 01

83. KATR2

Type: string → VARCHAR(3)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 83,129 (27.3%)
Null 221,519 (72.71%)
Unique 0 (0.0%)
Min Length 0
Max Length 2
Avg Length 0.0
Buffered Length 3 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

00, 01, 05, 02

84. KATR3

Type: string → VARCHAR(3)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 78,656 (25.8%)
Null 225,992 (74.18%)
Unique 0 (0.0%)
Min Length 0
Max Length 2
Avg Length 0.0
Buffered Length 3 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

00, 01, 04, 03

85. KATR4

Type: string → VARCHAR(3)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 80,783 (26.5%)
Null 223,865 (73.48%)
Unique 0 (0.0%)
Min Length 0
Max Length 2
Avg Length 0.0
Buffered Length 3 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

00, 01, 05, 04

86. KATR5

Type: string → VARCHAR(3)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 53,222 (17.5%)
Null 251,426 (82.53%)
Unique 0 (0.0%)
Min Length 0
Max Length 2
Avg Length 0.0
Buffered Length 3 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

00, 01, 05

87. KATR6

Type: string → VARCHAR(4)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 80,513 (26.4%)
Null 224,135 (73.57%)
Unique 0 (0.0%)
Min Length 0
Max Length 3
Avg Length 0.0
Buffered Length 4 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

000, 001

88. KATR7

Type: string → VARCHAR(4)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 76,108 (25.0%)
Null 228,540 (75.02%)
Unique 0 (0.0%)
Min Length 0
Max Length 3
Avg Length 0.0
Buffered Length 4 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

000, 003, 002, 011, 001

89. KATR8

Type: string → VARCHAR(4)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 52,375 (17.2%)
Null 252,273 (82.81%)
Unique 0 (0.0%)
Min Length 0
Max Length 3
Avg Length 0.0
Buffered Length 4 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

000, 001

90. KATR9

Type: string → VARCHAR(4)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 52,301 (17.2%)
Null 252,347 (82.83%)
Unique 0 (0.0%)
Min Length 0
Max Length 3
Avg Length 0.0
Buffered Length 4 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

000, 001, 002

91. KATR10

Type: string → VARCHAR(4)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 52,221 (17.1%)
Null 252,427 (82.86%)
Unique 0 (0.0%)
Min Length 0
Max Length 3
Avg Length 0.0
Buffered Length 4 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

000, 001, 002, 003

92. STKZN

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

93. UMSA1

Type: numeric → NUMERIC(12,2)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

0.0

94. TXJCD

Type: string → VARCHAR(22)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 15
Avg Length 0.0
Buffered Length 22 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

               , 9987

95. PERIV

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

96. ABRVW

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

97. INSPBYDEBI

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

98. INSPATDEBI

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

99. KTOCD

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 4
Avg Length 0.0
Buffered Length 6 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

100. PFORT

Type: string → VARCHAR(52)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 35
Avg Length 0.0
Buffered Length 52 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

                                   , Zürich-Mülligen                    , Zürich                             , Feldmeilen                         , Dietikon 2

101. WERKS

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 4
Avg Length 0.0
Buffered Length 6 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

102. DTAMS

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

103. DTAWS

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

104. DUEFL

Type: string → VARCHAR(1)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 1
Avg Length 0.0
Buffered Length 1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

X

105. HZUOR

Type: string → VARCHAR(3)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 2
Avg Length 0.0
Buffered Length 3 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

00

106. SPERZ

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

107. ETIKG

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

108. CIVVE

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

109. MILVE

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

110. KDKG1

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

111. KDKG2

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

112. KDKG3

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

113. KDKG4

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

114. KDKG5

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

115. XKNZA

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

116. FITYP

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

117. STCDT

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

118. STCD3

Type: string → VARCHAR(27)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 18
Avg Length 0.0
Buffered Length 27 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

119. STCD4

Type: string → VARCHAR(27)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 18
Avg Length 0.0
Buffered Length 27 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

120. STCD5

Type: string → VARCHAR(90)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 60
Avg Length 0.0
Buffered Length 90 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

121. STCD6

Type: string → VARCHAR(30)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

122. XICMS

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

123. XXIPI

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

124. XSUBT

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

125. CFOPC

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

126. TXLW1

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

127. TXLW2

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

128. CCC01

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

129. CCC02

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

130. CCC03

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

131. CCC04

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

132. BONDED_AREA_CONFIRM

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

133. DONATE_MARK

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

134. CONSOLIDATE_INVOICE

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

135. ALLOWANCE_TYPE

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

136. EINVOICE_MODE

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

137. CASSD

Type: string → VARCHAR(3)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 20 (0.0%)
Null 304,628 (99.99%)
Unique 0 (0.0%)
Min Length 0
Max Length 2
Avg Length 0.0
Buffered Length 3 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

X

138. KNURL

Type: string → VARCHAR(198)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 132
Avg Length 0.0
Buffered Length 198 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

                                                                                                                                    , https://www.a-b-z.ch/                                                                                                               , https://www.halter.ch/de/kontakt                                                                                                    , https://www.iem.ch/ueber-iem                                                                                                        , https://www.swissbimi.ch/

139. J_1KFREPRE

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

140. J_1KFTBUS

Type: string → VARCHAR(45)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 30
Avg Length 0.0
Buffered Length 45 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

141. J_1KFTIND

Type: string → VARCHAR(45)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 30
Avg Length 0.0
Buffered Length 45 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

142. CONFS

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

143. UPDAT

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 8
Avg Length 0.0
Buffered Length 12 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

00000000

144. UPTIM

Type: string → VARCHAR(9)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 6
Avg Length 0.0
Buffered Length 9 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

000000

145. NODEL

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 960 (0.3%)
Null 303,688 (99.68%)
Unique 0 (0.0%)
Min Length 0
Max Length 1
Avg Length 0.0
Buffered Length 1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

X

146. DEAR6

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

147. DELIVERY_DATE_RULE

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

148. CVP_XBLCK

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

149. SUFRAMA

Type: string → VARCHAR(13)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 9
Avg Length 0.0
Buffered Length 13 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

150. RG

Type: string → VARCHAR(16)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 11
Avg Length 0.0
Buffered Length 16 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

151. EXP

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

152. UF

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

153. RGDATE

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 8
Avg Length 0.0
Buffered Length 12 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

00000000

154. RIC

Type: string → VARCHAR(16)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 11
Avg Length 0.0
Buffered Length 16 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

00000000000

155. RNE

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

156. RNEDATE

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 8
Avg Length 0.0
Buffered Length 12 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

00000000

157. CNAE

Type: string → VARCHAR(10)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 7
Avg Length 0.0
Buffered Length 10 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

158. LEGALNAT

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 4
Avg Length 0.0
Buffered Length 6 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

0000

159. CRTN

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

160. ICMSTAXPAY

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

161. INDTYP

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

162. TDT

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

163. COMSIZE

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

164. DECREGPC

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

165. PH_BIZ_STYLE

Type: string → VARCHAR(210)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 140
Avg Length 0.0
Buffered Length 210 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

166. PAYTRSN

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 4
Avg Length 0.0
Buffered Length 6 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

167. KNA1_EEW_CUST

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

168. RULE_EXCLUSION

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

169. KNA1_ADDR_EEW_CUST

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

170. /VSO/R_PALHGT

Type: numeric → NUMERIC(12,2)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

0.0

171. /VSO/R_PAL_UL

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

172. /VSO/R_PK_MAT

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

173. /VSO/R_MATPAL

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 40
Avg Length 0.0
Buffered Length 60 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

174. /VSO/R_I_NO_LYR

Type: string → VARCHAR(3)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 2
Avg Length 0.0
Buffered Length 3 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

00

175. /VSO/R_ONE_MAT

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

176. /VSO/R_ONE_SORT

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

177. /VSO/R_ULD_SIDE

Type: integer → INTEGER
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

0

178. /VSO/R_LOAD_PREF

Type: integer → INTEGER
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

0

179. /VSO/R_DPOINT

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

180. ALC

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 8
Avg Length 0.0
Buffered Length 12 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

181. PMT_OFFICE

Type: string → VARCHAR(7)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 5
Avg Length 0.0
Buffered Length 7 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

182. FEE_SCHEDULE

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 4
Avg Length 0.0
Buffered Length 6 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

183. DUNS

Type: string → VARCHAR(13)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 9
Avg Length 0.0
Buffered Length 13 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

184. DUNS4

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 4
Avg Length 0.0
Buffered Length 6 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

185. SAM_UE_ID

Type: string → VARCHAR(18)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 12
Avg Length 0.0
Buffered Length 18 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

186. SAM_EFT_IND

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 4
Avg Length 0.0
Buffered Length 6 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

187. PSOFG

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

188. PSOIS

Type: string → VARCHAR(30)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

189. PSON1

Type: string → VARCHAR(52)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 35
Avg Length 0.0
Buffered Length 52 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

190. PSON2

Type: string → VARCHAR(52)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 35
Avg Length 0.0
Buffered Length 52 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

191. PSON3

Type: string → VARCHAR(52)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 35
Avg Length 0.0
Buffered Length 52 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

192. PSOVN

Type: string → VARCHAR(52)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 35
Avg Length 0.0
Buffered Length 52 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

193. PSOTL

Type: string → VARCHAR(30)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

194. PSOHS

Type: string → VARCHAR(9)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 6
Avg Length 0.0
Buffered Length 9 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

195. PSOST

Type: string → VARCHAR(42)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 28
Avg Length 0.0
Buffered Length 42 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

196. PSOO1

Type: string → VARCHAR(75)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 50
Avg Length 0.0
Buffered Length 75 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

197. PSOO2

Type: string → VARCHAR(75)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 50
Avg Length 0.0
Buffered Length 75 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

198. PSOO3

Type: string → VARCHAR(75)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 50
Avg Length 0.0
Buffered Length 75 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

199. PSOO4

Type: string → VARCHAR(75)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 50
Avg Length 0.0
Buffered Length 75 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

200. PSOO5

Type: string → VARCHAR(75)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 50
Avg Length 0.0
Buffered Length 75 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

201. J_1IEXCD

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 40
Avg Length 0.0
Buffered Length 60 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

202. J_1IEXRN

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 40
Avg Length 0.0
Buffered Length 60 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

203. J_1IEXRG

Type: string → VARCHAR(90)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 60
Avg Length 0.0
Buffered Length 90 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

204. J_1IEXDI

Type: string → VARCHAR(90)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 60
Avg Length 0.0
Buffered Length 90 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

205. J_1IEXCO

Type: string → VARCHAR(90)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 60
Avg Length 0.0
Buffered Length 90 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

206. J_1ICSTNO

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 40
Avg Length 0.0
Buffered Length 60 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

207. J_1ILSTNO

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 40
Avg Length 0.0
Buffered Length 60 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

208. J_1IPANNO

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 40
Avg Length 0.0
Buffered Length 60 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

209. J_1IEXCICU

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

210. AEDAT

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 8
Avg Length 0.0
Buffered Length 12 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

00000000

211. USNAM

Type: string → VARCHAR(18)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 12
Avg Length 0.0
Buffered Length 18 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

212. J_1ISERN

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 40
Avg Length 0.0
Buffered Length 60 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

213. J_1IPANREF

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 40
Avg Length 0.0
Buffered Length 60 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

214. GST_TDS

Type: string → VARCHAR(27)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 18
Avg Length 0.0
Buffered Length 27 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

215. J_3GETYP

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

216. J_3GREFTYP

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

217. PSPNR

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 8
Avg Length 0.0
Buffered Length 12 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

00000000

218. COAUFNR

Type: string → VARCHAR(18)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 12
Avg Length 0.0
Buffered Length 18 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

219. J_3GAGEXT

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

220. J_3GAGINT

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

221. J_3GAGDUMI

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

222. J_3GAGSTDI

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

223. LGORT

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 4
Avg Length 0.0
Buffered Length 6 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

224. KOKRS

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 4
Avg Length 0.0
Buffered Length 6 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

225. KOSTL

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

226. J_3GABGLG

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

227. J_3GABGVG

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

228. J_3GABRART

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

229. J_3GSTDMON

Type: numeric → NUMERIC(12,2)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

0.0

230. J_3GSTDTAG

Type: numeric → NUMERIC(12,2)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

0.0

231. J_3GTAGMON

Type: numeric → NUMERIC(12,2)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

0.0

232. J_3GZUGTAG

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

233. J_3GMASCHB

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

234. J_3GMEINSA

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

235. J_3GKEINSA

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

236. J_3GBLSPER

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

237. J_3GKLEIVO

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

238. J_3GCALID

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

239. J_3GVMONAT

Type: integer → INTEGER
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

0

240. J_3GABRKEN

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

241. J_3GLABRECH

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 8
Avg Length 0.0
Buffered Length 12 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

00000000

242. J_3GAABRECH

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 8
Avg Length 0.0
Buffered Length 12 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

00000000

243. J_3GZUTVHLG

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

244. J_3GNEGMEN

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

245. J_3GFRISTLO

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

246. J_3GEMINBE

Type: string → VARCHAR(7)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 5
Avg Length 0.0
Buffered Length 7 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

00000

247. J_3GFMGUE

Type: string → VARCHAR(7)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 5
Avg Length 0.0
Buffered Length 7 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

00000

248. J_3GZUSCHUE

Type: string → VARCHAR(7)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 5
Avg Length 0.0
Buffered Length 7 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

00000

249. J_3GSCHPRS

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

250. J_3GINVSTA

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

251. /SAPCEM/DBER

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 8
Avg Length 0.0
Buffered Length 12 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values:

252. /SAPCEM/KVMEQ

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

253. ZZ_ABC_H

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

254. ZZ_ABC_N

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

255. ZZ_ABC_V

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 0 (0.0%)
Null 304,648 (100.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 0
Avg Length 0.0
Buffered Length 0 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

(no data)

256. ZZKUNDENSEGMENT

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

MIET-KLEIN, EFH       , HH        , GEWERBE   , DIENST

257. ZZCRM_ID

Type: string → VARCHAR(75)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 50
Avg Length 0.0
Buffered Length 75 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

                                                  , 6DF64F28-89C3-E211-A595-005056B60000              , 277CE58C-B9B0-E211-B842-005056B60000              , 69224C90-B56C-E511-80D8-005056BF1B08              , DA92F67F-ED56-E511-80D6-005056BF1B08

258. ZZMAKTIVG

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 3,697 (1.2%)
Null 300,951 (98.79%)
Unique 0 (0.0%)
Min Length 0
Max Length 1
Avg Length 0.0
Buffered Length 1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

X

259. ZZVSART

Type: string → VARCHAR(3)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 93 (0.0%)
Null 304,555 (99.97%)
Unique 0 (0.0%)
Min Length 0
Max Length 2
Avg Length 0.0
Buffered Length 3 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

01, 02, 03

260. ZZKWM_KW

Type: integer → INTEGER
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 66,531 (21.8%)
Null 238,117 (78.16%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

3, 4, 2, 5, 1

261. ZZKWM_UMS

Type: integer → INTEGER
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 66,531 (21.8%)
Null 238,117 (78.16%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

1, 3, 4, 2, 5

262. ZZKWM_DB

Type: integer → INTEGER
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 66,531 (21.8%)
Null 238,117 (78.16%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

1, 3, 2, 4, 5

263. ZZKWM_LZ

Type: integer → INTEGER
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 66,531 (21.8%)
Null 238,117 (78.16%)
Unique 0 (0.0%)
Min Length 0
Max Length 20
Avg Length 0.0
Buffered Length 30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

7, 3, 5, 6, 4

264. ZZKWM_POT

Type: string → VARCHAR(3)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 6,089 (2.0%)
Null 298,559 (98.00%)
Unique 0 (0.0%)
Min Length 0
Max Length 2
Avg Length 0.0
Buffered Length 3 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

BG, SO, ED, TS, PE

265. ZZKONZNR

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

          , 0001101952, 0008278184, 0001066292, 0001098628

266. ZZENAW

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 59 (0.0%)
Null 304,589 (99.98%)
Unique 0 (0.0%)
Min Length 0
Max Length 1
Avg Length 0.0
Buffered Length 1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

X

267. ZZNOGA

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

          , 711101    , 841100    , 683200    , 0000432203

268. ZZAZDIRECT

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

          , 0000000000, 0000542925, 0000603031, 0000560004

269. ZZMARKTPARTNERSEGMENT

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

          , N/A       , ARCH      , PLANER HLK, INSTALKONZ

270. ZZMARKTSEGMENT

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

          , EFH       , MFH       , FIRMA     , EG

271. ZZBESITZSTATUS

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 304,648
Non-null 304,648 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 10
Avg Length 0.0
Buffered Length 15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

          , EIGENTUM  , MIETE     , KEINEINFO

272. ZZMARKT_MITBEWERBER

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 25 (0.0%)
Null 304,623 (99.99%)
Unique 0 (0.0%)
Min Length 0
Max Length 1
Avg Length 0.0
Buffered Length 1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

J, N

273. ZZBIOGASWUNSCH

Type: string → VARCHAR(6)
Nullable: Yes

Metric Value
Total Rows 304,648
Non-null 107 (0.0%)
Null 304,541 (99.96%)
Unique 0 (0.0%)
Min Length 0
Max Length 4
Avg Length 0.0
Buffered Length 6 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 304,648 - Parse Success: 304,648 / 304,648

Sample Values: 

NIE, .B10, .B40, .B70, .B30

PostgreSQL DDL

See kna1_schema.sql

Generated by process-csv-to-postgres v1.0.0