Table 6934 "Posted Exp. Rep. Line VAT Spec"

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

Properties

Property	Value
Caption	Posted Expense Report Line VAT Specification
Access	Internal
DataClassification	CustomerContent

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 Report No.	Code[20]	Specifies the unique identifier of the posted expense report this VAT specification line belongs to.	TableRelation Table 6915 “Posted Expense Report Header” (“Posted Expense Report Header”.“No.”); NotBlank
2	Expense Report Line No.	Integer	Specifies the line number of the posted expense report line this VAT specification line belongs to. A value of 0 indicates that this is a report-level aggregate line representing totals for the entire report.
3	Line No.	Integer	Specifies the line number of this VAT specification line. This is used to uniquely identify multiple VAT specifications for the same expense report line when there are multiple VAT rates or product posting groups involved.
10	VAT %	Decimal	Specifies the VAT percentage rate applied to this expense line for this VAT specification. This is used to calculate the VAT amount based on the VAT base amount.
11	VAT Base Amount	Decimal	Specifies the VAT base amount for this expense line and VAT specification. This is the amount on which the VAT percentage is applied to calculate the VAT amount.
12	VAT Amount	Decimal	Specifies the VAT amount for this expense line and VAT specification, calculated by applying the VAT percentage to the VAT base amount.
13	Amount	Decimal	Specifies the total amount (including VAT) that the expense line consists of.
14	VAT Difference	Decimal	Specifies the difference in VAT amount calculated at the time of posting compared to the VAT amount calculated at the time of expense report approval. This can occur due to changes in exchange rates or VAT rates between approval and posting.	not editable
15	Currency Code	Code[10]	Specifies the currency code of the amounts in this VAT specification line, based on ISO 4217 standard. This is used for proper formatting and calculations of the amounts.
16	Currency Factor	Decimal	Specifies the currency factor used to convert amounts from the original transaction currency to the reporting currency (usually the company’s local currency) at the time of posting. This is used to calculate the amounts in local currency for reporting and VAT reclaim purposes.	not editable
20	VAT Bus. Posting Group	Code[20]	Specifies the VAT business posting group associated with this VAT specification line, used to determine the VAT rules and rates applicable for this transaction based on the type of business activity.	TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group)
21	VAT Prod. Posting Group	Code[20]	Specifies the VAT product posting group associated with this VAT specification line, used to determine the VAT rules and rates applicable for this transaction based on the type of product or service.	TableRelation Table 324 “VAT Product Posting Group” (VAT Product Posting Group)
24	VAT Amount (LCY)	Decimal	Specifies the VAT amount converted to local currency (LCY) using the currency factor at the time of posting. This is used for reporting and VAT reclaim purposes in the company’s local currency.	not editable
25	VAT Base Amount (LCY)	Decimal	Specifies the VAT base amount converted to local currency (LCY) using the currency factor at the time of posting. This is used for reporting and VAT reclaim purposes in the company’s local currency.	not editable
26	Amount (LCY)	Decimal	Specifies the total amount (including VAT) converted to local currency (LCY) using the currency factor at the time of posting. This is used for reporting and VAT reclaim purposes in the company’s local currency.	not editable
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 the VAT amount for this line is reclaimable.
31	Reclaim %	Decimal	Specifies the percentage of the VAT amount that is reclaimable. This is used to calculate the reclaimable VAT amount for this line.
32	Reclaim Reason	Text[250]	Specifies the reason why the VAT is reclaimable or not reclaimable for this line. This can be used for internal documentation and audit purposes when processing VAT reclaims.
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 ID of the person who approved the reclaim of the VAT amount for this line. This is used for audit purposes to track who approved the reclaim.	not editable; DataClassification EndUserIdentifiableInformation
35	Reclaim Approved At	DateTime	Specifies the date and time when the reclaim of the VAT amount for this line was approved. This is used for audit purposes to track when the reclaim was approved.	not editable
36	Reclaim Justification	Blob	Specifies the justification text for the reclaim of the VAT amount for this line, stored as a UTF-8 encoded blob. This allows for longer text than a standard string field and can include detailed explanations or notes regarding 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 source of this VAT specification line, indicating how it was generated (e.g., from the original expense report line, from a correction, etc.). This can be used for tracking and reporting purposes to understand the origin of each VAT specification line.	enum Enum 6921 “Expense VAT Spec Source”
41	Source Spec Line No.	Integer	Specifies the line number of the source VAT specification line that this line was generated from, if applicable. This is used to trace back the origin of this VAT specification line to the original specification line it was based on, which can be helpful for auditing and troubleshooting purposes.	not editable
42	Confidence	Decimal	Specifies the confidence level of the VAT specification line, represented as a decimal value between 0 and 1. This can be used to indicate the reliability or accuracy of the VAT specification, especially in cases where it is generated based on machine learning predictions or incomplete data.
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: Expense Report No., Expense Report Line No., Line No. (clustered)
Secondary: VAT Bus. Posting Group, VAT Prod. Posting Group

Procedures

SetJustification(NewText: Text): Stores a UTF-8 reclaim justification text into the blob.
GetJustification(): Text: Reads the reclaim justification blob as text.

Plus 1 local procedures.

Relations

VAT Bus. Posting Group: TableRelation Table 323 “VAT Business Posting Group”
VAT Prod. Posting Group: TableRelation Table 324 “VAT Product Posting Group”
Expense Report No.: TableRelation Table 6915 “Posted Expense Report Header”
Expense Category: TableRelation Table 6921 “Expense Category”
Expense Subcategory: TableRelation Table 6929 “Expense Subcategory”

Referenced by

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

Table 6915 “Posted Expense Report Header”: Approved Reclaim VAT (LCY)

Pages and codeunits on this table

Page 7083 “Posted Exp.Rep.Line VAT Spec” (source table)
Page 7093 “Posted 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: "Posted Exp. Rep. Line VAT Spec"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.