Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ArchiveLocation | Unknown | 0 | null |
|
|
Archive location - Location where the deleted history is permanently archived |
||
| AuditTrail | Unknown | 0 | null |
|
|
Audit trail - Complete audit trail for the deleted history record |
||
| ComplianceFlag | Unknown | 0 | null |
|
|
Compliance flag - Boolean indicating if deletion meets compliance requirements |
||
| DateArchived | datetime | 16,3 | √ | null |
|
|
Archive date - Date when the history record was archived |
|
| DeletionReason | Unknown | 0 | null |
|
|
Deletion reason - Reason why the history record was deleted |
||
| HistID | int | 4 | null |
|
|
History ID - Original history record identifier that was deleted |
||
| FieldName | varchar | 50 | √ | null |
|
|
Field name - Name of the field that was changed in the deleted history |
|
| HistoryAction | Unknown | 0 | null |
|
|
History action - Action that triggered the history record (Update, Delete, etc.) |
||
| HistoryData | Unknown | 0 | null |
|
|
Historical data - JSON or XML backup of the complete historical record |
||
| HistoryDate | Unknown | 0 | null |
|
|
History date - Date when the original record was archived to history |
||
| ID | Unknown | 0 | null |
|
|
Primary key - Unique identifier for each deleted history record |
||
| OriginalHistoryID | Unknown | 0 | null |
|
|
Original history ID - ID of the history record that was deleted |
||
| pkId | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each deleted history record |
|
| RecordID | Unknown | 0 | null |
|
|
Record identifier - ID of the original record that was historized |
||
| RecoveryPossible | Unknown | 0 | null |
|
|
Recovery possible - Boolean indicating if the record can be recovered |
||
| RetentionPeriod | Unknown | 0 | null |
|
|
Retention period - Required retention period for this type of historical data |
||
| TableName | varchar | 50 | √ | null |
|
|
Table name - Name of the table that contained the deleted history |
|
| ValueBefore | varchar | 4000 | √ | null |
|
|
Previous value - Value before the change in the deleted history |
|
| ValueAfter | varchar | 4000 | √ | null |
|
|
New value - Value after the change in the deleted history |
|
| ArchivedBy | int | 4 | √ | null |
|
|
Archived by user - UserID of the person who archived the history |
|
| InsertID | int | 4 | √ | null |
|
|
Insert ID - Identifier for the insertion process |
|
| FieldID | int | 4 | √ | null |
|
|
Field ID - Identifier for the field that was changed |
|
| fkInvoicePresentID | nvarchar | 40 | √ | null |
|
|
Invoice presentation reference - Links to invoice presentation if applicable |
|
| ActionId | int | 4 | √ | null |
|
|
Action ID - Identifier for the action that caused the change |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Date when the history record was deleted |
|
| DeletedBy | datetime | 16,3 | √ | null |
|
|
Deleted by date - Date when the deletion was performed |
Relationships
Close relationships within degrees of separation
