Contains all items associated to a particular invoice.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| statement_id | integer | not null | Unique id that identifies each invoice. This will change in the near future such that every statements record will be unqiue based on the account_no and the statement_id |
| statement_label | nvarchar(128) | with null | a unique invoice identifier, such as an invoice number, that is comprised of the tenant id, account_label, and the statement_id |
| account_type | integer | not null | 0=Open Item, 1=Balance Forward. This is the same value of the billing_account.account_type that is stored here at the time this invoice was created for that account |
| invoice_history_id | integer | with null | a pointer to the invoice_history record that this invoice is associated to. In other words, this tells iCanBill what bill run this invoice was created for |
| 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. |
| invoice_date | date | with null | The date the invoice was generated |
| status | integer | with null | 0=delete, 1=zero balance (or paid), 2=debit balance (or balance remaining), 3=credit balance |
| status_reason | nvarchar(128) | with null | Currently not used |
| due_date | date | with null | The date payment is due for this invoice. This is set by taking the billing_account.days_due and adding it to the invoice_date |
| tax_amount | float | with null | Currently not used |
| debit_amount | float | with null | The new debits on the invoice |
| credit_amount | float | with null | The new credits on this invoice |
| account_debit_amount | float | with null | The old debits from the account balance, from billing_account.debit_amount |
| account_credit_amount | float | with null | The old credits from the account balance, from billing_account.credit_amount |
| period_to | date | with null | The billing account |
| period_from | date | with null | The billing account |
| violations | integer | with null | The number of SLA violations that occured in this the invoiced billing period |
| purchase_order_no | nvarchar(30) | with null | Retrieved from billing_account.purchase_order_no and stored here to display on the invoice |
| invoice_loc | nvarchar(512) | with null | The location of the invoice on the hard drive. If none is specified then the data for the invoice is always fetched from the database |
| comments | nvarchar(128) | with null | Currently not used |
| account_no | varchar(50) | with null | The account number associated to the billing_account. |
Product Name: Unicenter Service Management
Table Type: Table