Column | Description |
|---|
id | The internal CAM id for the audit table. Is a mandatory field. |
docId | It is a mandatory field if a document is set. Displays the docid. |
folderId | It is a mandatory field if a folderid folder is set. |
userId | Displays the user Id associated to the user. Displays the user Id associated to the user. |
extDocId | The external document id (filled if a document was added/changed/updated/deleted) |
extFolder | The external folder id (filled if a folder/workspace was added/changed/updated/deleted) |
extUserId | The external userid (filled if a user or security was added/changed/updated/deleted) |
objectType | Displays the object type. |
actionCodeId | The id of the particular action done on the object. Is a mandatory field. |
actionCodeName | The name of the particular action done on the object. Is a mandatory field. |
logType | The type of the log. |
applicationName | Name of the CAM application module making the modification/addition/deletion. |
ipAddress | If the ip address is filled from an external system or user. |
clientCode | If a client is changed, this is the client code. |
MatterCode | If a matter is changed, this is the matter code. |
actionUserName | If a action has a specific user name passed, this will be filled. |
ticketId | |
comments | Any comments left on the audit. |
docNumber | If a document was added/changed/updated/deleted, the docnumber is filled. |
hasJournal | Set to 1 if a journal is with the object. |
version | Version of the object. |
metadata | Any metadata added/changed/updated/deleted |
createdDate | Displays the audit creation date. Is mandatory. |
createdByUserId | The user id of the person who created the record. |
camCreatedDate | The date the record is created in CAM |
camCreatedBy | The user who created in CAM |
extSystemId | The external system id (iManage, ND etc) |
subscriberId | Displays the tenant subscriber Id. |
runId | The ID of the job run |
actionDate | Date the action on the record was taken |
extContainerId | If the configured External System is iManage this column displays the database name, followed by the folder number (e.g. demo!1234), in case of NetDocuments, this displays the 12 digit folder number (e.g. 4816-5122-8805). It is a mandatory field. |
extContainerName | If the configured External System is iManage, this column displays the database name, followed by the document number and version (e.g. demo!463.1), in case of NetDocuments, this displays the document name. |