Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| BillingUnit | Unknown | 0 | null |
|
|
Billing unit - Unit of measurement for billing (per user, per month, etc.) |
||
| CreditAccount | int | 4 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for Item records |
|
| DebitAccount | int | 4 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for Item records |
|
| ActiveItem | int | 4 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for Item records |
|
| DefaultRate | Unknown | 0 | null |
|
|
Default rate - Standard billing rate for the item |
||
| pkItemID | int identity | 4 | √ | null |
|
|
Primary key - Item unique identifier for each record |
|
| ItemName | varchar | 200 | √ | null |
|
|
Item name - Descriptive name of the billable item |
|
| Description | varchar | 2000 | √ | null |
|
|
Description field - Detailed description or explanation of Item information |
|
| IsActive | Unknown | 0 | null |
|
|
Active status - Whether this item is currently available for billing |
||
| ItemCategory | Unknown | 0 | null |
|
|
Item category - Category classification for the item |
||
| ItemDescription | Unknown | 0 | null |
|
|
Item description - Detailed description of the item or service |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Item | Primary key | Asc | pkItemID |