Expense Per Diem #6905

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

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

All fields (20)

Expense Per Diem — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Expense No. PK	Code	Normal	→ Expense #6900
2	Line No. PK	Integer	Normal
4	Expense Category Code	Code	Normal	→ Expense Category #6921
5	Expense Subcategory Code	Code	Normal	→ Expense Subcategory #6929
6	Expense Location	Code	Normal	→ Expense Location #6925
7	Description	Text	Normal
8	Date	Date	Normal
9	Breakfast	Boolean	Normal
10	Lunch	Boolean	Normal
11	Dinner	Boolean	Normal
12	Per Diem Amount	Decimal	Normal
13	Original Per Diem Amount	Decimal	Normal
14	Breakfast Reduction Percent	Decimal	Normal
15	Lunch Reduction Percent	Decimal	Normal
16	Dinner Reduction Percent	Decimal	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 Per Diem table through TableRelation properties.

Expense

#6900 · Other · via Expense No.

Expense Category

#6921 · Other · via Expense Category Code

Expense Subcategory

#6929 · Other · via Expense Subcategory Code

Expense Location

#6925 · Other · via Expense Location