Field

Data Type

Width

Description

AuditID

int

Primary Key

ClientID

int

Foreign Key to tblClient

UserId

int

Foreign Key to tblUser (Person who Made Change)

TenantID

int

Foreign Key to tblTenant

AppFunction

varchar

30

Function that Created Audited Value

TableName

char

40

Table Name of Audited Value

AuditData

xml

Old value and new value

PrimaryKey

int

Primary Key of Audited Value

Operation

char

 1

Operation that Created Audited Value

ModDate

datetime

Date Value Changed