Table 6922 "Expense Report Line VAT Spec."

ExpenseAgent · Microsoft.ExpenseAgent · captioned “Expense Report Line VAT Specification” · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Expense Report Line VAT Specification
Access	Internal
DataClassification	CustomerContent
LookupPageId	Expense Report Line VAT Spec.
DrillDownPageId	Expense Report Line VAT Spec.

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	Document No.	Code[20]	Specifies the document number of the associated expense report.	TableRelation Table 6906 “Expense Report Header” (“Expense Report Header”.“No.”); NotBlank
2	Document Line No.	Integer	Specifies the line number of the associated expense report line.
3	Line No.	Integer	Specifies the line number of this VAT specification.
10	VAT %	Decimal	Specifies the VAT rate.
11	VAT Base Amount	Decimal	Specifies the net amount this VAT rate applies to.
12	VAT Amount	Decimal	Specifies the VAT amount for this rate.
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
15	Currency Code	Code[10]	Specifies the currency code for the amounts in this VAT specification line. If empty, amounts are in local currency.
16	Currency Factor	Decimal	Specifies the currency factor used to convert amounts to the local currency.	not editable
20	VAT Bus. Posting Group	Code[20]	Specifies the VAT business posting group used when posting this rate.	TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group)
21	VAT Prod. Posting Group	Code[20]	Specifies the VAT product posting group used when posting this rate.	TableRelation Table 324 “VAT Product Posting Group” (VAT Product Posting Group)
24	VAT Amount (LCY)	Decimal	Specifies the VAT amount in local currency for this rate.	not editable
25	VAT Base Amount (LCY)	Decimal	Specifies the net amount in local currency this VAT rate applies to.	not editable
26	Amount (LCY)	Decimal	Specifies the total amount in local currency for this expense line.
27	Expense Category	Code[20]	Specifies the expense category associated with this VAT specification line, used to identify the type of expense for reporting and VAT reclaim purposes.	TableRelation Table 6921 “Expense Category” (“Expense Category”.Code)
28	Expense Subcategory	Code[20]	Specifies the expense subcategory associated with this VAT specification line, providing a more detailed classification within the expense category.	TableRelation Table 6929 “Expense Subcategory” (“Expense Subcategory”.Code where(“Expense Category Code” = field(“Expense Category”)))
30	Reclaimable	Boolean	Specifies whether this VAT amount is reclaimable.
31	Reclaim %	Decimal	Specifies the reclaim percentage for partial deductibility.
32	Reclaim Reason	Text[250]	Specifies a short reason supplied with the reclaim suggestion.
33	Reclaim Approved	Boolean	Specifies whether reclaim has been approved for this VAT row.	obsolete Pending 29.0; not editable
34	Reclaim Approved By	Code[50]	Specifies the user who approved the reclaim.	not editable; DataClassification EndUserIdentifiableInformation
35	Reclaim Approved At	DateTime	Specifies when the reclaim was approved.	not editable
36	Reclaim Justification	Blob	Specifies the justification for the reclaim.
37	Reclaim VAT Amount	Decimal	Specifies the reclaim amount calculated based on the reclaim percentage.	not editable
38	Reclaim VAT Amount (LCY)	Decimal	Specifies the reclaim amount in local currency calculated based on the reclaim percentage.	not editable
40	Source	Enum “Expense VAT Spec Source”	Specifies the provenance of this row (Agent / Manual / Override).	enum Enum 6921 “Expense VAT Spec Source”
41	Source Spec Line No.	Integer	—	not editable
42	Confidence	Decimal	Specifies the agent confidence (0..1) for this row.
43	Reclaim Status	Enum “Expense Reclaim Status”	Specifies whether the VAT reclaim for this row is pending, approved, or rejected.	enum Enum 6988 “Expense Reclaim Status”; not editable
50	VAT Base Amount (RCY)	Decimal	Specifies the VAT base amount in reimbursement currency for this rate.	not editable
51	VAT Amount (RCY)	Decimal	Specifies the VAT amount in reimbursement currency for this rate.	not editable
52	Amount (RCY)	Decimal	Specifies the total amount in reimbursement currency for this rate.	not editable
53	Reclaim VAT Amount (RCY)	Decimal	Specifies the reclaim VAT amount in reimbursement currency for this rate.	not editable

Keys

PK: Document No., Document Line No., Line No. (clustered)
Reclaim: Document No., Reclaimable, Reclaim Status

Procedures

UpdateReimbursementAmounts() (internal)
UpdateReimbursementAmounts(NewExpenseReportHeader: Record "Expense Report Header") (internal)
SetJustification(NewText: Text): Stores a UTF-8 reclaim justification text into the blob.
GetJustification(): Text: Reads the reclaim justification blob as text.

Plus 8 local procedures.

Relations

drill-down page Page 7081 “Expense Report Line VAT Spec.”
lookup page Page 7081 “Expense Report Line VAT Spec.”
VAT Bus. Posting Group: TableRelation Table 323 “VAT Business Posting Group”
VAT Prod. Posting Group: TableRelation Table 324 “VAT Product Posting Group”
Document No.: TableRelation Table 6906 “Expense Report Header”
Expense Category: TableRelation Table 6921 “Expense Category”
Expense Subcategory: TableRelation Table 6929 “Expense Subcategory”

Referenced by

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

Table 6906 “Expense Report Header”: Approved Reclaim VAT (LCY), Has VAT Specification

Pages and codeunits on this table

Page 7081 “Expense Report Line VAT Spec.” (source table)
Page 7086 “Expense Report Line VATFactBox” (source table)
Page 7096 “Expense Report VAT Spec.” (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)

Deprecations

field Reclaim Approved: Pending 29.0, “Use “Reclaim Status” field instead.”

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

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 Report Line VAT Spec."), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.