Expense Agent Setup #6930

Other table in Microsoft Dynamics 365 Business Central. 73 fields, 1 records in Cronus demo.

The Expense Agent Setup table (ID 6930) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 73 fields, with a primary key of Primary Key, and includes 1 calculated FlowField. Use the reference below to explore every field, data type, and table relation.

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Primary Key.

All fields (73)

Expense Agent Setup — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Primary Key PK	Code	Normal
2	Expense Reports Nos.	Code	Normal	→ No. Series #308
3	Posted Expense Reports Nos.	Code	Normal	→ No. Series #308
4	Expenses Nos.	Code	Normal	→ No. Series #308
5	Apply rules	Boolean	Normal
6	Enable agent	Boolean	Normal
7	Exchange Rate for Expenses	Option	Normal
8	Do not allow expenses older than	DateFormula	Normal
9	If expense is older than allowed	Option	Normal
10	Allow prepayment-cash advance	Boolean	Normal
11	Allow grouping of transactions in report	Boolean	Normal
12	Expense Report Rounding Precision	Decimal	Normal
13	Expense Report Rounding Type	Option	Normal
14	Check category/subcategory usage	Boolean	Normal
15	Create Expense Reports Automatically	Boolean	Normal
16	When To Create Expense Reports	Option	Normal
17	Custom Formula For Expense Report Creation	DateFormula	Normal
18	Communication Channel	Option	Normal
19	System Communication Channel	Text	Normal
20	Approval Reminder After	DateFormula	Normal
21	Standard Rate of Mileage	Decimal	Normal
22	Full Per-Diem Calculation	Option	Normal
23	Per Diem Rounding Precision	Decimal	Normal
24	Minimum Hours for Per Diem	Decimal	Normal
25	Partial Day Rules	Option	Normal
26	Reduction for Breakfast %	Decimal	Normal
27	Reduction for Lunch %	Decimal	Normal
28	Reduction for Dinner %	Decimal	Normal
29	Time Tolerance for Calendar	Decimal	Normal
30	Display anti-corruption attestation	Boolean	Normal
34	Expense User Nos.	Code	Normal	→ No. Series #308
37	Minimum Hours for Partial Per-Diem	Decimal	Normal
38	Percentage For Partial Day	Decimal	Normal
39	Receipt No. Mandatory	Boolean	Normal
40	Merchant Name Mandatory	Boolean	Normal
41	Default Mileage UOM	Code	Normal	→ Unit of Measure #204
42	Only Shortest Route	Boolean	Normal
52	User Security ID	GUID	Normal
53	Email Account ID	GUID	Normal
54	Email Connector	Option	Normal
60	Email Address	Text	Normal
61	Email Folder	Text	Normal
62	Email Folder Id	Text	Normal
76	Open Report Notification Frequency	Option	Normal
80	Enable approval workflow	Boolean	Normal
81	Day of Week	Option	Normal
82	Day In A Month	Integer	Normal
83	Expense Report Grouping	Option	Normal
84	Enable Open Report Notifications	Boolean	Normal
85	Notification Day of Week	Option	Normal
86	Notification Day In A Month	Integer	Normal
87	Custom Notification Formula	DateFormula	Normal
88	Notify users about approval updates	Boolean	Normal
89	Process incoming emails with receipts	Boolean	Normal
90	Default expense posting groups applied	Boolean	Normal
91	Default expense categories applied	Boolean	Normal
92	Default expense locations applied	Boolean	Normal
93	Default management rules applied	Boolean	Normal
94	Default payment methods applied	Boolean	Normal
95	Default number series applied	Boolean	Normal
96	Noreply Email Account ID	GUID	Normal
97	Noreply Email Connector	Option	Normal
98	Noreply Email Address	Text	Normal
100	Default Approver No.	Code	Normal	→ Expense User #6923
101	Default Approver ⚡ FLOW	Text	FlowField
102	Create Employees for Expense Users	Boolean	Normal
120	Enable project fields	Boolean	Normal
121	Project visibility	Option	Normal
2000000000	System ID	GUID	Normal
2000000001	Created At	DateTime	Normal
2000000002	Created By	GUID	Normal
2000000003	Modified At	DateTime	Normal
2000000004	Modified By	GUID	Normal

Related tables (4)

Tables referenced by fields on the Expense Agent Setup table through TableRelation properties.

No. Series

#308 · Other · via Expense Reports Nos., Posted Expense Reports Nos., Expenses Nos., Expense User Nos.

Unit of Measure

#204 · Other · via Default Mileage UOM

Expense User

#6923 · Other · via Default Approver No.