--- id: object/table/7100 type: object title: Table 7100 "Expense Activity Log Entry" summary: Table 7100 "Expense Activity Log Entry" in ExpenseAgent (Microsoft.ExpenseAgent). 34 fields. Introduced in BC29, still in BC30, changed in BC30. tier: official language: en tags: - table - expenseagent versions: introduced: "29" last_changed: "30" deprecated: null review: state: derived by: null at: null flags: [] generated: at: "2026-10-11T00:31:51.816Z" pipeline: 0.2.0 prompts: {} input_hash: a068cc8c3812a90bb281a50f943f28ae019428199e52dce837ae6dad30630c7f evidence: - kind: code url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/ExpenseAgent/app/src/ActivityLog/Tables/ExpenseActivityLogEntry.Table.al title: src/Apps/W1/ExpenseAgent/app/src/ActivityLog/Tables/ExpenseActivityLogEntry.Table.al (releases/29.x) date: null commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220 t: null quote: null links: learn: [] objects: [] features: [] topics: [] localizations: [] videos: [] posts: [] guidelines: [] changes: - change/bcapps/12074 - change/bcapps/11628 - change/bcapps/10614 - change/bcapps/10359 - change/bcapps/10255 object_type: table object_id: 7100 name: Expense Activity Log Entry namespace: Microsoft.ExpenseAgent app: ExpenseAgent extends: null first_version: "29" last_version: "30" present_in: - "29" - "30" changed_in: - "30" source_major: "29" obsolete: null countries: [] ms_search_form_ids: [] counts: fields: 34 procedures: 0 events: 0 subscribers: 0 relations: out: 4 referenced_by: 1 pages: 2 extended_by: 0 event_subscribers: 0 calls: 0 called_by: 0 implements: 0 --- # Table 7100 "Expense Activity Log Entry" > Table 7100 "Expense Activity Log Entry" in ExpenseAgent (Microsoft.ExpenseAgent). 34 fields. Introduced in BC29, still in BC30, changed in BC30. ExpenseAgent · Microsoft.ExpenseAgent · BC29-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/ExpenseAgent/app/src/ActivityLog/Tables/ExpenseActivityLogEntry.Table.al) · facts from BC29 ## Properties | Property | Value | |---|---| | Caption | Expense Activity Log Entry | | Access | Internal | | 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 | — | AutoIncrement; DataClassification SystemMetadata | | 2 | Source Table ID | Integer | Specifies the table containing the source document that currently owns the activity entry. | DataClassification SystemMetadata | | 3 | Source Record System ID | Guid | Specifies the immutable SystemId of the source document that currently owns the activity entry. | TableRelation [Table 6906 "Expense Report Header"](../table/6906.md), [Table 6915 "Posted Expense Report Header"](../table/6915.md) (if ("Source Table ID" = const(Database::"Expense Report Header")) "Expense Report Header".SystemId else if ("Source Table ID" = const(Database::"Posted Expense Report Header")) "Posted Expense Report Header".SystemId); DataClassification SystemMetadata | | 4 | Subject Table ID | Integer | Specifies the table containing the logical subject described by the activity entry. | DataClassification SystemMetadata | | 5 | Subject System ID | Guid | Specifies the stable SystemId of the logical subject described by the activity entry. | DataClassification SystemMetadata | | 6 | Document No. | Code[20] | — | | | 7 | Document Description | Text[100] | — | | | 8 | Event Type | Enum "Expense Activity Event Type" | Specifies the activity that occurred for the expense report. | enum [Enum 6922 "Expense Activity Event Type"](../enum/6922.md); DataClassification SystemMetadata | | 9 | Occurred At | DateTime | Specifies the date and time when the activity occurred. | DataClassification SystemMetadata | | 10 | Initiated By | Enum "Expense Activity Initiator" | Specifies whether the activity originated from a person or the autonomous Expense Agent. | enum [Enum 6923 "Expense Activity Initiator"](../enum/6923.md); DataClassification SystemMetadata | | 11 | Actor Role | Enum "Expense Activity Actor Role" | Specifies the business capacity in which the actor performed the activity. | enum [Enum 6924 "Expense Activity Actor Role"](../enum/6924.md); DataClassification SystemMetadata | | 12 | Actor Table ID | Integer | Specifies the table containing the record that represents the actor. | DataClassification SystemMetadata | | 13 | Actor Record System ID | Guid | Specifies the immutable SystemId of the record that represents the actor. | TableRelation [Table 6923 "Expense User"](../table/6923.md) (if ("Actor Table ID" = const(Database::"Expense User")) "Expense User".SystemId else if ("Actor Table ID" = const(Database::User)) User.SystemId); DataClassification EndUserPseudonymousIdentifiers | | 14 | Actor Display Name | Text[100] | Specifies the name of the user or agent that performed the activity. | DataClassification EndUserIdentifiableInformation | | 15 | Amount (LCY) | Decimal | — | DataClassification AccountData | | 16 | Non-Refundable Amount (LCY) | Decimal | — | DataClassification AccountData | | 17 | Reimbursable Amount | Decimal | — | DataClassification AccountData | | 18 | Reimbursable Amount (LCY) | Decimal | — | DataClassification AccountData | | 19 | Refundable Amount | Decimal | — | DataClassification AccountData | | 20 | Refundable Amount (LCY) | Decimal | — | DataClassification AccountData | | 21 | Reimbursement Currency Code | Code[10] | — | DataClassification AccountData | | 22 | Reimbursement Currency Factor | Decimal | — | DataClassification AccountData | | 50 | Comment | Text[2048] | Specifies additional details recorded for the activity. | | | 51 | Categories | Text[2048] | — | | | 52 | Attached Receipt Count | Integer | — | DataClassification SystemMetadata | | 53 | Expense Count | Integer | — | DataClassification SystemMetadata | | 55 | Policy Status | Enum "Expense Policy Status" | — | enum [Enum 6989 "Expense Policy Status"](../enum/6989.md); DataClassification SystemMetadata | | 56 | Failed Policy Count | Integer | — | DataClassification SystemMetadata | | 57 | Passed Policy Count | Integer | — | DataClassification SystemMetadata | | 58 | Flagged Categories | Text[2048] | — | | | 100 | History Actor Table ID Filter | Integer | — | FlowFilter | | 101 | History Actor System ID Filter | Guid | — | FlowFilter | | 102 | History Actor Role Filter | Enum "Expense Activity Actor Role" | — | FlowFilter; enum [Enum 6924 "Expense Activity Actor Role"](../enum/6924.md) | | 103 | History Subject Match | Boolean | — | FlowField: exist("Expense Activity Log Entry" where( "Subject Table ID" = field("Subject Table ID"), "Subject System ID" = field("Subject System ID"), "Actor Table ID" = field("History Actor Table ID Filter"), "Actor Record System ID" = field("History Actor System ID Filter"), "Actor Role" = field("History Act... | ## Keys - PK: Entry No. (clustered) - Source: Source Table ID, Source Record System ID, Occurred At, Entry No. - SourceEvent: Source Table ID, Source Record System ID, Event Type, Entry No. - Subject: Subject Table ID, Subject System ID, Occurred At, Entry No. - Actor: Actor Table ID, Actor Record System ID, Actor Role, Subject Table ID, Subject System ID, Occurred At, Entry No. - Occurred: Occurred At, Entry No. ## Triggers OnModify, OnRename ## Relations - Source Record System ID: TableRelation [Table 6906 "Expense Report Header"](../table/6906.md) (conditional) - Source Record System ID: TableRelation [Table 6915 "Posted Expense Report Header"](../table/6915.md) (conditional) - Actor Record System ID: TableRelation [Table 6923 "Expense User"](../table/6923.md) (conditional) - History Subject Match: CalcFormula [Table 7100 "Expense Activity Log Entry"](../table/7100.md) ## Referenced by 1 fields in 1 objects relate to this table (TableRelation or CalcFormula). - [Table 7100 "Expense Activity Log Entry"](../table/7100.md): History Subject Match ## Pages and codeunits on this table - [Page 7122 "Expense Activity Log API"](../page/7122.md) (source table) - [Page 7123 "Expense Activity Log FactBox"](../page/7123.md) (source table) ## Recent changes - 2026-10-02 [#12074 Expense Agent: travel request expense location, per-traveler reports, activity log and submitter comment](../../changes/bcapps/12074.md) (main, BC30, feature) - 2026-10-01 [#11628 Expense Agent: capture submission policy evaluation history](../../changes/bcapps/11628.md) (main, BC30, feature) - 2026-08-31 [#10614 Expense Agent: Improve expense activity history captions](../../changes/bcapps/10614.md) (main, BC30, other) - 2026-08-19 [#10359 Add activity log amount formatting metadata](../../changes/bcapps/10359.md) (main, BC30, feature) - 2026-08-17 [#10255 Add expense activity history foundation](../../changes/bcapps/10255.md) (main, BC30, feature, added) ## Across versions - Present in: BC29-30 - Changed (declaration) in: BC30 Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10). ## Ask your agent Procedure bodies are not stored here (D10). 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: "Expense Activity Log Entry")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.