| 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 | BELZEILE | Billing line item for billing documents | nvarchar | 6 | 0 | | | | Allow NULL? |
| 4 | EQUNR | Equipment Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 5 | GERAET | Device | nvarchar | 18 | 0 | | | | Allow NULL? |
| 6 | MATNR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 7 | ZWNUMMER | Register | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | INDEXNR | Consecutive number of register relationship | nvarchar | 12 | 0 | | | | Allow NULL? |
| 9 | ABLESGR | Meter reading reason | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | ABLESGRV | Previous meter reading reason | nvarchar | 2 | 0 | | | | Allow NULL? |
| 11 | ATIM | Meter reading time (relevant to billing) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | ATIMVA | Time of day of previous meter reading | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | ADATMAX | Date of maximum meter reading | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | ATIMMAX | Time of maximum meter reading | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | THGDATUM | Gas allocation date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | ZUORDDAT | Meter reading allocation date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | REGRELSORT | Sort help for register relationships during bill printout | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | ABLBELNR | Internal ID for meter reading document | nvarchar | 20 | 0 | | | | Allow NULL? |
| 19 | LOGIKNR | Logical device number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 20 | LOGIKZW | Logical register number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 21 | ISTABLART | Meter reading type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 22 | ISTABLARTVA | Meter reading type of previous meter reading | nvarchar | 2 | 0 | | | | Allow NULL? |
| 23 | EXTPKZ | Simulation indicator for meter reading results | char | 1 | 0 | | | | Allow NULL? |
| 24 | BEGPROG | Start of forecast period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 25 | ENDEPROG | End of forecast period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | ABLHINW | Note from meter reader | nvarchar | 4 | 0 | | | | Allow NULL? |
| 27 | QDPROC | Quantity Determination Procedure | nvarchar | 2 | 0 | | | | Allow NULL? |
| 28 | MRCONNECT | Internal ID for meter reading document | nvarchar | 20 | 0 | | | | Allow NULL? |
| 29 | V_ZWSTAND | Places Before Decimal Point in Meter Reading | decimal | 17 | 0 | | | | |
| 30 | N_ZWSTAND | Places After Decimal Point in the Meter Reading | decimal | 14 | 14 | | | | |
| 31 | V_ZWSTNDAB | Predecimal Places in Billed Meter Reading | decimal | 17 | 0 | | | | |
| 32 | N_ZWSTNDAB | Decimal Places in the Billed Meter Reading | decimal | 14 | 14 | | | | |
| 33 | V_ZWSTVOR | Predecimal places in previous meter reading result | decimal | 17 | 0 | | | | |
| 34 | N_ZWSTVOR | Decimal places in previous meter reading | decimal | 14 | 14 | | | | |
| 35 | V_ZWSTDIFF | Pre-decimal places for the meter reading difference | decimal | 17 | 0 | | | | |
| 36 | N_ZWSTDIFF | Decimal places for the meter reading difference | decimal | 14 | 14 | | | | |
