| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | MATNR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 3 | KOMBINAT | Combination of a device category | nvarchar | 8 | 0 | | | | Allow NULL? |
| 4 | FUNKLAS | Function class | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | BAUKLAS | Construction class | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | BAUFORM | Device category description | nvarchar | 30 | 0 | | | | Allow NULL? |
| 7 | BAUTXT | Text for description | nvarchar | 30 | 0 | | | | Allow NULL? |
| 8 | PREISKLA | Price Class | nvarchar | 10 | 0 | | | | Allow NULL? |
| 9 | PTBNUM | PTI number | nvarchar | 15 | 0 | | | | Allow NULL? |
| 10 | DVGWNUM | GGWA number | nvarchar | 15 | 0 | | | | Allow NULL? |
| 11 | BGLKZ | Type of certification requirement | char | 1 | 0 | | | | Allow NULL? |
| 12 | VLZEITT | Calibration validity (yrs) for ext. devs subject to certif. | decimal | 2 | 0 | | | | |
| 13 | VLZEITTI | Internal certification period (years) | decimal | 2 | 0 | | | | |
| 14 | VLZEITN | Old cal. validity/int. cert. period (yrs) until prod. year | decimal | 2 | 0 | | | | |
| 15 | VLKZBAU | Prod. yr until which old calib. valid./int.insp.per.is valid | nvarchar | 4 | 0 | | | | Allow NULL? |
| 16 | ZWGRUPPE | Register Group | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | EAGRUPPE | Input/output group | nvarchar | 8 | 0 | | | | Allow NULL? |
| 18 | MESSART | Type of measurement | char | 1 | 0 | | | | Allow NULL? |
| 19 | UEBERVER | Transformation ratio | decimal | 10 | 3 | | | | |
| 20 | BGLNETZ | Certify installed devices | char | 1 | 0 | | | | Allow NULL? |
| 21 | WGRUPPE | Winding group | nvarchar | 8 | 0 | | | | Allow NULL? |
| 22 | PRIMWNR1 | Winding number of active primary winding | nvarchar | 2 | 0 | | | | Allow NULL? |
| 23 | SEKWNR1 | Winding number of active secondary winding | nvarchar | 2 | 0 | | | | Allow NULL? |
| 24 | PRIMWNR2 | Winding number of active primary winding | nvarchar | 2 | 0 | | | | Allow NULL? |
| 25 | SEKWNR2 | Winding number of active secondary winding | nvarchar | 2 | 0 | | | | Allow NULL? |
| 26 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 27 | AEDAT | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | ZSPANNS | Register factor: secondary transformer voltage | decimal | 4 | 1 | | | | |
| 29 | ZSTROMS | Register factor: secondary transformer current | decimal | 5 | 2 | | | | |
| 30 | ZSPANNP | Register factor: primary transformer voltage | decimal | 6 | 0 | | | | |
| 31 | ZSTROMP | Register factor: primary transformer current | decimal | 5 | 1 | | | | |
| 32 | GRPMATNR | Number for group material for IS-U serialization | nvarchar | 18 | 0 | | | | Allow NULL? |
| 33 | ORDER_CODE | Special Order Code for Dev./Dev. Category in Replacement | nvarchar | 4 | 0 | | | | Allow NULL? |
| 34 | SPARTE | Division | nvarchar | 2 | 0 | | | | Allow NULL? |
| 35 | NENNBEL | Nominal load | decimal | 10 | 4 | | | | |
| 36 | KENNZTYP | Vehicle category | nvarchar | 2 | 0 | | | | Allow NULL? |
| 37 | KENNZTYP_TXT | Short Description of Repository Objects | nvarchar | 60 | 0 | | | | Allow NULL? |
| 38 | STELLPLATZ | Number of container spaces | nvarchar | 2 | 0 | | | | Allow NULL? |
| 39 | HOEHEBEH | Height of container category | decimal | 7 | 2 | | | | |
| 40 | BREITEBEH | Width of container category | decimal | 7 | 2 | | | | |
| 41 | TIEFEBEH | Depth of container category | decimal | 7 | 2 | | | | |
| 42 | ABMEIH | Unit for the dimensions of the container category | nvarchar | 3 | 0 | | | | Allow NULL? |
| 43 | LADEZEIT | Pull-up time of container category | decimal | 7 | 2 | | | | |
| 44 | LADZ_EIH | Unit of pull-up time | nvarchar | 3 | 0 | | | | Allow NULL? |
| 45 | LADEVOL | Load volume | decimal | 7 | 2 | | | | |
| 46 | LADV_EIH | Unit of load volume | nvarchar | 3 | 0 | | | | Allow NULL? |
| 47 | GEW_ZUL | Maximum permissible load for container category | decimal | 7 | 2 | | | | |
| 48 | GEWEIH | Unit of Weight | nvarchar | 3 | 0 | | | | Allow NULL? |
| 49 | EIGENTUM | Owner | nvarchar | 2 | 0 | | | | Allow NULL? |
| 50 | EIGENTUM_TXT | Short Description of Repository Objects | nvarchar | 60 | 0 | | | | Allow NULL? |
| 51 | LADV_TXT | Dimension Text | nvarchar | 60 | 0 | | | | Allow NULL? |
| 52 | LADZ_TXT | Dimension Text | nvarchar | 60 | 0 | | | | Allow NULL? |
| 53 | GEW_TXT | Dimension Text | nvarchar | 60 | 0 | | | | Allow NULL? |
| 54 | ABM_TXT | Dimension Text | nvarchar | 60 | 0 | | | | Allow NULL? |
| 55 | PRODUCT_AREA | Service Area | nvarchar | 2 | 0 | | | | Allow NULL? |
| 56 | NOTIF_CODE | Notification code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 57 | G_INFOSATZ | Type of Device to be Created | char | 1 | 0 | | | | Allow NULL? |
| 58 | PPM_METER | Prepayment Meter | nvarchar | 2 | 0 | | | | Allow NULL? |
| 59 | LOSSDTGROUP | Loss Determination Group | nvarchar | 8 | 0 | | | | Allow NULL? |
| 60 | RATING | Power Transformer: Rating | nvarchar | 11 | 0 | | | | Allow NULL? |
| 61 | P_VOLTAGE | Power Transformer: Primary Voltage | nvarchar | 8 | 0 | | | | Allow NULL? |
| 62 | S_VOLTAGE | Power Transformer: Secondary Voltage | nvarchar | 8 | 0 | | | | Allow NULL? |
| 63 | AMS_DGRP | AMS Determination Group | nvarchar | 10 | 0 | | | | Allow NULL? |
| 64 | AMCG_DGRP | AMCG Determination Group | nvarchar | 10 | 0 | | | | Allow NULL? |
| 65 | SMART_METER | Advanced Meter | char | 1 | 0 | | | | Allow NULL? |
| 66 | MSG_DGRP_ID | Message Attribute Determination Group | nvarchar | 4 | 0 | | | | Allow NULL? |
