Skip to content

Data Profile: iflo

Generated: 2025-11-27 09:38:33.454811 Schema: raw.iflo Total Rows: 842,478 Columns: 155 Completeness: 82.58%

Source Files

File Rows Size
20251105000002_iflo_6120.csv 842,478 1524.7 MB
Total 842,478 1524.7 MB

Column Summary

# Column Type PostgreSQL Nullable Nulls Unique
1 MANDT integer INTEGER No 0.00% 0
2 TPLNR string VARCHAR(45) No 0.00% 0
3 SPRAS string VARCHAR(1) No 0.00% 0
4 PLTXT string VARCHAR(60) No 0.00% 0
5 KZLTX string VARCHAR(1) Yes 97.53% 0
6 KZMLA string VARCHAR(1) Yes 52.94% 0
7 PLTXU string VARCHAR(60) No 0.00% 0
8 TEXTCHANGEDDATETIME string VARCHAR(21) No 0.00% 0
9 MLANG string VARCHAR(1) No 0.00% 0
10 TPLKZ string VARCHAR(7) No 0.00% 0
11 FLTYP string VARCHAR(1) No 0.00% 0
12 TPLMA string VARCHAR(45) No 0.00% 0
13 ERDAT string VARCHAR(12) No 0.00% 0
14 ERNAM string VARCHAR(18) No 0.00% 0
15 AEDAT string VARCHAR(12) No 0.00% 0
16 AENAM string VARCHAR(18) No 0.00% 0
17 DATAB string VARCHAR(12) No 0.00% 0
18 BEGRU string VARCHAR(6) No 0.00% 0
19 TRPNR string VARCHAR(45) No 0.00% 0
20 PSTAE string VARCHAR(6) No 0.00% 0
21 STNAM string VARCHAR(18) No 0.00% 0
22 LVORM string VARCHAR(1) Yes 100.00% 0
23 SUBMT string VARCHAR(60) No 0.00% 0
24 SUBMTI string VARCHAR(1) No 0.00% 0
25 MAPAR string VARCHAR(45) No 0.00% 0
26 MAPARI string VARCHAR(1) Yes 53.13% 0
27 IEQUI string VARCHAR(1) Yes 0.00% 0
28 IEQUII string VARCHAR(1) Yes 0.69% 0
29 EINZL string VARCHAR(1) Yes 100.00% 0
30 EINZLI string VARCHAR(1) No 0.00% 0
31 IWERK string VARCHAR(6) No 0.00% 0
32 IWERKI string VARCHAR(1) No 0.00% 0
33 INGRP string VARCHAR(4) Yes 99.99% 0
34 INGRPI string VARCHAR(1) No 0.00% 0
35 PM_OBJTY string VARCHAR(3) Yes 99.91% 0
36 LGWID string VARCHAR(12) No 0.00% 0
37 LGWIDI string VARCHAR(1) No 0.00% 0
38 RBNR string VARCHAR(13) No 0.00% 0
39 RBNR_I string VARCHAR(1) No 0.00% 0
40 OBJNR string VARCHAR(33) No 0.00% 0
41 POSNR string VARCHAR(6) No 0.00% 0
42 ISTYP string VARCHAR(1) Yes 16.68% 0
43 PREMS string VARCHAR(15) No 0.00% 0
44 EQART string VARCHAR(15) No 0.00% 0
45 INVNR string VARCHAR(37) No 0.00% 0
46 GROES string VARCHAR(27) No 0.00% 0
47 BRGEW numeric NUMERIC(12,2) No 0.00% 0
48 GEWEI string VARCHAR(1) Yes 100.00% 0
49 ANSWT numeric NUMERIC(12,2) No 0.00% 0
50 WAERS string VARCHAR(7) No 0.00% 0
51 ANSDT string VARCHAR(12) No 0.00% 0
52 HERST string VARCHAR(45) No 0.00% 0
53 HERLD string VARCHAR(1) Yes 100.00% 0
54 BAUJJ string VARCHAR(6) No 0.00% 0
55 BAUMM string VARCHAR(1) Yes 100.00% 0
56 TYPBZ string VARCHAR(30) No 0.00% 0
57 EMATN string VARCHAR(60) No 0.00% 0
58 SERGE string VARCHAR(45) No 0.00% 0
59 HANDLE string VARCHAR(33) No 0.00% 0
60 TSEGTP string VARCHAR(15) No 0.00% 0
61 CHANGEDDATETIME string VARCHAR(21) No 0.00% 0
62 ENDOFUSE string VARCHAR(12) No 0.00% 0
63 ZZHAUSART string VARCHAR(12) No 0.00% 0
64 ZZFWGEB string VARCHAR(60) No 0.00% 0
65 ZZSLGEB string VARCHAR(15) No 0.00% 0
66 ZZVORDR numeric NUMERIC(12,2) No 0.00% 0
67 ZZEGID string VARCHAR(13) No 0.00% 0
68 ZZDRMNR string VARCHAR(18) No 0.00% 0
69 ZZDRMSCH string VARCHAR(1) Yes 99.84% 0
70 ZZENERGIEZONE string VARCHAR(15) No 0.00% 0
71 ZZBAUZONE string VARCHAR(150) No 0.00% 0
72 ZZN_SAN_JAHR string VARCHAR(6) No 0.00% 0
73 ZZN_SAN_DAEMM string VARCHAR(1) Yes 100.00% 0
74 ZZN_SAN_FENSTER string VARCHAR(1) Yes 100.00% 0
75 ZZN_SAN_DACH string VARCHAR(1) Yes 100.00% 0
76 ZZL_SAN_JAHR string VARCHAR(6) No 0.00% 0
77 ZZL_SAN_DAEMM string VARCHAR(1) Yes 100.00% 0
78 ZZL_SAN_FENSTER string VARCHAR(1) Yes 100.00% 0
79 ZZL_SAN_DACH string VARCHAR(1) Yes 100.00% 0
80 ZZANZ_WOHNUNGEN string VARCHAR(6) No 0.00% 0
81 ZZEXZONE integer INTEGER Yes 99.99% 0
82 ZMAXAUSLASTHAK string VARCHAR(12) No 0.00% 0
83 ZANSCHLSICHHAK string VARCHAR(12) No 0.00% 0
84 ZABSICHHV string VARCHAR(12) No 0.00% 0
85 ZVERTEILNETZB string VARCHAR(15) No 0.00% 0
86 ZLASTABWURF string VARCHAR(6) No 0.00% 0
87 ZPPOBJEKT_B string VARCHAR(12) No 0.00% 0
88 ZMAXABSICHEMOB string VARCHAR(12) No 0.00% 0
89 ZERSCHLART string VARCHAR(15) No 0.00% 0
90 ZLASTMANAGEMENT string VARCHAR(15) No 0.00% 0
91 ZKONEKTIVITAET string VARCHAR(15) No 0.00% 0
92 ZBETREIBMOD string VARCHAR(60) No 0.00% 0
93 ZPROJEKTBEZ string VARCHAR(90) No 0.00% 0
94 VBELN_MOB string VARCHAR(15) No 0.00% 0
95 ZINBETRIEBSETZUNGSDATUM string VARCHAR(12) No 0.00% 0
96 ZSTROMPRODUKT string VARCHAR(30) No 0.00% 0
97 ZNACHW_GRUENSTROM string VARCHAR(6) No 0.00% 0
98 ZKUNDENNUMMER_VNB string VARCHAR(30) No 0.00% 0
99 ZINSTANDHALTUNGSVERTRAG string VARCHAR(6) No 0.00% 0
100 ZINSTANDHALTUNGSINTERVALL string VARCHAR(3) No 0.00% 0
101 ZPARKPLATZBEZEICHNUNG string VARCHAR(30) No 0.00% 0
102 ZPARKPLATZZUSATZBEZ string VARCHAR(30) No 0.00% 0
103 ZPARKPLATZVORSICHERUNG string VARCHAR(30) No 0.00% 0
104 ZZVBELN_NACHWEIS_TP string VARCHAR(15) No 0.00% 0
105 ZZBEMERKUNG_TP string VARCHAR(60) No 0.00% 0
106 DUMMY_IFLOT_INCL_EEW_PS string VARCHAR(1) Yes 100.00% 0
107 FLLB_DUTY string VARCHAR(1) Yes 100.00% 0
108 FLLB_HIDE string VARCHAR(1) Yes 100.00% 0
109 ILOAN string VARCHAR(18) No 0.00% 0
110 ABCKZ string VARCHAR(1) Yes 100.00% 0
111 ABCKZI string VARCHAR(1) No 0.00% 0
112 EQFNR string VARCHAR(45) No 0.00% 0
113 EQFNRI string VARCHAR(1) Yes 26.03% 0
114 SWERK string VARCHAR(6) No 0.00% 0
115 SWERKI string VARCHAR(1) No 0.00% 0
116 STORT string VARCHAR(15) No 0.00% 0
117 STORTI string VARCHAR(1) Yes 4.33% 0
118 MSGRP string VARCHAR(12) No 0.00% 0
119 MSGRPI string VARCHAR(1) No 0.00% 0
120 BEBER string VARCHAR(1) Yes 100.00% 0
121 BEBERI string VARCHAR(1) No 0.00% 0
122 CR_OBJTY string VARCHAR(3) Yes 99.91% 0
123 PPSID string VARCHAR(12) No 0.00% 0
124 PPSIDI string VARCHAR(1) No 0.00% 0
125 GSBER string VARCHAR(6) No 0.00% 0
126 GSBERI string VARCHAR(1) Yes 5.81% 0
127 KOKRS string VARCHAR(6) No 0.00% 0
128 KOKRSI string VARCHAR(1) No 0.00% 0
129 KOSTL string VARCHAR(15) No 0.00% 0
130 KOSTLI string VARCHAR(1) No 0.00% 0
131 PROID string VARCHAR(12) No 0.00% 0
132 PROIDI string VARCHAR(1) No 0.00% 0
133 BUKRS string VARCHAR(6) No 0.00% 0
134 BUKRSI string VARCHAR(1) No 0.00% 0
135 ANLNR string VARCHAR(18) No 0.00% 0
136 ANLNRI string VARCHAR(1) Yes 5.80% 0
137 ANLUN string VARCHAR(6) No 0.00% 0
138 ANLUNI string VARCHAR(1) Yes 29.00% 0
139 DAUFN string VARCHAR(18) No 0.00% 0
140 DAUFNI string VARCHAR(1) No 0.00% 0
141 AUFNR string VARCHAR(18) No 0.00% 0
142 AUFNRI string VARCHAR(1) No 0.00% 0
143 VKORG string VARCHAR(6) No 0.00% 0
144 VKORGI string VARCHAR(1) No 0.00% 0
145 VTWEG string VARCHAR(3) Yes 54.32% 0
146 VTWEGI string VARCHAR(1) No 0.00% 0
147 SPART string VARCHAR(3) Yes 54.32% 0
148 SPARTI string VARCHAR(1) No 0.00% 0
149 ADRNR string VARCHAR(15) No 0.00% 0
150 ADRNRI string VARCHAR(1) Yes 0.00% 0
151 OWNER integer INTEGER No 0.00% 0
152 VKBUR string VARCHAR(6) No 0.00% 0
153 VKGRP string VARCHAR(4) Yes 99.99% 0
154 IFLOT_SRTYPE string VARCHAR(15) No 0.00% 0
155 IFLOT_SNTYPE string VARCHAR(1) Yes 100.00% 0

Detailed Column Profiles

1. MANDT

Type: integer → INTEGER
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

100

2. TPLNR

Type: string → VARCHAR(45)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

X/4584.G1548.0001             , X/4604.G1552.0002             , X/4604.G1560.0001             , X/0134.08950.0001             , 0/0088.07264.0018    .075

3. SPRAS

Type: string → VARCHAR(1)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

D

4. PLTXT

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

                                        , Haupthahn / Hausregler                  , Haupthahnen / Hausregler                , Via Plaun da l'Aua 4                    , Via Bulaseras 1

5. KZLTX

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 20,798 (2.5%)
Null 821,680 (97.53%)
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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

X

6. KZMLA

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 396,502 (47.1%)
Null 445,976 (52.94%)
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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

X

7. PLTXU

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

                                        , HAUPTHAHN / HAUSREGLER                  , HAUPTHAHNEN / HAUSREGLER                , KARLIHOF 1A                             , OBERDORF 3

8. TEXTCHANGEDDATETIME

Type: string → VARCHAR(21)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

0, 20241230085431, 20241230085510, 20241230085417, 20241230085504

9. MLANG

Type: string → VARCHAR(1)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

D

10. TPLKZ

Type: string → VARCHAR(7)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

AO_GP, GEO  , NET

11. FLTYP

Type: string → VARCHAR(1)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

A, G, S, T, O

12. TPLMA

Type: string → VARCHAR(45)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

X                             , Z/0001                        , X/4547.85572                  , X/3390.50589                  , X/4547.85557

13. ERDAT

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

20131004, 20250218, 20010418, 19980308, 20021216

14. ERNAM

Type: string → VARCHAR(18)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

FINK        , JOBADMIN    , FISCHERN    , HALBHERR    , GAHLER

15. AEDAT

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

00000000, 20030217, 20021213, 20080925, 20010425

16. AENAM

Type: string → VARCHAR(18)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

            , SCHREFEL    , STALDER     , IRNIGER     , JOBADMIN

17. DATAB

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

00000000, 20221201, 20220905, 20000614, 20000502

18. BEGRU

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

    , IHA

19. TRPNR

Type: string → VARCHAR(45)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values:

20. PSTAE

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values:

21. STNAM

Type: string → VARCHAR(18)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values:

22. LVORM

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 0 (0.0%)
Null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

(no data)

23. SUBMT

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values:

24. SUBMTI

Type: string → VARCHAR(1)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

D

25. MAPAR

Type: string → VARCHAR(45)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values:

26. MAPARI

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 394,885 (46.9%)
Null 447,593 (53.13%)
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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

D

27. IEQUI

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 842,462 (100.0%)
Null 16 (0.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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

X

28. IEQUII

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 836,691 (99.3%)
Null 5,787 (0.69%)
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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

D

29. EINZL

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 1 (0.0%)
Null 842,477 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

X

30. EINZLI

Type: string → VARCHAR(1)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

H, D

31. IWERK

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

0100,     , 0300

32. IWERKI

Type: string → VARCHAR(1)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

D, H

33. INGRP

Type: string → VARCHAR(4)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 50 (0.0%)
Null 842,428 (99.99%)
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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

094

34. INGRPI

Type: string → VARCHAR(1)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

D, H

35. PM_OBJTY

Type: string → VARCHAR(3)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 743 (0.1%)
Null 841,735 (99.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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

A

36. LGWID

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

00000000, 10000234, 10000167

37. LGWIDI

Type: string → VARCHAR(1)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

H, D

38. RBNR

Type: string → VARCHAR(13)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values:

39. RBNR_I

Type: string → VARCHAR(1)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

H, D

40. OBJNR

Type: string → VARCHAR(33)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 22
Avg Length 0.0
Buffered Length 33 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

IF00000000000001161929, IF00000000000001161940, IF00000000000001161942, IF00000000000001162078, IF00000000000001161821

41. POSNR

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

    , 345 , 450 , 340 , 300

42. ISTYP

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 701,918 (83.3%)
Null 140,560 (16.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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

C, D

43. PREMS

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

          , 0002010304, 0002008134, 0002302916, 0001012970

44. EQART

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

          , Y-ERDGAS  , Y-ÖL      , Y-FERNW   , Y-PELLETS

45. INVNR

Type: string → VARCHAR(37)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values:

46. GROES

Type: string → VARCHAR(27)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values:

47. BRGEW

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

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

0.0

48. GEWEI

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 0 (0.0%)
Null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

(no data)

49. ANSWT

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

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

0.0

50. WAERS

Type: string → VARCHAR(7)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values:

51. ANSDT

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

00000000, 19000101

52. HERST

Type: string → VARCHAR(45)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

                              , Roland Leuthold

53. HERLD

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 0 (0.0%)
Null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

(no data)

54. BAUJJ

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

    , 1947, 1944, 1931, 1946

55. BAUMM

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 0 (0.0%)
Null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

(no data)

56. TYPBZ

Type: string → VARCHAR(30)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

                    , feines Raclette

57. EMATN

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values:

58. SERGE

Type: string → VARCHAR(45)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values:

59. HANDLE

Type: string → VARCHAR(33)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 22
Avg Length 0.0
Buffered Length 33 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,478 - Parse Success: 842,478 / 842,478

Sample Values:

60. TSEGTP

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values:

61. CHANGEDDATETIME

Type: string → VARCHAR(21)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

0, 20241230085431, 20241230085510, 20241230085516, 20241230085519

62. ENDOFUSE

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

00000000

63. ZZHAUSART

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

        , MFH     , EFH     , BG      , ÖG

64. ZZFWGEB

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

                                        , GA_4.22_Tellstrasse                     , GA_5.02_Thurwiesenstrasse               , GA_2.33_Josefstrasse                    , GA_5.04_Nürenbergstrasse

65. ZZSLGEB

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

          , Oerlikon  , Seebach   , Schwamendi, Neuaffolte

66. ZZVORDR

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

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

0.0, 4.5

67. ZZEGID

Type: string → VARCHAR(13)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

000000000, 210216424, 001157594, 210222774, 001436756

68. ZZDRMNR

Type: string → VARCHAR(18)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

            , 6.004       , 12.004      , 9.044       , 14.106

69. ZZDRMSCH

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 1,307 (0.2%)
Null 841,171 (99.84%)
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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

A, -, B, Z, C

70. ZZENERGIEZONE

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

          , B 11      , F 11      , F 23      , K 11

71. ZZBAUZONE

Type: string → VARCHAR(150)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 100
Avg Length 0.0
Buffered Length 150 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

                                                                                                    , Wohnzonen                                                                                           , Mischzonen                                                                                          , Zentrumszonen                                                                                       , Arbeitszonen

72. ZZN_SAN_JAHR

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values:

73. ZZN_SAN_DAEMM

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 0 (0.0%)
Null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

(no data)

74. ZZN_SAN_FENSTER

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 0 (0.0%)
Null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

(no data)

75. ZZN_SAN_DACH

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 0 (0.0%)
Null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

(no data)

76. ZZL_SAN_JAHR

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values:

77. ZZL_SAN_DAEMM

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 0 (0.0%)
Null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

(no data)

78. ZZL_SAN_FENSTER

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 0 (0.0%)
Null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

(no data)

79. ZZL_SAN_DACH

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 0 (0.0%)
Null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

(no data)

80. ZZANZ_WOHNUNGEN

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

0000, 0012, 0018, 0083, 0022

81. ZZEXZONE

Type: integer → INTEGER
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 57 (0.0%)
Null 842,421 (99.99%)
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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

2, 0, 1

82. ZMAXAUSLASTHAK

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

        , k.A.    , 160     , 125     , 100

83. ZANSCHLSICHHAK

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

        , k.A.    , 125     , 160     , 80

84. ZABSICHHV

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

        , k.A.    , 80      , 160     , 125

85. ZVERTEILNETZB

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

          , EKZ       , EWZ       , BKW       , TBW

86. ZLASTABWURF

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

    , Ja  , Nein

87. ZPPOBJEKT_B

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

        , 20      , 13      , 12      , 75

88. ZMAXABSICHEMOB

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

        , 63      , 80      , K.A.    , 160

89. ZERSCHLART

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

          , FB        , SF        , STERN     , SS

90. ZLASTMANAGEMENT

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

          , Dynamisch , Statisch

91. ZKONEKTIVITAET

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

          , LTE-Router, LAN       , SIM

92. ZBETREIBMOD

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

                                        , start                                   , smart                                   , smart+                                  , keines

93. ZPROJEKTBEZ

Type: string → VARCHAR(90)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

                                                            , Ladeinfrastruktur charge@immo

94. VBELN_MOB

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

          , 0007025048, 0007025433, 0007025254, 0007025128

95. ZINBETRIEBSETZUNGSDATUM

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

00000000

96. ZSTROMPRODUKT

Type: string → VARCHAR(30)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values:

97. ZNACHW_GRUENSTROM

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values:

98. ZKUNDENNUMMER_VNB

Type: string → VARCHAR(30)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values:

99. ZINSTANDHALTUNGSVERTRAG

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values:

100. ZINSTANDHALTUNGSINTERVALL

Type: string → VARCHAR(3)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

00

101. ZPARKPLATZBEZEICHNUNG

Type: string → VARCHAR(30)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values:

102. ZPARKPLATZZUSATZBEZ

Type: string → VARCHAR(30)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

                    , Bugnion Chi Meei

103. ZPARKPLATZVORSICHERUNG

Type: string → VARCHAR(30)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values:

104. ZZVBELN_NACHWEIS_TP

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

          , 0008057180, 0008057095

105. ZZBEMERKUNG_TP

Type: string → VARCHAR(60)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values:

106. DUMMY_IFLOT_INCL_EEW_PS

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 0 (0.0%)
Null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

(no data)

107. FLLB_DUTY

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 0 (0.0%)
Null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

(no data)

108. FLLB_HIDE

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 0 (0.0%)
Null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

(no data)

109. ILOAN

Type: string → VARCHAR(18)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

000002951015, 000002951029, 000002951055, 000002951427, 000002951798

110. ABCKZ

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 1 (0.0%)
Null 842,477 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

N

111. ABCKZI

Type: string → VARCHAR(1)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

H, D

112. EQFNR

Type: string → VARCHAR(45)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

                              , ZH                            , 6257076                       , 6257103                       , 6257096

113. EQFNRI

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 623,160 (74.0%)
Null 219,318 (26.03%)
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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

D

114. SWERK

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

0100,     , 0300

115. SWERKI

Type: string → VARCHAR(1)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

D, H

116. STORT

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

          , U1        , EG        , PA        , 1.

117. STORTI

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 805,969 (95.7%)
Null 36,509 (4.33%)
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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

D, H

118. MSGRP

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

        , TECHNIK , HEIZZENT, LINKS   , HEIZUNG

119. MSGRPI

Type: string → VARCHAR(1)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

D, H

120. BEBER

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 0 (0.0%)
Null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

(no data)

121. BEBERI

Type: string → VARCHAR(1)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

D, H

122. CR_OBJTY

Type: string → VARCHAR(3)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 750 (0.1%)
Null 841,728 (99.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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

A

123. PPSID

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

00000000, 10000234, 10000167

124. PPSIDI

Type: string → VARCHAR(1)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

D, H

125. GSBER

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values:

126. GSBERI

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 793,566 (94.2%)
Null 48,912 (5.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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

H, D

127. KOKRS

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

0100,

128. KOKRSI

Type: string → VARCHAR(1)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

D, H

129. KOSTL

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

          , 0000006241, 0000003736, 0000003745, 0000003737

130. KOSTLI

Type: string → VARCHAR(1)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

D, H

131. PROID

Type: string → VARCHAR(12)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

00000000

132. PROIDI

Type: string → VARCHAR(1)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

D, H

133. BUKRS

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

0100,     , 0300

134. BUKRSI

Type: string → VARCHAR(1)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

D, H

135. ANLNR

Type: string → VARCHAR(18)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values:

136. ANLNRI

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 793,574 (94.2%)
Null 48,904 (5.80%)
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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

D, H

137. ANLUN

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values:

138. ANLUNI

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 598,195 (71.0%)
Null 244,283 (29.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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

D, H

139. DAUFN

Type: string → VARCHAR(18)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

            , 000002010247, 000002007384, 000002001103, 000002010933

140. DAUFNI

Type: string → VARCHAR(1)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

D, H

141. AUFNR

Type: string → VARCHAR(18)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values:

142. AUFNRI

Type: string → VARCHAR(1)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

D, H

143. VKORG

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

    , 0001

144. VKORGI

Type: string → VARCHAR(1)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

D, H

145. VTWEG

Type: string → VARCHAR(3)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 384,848 (45.7%)
Null 457,630 (54.32%)
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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

01, 02

146. VTWEGI

Type: string → VARCHAR(1)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

D, H

147. SPART

Type: string → VARCHAR(3)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 384,848 (45.7%)
Null 457,630 (54.32%)
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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

01, 07

148. SPARTI

Type: string → VARCHAR(1)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

D, H

149. ADRNR

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

          , 0002007423, 0002007435, 0002007440, 0002007445

150. ADRNRI

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 842,473 (100.0%)
Null 5 (0.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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

D, H

151. OWNER

Type: integer → INTEGER
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

2

152. VKBUR

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

    , MS  , VE  , VM

153. VKGRP

Type: string → VARCHAR(4)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 56 (0.0%)
Null 842,422 (99.99%)
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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

MCH, WD , GC

154. IFLOT_SRTYPE

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 842,478
Non-null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values:

155. IFLOT_SNTYPE

Type: string → VARCHAR(1)
Nullable: Yes

Metric Value
Total Rows 842,478
Non-null 0 (0.0%)
Null 842,478 (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: 842,478 - Parse Success: 842,478 / 842,478

Sample Values: 

(no data)

PostgreSQL DDL

See iflo_schema.sql

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