Settlements are special type of adjustments, they are not used in the current billing system
| Column Name | Column Datatype | Column Null Option | Column Comment |
| settlement_no | integer | not null | |
| adjustment_id | integer | with null | All adjustments are recorded here and then applied to the
accounts when they are invoiced in a bill run.
When adjustment_type=0 (general adjustment) and value_type=0 (fixed amount): " enum_1 = billing cycle (0=onetime, 1=periodic, 2=every invoice) " enum_2 = periodic type (0=NA,1=daily,2=weekly,3=monthly,4=quarterly,5=yearly) When adjustment_type=0 (general adjustment) and value_type=1 (percentage): " enum_1 = billing cycle (0=onetime, 2=every invoice) " enum_2 = periodic type (0=NA) " enum_3 = apply adjustment to (1=offering,2=rate column, 3=all charges, 4=total invoice amount) " enum_4 = select offering ( when enum_3=1 or 2, then this is the offering_id ) " enum_5 = select rate column ( when enum_3=2, then this is the item_id of the column header rate item) " enum_6 = percent of ( when enum_3=2, then 0=Quantity, 1=UnitCost, 2=Cost) |
| domain | varchar(50) | not null | |
| settle_account | varchar(50) | with null | |
| settle_domain | varchar(50) | not null | |
| settle_user | nvarchar(128) | with null | |
| type | integer | not null | |
| status | integer | not null | |
| recorded_date | date | not null | |
| unsettled_date | date | with null | |
| settled_date | date | with null | |
| amount | float | with null | |
| amount_settled | float | with null | |
| show_on_invoice | integer | not null | |
| enum_1 | integer | with null | |
| enum_2 | integer | with null | |
| comments | nvarchar(128) | with null | |
| account_no | varchar(50) | with null | The account number associated to the billing_account. |
Product Name: Unicenter Service Management
Table Type: Table