DeletedInvoice


Description

Deleted invoice audit trail preserving deleted invoice records for financial audit trails, compliance, and potential recovery. This system maintains comprehensive invoice history for financial reporting and regulatory compliance.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
DeleteReason Unknown 0 null

Deletion reason - Reason provided for deleting the invoice

pkId int identity 4 null

Primary key - Primary key identifier for deleted invoice record

InvoiceID int 4 null

Invoice identifier - Primary identifier for the invoice

InvoiceDate datetime 16,3 null

Invoice date - Date of the deleted invoice

InvoiceDateCycle datetime 16,3 null

Invoice date cycle - Billing cycle date for the invoice

InvoiceTotal money 21,4 null

Invoice total amount - Total amount of the invoice

Status int 4 null

Invoice status - Status of the invoice when it was deleted

PatientID int 4 null

Patient identifier - Reference to patient associated with invoice

PresentID nvarchar 40 null

Present identifier - Reference to present record

VOUCHER varchar 30 null

Voucher number - Voucher number for the invoice

fkInvoiceby int 4 null

Invoice creator reference - Foreign key to user who created invoice

ProgramID int 4 null

Program identifier - Reference to program associated with invoice

Checkamount money 21,4 null

Check amount - Amount of check payment for the invoice

VoidAmount money 21,4 null

Void amount - Amount that was voided on the invoice

DateFileGenerated datetime 16,3 null

File generation date - Date when invoice file was generated

FiledBy int 4 null

Filing user - User who filed the invoice

fkBillID int 4 null

Bill reference - Foreign key to bill associated with invoice

DateAction datetime 16,3 null

Action date - Date when action was performed on the invoice

ActionBy int 4 null

Action user - User who performed the action on the invoice

INVOICEPAID money 21,4 null

Invoice paid flag - Boolean indicating if invoice was paid

importid int 4 null

Import identifier - Reference to import operation that created invoice

source varchar 20 null

Invoice source - Source system or process that generated the invoice

fksiteID int 4 null

Site reference - Foreign key to site where invoice was generated

AmountAdjusted money 21,4 null

Adjusted amount - Amount that was adjusted on the invoice

InvComments text 2147483647 null

Invoice comments - Comments associated with the invoice

fkRateTypeID int 4 null

Rate type reference - Foreign key to rate type for invoice

DeletedDate datetime 16,3 null

Deletion timestamp - When the invoice was deleted

DeletedBy int 4 null

Deletion user - User who deleted the invoice

TotalAmount Unknown 0 null

Invoice total - Total amount of the deleted invoice

Relationships