Invoice


Description

Billing invoices grouping multiple claims into consolidated billing documents for submission to payers. This table manages invoice generation, submission tracking, payment processing, and financial reconciliation for batch billing and accounts receivable management.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
InvoiceID int identity 4 √ null
BillingInvArchive.fkInvoiceID FK__BillingIn__fkInv__2C002054 C
ClaimTransInvoice.fkInvoiceID FK__ClaimTran__fkInv__094BE0F4 R
InvoiceTransaction.fkInvoiceID FK_Invoice C

Primary key - Unique identifier for each billing invoice
InvoiceDate datetime 16,3 √ (getdate())

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

Invoice cycle date - Date associated with the billing cycle
InvoiceTotal money 21,4 √ (0)

Invoice total - Total amount of all claims included in the invoice
Status int 4 √ null

Invoice status - Current processing status (Draft, Submitted, Paid, etc.)
PatientID int 4 √ null

Patient reference - Links to Patient table if invoice is patient-specific
PresentID nvarchar 40 √ null

Presentation ID - External identifier for invoice presentation
VOUCHER varchar 30 √ null

Voucher number - Voucher or reference number for payment processing
fkInvoiceby int 4 √ null
AccessUser.UserID FK__INVOICE__fkInvoi__4AB9B19E R

Invoiced by user - UserID of the person who generated the invoice
ProgramID int 4 √ null

Program reference - Links to iCS2.dbo.ProgramType for centralized program type definitions for the services
Checkamount money 21,4 √ null

Check amount - Amount of check payment received
VoidAmount money 21,4 √ null

Voided amount - Amount voided from the invoice
DateFileGenerated datetime 16,3 √ null

File generation date - Date when invoice file was generated for submission
FiledBy int 4 √ null

Filed by user - UserID of the person who filed the invoice
fkBillID int 4 √ null
Billing.BillID FK__Invoice__Billing R

Billing reference - Links to Billing table for billing configuration
DateAction datetime 16,3 √ null

Action date - Date when last action was taken on the invoice
ActionBy int 4 √ null

Action by user - UserID of the person who took the last action
INVOICEPAID money 21,4 √ null

Invoice paid amount - Total amount paid against this invoice
importid int 4 √ null

Import identifier - Reference ID for data migration and import tracking
source varchar 20 √ null

Data source - Source of invoice data (system generated, imported, etc.)
fksiteID int 4 √ null

Site reference - Links to AgencySite table for the billing location
AmountAdjusted money 21,4 √ null

Adjusted amount - Total amount of adjustments made to the invoice
InvComments text 2147483647 √ null

Invoice comments - Notes about the invoice processing or issues
fkRateTypeID int 4 √ null
RateType.RateTypeID FK_Invoice_RateType R

Rate type - Links to RateType table for billing rate classification

Indexes

Constraint Name Type Sort Column(s)
PK_Invoice Primary key Asc InvoiceID
IX_PresentID Performance Asc PresentID
IX_Voucher Performance Desc VOUCHER

Relationships

Close relationships within degrees of separation