---
id: object/table/20140
type: object
title: Table 20140 "Lookup Field Filter"
summary: Table 20140 "Lookup Field Filter" in INTaxEngine (Microsoft.Finance.TaxEngine.Core). 9 fields. Introduced in BC29, still in BC30.
tier: official
language: en
tags:
  - table
  - intaxengine
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: 34a0345ac93cf75b096a4e0441bc87491838c79696f4139572b8fbc9ee8b1270
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/INTaxEngine/app/TaxEngine-Core/src/Lookup/Table/LookupFieldFilter.Table.al
    title: src/Apps/W1/INTaxEngine/app/TaxEngine-Core/src/Lookup/Table/LookupFieldFilter.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
object_type: table
object_id: 20140
name: Lookup Field Filter
namespace: Microsoft.Finance.TaxEngine.Core
app: INTaxEngine
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: 9
  procedures: 2
  events: 0
  subscribers: 0
relations:
  out: 2
  referenced_by: 0
  pages: 1
  extended_by: 0
  event_subscribers: 0
  calls: 4
  called_by: 0
  implements: 0
---

# Table 20140 "Lookup Field Filter"

> Table 20140 "Lookup Field Filter" in INTaxEngine (Microsoft.Finance.TaxEngine.Core). 9 fields. Introduced in BC29, still in BC30.

INTaxEngine · Microsoft.Finance.TaxEngine.Core · BC29-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/INTaxEngine/app/TaxEngine-Core/src/Lookup/Table/LookupFieldFilter.Table.al) · facts from BC29

## Properties

| Property | Value |
|---|---|
| Caption | Lookup Field Filter |
| Access | Public |
| Extensible | false |
| 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 | Case ID | Guid | — | DataClassification SystemMetadata |
| 2 | Script ID | Guid | — | DataClassification SystemMetadata |
| 3 | Table Filter ID | Guid | — | TableRelation [Table 20142 "Lookup Table Filter"](../table/20142.md) ("Lookup Table Filter".ID where("Case ID" = field("Case ID"))); DataClassification SystemMetadata |
| 4 | Field ID | Integer | — | TableRelation Field."No." where(TableNo = field("Table ID")); NotBlank; DataClassification SystemMetadata |
| 5 | Table ID | Integer | — | TableRelation AllObj."Object ID" where("Object Type" = const(Table)); DataClassification SystemMetadata |
| 6 | Filter Type | Enum "Conditional Operator" | Specifies the type of filter which will be applied on the field. <small>via [Page 20140 "Lookup Field Filter Dialog"](../page/20140.md)</small> | enum [Enum 20140 "Conditional Operator"](../enum/20140.md) |
| 7 | Value Type | Option | — | DataClassification SystemMetadata |
| 8 | Value | Text[250] | Value Text <small>caption</small> | DataClassification SystemMetadata |
| 9 | Lookup ID | Guid | — | TableRelation [Table 20144 "Script Symbol Lookup"](../table/20144.md) ("Script Symbol Lookup".ID); DataClassification SystemMetadata |

## Keys

- K0: Case ID, Script ID, Table Filter ID, Field ID (clustered)

## Procedures

2 local procedures, no public ones.

## Triggers

OnInsert, OnModify, OnDelete

## Relations

- Table Filter ID: TableRelation [Table 20142 "Lookup Table Filter"](../table/20142.md)
- Lookup ID: TableRelation [Table 20144 "Script Symbol Lookup"](../table/20144.md)

## Pages and codeunits on this table

- [Page 20140 "Lookup Field Filter Dialog"](../page/20140.md) (source table)

## Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an `Object::"Name"` argument. Interface dispatch and calls through events are not counted, so the list is not complete.

- [Codeunit 20132 "Script Data Type Mgmt."](../codeunit/20132.md) (5 calls: `ValidateDataType → GetFieldDatatype`, `ValidateValue → GetFieldDatatype`, `ValidateValue → GetFieldOptionString`, …)
- [Codeunit 20134 "Script Symbol Store"](../codeunit/20134.md) (3 calls: `OnDelete → OnBeforeValidateIfUpdateIsAllowed`, `OnInsert → OnBeforeValidateIfUpdateIsAllowed`, `OnModify → OnBeforeValidateIfUpdateIsAllowed`)
- [Codeunit 10 "Type Helper"](../codeunit/10.md) (2 calls: `ValidateValue → GetOptionNo`, `ValidateValue → IsNumeric`)
- [Codeunit 20141 "Lookup Entity Mgmt."](../codeunit/20141.md) (1 call: `OnDelete → DeleteLookup`)

## Across versions

- Present in: BC29-30
- Changed (declaration) in: none

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). The call sections above are our own, per object, from the BC29 call graph. 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: "Lookup Field Filter")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.