| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBilling in Contract Accounts Receivable and Payable |
1 | DFKKBIEDRAT | EDRs for Payment, Receivable, and Credit Amounts | 7 | EDRTYPE | Type of EDR | nvarchar | 10 | 0 | | |
2 | DFKKBIEDRRJAT | Provisionally Rejected EDRs (Payments, Receivables, Credit) | 5 | EDRTYPE | Type of EDR | nvarchar | 10 | 0 | | |
3 | DFKKBIEDRRJTC | Provisionally Rejected EDRs | 5 | EDRTYPE | Type of EDR | nvarchar | 10 | 0 | | |
4 | DFKKBIEDRRJZ01 | Test Data: Provisionally Rejected EDRs fr. Cat. ZTCSERVICE | 5 | EDRTYPE | Type of EDR | nvarchar | 10 | 0 | | |
5 | DFKKBIEDRTC | EDRs for Toll Billing | 7 | EDRTYPE | Type of EDR | nvarchar | 10 | 0 | | |
6 | DFKKBIEDRWOAT | Permanently Rejected EDRs (Payments, Receivables, Credit) | 5 | EDRTYPE | Type of EDR | nvarchar | 10 | 0 | | |
7 | DFKKBIEDRWOTC | Permanently Rejected EDRs | 5 | EDRTYPE | Type of EDR | nvarchar | 10 | 0 | | |
8 | DFKKBIEDRWOZ01 | Test Data: Permanently Rejected EDRs fr. Category ZTCSERVICE | 5 | EDRTYPE | Type of EDR | nvarchar | 10 | 0 | | |
9 | DFKKBIEDRZ01 | Test Data: EDRs with Additional Services for Toll Billing | 7 | EDRTYPE | Type of EDR | nvarchar | 10 | 0 | | |
10 | TFK8002 | Type of EDR / Type of Billing Account Item | 3 | EDRTYPE | Type of EDR | nvarchar | 10 | 0 | | |
11 | TFK8002_BILLPROC | Log Table for Billing Procedure | 4 | EDRTYPE | Type of EDR | nvarchar | 10 | 0 | | |
12 | TFK8013 | Type of EDR | 2 | EDRTYPE | Type of EDR | nvarchar | 10 | 0 | | |
13 | TFK8013T | Text for Type of EDR | 3 | EDRTYPE | Type of EDR | nvarchar | 10 | 0 | | |
14 | TFK8030 | EDR Types for Demand-Driven Billing | 2 | EDRTYPE | Type of EDR | nvarchar | 10 | 0 | | |
15 | TFK8900 | Test Data: Route Description for Toll Billing | 10 | EDRTYPE | Type of EDR | nvarchar | 10 | 0 | | |
16 | TFK8901 | Test Data: Cities with Congestion Charging | 3 | EDRTYPE | Type of EDR | nvarchar | 10 | 0 | | |
17 | TFK8902 | Test Data: Chargeable Objects (Tunnel, Pass) | 3 | EDRTYPE | Type of EDR | nvarchar | 10 | 0 | | |
18 | TFK8903 | Testdaten: Gas Stations | 3 | EDRTYPE | Type of EDR | nvarchar | 10 | 0 | | |
19 | TFK8904 | Test Data: Paid Parking Lots and Garages | 3 | EDRTYPE | Type of EDR | nvarchar | 10 | 0 | | |