Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| TransID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each payment transaction |
||||
| fkCheckLogID | int | 4 | √ | null |
|
|
Check reference - Links to checkLog table for the payment check |
||||
| DateTransaction | smalldatetime | 16 | √ | (getdate()) |
|
|
Transaction date - Date when the transaction was processed |
||||
| Amount | money | 21,4 | √ | null |
|
|
Transaction amount - Dollar amount of the transaction |
||||
| TransType | varchar | 50 | √ | null |
|
|
Transaction type - Type of transaction (Payment, Adjustment, Allocation, etc.) |
||||
| DateTransType | smalldatetime | 16 | √ | null |
|
|
Transaction type date - Date associated with the specific transaction type |
||||
| InsertBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created this transaction |
||||
| Editable | int | 4 | √ | null |
|
|
Editable flag - Indicates if this transaction can be modified |
||||
| TransComments | varchar | 1000 | √ | null |
|
|
Transaction comments - Detailed notes about the transaction |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_CheckLogTransaction | Primary key | Asc | TransID |
Relationships
Close relationships within degrees of separation
