| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | ECBPRG | Conditional Billing Program | 3 | SCHEMANR | Number of the billing schema | nvarchar | 10 | 0 | | |
2 | ESCHCR2CBP | Assign Conditional Rate to Conditional Billing Program | 2 | SCHEMANR | Number of the billing schema | nvarchar | 10 | 0 | | |
3 | ESCHEXT | Billing Schema Extension (Administrative Data) | 2 | SCHEMANR | Number of the billing schema | nvarchar | 10 | 0 | | |
4 | ESCHRR | Rate Relationships | 2 | SCHEMANR | Number of the billing schema | nvarchar | 10 | 0 | | |
5 | ESCHRRG | Rate Relationship Groups | 2 | SCHEMANR | Number of the billing schema | nvarchar | 10 | 0 | | |
6 | ESCHRRGT | Rate Relationship Groups Texts | 2 | SCHEMANR | Number of the billing schema | nvarchar | 10 | 0 | | |
TOPContract Billing |
7 | DBERCHZ | Individual Line Items | 24 | SCHEMANR | Number of the billing schema | nvarchar | 10 | 0 | | |
8 | DBERCHZ1 | Individual line items | 23 | SCHEMANR | Number of the billing schema | nvarchar | 10 | 0 | | |
9 | DBERCHZ5 | Individual line items (unimportant rows) | 23 | SCHEMANR | Number of the billing schema | nvarchar | 10 | 0 | | |
10 | EPERDET | Periods to set up from DYPERCON and PBASCAT | 2 | SCHEMANR | Number of the billing schema | nvarchar | 10 | 0 | | |
11 | ESCH | Billing Schema (Header Data) | 2 | SCHEMANR | Number of the billing schema | nvarchar | 10 | 0 | | |
12 | ESCHS | Billing Schema Steps | 2 | SCHEMANR | Number of the billing schema | nvarchar | 10 | 0 | | |
13 | ESCHST | Schema Step Notes | 2 | SCHEMANR | Number of the billing schema | nvarchar | 10 | 0 | | |
14 | ESCHT | Billing Schema (Texts) | 3 | SCHEMANR | Number of the billing schema | nvarchar | 10 | 0 | | |
15 | ETTA | General Rate Category (Header Data) | 13 | SCHEMANR | Number of the billing schema | nvarchar | 10 | 0 | | |
TOPInvoicing |
16 | DBERDZ | DB Table: Individ. Lines - Print Document | 50 | SCHEMANR | Number of the billing schema | nvarchar | 10 | 0 | | |
TOPMaster Data |
17 | EANLH | Install.Time Slice | 22 | SCHEMANR | Number of the billing schema | nvarchar | 10 | 0 | | |