---
id: object/table/20141
type: object
title: Table 20141 "Lookup Field Sorting"
summary: Table 20141 "Lookup Field Sorting" in INTaxEngine (Microsoft.Finance.TaxEngine.Core). 6 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: 11f18f1084fbff6d6be148085105f0068b1145d609e086d55032b8400bb10f39
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/INTaxEngine/app/TaxEngine-Core/src/Lookup/Table/LookupFieldSorting.Table.al
    title: src/Apps/W1/INTaxEngine/app/TaxEngine-Core/src/Lookup/Table/LookupFieldSorting.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: 20141
name: Lookup Field Sorting
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: 6
  procedures: 0
  events: 0
  subscribers: 0
relations:
  out: 1
  referenced_by: 0
  pages: 1
  extended_by: 0
  event_subscribers: 0
  calls: 1
  called_by: 0
  implements: 0
---

# Table 20141 "Lookup Field Sorting"

> Table 20141 "Lookup Field Sorting" in INTaxEngine (Microsoft.Finance.TaxEngine.Core). 6 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/LookupFieldSorting.Table.al) · facts from BC29

## Properties

| Property | Value |
|---|---|
| Caption | Lookup Field Sorting |
| 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 Sorting ID | Guid | — | TableRelation [Table 20143 "Lookup Table Sorting"](../table/20143.md) ("Lookup Table Sorting".ID where( "Case ID" = field("Case ID"), "Script ID" = field("Script ID"))); DataClassification SystemMetadata |
| 4 | Line No. | Integer | — | DataClassification SystemMetadata |
| 5 | Table ID | Integer | — | TableRelation AllObj."Object ID" where("Object Type" = const(Table)); DataClassification SystemMetadata |
| 6 | Field ID | Integer | — | TableRelation Field."No." where(TableNo = Field("Table ID")); NotBlank; DataClassification SystemMetadata |

## Keys

- K0: Case ID, Script ID, Table Sorting ID, Line No. (clustered)

## Triggers

OnInsert, OnModify, OnDelete

## Relations

- Table Sorting ID: TableRelation [Table 20143 "Lookup Table Sorting"](../table/20143.md)

## Pages and codeunits on this table

- [Page 20141 "Lookup Field Sorting Dialog"](../page/20141.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 20134 "Script Symbol Store"](../codeunit/20134.md) (3 calls: `OnDelete → OnBeforeValidateIfUpdateIsAllowed`, `OnInsert → OnBeforeValidateIfUpdateIsAllowed`, `OnModify → OnBeforeValidateIfUpdateIsAllowed`)

## 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 Sorting")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.