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)
| Column Name | Column Datatype | Column Null Option | Column Comment |
| adjustment_id | integer | not null | Unique identifier that identifies each adjustment. |
| adjustment_name | nvarchar(50) | with null | The name of the adjustment that appears in the adjustment gui, and on the invoice. |
| 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. |
| charge_type | integer | with null | 0=apply as credit, 1=apply as debit |
| adjustment_type | integer | with null | 0=general adjustment, 1=violation adjustment |
| value | float | with null | The amount of the adjustment (this is either a fixed amount or a percentage). |
| value_type | integer | with null | 0=fixed amount, 1=percentage, 2=association (for violation adjustment that will do a tiered lookup into a rate plan to determine the adjustment), 3=SLO association, 4=SLO value association, 5=catalog percentage. For most purposes, any integrated components will almost always use fixed amount or percentage. |
| description | nvarchar(128) | with null | Appended to the adjusment_name and display on the invoice if there is a value for this field. |
| status | integer | with null | 0=not active 1=active |
| active_date | date | with null | This is populated with the date of when the status field is set to 0 |
| inactive_date | date | with null | This is populated with the date of when the status field is set to 1 |
| global_adjustment | integer | with null | 0=applied to a single account, 1=applied to all accounts |
| account_no | varchar(50) | with null | If global_adjustment=0 then this is a pointer to the billing_account record. |
| account_label | nvarchar(128) | not null | If global_adjustment=0 then this is the displayable label of the billing_account. |
| start_date | date | with null | Currently not used. |
| end_date | date | with null | Currently not used. |
| 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 |
| text_1 | nvarchar(50) | with null | Reference to SLA when adjustment is for SLA |
| text_2 | nvarchar(50) | with null | |
| text_3 | nvarchar(50) | with null |
Product Name: Unicenter Service Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| adjustment_id | usm_settlement | adjustment_id |