Table 7100 "Expense Activity Log Entry"

ExpenseAgent · Microsoft.ExpenseAgent · BC29-30 · source at ea08af5e · 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 6915 “Posted Expense Report Header” (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”; 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”; 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”; 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” (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”; 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”
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” (conditional)
Source Record System ID: TableRelation Table 6915 “Posted Expense Report Header” (conditional)
Actor Record System ID: TableRelation Table 6923 “Expense User” (conditional)
History Subject Match: CalcFormula Table 7100 “Expense Activity Log Entry”

Referenced by

1 fields in 1 objects relate to this table (TableRelation or CalcFormula).

Table 7100 “Expense Activity Log Entry”: History Subject Match

Pages and codeunits on this table

Page 7122 “Expense Activity Log API” (source table)
Page 7123 “Expense Activity Log FactBox” (source table)

Recent changes

2026-10-02 #12074 Expense Agent: travel request expense location, per-traveler reports, activity log and submitter comment (main, BC30, feature)
2026-10-01 #11628 Expense Agent: capture submission policy evaluation history (main, BC30, feature)
2026-08-31 #10614 Expense Agent: Improve expense activity history captions (main, BC30, other)
2026-08-19 #10359 Add activity log amount formatting metadata (main, BC30, feature)
2026-08-17 #10255 Add expense activity history foundation (main, BC30, feature, added)

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.