| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | DFKKBIXCIT_HIST | History Table for Billable Item Exceptions | 13 | STATUSGROUP | Status Group for Consumption Items | nvarchar | 1 | 0 | | |
2 | TFK8165E | Exception Reasons for Consumption Items | 3 | STATUSGROUP | Status Group for Consumption Items | nvarchar | 1 | 0 | | |
3 | TFK8165R | Reasons for Restoration for Consumption Items | 3 | STATUSGROUP | Status Group for Consumption Items | nvarchar | 1 | 0 | | |
TOPBilling in Contract Accounts Receivable and Payable |
4 | DFKKBIXBIT_HIST | History Table for Billable Item Exceptions | 14 | STATUSGROUP | Status Group of Billable Items | nvarchar | 1 | 0 | | |
5 | TFK8105E | Exception Reasons for Billable Items | 3 | STATUSGROUP | Status Group of Billable Items | nvarchar | 1 | 0 | | |
6 | TFK8105R | Restoration Reasons for Billable Items | 3 | STATUSGROUP | Status Group of Billable Items | nvarchar | 1 | 0 | | |
TOPEnergy Data Management |
7 | EFORMULAINST | IS-U EDM Header Data of Formula Instance (DB Table) | 5 | STATUSGROUP | Status group of formula allocation | nvarchar | 10 | 0 | | |
8 | EFORMULASTATGRP | Status Group of Formula Instance | 2 | STATUSGROUP | Status group of formula allocation | nvarchar | 10 | 0 | | |
9 | EFORMULASTATGRPT | Description of Status Group of Formula Instance | 3 | STATUSGROUP | Status group of formula allocation | nvarchar | 10 | 0 | | |
10 | EFORMULASTATUS | EDM Status for Status Group (DB Table) | 2 | STATUSGROUP | Status group of formula allocation | nvarchar | 10 | 0 | | |