Expense Report Line Particip. #6908

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

The Expense Report Line Particip. table (ID 6908) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 18 fields, with a primary key of Expense Report No., Expense Report Line No., Line No.. 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: Expense Report No., Expense Report Line No., Line No..

All fields (18)

Expense Report Line Particip. — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Expense Report No. PK	Code	Normal	→ Expense Report Header #6906
2	Expense Report Line No. PK	Integer	Normal	→ Expense Report Line #6907
3	Line No. PK	Integer	Normal
5	Expense No.	Code	Normal	→ Expense #6900
6	Expense Category Code	Code	Normal	→ Expense Category #6921
7	Expense Subcategory Code	Code	Normal	→ Expense Subcategory #6929
8	Participant Type	Option	Normal
9	Participant Employee No.	Code	Normal
10	Participant Name	Text	Normal
11	Participant Organization	Text	Normal
12	Participant Country/Region	Code	Normal	→ Country/Region #9
13	Participant Title	Text	Normal
14	Participant Email	Text	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 (7)

Tables referenced by fields on the Expense Report Line Particip. table through TableRelation properties.

Expense Report Header

#6906 · Other · via Expense Report No.

Expense Report Line

#6907 · Other · via Expense Report Line No.

Expense

#6900 · Other · via Expense No.

Expense Category

#6921 · Other · via Expense Category Code

Expense Subcategory

#6929 · Other · via Expense Subcategory Code

Country/Region

#9 · General Ledger · via Participant Country/Region