BillingInvArchive


Description

Invoice archive tracking managing the archival status and history of billing invoices. This table tracks when invoices are archived, their status changes, and associated voucher information for audit trail purposes and invoice lifecycle management in the billing system.

Columns

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

Primary key - Unique identifier for each invoice archive record
fkInvoiceID int 4 √ null
Invoice.InvoiceID FK__BillingIn__fkInv__2C002054 C

Invoice reference - Links to Invoice table for the archived invoice
StatusID int 4 √ null

Archive status - Status of the archived invoice, references iCS2.dbo.StatusType for centralized status management
DateArchived smalldatetime 16 √ (getdate())

Archive date - Date when the invoice was archived
Voucher varchar 30 √ null

Voucher number - Voucher or reference number associated with the archived invoice
ActionBy int 4 √ null

Action by user - UserID of the person who performed the archive action
PresentID nvarchar 40 √ null

Present ID - Current identifier or reference for the archived invoice
ActionID int 4 √ null

Action reference - Links to the specific action that caused the archival

Relationships

Close relationships within degrees of separation