Currently persists only notes for rate items. But can be used to store notes for any object.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| notes_id | integer | not null | Unique id for each note |
| source_type | integer | not null | The origination of the note. Or an identifier as to where the note came from. –1=none, 0=offerings, 1=rate plans, 2=rate items, 3=subscriptions, 4=billing account |
| source_id | integer | not null | Currently not used. |
| ref_1 | integer | not null | Id of the object the note is posted to |
| ref_2 | integer | not null | Sub-id of the object the note is posted to. Requires that ref_1 has a value |
| ref_3 | integer | not null | Sub-sub-id of the object the note is posted to. Requires that ref_2 has a value |
| type_1 | integer | not null | Type of object specified in ref_1. –1=none, 0=offerings, 1=rate plans, 2=rate items, 3=subscriptions, 4=billing account |
| type_2 | integer | not null | Type of object specified in ref_3. –1=none, 0=offerings, 1=rate plans, 2=rate items, 3=subscriptions, 4=billing account |
| type_3 | integer | not null | Type of object specified in ref_3. –1=none, 0=offerings, 1=rate plans, 2=rate items, 3=subscriptions, 4=billing account |
| status | integer | not null | Currently not used |
| created_date | date | not null | |
| account_label | nvarchar(50) | with null | Account label of the account this note was posted to |
| note_type | integer | with null | |
| note_text | nvarchar(1024) | with null | Note |
| user_id | nvarchar(100) | with null | |
| account_id | varchar(50) | with null | |
| domain | varchar(50) | with null | Domain to which the notes belong. |
Product Name: Unicenter Service Management
Table Type: Table