Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| DeletedDate | Unknown | 0 | null |
|
|
Deletion date - Date when the transaction was deleted |
||
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each deleted transaction record |
|
| TransId | int | 4 | √ | null |
|
|
Transaction ID - Original transaction identifier that was deleted |
|
| ClaimId | int | 4 | √ | null |
|
|
Claim reference - Links to Claim table for the associated claim |
|
| DateTransaction | datetime | 16,3 | √ | null |
|
|
Transaction date - Date when the original transaction occurred |
|
| Amount | money | 21,4 | √ | null |
|
|
Transaction amount - Monetary amount of the deleted transaction |
|
| BillingUnit | decimal | 20 | √ | null |
|
|
Billing units - Number of billing units for the deleted transaction |
|
| TransType | varchar | 20 | √ | null |
|
|
Transaction type - Type of the deleted transaction (Payment, Adjustment, etc.) |
|
| DateTransType | datetime | 16,3 | √ | null |
|
|
Transaction type date - Date associated with the transaction type |
|
| InsertBy | int | 4 | √ | null |
|
|
Inserted by user - UserID of the person who originally created the transaction |
|
| UpdateBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated the transaction |
|
| DeletedBy | int | 4 | √ | null |
|
|
Deleted by user - UserID of the person who deleted the transaction |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__DeletedC__3214EC273D294772 | Primary key | Asc | ID |
Relationships
Close relationships within degrees of separation
