| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPContract Billing |
1 | DBERCHZ | Individual Line Items | 127 | OPLFDNR | Consecutive number of an operand | nvarchar | 4 | 0 | | |
2 | DBERCHZ1 | Individual line items | 81 | OPLFDNR | Consecutive number of an operand | nvarchar | 4 | 0 | | |
3 | DBERCHZ5 | Individual line items (unimportant rows) | 81 | OPLFDNR | Consecutive number of an operand | nvarchar | 4 | 0 | | |
4 | EBASL | Operation Type for Lighting Unit | 5 | OPLFDNR | Consecutive number of an operand | nvarchar | 4 | 0 | | |
5 | ESOHZG | Special Agreemts for Heating Installtn | 4 | OPLFDNR | Consecutive number of an operand | nvarchar | 4 | 0 | | |
6 | ETTIF | Instln Facts | 4 | OPLFDNR | Consecutive number of an operand | nvarchar | 4 | 0 | | |
7 | ETTIFB | Installation Facts (Reference Values) | 4 | OPLFDNR | Consecutive number of an operand | nvarchar | 4 | 0 | | |
TOPInvoicing |
8 | DBERDZ | DB Table: Individ. Lines - Print Document | 153 | OPLFDNR | Consecutive number of an operand | nvarchar | 4 | 0 | | |
TOPMaster Data |
9 | EVST | Alloc. of ARCR to Ref. Val. | 4 | OPLFDNR | Consecutive number of an operand | nvarchar | 4 | 0 | | |
TOPStatistics |
10 | EMDSTTSOPL | Notes for Future Changes to Stock Statistics | 5 | OPLFDNR | Consecutive number of an operand | nvarchar | 4 | 0 | | |
TOPWaste Management |
11 | EWAOBJ | Header Data for Service Frequency | 7 | OPLFDNR | Consecutive number of an operand | nvarchar | 4 | 0 | | |