DaycareInvoices


Description

Daycare billing invoices managing invoices for daycare services including billing dates, payment status, and payment methods. This table handles daycare-specific billing with invoice tracking, due dates, payment methods, and paysource assignments to support daycare billing operations and financial management for childcare services.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int identity 4 √ null
DaycareTransactions.fkInvoiceID FK_DaycareTransactions_DaycareInvoices R

Primary key - Unique identifier for each daycare invoice
InvoiceDate datetime 16,3 √ null

Invoice date - Date when the invoice was generated
DueDate datetime 16,3 √ null

Due date - Date when payment is due
Status nvarchar 50 √ null

Invoice status - Current status of the invoice (Open, Paid, Overdue, etc.)
DateCreated datetime 16,3 √ null

Creation date - Date when the invoice was created
CreatedBy int 4 √ null

Created by user - UserID of the person who created the invoice
DateUpdated datetime 16,3 √ null

Update date - Date when the invoice was last updated
UpdatedBy int 4 √ null

Updated by user - UserID of the person who last updated the invoice
DateDeleted datetime 16,3 √ null

Deletion date - Soft delete timestamp for audit trail purposes
PaysourceID int 4 √ null
AccessUser.UserID FK_DaycareInvoices_AccessUser R

Paysource reference - Links to AccessUser table for the paysource
PaymentMethod nvarchar 100 √ null

Payment method - Method of payment (Check, Credit Card, Cash, etc.)
CasePaysourceId int 4 √ null

Case paysource reference - Links to case-specific paysource information

Indexes

Constraint Name Type Sort Column(s)
PK_DaycareInvoices Primary key Asc ID

Relationships

Close relationships within degrees of separation