Expense Rule Header #6927

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

The Expense Rule Header table (ID 6927) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 13 fields, with a primary key of Expense Category Code, Expense Location, Effective Date. 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 Category Code, Expense Location, Effective Date.

All fields (13)

Expense Rule Header — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Expense Category Code PK	Code	Normal	→ Expense Category #6921
2	Expense Location PK	Code	Normal	→ Expense Location #6925
3	Effective Date PK	Date	Normal
30	Justification Required	Option	Normal
40	Required Specific Merchant	Boolean	Normal
41	Specific Merchant Name	Text	Normal
60	Currency Code	Code	Normal	→ Currency #4
61	Unit of Measure Code	Code	Normal	→ Unit of Measure #204
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 Rule Header table through TableRelation properties.

Expense Category

#6921 · Other · via Expense Category Code

Expense Location

#6925 · Other · via Expense Location

Currency

#4 · General Ledger · via Currency Code

Unit of Measure

#204 · Other · via Unit of Measure Code