Expense Itemization #6902

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

The Expense Itemization table (ID 6902) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 15 fields, with a primary key of Expense No., Line No.. Use the reference below to explore every field, data type, and table relation.

15
Fields
0
Records
2
Primary key
0
FlowFields
5
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 (15)

Expense Itemization — FIELDS
NO.FIELDTYPECLASSRELATION
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 Description Text Normal
7 Start Date Date Normal
8 Quantity Decimal Normal
9 Daily Rate Decimal Normal
10 Amount Decimal Normal
11 Refundable Boolean 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 Itemization 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