Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| AuthorizationNumber | Unknown | 0 | null |
|
|
Authorization number - Insurance authorization number |
|||||
| ClientId | Unknown | 0 | null |
|
|
Client reference - Reference to the client receiving services |
|||||
| EndDate | Unknown | 0 | null |
|
|
End date - Date when services should end |
|||||
| pkServiceOrderID | int identity | 4 | √ | null |
|
|
Primary key - ServiceOrder unique identifier for each record |
||||
| fkAgreementID | int | 4 | √ | null |
|
|
Foreign key reference - Reference to Agreement table for data relationships |
||||
| Status | varchar | 50 | null |
|
|
Order status - Current status of the service order |
|||||
| InvoiceDate | smalldatetime | 16 | √ | null |
|
|
Date/time field - Date and time when invoice occurred or was recorded |
||||
| OrderDate | Unknown | 0 | null |
|
|
Order date - Date when the service was ordered |
|||||
| OrderNumber | Unknown | 0 | null |
|
|
Order number - Unique identifier for the service order |
|||||
| Recurring | bit | 1 | null |
|
|
Boolean flag - Indicates whether specific condition or feature is enabled/active |
|||||
| Item | varchar | 100 | √ | null |
|
|
Text field - Item text information for ServiceOrder records |
||||
| Description | varchar | 7000 | √ | null |
|
|
Description field - Detailed description or explanation of ServiceOrder information |
||||
| Quantity | int | 4 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for ServiceOrder records |
||||
| Rate | money | 21,4 | √ | null |
|
|
Financial amount - Monetary value or rate for ServiceOrder financial calculations |
||||
| AgreementCode | uniqueidentifier | 16 | √ | (newid()) |
|
|
Code identifier - Standardized code or identifier for ServiceOrder classification |
||||
| ItemOrder | int | 4 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for ServiceOrder records |
||||
| AgreementType | varchar | 100 | √ | null |
|
|
Type classification - Category or classification type for ServiceOrder records |
||||
| ServiceOrderId | Unknown | 0 | null |
|
|
Primary key - ServiceOrder unique identifier for each service order |
|||||
| ServiceType | Unknown | 0 | null |
|
|
Service type - Type of service being ordered |
|||||
| SignupCode | uniqueidentifier | 16 | √ | null |
|
|
Code identifier - Standardized code or identifier for ServiceOrder classification |
||||
| StartDate | Unknown | 0 | null |
|
|
Start date - Date when services should begin |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ServiceOrder | Primary key | Asc | pkServiceOrderID |