TuitionInvoiceAppliedAmountByCheckLog_vw


Description

Tuition invoice applied amounts view providing aggregated applied amounts from tuition transactions by check log for financial reporting and reconciliation. This view consolidates transaction amounts from TuitionTransactionChecklog and DaycareTransactions tables to support tuition payment tracking, invoice reconciliation, and financial reporting for daycare and tuition management.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
CheckLogId int 4 null

Check log reference - Links to the check log record for transaction grouping
Amount decimal 40,2 null

Applied amount - Total amount applied from transactions associated with this check log

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views