| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | BELNR | Number of a billing document | nvarchar | 12 | 0 | | | | Allow NULL? |
| 3 | LFDNR | Sequence Number | nvarchar | 3 | 0 | | | | Allow NULL? |
| 4 | ERCHV_ORIG | Indicator: Origin of ERCHV | char | 1 | 0 | | | | Allow NULL? |
| 5 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | LOGIKZW | Logical register number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 8 | TIMTYP | Time category (days or months) | char | 1 | 0 | | | | Allow NULL? |
| 9 | PREISTYP | Price category | char | 1 | 0 | | | | Allow NULL? |
| 10 | PREIS | Price | nvarchar | 10 | 0 | | | | Allow NULL? |
| 11 | MASSBILL | Unit of measurement for billing | nvarchar | 3 | 0 | | | | Allow NULL? |
| 12 | ISTABLART | Meter reading type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 13 | ISTABLARTVA | Meter reading type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 14 | ABLESGR | Meter reading reason | nvarchar | 2 | 0 | | | | Allow NULL? |
| 15 | ABLESGRV | Previous meter reading reason | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | OPERAND | Operand | nvarchar | 10 | 0 | | | | Allow NULL? |
| 17 | STTARIF | Statistical rate | nvarchar | 10 | 0 | | | | Allow NULL? |
| 18 | BRENNWTA | Calorific value to be billed | decimal | 8 | 6 | | | | |
| 19 | ZUSTZAHL | Fixed Volume Correction Factor | decimal | 9 | 6 | | | | |
| 20 | ARTMENGE | Classification of billed quantity for statistics | char | 1 | 0 | | | | Allow NULL? |
| 21 | UMFAKTOR | Gas Conversion Factor | decimal | 17 | 12 | | | | |
| 22 | NETTOBTR | Net amount of billing line item | decimal | 13 | 2 | | | | |
| 23 | TWAERS | Transaction Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 24 | ABLBELNR | Internal ID for meter reading document | nvarchar | 20 | 0 | | | | Allow NULL? |
| 25 | BELZEILE | Billing line item for billing documents | nvarchar | 6 | 0 | | | | Allow NULL? |
| 26 | ERCHV_BW_REL | Not Relevant for Consumption History in BW | char | 1 | 0 | | | | Allow NULL? |
| 27 | SUBINST | Secondary Installation: Key | nvarchar | 10 | 0 | | | | Allow NULL? |
| 28 | SUBABRDATS | Scheduled Billing Date of Secondary Installation | nvarchar | 8 | 0 | | | | Allow NULL? |
| 29 | SUBABRVORG | Billing Transaction for Secondary Installation | nvarchar | 2 | 0 | | | | Allow NULL? |
| 30 | EZ_ZWSTAND | Meter Reading Recorded | float | 15 | 16 | | | | |
| 31 | EZ_ZWSTNDAB | Billed Meter Reading | float | 15 | 16 | | | | |
| 32 | EZ_ZWSTVOR | Previous Meter Reading | float | 15 | 16 | | | | |
| 33 | EZ_ABRMENGE | Billing Quantity | float | 15 | 16 | | | | |
| 34 | EZ_ZWSTDIFF | Meter Reading Difference | float | 15 | 16 | | | | |
