审核日志相关

https://community.dynamics.com/crm/b/mscrmcustomization/posts/ms-crm-audit-database-table-details

查询指定字段的ColumnNumber

select a.ColumnNumber
from Attribute a
left join Entity e on a.EntityId=e.EntityId
where a.Name='new_remarks' and e.Name='account'

更新审核日志

update a
set ChangeData='10~P1~Y~w',AttributeMask=',38,46,44,45,'
from auditBase a
where AuditId='1F87361C-B8CB-EA11-B7FC-BF2DDEC2B7D8'

新增审核日志

insert AuditBase (UserId,CreatedOn,TransactionId,ChangeData,Action,Operation,ObjectId,AuditId,AttributeMask,ObjectTypeCode)
values ('98926946-8FD1-E611-93FB-00155DC81318','2020-07-23 01:10:20.000','8C93341C-B8CB-EA11-B801-B194930F8763','remark',2,2,'5F837D18-F0D3-E611-93FC-00155DC81317',NEWID(),',31,',10101)

备注：TransactionId代表什么，暂时不清楚，如有了解的欢迎补充。