| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPContract Billing |
1 | DBERCHR | Discnt for Bill.Line Item | 3 | BELZEILE | Billing line item for billing documents | nvarchar | 6 | 0 | | |
2 | DBERCHT | Texts for billing documents | 4 | BELZEILE | Billing line item for billing documents | nvarchar | 6 | 0 | | |
3 | DBERCHU | Conversion Steps per Billing Line Item | 3 | BELZEILE | Billing line item for billing documents | nvarchar | 6 | 0 | | |
4 | DBERCHV | Consumption History | 25 | BELZEILE | Billing line item for billing documents | nvarchar | 6 | 0 | | |
5 | DBERCHZ | Individual Line Items | 3 | BELZEILE | Billing line item for billing documents | nvarchar | 6 | 0 | | |
6 | DBERCHZ1 | Individual line items | 3 | BELZEILE | Billing line item for billing documents | nvarchar | 6 | 0 | | |
7 | DBERCHZ2 | Individual line items (device data) | 3 | BELZEILE | Billing line item for billing documents | nvarchar | 6 | 0 | | |
8 | DBERCHZ3 | Individual line items (amount and price data) | 3 | BELZEILE | Billing line item for billing documents | nvarchar | 6 | 0 | | |
9 | DBERCHZ4 | Individual line items (rarely used fields) | 3 | BELZEILE | Billing line item for billing documents | nvarchar | 6 | 0 | | |
10 | DBERCHZ5 | Individual line items (unimportant rows) | 3 | BELZEILE | Billing line item for billing documents | nvarchar | 6 | 0 | | |
11 | DBERCHZ6 | Document line items (device data, unimportant rows) | 3 | BELZEILE | Billing line item for billing documents | nvarchar | 6 | 0 | | |
12 | DBERCHZ7 | Document line items (amount/price data, unimportant rows) | 3 | BELZEILE | Billing line item for billing documents | nvarchar | 6 | 0 | | |
13 | DBERCHZ8 | Document line items (rarely used fields, unimportant) | 3 | BELZEILE | Billing line item for billing documents | nvarchar | 6 | 0 | | |
14 | ERCHZ_RIVA | Billing Document Individual Line Item Extract (RIVA) | 3 | BELZEILE | Billing line item for billing documents | nvarchar | 6 | 0 | | |
15 | ERCHZ_SHORT | Billing Document Individual Lines Extract | 3 | BELZEILE | Billing line item for billing documents | nvarchar | 6 | 0 | | |
TOPInvoicing |
16 | DBERDR | DB Table: Discount Lines - Print Document | 3 | BELZEILE | Billing line item for billing documents | nvarchar | 6 | 0 | | |
17 | DBERDU | Conversion Steps per Billing Line Item | 3 | BELZEILE | Billing line item for billing documents | nvarchar | 6 | 0 | | |
18 | DBERDZ | DB Table: Individ. Lines - Print Document | 3 | BELZEILE | Billing line item for billing documents | nvarchar | 6 | 0 | | |
19 | ERDZ_SHORT | Internal Table for Individual Print Doc.Lines -Extract Data | 3 | BELZEILE | Billing line item for billing documents | nvarchar | 6 | 0 | | |