All the information viewed through the billing profile in the UI is stored in this table. Except for the configuration table, all the other tables have some form of dependency on this table.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| account_no | varchar(50) | not null | The account number associated to the billing_account. |
| account_label | nvarchar(128) | not null | This is the displayable name 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. |
| account_type | integer | not null | 0=Open Item, 1=Balance Forward |
| billing_type | integer | with null | 0=Billable, 1=Chargeback, 2= Resource |
| credit_amount | float | with null | The account balance is derived from subtracting debit_amount from credit_amount |
| debit_amount | float | with null | The account balance is derived from subtracting debit_amount from credit_amount |
| opened_date | date | not null | The date the billing_account record is created |
| closed_date | date | with null | This really means the date the status of account changed |
| billing_cycle | nvarchar(50) | not null | Daily, Weekly, or Monthly |
| billing_cycle_date | date | not null | This now represents the billing period TO date. |
| billing_cycle_interval | integer | not null | An integer specifying the intervals of the billing cycle. For instance a billing_cycle=Monthly and billing_cycle_interval=1 would be a Monthly billing cycle, a billing_cycle=Monthly and billing_cycle_interval=3 would be a quarterly billing cycle, etc. A Daily billing cycle can only have 1 for its billing_cycle_interval |
| last_invoice_date | date | with null | This now represents the billing period FROM date. |
| invoice_sent_date | date | with null | This now represents the date of when the last time an invoice was generated for this account. |
| bill_date | date | with null | The date that an invoice should be generated for this account for the billing period specified in billing_cycle_date and last_invoice_date. |
| invoice_method | nvarchar(50) | not null | Email, Fax, Postal, or Printer |
| payment_method | nvarchar(50) | with null | PrePay is the only value we currently support |
| status | integer | not null | 1=deleted, 0=closed, 1=open, 2=suspended, 3=closed requested. A status of deleted is a soft deleted, it simply means the account and all it |
| status_reason | nvarchar(128) | with null | Generic item to state the reason for current state. |
| days_due_default | integer | not null | The number of days that will be added to the invoice date of the account |
| grace_days | integer | not null | Currently not used. |
| notification_days | integer | not null | Currently not used. |
| notification_method | nvarchar(50) | not null | Currently not used. |
| notify_stmt_sent | integer | not null | Currently not used. |
| notify_stmt_method | nvarchar(50) | not null | Currently not used. |
| notify_stmt_to | integer | not null | Currently not used. |
| notify_stmt_id | nvarchar(50) | not null | Currently not used. |
| automatic_invoicing | integer | not null | A1 indicates this account should be automatically invoiced by being picked up in the next bill run if all other billing criterias for the bill run are satisfied. Changing this field to 0 is the quickest and easiest way to exclude this account from all bill runs. |
| summarize_statements | integer | not null | Currently not used |
| taxable | integer | not null | Currently not used |
| purchase_order_no | nvarchar(30) | with null | Generic item that can be used in integration. |
| payment_applied_method | integer | not null | Currently not used |
| revenue_sharing_account | integer | with null | Currently not used. Not likely to ever really be used. |
| aggregate | integer | with null | 0=does not contribute it |
| aggregation_type | integer | with null | If the aggregate value = 2, then this field would specify the type of aggregation that should occur. 0=Total accounts, 1=Total charges. |
| text_1 | nvarchar(100) | with null | |
| text_2 | nvarchar(50) | with null | |
| enum_1 | integer | with null | |
| last_transaction_id | integer | not null | Id of last transaction. |
| last_payment_id | integer | not null | Id of last payment. |
| last_statement_id | integer | not null | Id of last statement generated. |
| comments | nvarchar(128) | with null | Used only in the billing profile gui |
| sub_billing_info | nvarchar(128) | with null | Currently not used. Not likely to ever really be used. |
| sub_billing_info_id | integer | with null | Currently not used. Not likely to ever really be used |
| domain | varchar(50) | with null | Domain to which this account belongs. |
| currency_type_code | varchar(3) | with null | The associated currency type. |
Product Name: Unicenter Service Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| account_no | usm_subscription_detail | account_no |
| account_no | usm_statement | account_no |
| account_no | usm_settlement | account_no |
| account_no | usm_adjustment | account_no |
| account_no | usm_transaction | account_no |
| account_no | usm_payment_method | account_no |
| account_no | usm_link_billing_account_group | account_no |
| account_no | usm_dependency | account_no |