paymentInfo


Description

Payment information summary tracking applied and unapplied payment amounts for claims and invoices by check log. This table provides financial summary data including applied amounts for claims and invoices, unapplied balances, and update tracking to support payment reconciliation, financial reporting, and payment management for healthcare billing and accounts receivable.

Columns

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

Check log reference - Links to CheckLog table for the payment batch
AmountAppliedClaim money 21,4 √ null

Applied claim amount - Total amount applied to claims from this payment
AmountUnappliedClaim money 21,4 √ null

Unapplied claim amount - Amount from this payment not yet applied to claims
AmountAppliedInvoice money 21,4 √ null

Applied invoice amount - Total amount applied to invoices from this payment
AmountUnappliedInvoice money 21,4 √ null

Unapplied invoice amount - Amount from this payment not yet applied to invoices
DateUpdate smalldatetime 16 √ (getdate())

Last update date - Date when the payment information was last updated

Relationships

Close relationships within degrees of separation