Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| InvoiceId | int | 4 | √ | null |
|
|
Invoice reference - Links to DaycareInvoices table |
|
| DueDate | datetime | 16,3 | √ | null |
|
|
Due date - Date when payment is due |
|
| Total | decimal | 40,2 | √ | null |
|
|
Total amount - Total invoice amount excluding payments |
|
| TotalCharge | decimal | 40,2 | √ | null |
|
|
Total charges - Sum of all charge transactions |
|
| TotalAdjustment | decimal | 40,2 | √ | null |
|
|
Total adjustments - Sum of all adjustment transactions |
|
| TotalPayment | decimal | 40,2 | √ | null |
|
|
Total payments - Sum of all payment transactions |
|
| OutStanding | decimal | 40,2 | √ | null |
|
|
Outstanding balance - Remaining balance due on the invoice |
|
| Status | varchar | 12 | null |
|
|
Payment status - Calculated status based on payment and due date (Paid, Open, Overdue, Partial Paid) |
Relationships
Close relationships within degrees of separation
