| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | ECBP2TEP | Assign Conditional Billing Program to TOU Exception Program | 2 | CONDBILLPROGID | Conditional Billing Program ID | nvarchar | 10 | 0 | | |
2 | ECBPRG | Conditional Billing Program | 2 | CONDBILLPROGID | Conditional Billing Program ID | nvarchar | 10 | 0 | | |
3 | ECBPRGT | Conditional Billing Program Texts | 2 | CONDBILLPROGID | Conditional Billing Program ID | nvarchar | 10 | 0 | | |
4 | ESCHCR2CBP | Assign Conditional Rate to Conditional Billing Program | 5 | CONDBILLPROGID | Conditional Billing Program ID | nvarchar | 10 | 0 | | |
TOPContract Billing |
5 | DBERCHZ4 | Individual line items (rarely used fields) | 46 | CONDBILLPROGID | Conditional Billing Program ID | nvarchar | 10 | 0 | | |
6 | DBERCHZ8 | Document line items (rarely used fields, unimportant) | 46 | CONDBILLPROGID | Conditional Billing Program ID | nvarchar | 10 | 0 | | |