Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each transaction, auto-incrementing integer |
||||
| fkInvoiceID | int | 4 | √ | null |
|
|
Invoice reference - Foreign key linking to DaycareInvoices.ID for the associated invoice |
||||
| fkPatientID | int | 4 | √ | null |
|
|
Patient reference - Foreign key linking to patient associated with transaction |
||||
| DateFrom | datetime | 16,3 | √ | null |
|
|
Service period start - Start date of service period for this transaction |
||||
| DateTo | datetime | 16,3 | √ | null |
|
|
Service period end - End date of service period for this transaction |
||||
| TransactionType | nvarchar | 100 | √ | null |
|
|
Transaction type - Type of transaction (Charge, Payment, Adjustment, Refund) |
||||
| TransactionCategory | nvarchar | 200 | √ | null |
|
|
Transaction category - Category classification for the transaction |
||||
| TransactionAmount | decimal | 20,2 | √ | null |
|
|
Transaction amount - Monetary amount of the transaction |
||||
| Comments | nvarchar | 1073741823 | √ | null |
|
|
Transaction comments - Additional comments or notes about the transaction |
||||
| PaysourceId | int | 4 | √ | null |
|
|
Payment source reference - Reference to payment source or funding source |
||||
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation timestamp - When this transaction was first created |
||||
| CreatedBy | int | 4 | √ | null |
|
|
Creator user ID - Reference to user who created this transaction |
||||
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Last modification timestamp - When this transaction was most recently updated |
||||
| UpdatedBy | int | 4 | √ | null |
|
|
Last modifier - User ID who made the most recent update |
||||
| DateDeleted | datetime | 16,3 | √ | null |
|
|
Deletion timestamp - When this transaction was logically deleted |
||||
| Description | Unknown | 0 | null |
|
|
Transaction description - Detailed description of the transaction |
|||||
| StripeChargeId | nvarchar | 100 | √ | null |
|
|
Stripe charge ID - External Stripe payment processor charge identifier |
||||
| PaymentMethod | nvarchar | 100 | √ | null |
|
|
Payment method - Method used for payment transactions (Cash, Check, Credit Card, etc.) |
||||
| fkEnrollmentIDs | nvarchar | 1073741823 | √ | null |
|
|
Enrollment references - Foreign key references to associated enrollments |
||||
| CasePaysourceId | int | 4 | √ | null |
|
|
Case paysource reference - Reference to case-specific payment source |
||||
| Note | varchar | 2147483647 | √ | null |
|
|
Transaction note - Additional notes or memo for the transaction |
||||
| fkTransactionCategoryId | int | 4 | √ | null |
|
|
Transaction category reference - Foreign key linking to transaction category |
||||
| fkSiteId | int | 4 | √ | null |
|
|
Site reference - Foreign key linking to site where transaction occurred |
||||
| ReferenceNumber | Unknown | 0 | null |
|
|
Reference number - External reference number for tracking and reconciliation |
|||||
| TransactionDate | Unknown | 0 | null |
|
|
Transaction date - Date when the transaction occurred |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_DaycareTransactions | Primary key | Asc | ID |