| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPContract Billing |
1 | DBERCHZ | Individual Line Items | 38 | PREISTUF | Price level | nvarchar | 10 | 0 | | |
2 | DBERCHZ3 | Individual line items (amount and price data) | 8 | PREISTUF | Price level | nvarchar | 10 | 0 | | |
3 | DBERCHZ7 | Document line items (amount/price data, unimportant rows) | 8 | PREISTUF | Price level | nvarchar | 10 | 0 | | |
4 | EPREI | Mstr Pricing Table for All Prices | 4 | PREISTUF | Price level | nvarchar | 10 | 0 | | |
5 | EPREIH | History Table for All Prices | 5 | PREISTUF | Price level | nvarchar | 10 | 0 | | |
6 | EPREII | History Table for All Index Prices | 4 | PREISTUF | Price level | nvarchar | 10 | 0 | | |
7 | EPREIT | Mstr Pricing Table for All Prices (Texts) | 5 | PREISTUF | Price level | nvarchar | 10 | 0 | | |
8 | ERCHZ_SHORT | Billing Document Individual Lines Extract | 57 | PREISTUF | Price level | nvarchar | 10 | 0 | | |
9 | TE471 | Rental Price Levels | 2 | PREISTUF | Price level | nvarchar | 10 | 0 | | |
10 | TE471T | Rental Price Levels (Texts) | 3 | PREISTUF | Price level | nvarchar | 10 | 0 | | |
TOPInvoicing |
11 | DBERDZ | DB Table: Individ. Lines - Print Document | 64 | PREISTUF | Price level | nvarchar | 10 | 0 | | |