Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each daycare invoice, auto-incrementing integer |
||||
| InvoiceDate | datetime | 16,3 | √ | null |
|
|
Invoice date - Date when the invoice was generated |
||||
| DueDate | datetime | 16,3 | √ | null |
|
|
Payment due date - Date when payment is due for this invoice |
||||
| Status | nvarchar | 50 | √ | null |
|
|
Invoice status - Current status of the invoice (e.g., Pending, Paid, Overdue, Cancelled) |
||||
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation timestamp - When this invoice record was first created |
||||
| CreatedBy | int | 4 | √ | null |
|
|
Creator user ID - Reference to user who created this invoice |
||||
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Last modification timestamp - When this invoice 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 invoice was logically deleted |
||||
| PaysourceID | int | 4 | √ | null |
|
|
Payment source reference - Reference to the payment source or payer for this invoice |
||||
| PaymentMethod | nvarchar | 100 | √ | null |
|
|
Payment method - Method of payment (e.g., Cash, Check, Credit Card, Electronic) |
||||
| CasePaysourceId | int | 4 | √ | null |
|
|
Case payment source - Reference to case-specific payment source information |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_DaycareInvoices | Primary key | Asc | ID |