Expense User #6923

Other table in Microsoft Dynamics 365 Business Central. 23 fields, 0 records in Cronus demo.

The Expense User table (ID 6923) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 23 fields, with a primary key of No., and includes 5 calculated FlowFields. Use the reference below to explore every field, data type, and table relation.

23
Fields
0
Records
1
Primary key
5
FlowFields
6
Relations
Open in Data Explorer →

Primary key

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

All fields (23)

Expense User — FIELDS
NO.FIELDTYPECLASSRELATION
1 No. PK Code Normal
2 Employee No. Code Normal → Employee #5200
3 Name Text Normal
4 E-mail Text Normal
5 Job Title Text Normal
9 Expense Team Code Code Normal → Expense Team #6931
10 Team Manager Boolean Normal
15 Entra Id GUID Normal
20 Can Approve Boolean Normal
21 User Id For Approvals Code Normal → User Setup #91
22 Employee Status ⚡ FLOW Option FlowField
23 Approver No. ⚡ FLOW Code FlowField
24 Approver ⚡ FLOW Text FlowField
30 Is a user in Business Central ⚡ FLOW Boolean FlowField
40 Resource No. ⚡ FLOW Code FlowField
53 No. Series Code Normal → No. Series #308
54 Welcome Email Sent Boolean Normal
55 Welcome Email Sent At DateTime 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 (5)

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

Employee
#5200 · Human Resources · via Employee No.
Expense Team
#6931 · Other · via Expense Team Code
User Setup
#91 · Other · via User Id For Approvals
No. Series
#308 · Other · via No. Series