Every bill run and invoice on demand is recorded in this table.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| invoice_history_id | integer | not null | Unique id |
| start_date | date | not null | The date the bill run associated to this invoice history record began |
| domain | varchar(50) | not null | This is the tenant ID of the account |
| parent_domain | varchar(50) | not null | This is the parent tenant ID, the value of this field is always either a Supert Tenant, Service Provider, or empty in the case when domain is the value of the Service Provider. |
| end_date | date | with null | The date the bill run associated to this invoice history record ended |
| status | integer | not null | No Comment Available |
| phases | integer | not null | Currently not used. Not likely to every be used again |
| num_invoices | integer | not null | The number of invoices generated in the bill run or invoice on demand |
| total_invoices | integer | not null | Total number of invoices to be generated that are supposed to be generated in the bill run or invoice on demand |
| forced | integer | not null | Unsupported and exists for backward compatibility |
| debit_amount | float | with null | Total debits generated for all accounts in the bill run |
| credit_amount | float | with null | Total credits generated for all accounts in the bill run |
| system_name | nvarchar(128) | not null | The host that ran the bill run or processed the invoice on demand |
| group_name | nvarchar(128) | with null | The billing group that the bill run processed |
| billing_cycle | nvarchar(50) | with null | Unsupported and exists for backward compatibility |
| billing_cycle_interval | integer | with null | Interval between billing cycles. |
| period_from_date | date | with null | Period start Date. |
| period_to_date | date | with null | Period end date. |
| bill_date | date | with null | Invoicing date. |
| days_due_default | integer | with null | Default days due from the account. |
| rollback_date | date | with null |
Product Name: Unicenter Service Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| invoice_history_id | usm_statement | invoice_history_id |