Audit & Logging - Key Tables
Full column listings for the 1 key table in this category.
AUDIT (15 columns)
| # | Column | Type | Length | Nullable | Default |
|---|---|---|---|---|---|
| 1 | AID |
int | NO | ||
| 2 | AFaultid |
int | NO | ||
| 3 | AUnum |
int | NO | ||
| 4 | ADate |
datetime | YES | ||
| 5 | AValue |
nvarchar | 4000 | YES | |
| 6 | ATo |
nvarchar | -1 | YES | |
| 7 | AFrom |
nvarchar | -1 | YES | |
| 8 | ID |
int | NO | ||
| 9 | atablename |
nvarchar | 50 | YES | ('') |
| 10 | apkid1 |
int | YES | ((0)) | |
| 11 | apkid2 |
int | YES | ((0)) | |
| 12 | apclientid |
int | YES | ((0)) | |
| 13 | aactoutcome |
nvarchar | 4000 | YES | ('') |
| 14 | auserid |
int | YES | ||
| 15 | aguid |
uniqueidentifier | YES |