| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPContract Billing |
1 | EMDUSDRQHEAD | Table of MDUS Request Data | 9 | ABRVORG | Billing Transaction | nvarchar | 2 | 0 | | |
2 | ERCH | Billing Doc. Data | 17 | ABRVORG | Billing Transaction | nvarchar | 2 | 0 | | |
3 | ERCH_RIVA | Header Data for Billing Document Extract (RIVA) | 9 | ABRVORG | Billing Transaction | nvarchar | 2 | 0 | | |
4 | ERCH_SHORT | Header Data for Billing Document - Extract | 11 | ABRVORG | Billing Transaction | nvarchar | 2 | 0 | | |
5 | INSTSET | Table of Error Extracts | 12 | ABRVORG | Billing Transaction | nvarchar | 2 | 0 | | |
6 | TE125 | Alloc. Data for Gas | 3 | ABRVORG | Billing Transaction | nvarchar | 2 | 0 | | |
7 | TE327 | Validations per Outsorting Check Group for Billing | 3 | ABRVORG | Billing Transaction | nvarchar | 2 | 0 | | |
TOPInvoicing |
8 | DBEOSB | IS-U On-Site Billing | 4 | ABRVORG | Billing Transaction | nvarchar | 2 | 0 | | |
9 | EITEDI | Temporary Index Selection in Invoicing -> EDI Transmission | 6 | ABRVORG | Billing Transaction | nvarchar | 2 | 0 | | |
10 | EITERDK | Temporary Data Selection: Invoicing -> Bill Printout | 6 | ABRVORG | Billing Transaction | nvarchar | 2 | 0 | | |
11 | EITR | Temporary Selection Data for IS-U Invoicing | 9 | ABRVORG | Billing Transaction | nvarchar | 2 | 0 | | |
12 | ERDK | Print Document/Header Data | 28 | ABRVORG | Billing Transaction | nvarchar | 2 | 0 | | |
13 | ERDK_SHORT | Header Data for Print Document - Extract | 17 | ABRVORG | Billing Transaction | nvarchar | 2 | 0 | | |
TOPMeter Reading |
14 | ETRG | Billing Order | 4 | ABRVORG | Billing Transaction | nvarchar | 2 | 0 | | |
TOPPortioning and scheduling |
15 | TE417 | Sched. Recs: Portions | 9 | ABRVORG | Billing Transaction | nvarchar | 2 | 0 | | |
16 | TE424 | Portion: Definition of Dates | 8 | ABRVORG | Billing Transaction | nvarchar | 2 | 0 | | |