
Every table in Business Central includes the following four system fields, which can be used for auditing records:
| Field name (in AL) | Column name (in database) | Data type | Field number | Description |
|---|---|---|---|---|
| SystemCreatedAt | $systemCreatedAt | DateTime | 2000000001 | Specifies the data and time that the record was created. |
| SystemCreatedBy | $systemCreatedBy | GUID | 2000000002 | Specifies security ID (SID) of the user that created the record. |
| SystemModifiedAt | $systemModifiedAt | DateTime | 2000000003 | Specifies the data and time that the record was last modified. |
| SystemModifiedBy | $systemModifiedBy | GUID | 2000000004 | Specifies the SID of the user that last modified the record |