| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPContract Billing |
1 | DBERCHV | Consumption History | 9 | PREISTYP | Price category | nvarchar | 1 | 0 | | |
2 | DBERCHZ | Individual Line Items | 39 | PREISTYP | Price category | nvarchar | 1 | 0 | | |
3 | DBERCHZ3 | Individual line items (amount and price data) | 9 | PREISTYP | Price category | nvarchar | 1 | 0 | | |
4 | DBERCHZ7 | Document line items (amount/price data, unimportant rows) | 9 | PREISTYP | Price category | nvarchar | 1 | 0 | | |
5 | EPREI | Mstr Pricing Table for All Prices | 3 | PREISTYP | Price category | nvarchar | 1 | 0 | | |
6 | EPREIH | History Table for All Prices | 4 | PREISTYP | Price category | nvarchar | 1 | 0 | | |
7 | EPREII | History Table for All Index Prices | 3 | PREISTYP | Price category | nvarchar | 1 | 0 | | |
8 | EPREIT | Mstr Pricing Table for All Prices (Texts) | 4 | PREISTYP | Price category | nvarchar | 1 | 0 | | |
9 | EPRESCL | Price Adjustment Clause for All Price Categories | 3 | PREISTYP | Price category | nvarchar | 1 | 0 | | |
10 | ERCHZ_SHORT | Billing Document Individual Lines Extract | 58 | PREISTYP | Price category | nvarchar | 1 | 0 | | |
TOPInvoicing |
11 | DBERDZ | DB Table: Individ. Lines - Print Document | 65 | PREISTYP | Price category | nvarchar | 1 | 0 | | |