PaymentAndChargeTransaction


Description

Payment and charge transaction linkage managing associations between payment transactions and charge transactions for comprehensive financial tracking. This table links payment transactions to their corresponding charge transactions, supporting payment allocation, financial reconciliation, audit trails, and comprehensive transaction tracking for healthcare billing and accounts receivable management.

Columns

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

Primary key - Unique identifier for each payment-charge transaction association
ChargeTransactionId int 4 √ null

Charge transaction reference - Links to the charge transaction being paid or adjusted
PaymentTransactionId int 4 √ null

Payment transaction reference - Links to the payment transaction being applied
CreatedDate datetime 16,3 √ null

Creation timestamp - Date and time when this transaction association was created
CreatedBy int 4 √ null

Creator reference - Links to AccessUser table for the user who created this association

Indexes

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

Relationships

Close relationships within degrees of separation