Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| TransReasonID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each transaction reason record |
||||
| fkTransID | int | 4 | √ | null |
|
|
Transaction reference - Links to InvoiceTransaction table for the transaction requiring reason documentation (foreign key to InvoiceTransaction.TransID) |
||||
| fkVoidID | int | 4 | √ | null |
|
|
Void reference - Links to void reason or void transaction for voided transactions |
||||
| DateTransTypeReas | datetime | 16,3 | √ | (getdate()) |
|
|
Reason date - Date and time when the transaction reason was recorded |
||||
| ReasonBy | int | 4 | √ | null |
|
|
Reason user reference - Links to AccessUser table for the user who provided the transaction reason |
||||
| TransType | varchar | 20 | √ | null |
|
|
Transaction type - Type of transaction requiring reason documentation (e.g., ‘Void’, ‘Adjustment’, ‘Correction’) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__InvoiceTransReas__288F8223 | Primary key | Asc | TransReasonID |
Relationships
Close relationships within degrees of separation
