InvoiceTransaction


Description

Invoice transactions and adjustments tracking financial transactions, payments, adjustments, and modifications applied to invoices. This table manages transaction history including amounts, transaction types, dates, user tracking, and comments to support comprehensive invoice management, payment processing, and financial audit trails for healthcare billing operations.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
TransID int identity 4 √ null
InvoiceTransCheck.fkTransID FK__InvTransCheckID__TransID C
InvoiceTransReason.fkTransID FK_InvoiceTransReason_InvoiceTransaction C

Primary key - Unique identifier for each invoice transaction
fkInvoiceID int 4 √ null
Invoice.InvoiceID FK_Invoice C

Invoice reference - Links to invoice that this transaction affects
DateTransaction datetime 16,3 √ (getdate())

Transaction date - Date when the transaction was processed
Amount money 21,4 √ null

Transaction amount - Dollar amount of the transaction (positive or negative)
TransType varchar 20 √ null

Transaction type - Type of transaction (Payment, Adjustment, Refund, etc.)
DateTransType datetime 16,3 √ null

Transaction type date - Date associated with the transaction type
InsertBy int 4 √ null
AccessUser.UserID FK_UserID_Inv R

Created by user - UserID of the person who created this transaction
Editable int 4 √ null

Editable flag - Indicates if this transaction can be edited (0=no, 1=yes)
fkInsertID int 4 √ null

Insert reference - Links to the record that triggered this transaction
Comments text 2147483647 √ null

Transaction comments - Additional notes and comments about the transaction
importID int 4 √ null

Import reference - Links to import batch if transaction was imported from external system

Indexes

Constraint Name Type Sort Column(s)
PK_TransInvID Primary key Desc TransID
IX_DateTransaction Performance Asc DateTransaction
IX_InvoiceID Performance Asc fkInvoiceID

Relationships

Close relationships within degrees of separation