tableAL Developmentofficial - Microsoftderived - from the source, no model text

Table 405 "Change Log Entry"

Base Application · System.Diagnostics

Across versions

  1. BC23present
  2. BC245 fields changed, 1 procedures removed
  3. BC25unchanged
  4. BC263 fields changed, 1 events removed
  5. BC27-30unchanged

Neighbourhood 7 connected objects and pages

Page 595 "Change Log Entries" (pages and codeunits on it, 3 links)Change Log EntriesCodeunit 510 "Change Log Entry - Delete" (pages and codeunits on it)Change Log Entry - DeletePage 1367 "Monitored Field Log Entries" (pages and codeunits on it)Monitored Field Log EntriesPage 205 "Confirm Alt. Cust. VAT Reg." (pages and codeunits on it)Confirm Alt. Cust. VAT Reg.Codeunit 423 "Change Log Management" (calls)Change Log ManagementAuditing changes (Learn pages)Auditing changesClean up data with retention policies (Learn pages)Clean up data with retention…

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

Base Application · System.Diagnostics · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 595 “Change Log Entries” (2 Learn pages), Page 1367 “Monitored Field Log Entries” (2).

Properties

Property Value
Caption Change Log Entry
DataClassification CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No. Name Type Explanation Notes
1 Entry No. BigInteger Specifies the number of the entry, as assigned from the specified number series when the entry was created. via Page 595 “Change Log Entries” AutoIncrement
2 Date and Time DateTime Specifies the date and time when this change log entry was created. via Page 595 “Change Log Entries”
3 Time Time —
4 User ID Code[50] Specifies the ID of the user who posted the entry, to be used, for example, in the change log. via Page 595 “Change Log Entries” TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation
5 Table No. Integer Specifies the number of the table containing the changed field. via Page 595 “Change Log Entries” TableRelation AllObjWithCaption.“Object ID” where(“Object Type” = const(Table))
6 Table Caption Δ BC24 Text[250] Specifies the name of the table containing the changed field. via Page 595 “Change Log Entries” FlowField: lookup(AllObjWithCaption.“Object Caption” where(“Object Type” = const(Table), “Object ID” = field(“Table No.”)))
7 Field No. Integer Specifies the field number of the changed field. via Page 595 “Change Log Entries” TableRelation Field.“No.” where(TableNo = field(“Table No.”))
8 Field Caption Δ BC24 Δ BC26 Text[80] Specifies the field caption of the changed field. FlowField: lookup(Field.“Field Caption” where(TableNo = field(“Table No.”), “No.” = field(“Field No.”)))
9 Type of Change Enum “Change Log Entry Type” Specifies the type of change made to the field. via Page 595 “Change Log Entries” enum Enum 405 “Change Log Entry Type”
10 Old Value Δ BC26 Text[2048] Specifies the value that the field had before a user made changes to the field.
11 New Value Δ BC26 Text[2048] Specifies the value that the field had after a user made changes to the field.
12 Primary Key Text[250] Specifies the primary key or keys of the changed field. via Page 595 “Change Log Entries”
13 Primary Key Field 1 No. Integer Specifies the field number of the first primary key for the changed field. via Page 595 “Change Log Entries” TableRelation Field.“No.” where(TableNo = field(“Table No.”))
14 Primary Key Field 1 Caption Δ BC24 Text[80] Specifies the field name of the first primary key for the changed field. via Page 595 “Change Log Entries” FlowField: lookup(Field.“Field Caption” where(TableNo = field(“Table No.”), “No.” = field(“Primary Key Field 1 No.”)))
15 Primary Key Field 1 Value Text[50] Specifies the value of the first primary key for the changed field. via Page 595 “Change Log Entries”
16 Primary Key Field 2 No. Integer Specifies the field number of the second primary key for the changed field. via Page 595 “Change Log Entries” TableRelation Field.“No.” where(TableNo = field(“Table No.”))
17 Primary Key Field 2 Caption Δ BC24 Text[80] Specifies the field name of the second primary key for the changed field. via Page 595 “Change Log Entries” FlowField: lookup(Field.“Field Caption” where(TableNo = field(“Table No.”), “No.” = field(“Primary Key Field 2 No.”)))
18 Primary Key Field 2 Value Text[50] Specifies the value of the second primary key for the changed field. via Page 595 “Change Log Entries”
19 Primary Key Field 3 No. Integer Specifies the field number of the third primary key for the changed field. via Page 595 “Change Log Entries” TableRelation Field.“No.” where(TableNo = field(“Table No.”))
20 Primary Key Field 3 Caption Δ BC24 Text[80] Specifies the field name of the third primary key for the changed field. via Page 595 “Change Log Entries” FlowField: lookup(Field.“Field Caption” where(TableNo = field(“Table No.”), “No.” = field(“Primary Key Field 3 No.”)))
21 Primary Key Field 3 Value Text[50] Specifies the value of the third primary key for the changed field. via Page 595 “Change Log Entries”
22 Record ID RecordID —
25 Protected Boolean — DataClassification SystemMetadata
26 Changed Record SystemId Guid — DataClassification SystemMetadata
27 Notification Status Enum “Monitor Field Notification” Specifies whether notification was sent, failed or was turned off via Page 1367 “Monitored Field Log Entries” enum Enum 1366 “Monitor Field Notification”; DataClassification SystemMetadata
28 Field Log Entry Feature Enum “Field Log Entry Feature” — enum Enum 1367 “Field Log Entry Feature”; DataClassification SystemMetadata
29 Notification Message Id Guid — DataClassification SystemMetadata

Keys

  • Key1: Entry No. (clustered)
  • Key2: Table No., Primary Key Field 1 Value, Primary Key Field 2 Value
  • Key3: Table No., Date and Time
  • Key4: Notification Message Id
  • key5: Field Log Entry Feature
  • key6: SystemCreatedAt, Protected, Field Log Entry Feature
  • Key7: Primary Key Field 2 Value, Table No., Primary Key Field 1 Value

Events published

  • OnAfterIsProtected(var ChangeLogEntry: Record "Change Log Entry"; var ProtectedRecord: Boolean) (integration)

Procedures

  • GetFullPrimaryKeyFriendlyName(): Text
  • GetLocalOldValue(): Text
  • GetLocalNewValue(): Text

Plus 2 local procedures.

Triggers

OnInsert

Relations

Pages and codeunits on this table

Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.

Recent changes

Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Change Log Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Evidence 1 sources