This table stores all the order header information. An oreder header can have many fields depending on the implementation. To facilitate dynamic fields it is closely tied to usm_order_values table. The line items of a order are stored in usm_subscription_details table.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| request_id | integer | not null | Unique id associated to the order. |
| name | nvarchar(128) | not null | Display name of order. |
| status | integer | not null | The status of the order. |
| created_date | date | not null | Date when order was initiated. |
| modified_date | date | not null | Date when order was modified. |
| completion_date | date | with null | Date when order was completed. |
| desired_date | date | with null | Desired date the end user would like the order fulfilled |
| comments | nvarchar(256) | with null | Comments associated to the order. |
| priority | integer | with null | The priority associated with this order, it is primarily used for the fulfillment part. |
| req_for_account_id | varchar(50) | with null | The account number that this request is for |
| req_by_account_id | varchar(50) | not null | The account number that is creating this request |
| req_for_user_id | nvarchar(100) | with null | The user that this request is for |
| req_by_user_id | nvarchar(100) | with null | The user that is creating this request |
| code | nvarchar(64) | with null | User data |
| location_uuid | byte(16) | with null | |
| domain | varchar(50) | with null | Domain to which this order belongs. |
Product Name: Unicenter Service Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| request_id | usm_request_value | request_id |