This table records all the transactions associated to a billing_account. The primary key is the account_no and the id. The id is calculated from the billing_account.last_transaction_id
the values for the overloaded fields for the transaction types supplied out-of-the-box. Users can created there own transaction plugins and override these fields meanings.
When type = 0 (Offering Transactions) " enum_1 = pointer to the subscription, ie: subscription_details.subscription_id " enum_2 = pointer to the offering, ie: offerings.offering_id
When type = 1 (Rateplan Transactions) " enum_1 = pointer to the subscription, ie: subscription_details.subscription_id " enum_2 = pointer to the offering, ie: offerings.offering_id " enum_3 = pointer to the rate plan, ie: rate_plans.rate_plan_id
When type = 2 (Rateitem Transactions) " enum_1 = pointer to the subscription, ie: subscription_details.subscription_id " enum_2 = pointer to the offering, ie: offerings.offering_id " enum_3 = pointer to the rate plan, ie: rate_plans.rate_plan_id " enum_4 = pointer to the rate item, ie: rate_definition.item_id " enum_5 = installment total. For transactions that are created from rate items that charge in installments " enum_6 = installments. For transactions that are created from rate item that charge in installments this will specify how may installment to date have been made. " enum_7 = rate item type " enum_8 = show additional value from numeric_1 on the invoice(ie: metric result, user entered quantity, etc) " numeric_1 = rate item result value (ie: metric result ) " date_1 = the transaction from date " date_2 = the transaction to date " prorate_value = the number of days in the billing period.
" period_multiplier = the factor calculated from prorating " num_periods = the number of periods the transaction is being billed for " advanced_periods = the number of periods the transaction is being billed in advance for. " period_type: -1=onetime, 0=daily, 1=weekly, 2=mon
| Column Name | Column Datatype | Column Null Option | Column Comment |
| account_no | varchar(50) | not null | The account to which this transaction is associated. |
| id | integer | not null | Integer that increments for each transaction associated to a particular account. |
| 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. |
| statement_id | integer | not null | This is the invoice that this transaction appeared on. A -1 indicates that this has not be invoiced yet. |
| sequence_no | integer | with null | The ordering of transactions as they have been processed and the order in which they will show up on the invoice |
| type | integer | not null | The type of transaction. 0=offering, 1=rate plan, 2=rate item, 3=adjustment, 4=payments, 5=message. Users can create and plugin there own types of transactions, and should use values greater then 10000. |
| post_date | date | with null | The date that the transaction was posted to the account. |
| status | integer | not null | 0=deleted, 1=open |
| description | nvarchar(1024) | not null | The description of the transaction |
| charge_type | integer | not null | 0=credit, 1=debit, 2=default. |
| commit_phase | integer | not null | 0=not committed, 1=committed. This is used for components that integrate with iCanBill to track transactions. |
| quantity | float | not null | The quantity associated with the transaction. |
| quantity_type | integer | not null | 0=quantity, 1=percent. Currently only 1 is supported. |
| unit_cost | float | not null | Is the unit cost used for calculations |
| unit_cost_text | nvarchar(50) | not null | Is the unit cost used for display. Used for resolving floating point errors. |
| unit_type | nvarchar(50) | with null | Used for display only to show the type of unit of the transaction |
| cost | float | not null | Calculated from quantity x unit_cost |
| code | nvarchar(50) | with null | Codes from the subscriptions are passed to this field. This can be overloaded by other transaction type plugins |
| enum_1 | integer | with null | See Table Comment |
| enum_2 | integer | with null | See Table Comment |
| enum_3 | integer | with null | See Table Comment |
| enum_4 | integer | with null | See Table Comment |
| enum_5 | integer | with null | See Table Comment |
| enum_6 | integer | with null | See Table Comment |
| enum_7 | integer | with null | See Table Comment |
| enum_8 | integer | with null | See Table Comment |
| text_1 | nvarchar(50) | with null | See Table Comment |
| text_2 | nvarchar(50) | with null | See Table Comment |
| text_3 | nvarchar(50) | with null | |
| numeric_1 | float | with null | See Table Comment |
| date_1 | date | with null | See Table Comment |
| date_2 | date | with null | See Table Comment |
| date_3 | date | with null | |
| prorate_value | integer | with null | See Table Comment |
| period_multiplier | float | with null | See Table Comment |
| num_periods | integer | with null | See Table Comment |
| advanced_periods | integer | with null | See Table Comment |
| period_type | integer | with null | See Table Comment |
| period_type_interval | integer | with null | See Table Comment |
| is_reverse | integer | not null | 0=not a reverse transaction, 1=reverse transaction |
| reverse_tran_id | integer | not null | |
| suspension_id | integer | with null | Id of the subscription_mgmt object that suspended this transaction |
| suspension_instance | date | with null |
Product Name: Unicenter Service Management
Table Type: Table