Table 6918 "Expense VAT Specification"

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

Properties

Property	Value
Caption	Expense VAT Specification
Access	Internal
DataClassification	CustomerContent
LookupPageId	Expense VAT Specification
DrillDownPageId	Expense VAT Specification

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 No.	Code[20]	Specifies the number of the expense this VAT specification line belongs to.	TableRelation Expense.“No.”; NotBlank
2	Line No.	Integer	Specifies the line number of the VAT specification entry within the expense.	AutoIncrement
10	VAT %	Decimal	Specifies the VAT percentage applied to this expense line. Changing this value recalculates the VAT amount and VAT base amount.
11	VAT Base Amount	Decimal	Specifies the amount that the VAT percentage is calculated from, i.e. the total amount excluding VAT.
12	VAT Amount	Decimal	Specifies the VAT amount calculated for this expense line based on the VAT percentage and base amount.
13	Amount	Decimal	Specifies the total amount (including VAT) that the expense line consists of.
14	VAT Difference	Decimal	Specifies the difference between the calculated VAT amount and a VAT amount that you have entered manually.	not editable
20	VAT Bus. Posting Group	Code[20]	Specifies the VAT business posting group that determines the VAT rate and VAT calculation method used for this expense line.	TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group)
21	VAT Prod. Posting Group	Code[20]	Specifies the VAT product posting group that determines the VAT rate and VAT calculation method used for this expense line.	TableRelation Table 324 “VAT Product Posting Group” (VAT Product Posting Group)
24	VAT Amount (LCY)	Decimal	Specifies the VAT amount converted to local currency for accounting and VAT reporting purposes.	not editable
25	VAT Base Amount (LCY)	Decimal	Specifies the VAT base amount converted to local currency for accounting and VAT reporting purposes.	not editable
26	Amount (LCY)	Decimal	Specifies the total expense amount (including VAT) converted to local currency using the applicable exchange rate.
27	Expense Category	Code[20]	Specifies the expense category for this VAT specification line. When set, the default VAT posting group and VAT percentage are copied from the category unless a subcategory is also specified.	TableRelation Table 6921 “Expense Category” (“Expense Category”.Code)
28	Expense Subcategory	Code[20]	Specifies the expense subcategory for this VAT specification line. When set, the VAT posting group and VAT percentage are copied from the subcategory, overriding any values from the expense category.	TableRelation Table 6929 “Expense Subcategory” (“Expense Subcategory”.Code where(“Expense Category Code” = field(“Expense Category”)))
40	Source	Enum “Expense VAT Spec Source”	Specifies how this VAT specification line was created, for example whether it was entered manually or extracted automatically from a receipt.	enum Enum 6921 “Expense VAT Spec Source”; not editable; DataClassification SystemMetadata
41	Confidence	Decimal	Specifies the confidence score (0–1) of the automatically extracted VAT data, indicating how certain the AI is about the captured values.
42	Reasoning	Blob	Specifies the AI reasoning text that explains how the VAT specification values were determined from the receipt or invoice.

Keys

PK: Expense No., Line No. (clustered)

Procedures

InitializeCurrency() (protected): Initializes the Currency record from the parent Expense for rounding calculations.
GetCurrencyCode(): Code[20] (protected)
GetExpense() (protected)
SetReasoning(NewReasoning: Text): Stores a UTF-8 reasoning string into the Reasoning blob.
GetReasoning(): Text: Reads the Reasoning blob as a UTF-8 string.

Plus 3 local procedures.

Triggers

OnInsert, OnModify, OnDelete

Relations

drill-down page Page 7084 “Expense VAT Specification”
lookup page Page 7084 “Expense VAT Specification”
VAT Bus. Posting Group: TableRelation Table 323 “VAT Business Posting Group”
VAT Prod. Posting Group: TableRelation Table 324 “VAT Product Posting Group”
Expense Category: TableRelation Table 6921 “Expense Category”
Expense Subcategory: TableRelation Table 6929 “Expense Subcategory”

Pages and codeunits on this table

Page 7080 “Expense VAT Spec. FactBox” (source table)
Page 7084 “Expense VAT Specification” (source table)
Page 7085 “Expense VAT Spec. API” (source table)

Recent changes

2026-08-31 #10312 Update expense VAT specification source (main, BC30, feature)
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 VAT Specification"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.