Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| InvoiceId | int | 4 | √ | null |
|
|
Invoice identifier - Reference to the daycare invoice |
|
| DueDate | datetime | 16,3 | √ | null |
|
|
Payment due date - When payment is due for this invoice |
|
| 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 after payments |
|
| Status | varchar | 12 | null |
|
|
Invoice status - Calculated status (Paid, Overdue, Open, Partial Paid) |