| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPContract Billing |
1 | DBERCHZ | Individual Line Items | 4 | CSNO | Sequence number of schema step during billing | nvarchar | 6 | 0 | | |
2 | DBERCHZ1 | Individual line items | 4 | CSNO | Sequence number of schema step during billing | nvarchar | 6 | 0 | | |
3 | DBERCHZ5 | Individual line items (unimportant rows) | 4 | CSNO | Sequence number of schema step during billing | nvarchar | 6 | 0 | | |
4 | ERCHZ_SHORT | Billing Document Individual Lines Extract | 4 | CSNO | Sequence number of schema step during billing | nvarchar | 6 | 0 | | |
5 | ISU_BRE_LOGS | Logs for BRE Runs | 5 | CSNO | Numeric field length 8 | nvarchar | 8 | 0 | | |
6 | ISU_DGEN_LOGS | Logs for BRE Extract Generation Runs | 5 | CSNO | Numeric field length 8 | nvarchar | 8 | 0 | | |
7 | ISU_SGEN_LOGS | Extract Generation Log for Statistical Backlog Sets | 5 | CSNO | Numeric field length 8 | nvarchar | 8 | 0 | | |
TOPEnergy Data Management |
8 | ERTPDAYTYPEX | Allocate Exceptions to Day Groups | 4 | CSNO | Consecutive number | nvarchar | 4 | 0 | | |
9 | ERTPFCOMPDATA | Data for Flexible RTP Components | 3 | CSNO | Sequence number of schema step during billing | nvarchar | 6 | 0 | | |
TOPInvoicing |
10 | DBERDZ | DB Table: Individ. Lines - Print Document | 30 | CSNO | Sequence number of schema step during billing | nvarchar | 6 | 0 | | |