---
id: object/table/1251
type: object
title: Table 1251 "Text-to-Account Mapping"
summary: Table 1251 "Text-to-Account Mapping" in Base Application (Microsoft.Bank.Reconciliation). 7 fields, 8 public procedures, 1 events. Present since at least BC23, still in BC30, changed in BC24, BC27-28.
tier: official
language: en
tags:
  - table
  - base application
versions:
  introduced: null
  last_changed: "28"
  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: a62d36da76ad029372ac7a9279b1be28ea3a89790380d2239f5264e8e6060eb9
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Bank/Reconciliation/TexttoAccountMapping.Table.al
    title: src/Layers/W1/BaseApp/Bank/Reconciliation/TexttoAccountMapping.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: 1251
name: Text-to-Account Mapping
namespace: Microsoft.Bank.Reconciliation
app: Base Application
extends: null
first_version: "23"
last_version: "30"
present_in:
  - "23"
  - "24"
  - "25"
  - "26"
  - "27"
  - "28"
  - "29"
  - "30"
changed_in:
  - "24"
  - "27"
  - "28"
source_major: "29"
obsolete: null
countries: []
ms_search_form_ids: []
counts:
  fields: 7
  procedures: 13
  events: 1
  subscribers: 0
relations:
  out: 7
  referenced_by: 0
  pages: 2
  extended_by: 0
  event_subscribers: 0
  calls: 2
  called_by: 0
  implements: 0
---

# Table 1251 "Text-to-Account Mapping"

> Table 1251 "Text-to-Account Mapping" in Base Application (Microsoft.Bank.Reconciliation). 7 fields, 8 public procedures, 1 events. Present since at least BC23, still in BC30, changed in BC24, BC27-28.

Base Application · Microsoft.Bank.Reconciliation · BC23-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Bank/Reconciliation/TexttoAccountMapping.Table.al) · facts from BC29

## Properties

| Property | Value |
|---|---|
| Caption | Text-to-Account Mapping |
| 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 | Line No. | Integer | — |  |
| 2 | Mapping Text | Text[250] | Specifies the text on the payment that is used to map the payment to a customer, vendor, or general ledger account when you choose the Apply Automatically function in the Payment Reconciliation Journal window. | NotBlank |
| 3 | Debit Acc. No. | Code[20] | Specifies the debit account that payments with this text-to-account mapping are matched with when you choose the Apply Automatically function in the Payment Reconciliation Journal window. | TableRelation [Table 15 "G/L Account"](../table/15.md) ("G/L Account" where("Account Type" = const(Posting), Blocked = const(false), "Direct Posting" = const(true))) |
| 4 | Credit Acc. No. | Code[20] | Specifies the credit account that payments with this text-to-account mapping are applied to when you choose the Apply Automatically function in the Payment Reconciliation Journal window. | TableRelation [Table 15 "G/L Account"](../table/15.md) ("G/L Account" where("Account Type" = const(Posting), Blocked = const(false), "Direct Posting" = const(true))) |
| 5 | Bal. Source Type | Option | Specifies the type of balancing account that amounts on payments or incoming documents that have this text to account mapping are posted to. The Bank Account option is used only for incoming documents and cannot be used in payment reconciliation journals. | OptionCaption: G/L Account,Customer,Vendor,Bank Account |
| 6 | Bal. Source No. | Code[20] | Specifies the balancing account to post amounts on payments or incoming documents that have this text to account mapping. The Bank Account option in the Bal. Source Type cannot be used in payment reconciliation journals. | TableRelation [Table 15 "G/L Account"](../table/15.md), [Table 18 "Customer"](../table/18.md), [Table 23 "Vendor"](../table/23.md) (if ("Bal. Source Type" = const("G/L Account")) "G/L Account" where("Account Type" = const(Posting), Blocked = const(false)) else if ("Bal. Source Type" = const(Customer)) Customer else if ("Bal. Source Type" = const(Vendor)) Vendor else if ("Bal. Source Type" = const("Bank Account")) "Bank Account") |
| 7 | Vendor No. | Code[20] | Specifies the number of the vendor that incoming documents containing the mapping text will be created for, or that payments will be posted to. | TableRelation [Table 23 "Vendor"](../table/23.md) |

## Keys

- Key1: Line No. (clustered)
- Key2: Mapping Text, Vendor No.

## Events published

- `OnInsertRecFromBankAccReconciliationLineOnBeforeInsert(var TextToAccountMapping: Record "Text-to-Account Mapping"; BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line")` (integration)

## Procedures

- `InsertRec(GenJnlLine: Record "Gen. Journal Line")`
- `InsertRecFromBankAccReconciliationLine(BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line")`
- `GetAccountNo(Amount: Decimal): Code[20]`
- `GetPaymentDocType(var PaymentDocType: Option; ActualSourceType: Option; Amount: Decimal)`
- `GetDocTypeForPmt(var DocType: Option; PaymentDocType: Option)`
- `IsBalSourceNoEnabled(): Boolean`
- `CheckEntriesAreConsistent(): Boolean`
- `SearchEnteriesInText(var TextToAccountMapping: Record "Text-to-Account Mapping"; LineDescription: Text; VendorNo: Code[20]): Integer`

Plus 4 local procedures.

## Triggers

OnInsert, OnModify

## Relations

- Bal. Source No.: TableRelation [Table 15 "G/L Account"](../table/15.md) (conditional)
- Credit Acc. No.: TableRelation [Table 15 "G/L Account"](../table/15.md)
- Debit Acc. No.: TableRelation [Table 15 "G/L Account"](../table/15.md)
- Bal. Source No.: TableRelation [Table 18 "Customer"](../table/18.md) (conditional)
- Bal. Source No.: TableRelation [Table 23 "Vendor"](../table/23.md) (conditional)
- Vendor No.: TableRelation [Table 23 "Vendor"](../table/23.md)
- Bal. Source No.: TableRelation [Table 270 "Bank Account"](../table/270.md) (conditional)

## Pages and codeunits on this table

- [Page 1251 "Text-to-Account Mapping"](../page/1251.md) (source table)
- [Page 1254 "Text-to-Account Mapping Wksh."](../page/1254.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 1251 "Record Match Mgt."](../codeunit/1251.md) (2 calls: `InsertRec → Trim`, `InsertRecFromBankAccReconciliationLine → Trim`)
- [Page 1251 "Text-to-Account Mapping"](../page/1251.md) (2 calls: `InsertRec → (object)`, `InsertRecFromBankAccReconciliationLine → (object)`)

## Across versions

- Present in: BC23-30
- Changed (declaration) in: BC24, BC27-28

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: "Text-to-Account Mapping")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.