| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPContract Billing |
1 | DBERCHZ | Individual Line Items | 37 | SAISON | Season | nvarchar | 10 | 0 | | |
2 | DBERCHZ1 | Individual line items | 27 | SAISON | Season | nvarchar | 10 | 0 | | |
3 | DBERCHZ5 | Individual line items (unimportant rows) | 27 | SAISON | Season | nvarchar | 10 | 0 | | |
4 | EKDI | Rate Facts | 5 | SAISON | Season | nvarchar | 10 | 0 | | |
5 | ERCHZ_SHORT | Billing Document Individual Lines Extract | 22 | SAISON | Season | nvarchar | 10 | 0 | | |
6 | ETRFV | Rate Steps | 14 | SAISON | Season reference for rate step | nvarchar | 10 | 0 | | |
7 | ETTAF | Rate Cat.Facts | 4 | SAISON | Season | nvarchar | 10 | 0 | | |
8 | ETTIF | Instln Facts | 5 | SAISON | Season | nvarchar | 10 | 0 | | |
9 | ETTIFN | Installation Facts (Normal) | 4 | SAISON | Season | nvarchar | 10 | 0 | | |
TOPInvoicing |
10 | DBERDZ | DB Table: Individ. Lines - Print Document | 63 | SAISON | Season | nvarchar | 10 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
11 | /BEV1/TSSAIDEF | Season Definition | 2 | SAISON | Season Indicator | nvarchar | 5 | 0 | | |
12 | /BEV1/TSSAIDEFT | Season Texts | 2 | SAISON | Season Indicator | nvarchar | 5 | 0 | | |
13 | /BEV1/TSSAIFLG | Season Sequences | 2 | SAISON | Season Indicator | nvarchar | 5 | 0 | | |
14 | /BEV1/TSSEQ | Sales Routes Sequence Numbers | 8 | SAISON | Season Indicator | nvarchar | 5 | 0 | | |
15 | /BEV1/TSZKK | Cyclical Customer Sales Activities for Telephone Sales | 8 | SAISON | Season Indicator | nvarchar | 5 | 0 | | |
16 | /BEV1/TSZKKS | Telephone Sales: Changes to Planned Sales Activities | 8 | SAISON | Season Indicator | nvarchar | 5 | 0 | | |
TOPWaste Management |
17 | EWAOBJH_AAT_HIST | History and Valution of WBCs for Service Freq. Service | 11 | SAISON | Season | nvarchar | 10 | 0 | | |