| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPContract Billing |
| 1 | DBERCHZ | Individual Line Items | 70 | BETRART | Operation Type for Lighting Unit | nvarchar | 4 | 0 | | |
| 2 | DBERCHZ4 | Individual line items (rarely used fields) | 5 | BETRART | Operation Type for Lighting Unit | nvarchar | 4 | 0 | | |
| 3 | DBERCHZ8 | Document line items (rarely used fields, unimportant) | 5 | BETRART | Operation Type for Lighting Unit | nvarchar | 4 | 0 | | |
| 4 | EBASL | Operation Type for Lighting Unit | 6 | BETRART | Operation Type for Lighting Unit | nvarchar | 4 | 0 | | |
| 5 | EBURNH | Burning Hour Calendar for Lighting Unit | 2 | BETRART | Operation Type for Lighting Unit | nvarchar | 4 | 0 | | |
| 6 | TE497T | Operation Type for Lighting Unit | 3 | BETRART | Operation Type for Lighting Unit | nvarchar | 4 | 0 | | |
| TOPInvoicing |
| 7 | DBERDZ | DB Table: Individ. Lines - Print Document | 96 | BETRART | Operation Type for Lighting Unit | nvarchar | 4 | 0 | | |
| TOPMaster Data |
| 8 | TE497 | Operation Type for Lighting Unit | 2 | BETRART | Operation Type for Lighting Unit | nvarchar | 4 | 0 | | |
