Skip to content

Data Profile: s610

Generated: 2025-11-25 04:24:14.588399 Schema: raw.s610 Total Rows: 2,982,657 Columns: 59 Completeness: 99.26%

Source Files

File Rows Size
20251029132741_s610_5978.csv 2,982,657 1513.7 MB
Total 2,982,657 1513.7 MB

Column Summary

# Column Type PostgreSQL Nullable Nulls Unique
1 MANDT integer INTEGER No 0.00% 0
2 SSOUR string VARCHAR(6) No 0.00% 0
3 VRSIO string VARCHAR(4) No 0.00% 0
4 SPMON string VARCHAR(9) No 0.00% 0
5 SPTAG string VARCHAR(12) No 0.00% 0
6 SPWOC string VARCHAR(9) No 0.00% 0
7 SPBUP integer INTEGER No 0.00% 0
8 REGION_03 string VARCHAR(4) Yes 0.00% 0
9 CITY_CO_04 string VARCHAR(18) No 0.00% 0
10 ANLART_05 string VARCHAR(6) No 0.00% 0
11 ZZVBSAR_06 string VARCHAR(12) No 0.00% 0
12 VERTRAG_07 string VARCHAR(15) No 0.00% 0
13 TARIFTY_08 string VARCHAR(15) No 0.00% 0
14 GPARTNE_09 string VARCHAR(15) No 0.00% 0
15 BUDAT_01 integer INTEGER No 0.00% 0
16 BELEGDAT string VARCHAR(12) No 0.00% 0
17 PERIV string VARCHAR(3) No 0.00% 0
18 VWDAT string VARCHAR(15) No 0.00% 0
19 MASSBILL string VARCHAR(4) Yes 4.45% 0
20 TWAERS string VARCHAR(7) No 0.00% 0
21 D_MASSBILL string VARCHAR(4) Yes 39.46% 0
22 I_ABRMENGE numeric NUMERIC(12,2) No 0.00% 0
23 NETTOBTR numeric NUMERIC(12,2) No 0.00% 0
24 ZUORDDAT string VARCHAR(12) No 0.00% 0
25 BIS integer INTEGER No 0.00% 0
26 ZZCALORARE string VARCHAR(12) No 0.00% 0
27 ZZPRAREAAI string VARCHAR(12) No 0.00% 0
28 SPARTE string VARCHAR(3) No 0.00% 0
29 AKLASSE string VARCHAR(6) No 0.00% 0
30 KONDIGR string VARCHAR(15) No 0.00% 0
31 STTARIF string VARCHAR(15) No 0.00% 0
32 TARIFNR string VARCHAR(15) No 0.00% 0
33 REGIOGROUP string VARCHAR(12) No 0.00% 0
34 REGPOLIT string VARCHAR(12) No 0.00% 0
35 ZZGASPRSAR string VARCHAR(12) No 0.00% 0
36 ARBEITBTR numeric NUMERIC(12,2) No 0.00% 0
37 LEISTBTR numeric NUMERIC(12,2) No 0.00% 0
38 PAUSCHBTR numeric NUMERIC(12,2) No 0.00% 0
39 SONSTBTR numeric NUMERIC(12,2) No 0.00% 0
40 I_LEIMENGE numeric NUMERIC(12,2) No 0.00% 0
41 MIETEBTR numeric NUMERIC(12,2) No 0.00% 0
42 ZZBRAN1 string VARCHAR(15) No 0.00% 0
43 ZZBRSCH string VARCHAR(6) No 0.00% 0
44 ZZVKANAL string VARCHAR(6) No 0.00% 0
45 ZZAPTRANSP numeric NUMERIC(12,2) No 0.00% 0
46 ZZAPBIOUP numeric NUMERIC(12,2) No 0.00% 0
47 ZZAPCO2UP numeric NUMERIC(12,2) No 0.00% 0
48 ZZAPHANDEL numeric NUMERIC(12,2) No 0.00% 0
49 ZZAPVERTEI numeric NUMERIC(12,2) No 0.00% 0
50 ZZAMBIOUP numeric NUMERIC(12,2) No 0.00% 0
51 ZZAMCO2UP numeric NUMERIC(12,2) No 0.00% 0
52 ZZLPHANDEL numeric NUMERIC(12,2) No 0.00% 0
53 ZZLPTRANSP numeric NUMERIC(12,2) No 0.00% 0
54 ZZLPVERTEI numeric NUMERIC(12,2) No 0.00% 0
55 ZZAPTR_REG numeric NUMERIC(12,2) No 0.00% 0
56 ZZAPTR_SWI numeric NUMERIC(12,2) No 0.00% 0
57 ZZLPTR_REG numeric NUMERIC(12,2) No 0.00% 0
58 ZZLPTR_SWI numeric NUMERIC(12,2) No 0.00% 0
59 ZZMENARBHA numeric NUMERIC(12,2) No 0.00% 0

Detailed Column Profiles



1. MANDT

Type: integer → INTEGER
Nullable: No

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

Sample Values:

100


2. SSOUR

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:



3. VRSIO

Type: string → VARCHAR(4)
Nullable: No

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

Sample Values:

000


4. SPMON

Type: string → VARCHAR(9)
Nullable: No

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

Sample Values:

000000


5. SPTAG

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

00000000


6. SPWOC

Type: string → VARCHAR(9)
Nullable: No

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

Sample Values:

000000


7. SPBUP

Type: integer → INTEGER
Nullable: No

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

Sample Values:

202306, 202409, 202309, 202312, 202203


8. REGION_03

Type: string → VARCHAR(4)
Nullable: Yes

Metric Value
Total Rows 2,982,657
Non-null 2,982,629 (100.0%)
Null 28 (0.00%)
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: 2,982,657 - Parse Success: 2,982,657 / 2,982,657

Sample Values:

 Z ,  0 ,  B ,  A , X  


9. CITY_CO_04

Type: string → VARCHAR(18)
Nullable: No

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

Sample Values:

000000000001, 000000000067, 000000000098, 000000000088, 000000000087


10. ANLART_05

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

NHE , NBA , AHE , XABF, XWAS


11. ZZVBSAR_06

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

MFH     , EFH     , BG      , DRM     ,         


12. VERTRAG_07

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

0001248898, 0001329849, 0001021186, 0001321382, 0001325557


13. TARIFTY_08

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

HE        , GH        , EW        , EWP       , EH        


14. GPARTNE_09

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

0001067283, 0008509460, 0001036010, 0009000032, 0009001403


15. BUDAT_01

Type: integer → INTEGER
Nullable: No

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

Sample Values:

20240930, 20220930, 20230930, 20250331, 20141231


16. BELEGDAT

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

20230719, 20240104, 20240514, 20241224, 20240620


17. PERIV

Type: string → VARCHAR(3)
Nullable: No

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

Sample Values:

V9


18. VWDAT

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

0000000000


19. MASSBILL

Type: string → VARCHAR(4)
Nullable: Yes

Metric Value
Total Rows 2,982,657
Non-null 2,849,866 (95.5%)
Null 132,791 (4.45%)
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: 2,982,657 - Parse Success: 2,982,657 / 2,982,657

Sample Values:

KWH, M3 


20. TWAERS

Type: string → VARCHAR(7)
Nullable: No

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

Sample Values:

CHF  


21. D_MASSBILL

Type: string → VARCHAR(4)
Nullable: Yes

Metric Value
Total Rows 2,982,657
Non-null 1,805,737 (60.5%)
Null 1,176,920 (39.46%)
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: 2,982,657 - Parse Success: 2,982,657 / 2,982,657

Sample Values:

KW , M3 , KWH


22. I_ABRMENGE

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

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

Sample Values:

0.0, 11.0, 21.0, 42.0, 169.0


23. NETTOBTR

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

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

Sample Values:

0.0, 75.0, 450.0, 150.0, 225.0


24. ZUORDDAT

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

00000000, 20011130, 20011231, 20021130, 20011015


25. BIS

Type: integer → INTEGER
Nullable: No

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

Sample Values:

20240930, 20220930, 20250131, 20250531, 20241031


26. ZZCALORARE

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

0100    , 0102    ,         , WÄRME   , 0104    


27. ZZPRAREAAI

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

H02     , H03     , H04     , H05     ,         


28. SPARTE

Type: string → VARCHAR(3)
Nullable: No

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

Sample Values:

01, 06, 03, 07


29. AKLASSE

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

0100, 0130, 0600, 0300, 0700


30. KONDIGR

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

TARIF     ,           , ZÜRICH    , BIOGAS_MX , STÄFA     


31. STTARIF

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

HE        , GH        , VAHA00.100, V020_0100 , I010_0100 


32. TARIFNR

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

HE        , GH        , VAHA00.100, V020_0100 , I010_0100 


33. REGIOGROUP

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

K0007   , K0003   , K0006   , K0009   , K0010   


34. REGPOLIT

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

00100056, 00100011, 00100042, 00100031, 00100029


35. ZZGASPRSAR

Type: string → VARCHAR(12)
Nullable: No

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

Sample Values:

N       , M       , H       ,         , D       


36. ARBEITBTR

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

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

Sample Values:

0.0, 387.63, 3069.18, 1401.84, 3318.75


37. LEISTBTR

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

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

Sample Values:

0.0, 175.0, 174.52, 175.48, 3.29


38. PAUSCHBTR

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

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

Sample Values:

0.0, 133.0, 75.0, 107.0, 152.0


39. SONSTBTR

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

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

Sample Values:

0.0, 74.58, 69.17, 76.17, 20.0


40. I_LEIMENGE

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

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

Sample Values:

0.0, 60.0, 100.0, 5.005, 120.0


41. MIETEBTR

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

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

Sample Values:

0.0, 74.79, 75.62, 73.97, 76.44


42. ZZBRAN1

Type: string → VARCHAR(15)
Nullable: No

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

Sample Values:

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


43. ZZBRSCH

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

PI  ,     , BB  , ZZ  , EN  


44. ZZVKANAL

Type: string → VARCHAR(6)
Nullable: No

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

Sample Values:

DVER,     , WVER


45. ZZAPTRANSP

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

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

Sample Values:

0.0, 0.03, 0.04, 0.12, 0.64


46. ZZAPBIOUP

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

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

Sample Values:

0.0, 2.1, 770.48, 145.3, -1.05


47. ZZAPCO2UP

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

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

Sample Values:

0.0, 0.94, 5.32, -5.32, -0.94


48. ZZAPHANDEL

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

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

Sample Values:

0.0, 2.72, 1.43, 287.71, -934.99


49. ZZAPVERTEI

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

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

Sample Values:

0.0, 0.27, 0.41, 2.92, 2805.74


50. ZZAMBIOUP

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

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

Sample Values:

0.0, 11.2, -6451.2, 496.8, 10.85


51. ZZAMCO2UP

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

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

Sample Values:

0.0, 94.0, 532.0, -532.0, -94.0


52. ZZLPHANDEL

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

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

Sample Values:

0.0, 0.01, 56.9, 56.74, 42.87


53. ZZLPTRANSP

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

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

Sample Values:

0.0, 5.6, 5.48, 5.54, 3.47


54. ZZLPVERTEI

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

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

Sample Values:

0.0, 23.53, 23.28, 23.02, 24.3


55. ZZAPTR_REG

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

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

Sample Values:

0.0, 0.05, 0.09, 0.36, 4.12


56. ZZAPTR_SWI

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

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

Sample Values:

0.0, 0.01, 0.03, 0.02, 0.04


57. ZZLPTR_REG

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

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

Sample Values:

0.0, 7.78, 7.87, 4.42, 7.7


58. ZZLPTR_SWI

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

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

Sample Values:

0.0, 0.45, 0.44, 0.46, 0.42


59. ZZMENARBHA

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

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

Sample Values:

0.0, 11.0, 21.0, 32.0, 42.0

PostgreSQL DDL

See s610_schema.sql


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