Table 6929 "Expense Subcategory"

ExpenseAgent · Microsoft.ExpenseAgent · BC29-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 6973 “Expense Subcategories” (1 Learn page).

Properties

Property	Value
Caption	Expense Subcategory
Access	Internal
DataClassification	CustomerContent
LookupPageId	Expense Subcategories
DrillDownPageId	Expense Subcategories

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	Expense Category Code	Code[20]	—	TableRelation Table 6921 “Expense Category” (“Expense Category”.Code); NotBlank
2	Code	Code[20]	Specifies the subcategory code.	NotBlank
3	Description	Text[250]	Specifies the description of the expense subcategory that identifies its purpose or usage.
4	Inactive	Boolean	Specifies that the expense subcategory is inactive and can’t be selected for new transactions.
5	Refundable	Boolean	Specifies whether the subcategory is refundable by default when itemization is used. This value can be changed on the expense report.
6	Expense Description Mandatory	Boolean	Specifies whether a description must be entered for expenses using this subcategory before they can be released.
15	VAT Prod. Posting Group	Code[20]	Specifies the VAT product posting group to link the expense subcategory to the correct VAT code on the expense report.	TableRelation Table 324 “VAT Product Posting Group” (“VAT Product Posting Group”.Code)
16	Default VAT %	Decimal	Specifies the default VAT percentage for the expense subcategory. This value is used to calculate the VAT amount on the expense report when the subcategory is selected, and can be changed on the expense report if needed.
17	Default VAT Reclaim %	Decimal	Specifies the default VAT reclaim percentage for the expense subcategory. This value is used to calculate the VAT reclaim amount on the expense report when the subcategory is selected, and can be changed on the expense report if needed.
20	Posting Description	Text[100]	Specifies the posting description of the expense subcategory that identifies its purpose or usage.

Keys

Key1: Expense Category Code, Code (clustered)

Procedures

1 local procedures, no public ones.

Triggers

OnInsert, OnDelete, OnRename

Relations

drill-down page Page 6973 “Expense Subcategories”
lookup page Page 6973 “Expense Subcategories”
VAT Prod. Posting Group: TableRelation Table 324 “VAT Product Posting Group”
Expense Category Code: TableRelation Table 6921 “Expense Category”

Referenced by

15 fields in 15 objects relate to this table (TableRelation or CalcFormula).

Table 6900 “Expense”: Expense Subcategory
Table 6902 “Expense Itemization”: Expense Subcategory Code
Table 6904 “Expense Participant”: Expense Subcategory Code
Table 6905 “Expense Per Diem”: Expense Subcategory Code
Table 6907 “Expense Report Line”: Expense Subcategory Code
Table 6908 “Expense Report Line Particip.”: Expense Subcategory Code
Table 6911 “Expense Report Line Item”: Expense Subcategory Code
Table 6912 “Expense Ledger Entry”: Expense Subcategory Code
Table 6916 “Posted Expense Report Line”: Expense Subcategory Code
Table 6917 “Posted Exp. Rep. Line Particip”: Expense Subcategory Code
Table 6918 “Expense VAT Specification”: Expense Subcategory
Table 6919 “Posted Exp. Rep. Line Item”: Expense Subcategory Code
Table 6922 “Expense Report Line VAT Spec.”: Expense Subcategory
Table 6934 “Posted Exp. Rep. Line VAT Spec”: Expense Subcategory
Table extension 6976 “Gen. Journal Line”: Expense Subcategory Code

Pages and codeunits on this table

Page 6925 “Expense Subcategories API” (source table)
Page 6967 “Exp. Subcategories Preview” (source table)
Page 6973 “Expense Subcategories” (source table)

Recent changes

2026-08-04 #9859 [Master] - Move Expense Agent (Preview) app into BCApps (main, BC30, feature, added)

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Expense Subcategory"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.