--- id: object/table/6922 type: object title: Table 6922 "Expense Report Line VAT Spec." summary: Table 6922 "Expense Report Line VAT Spec." in ExpenseAgent (Microsoft.ExpenseAgent). 34 fields, 4 public procedures. Introduced in BC29, still in BC30. tier: official language: en tags: - table - expenseagent versions: introduced: "29" last_changed: null deprecated: null review: state: derived by: null at: null flags: [] generated: at: "2026-10-11T00:31:51.816Z" pipeline: 0.2.0 prompts: {} input_hash: 0c90f017d427815212e6b743ca68ac58dde6bead923d8a53ea71e4b51ffdba58 evidence: - kind: code url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/ExpenseAgent/app/src/ExpenseReport/Tables/ExpenseReportLineVATSpec.Table.al title: src/Apps/W1/ExpenseAgent/app/src/ExpenseReport/Tables/ExpenseReportLineVATSpec.Table.al (releases/29.x) date: null commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220 t: null quote: null links: learn: [] objects: [] features: [] topics: [] localizations: [] videos: [] posts: [] guidelines: [] changes: - change/bcapps/10312 - change/bcapps/9859 object_type: table object_id: 6922 name: Expense Report Line VAT Spec. caption: Expense Report Line VAT Specification namespace: Microsoft.ExpenseAgent app: ExpenseAgent extends: null first_version: "29" last_version: "30" present_in: - "29" - "30" changed_in: [] source_major: "29" obsolete: null countries: [] ms_search_form_ids: [] counts: fields: 34 procedures: 12 events: 0 subscribers: 0 relations: out: 7 referenced_by: 2 pages: 3 extended_by: 0 event_subscribers: 0 calls: 0 called_by: 0 implements: 0 --- # Table 6922 "Expense Report Line VAT Spec." > Table 6922 "Expense Report Line VAT Spec." in ExpenseAgent (Microsoft.ExpenseAgent). 34 fields, 4 public procedures. Introduced in BC29, still in BC30. ExpenseAgent · Microsoft.ExpenseAgent · captioned "Expense Report Line VAT Specification" · BC29-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/ExpenseAgent/app/src/ExpenseReport/Tables/ExpenseReportLineVATSpec.Table.al) · 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"](../table/6906.md) ("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"](../table/323.md) (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"](../table/324.md) (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"](../table/6921.md) ("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"](../table/6929.md) ("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"](../enum/6921.md) | | 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"](../enum/6988.md); 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."](../page/7081.md) - lookup page [Page 7081 "Expense Report Line VAT Spec."](../page/7081.md) - VAT Bus. Posting Group: TableRelation [Table 323 "VAT Business Posting Group"](../table/323.md) - VAT Prod. Posting Group: TableRelation [Table 324 "VAT Product Posting Group"](../table/324.md) - Document No.: TableRelation [Table 6906 "Expense Report Header"](../table/6906.md) - Expense Category: TableRelation [Table 6921 "Expense Category"](../table/6921.md) - Expense Subcategory: TableRelation [Table 6929 "Expense Subcategory"](../table/6929.md) ## Referenced by 2 fields in 1 objects relate to this table (TableRelation or CalcFormula). - [Table 6906 "Expense Report Header"](../table/6906.md): Approved Reclaim VAT (LCY), Has VAT Specification ## Pages and codeunits on this table - [Page 7081 "Expense Report Line VAT Spec."](../page/7081.md) (source table) - [Page 7086 "Expense Report Line VATFactBox"](../page/7086.md) (source table) - [Page 7096 "Expense Report VAT Spec."](../page/7096.md) (source table) ## Recent changes - 2026-08-31 [#10312 Update expense VAT specification source](../../changes/bcapps/10312.md) (main, BC30, feature) - 2026-08-04 [#9859 [Master] - Move Expense Agent (Preview) app into BCApps](../../changes/bcapps/9859.md) (main, BC30, feature, added) ## Across versions - Present in: BC29-30 - Changed (declaration) in: none ## 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.