Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| TransID | int identity | 4 | null |
|
|
Primary key - Unique identifier for the claim transaction |
||
| fkClaimid | int | 4 | √ | null |
|
|
Claim foreign key - Links to the claim this transaction belongs to |
|
| DateTransaction | datetime | 16,3 | √ | null |
|
|
Transaction date - Date when the financial transaction occurred |
|
| Amount | money | 21,4 | √ | null |
|
|
Transaction amount - Monetary amount of the transaction (positive for payments, negative for adjustments) |
|
| BillingUnit | decimal | 6,2 | √ | null |
|
|
Billing units - Number of service units associated with this transaction |
|
| TransType | varchar | 20 | √ | null |
|
|
Transaction type - Type of transaction (Payment, Adjustment, Void, Refund, etc.) |
|
| DateTransType | datetime | 16,3 | √ | null |
|
|
Transaction type date - Date associated with the specific transaction type |
|
| InsertBy | int | 4 | √ | null |
|
|
Inserted by user - User ID of the person who created the transaction |
|
| Editable | int | 4 | √ | null |
|
|
Editable flag - Indicates whether this transaction can be modified |
|
| fkInsertID | int | 4 | √ | null |
|
|
Insert identifier - Foreign key linking to the insertion source or batch |
|
| original | int | 4 | √ | null |
|
|
Original flag - Indicates if this is the original transaction or a modification |
|
| transcomments | text | 2147483647 | √ | null |
|
|
Transaction comments - Additional notes or comments about the transaction |
|
| InvoiceID | int | 4 | √ | null |
|
|
Invoice foreign key - Links to the invoice containing this transaction |
|
| Balance | money | 21,4 | √ | null |
|
|
Running balance - Current balance for the claim after this transaction |
Relationships
Close relationships within degrees of separation
