Table 1251 "Text-to-Account Mapping"

Base Application · Microsoft.Bank.Reconciliation · BC23-30 · source at ea08af5e · 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 Δ BC28	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. Δ BC28	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” (“G/L Account” where(“Account Type” = const(Posting), Blocked = const(false), “Direct Posting” = const(true)))
4	Credit Acc. No. Δ BC28	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” (“G/L Account” where(“Account Type” = const(Posting), Blocked = const(false), “Direct Posting” = const(true)))
5	Bal. Source Type Δ BC28	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. Δ BC28	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 18 “Customer”, Table 23 “Vendor” (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. Δ BC28	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”

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") + BC27 (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” (conditional)
Credit Acc. No.: TableRelation Table 15 “G/L Account”
Debit Acc. No.: TableRelation Table 15 “G/L Account”
Bal. Source No.: TableRelation Table 18 “Customer” (conditional)
Bal. Source No.: TableRelation Table 23 “Vendor” (conditional)
Vendor No.: TableRelation Table 23 “Vendor”
Bal. Source No.: TableRelation Table 270 “Bank Account” (conditional)

Pages and codeunits on this table

Page 1251 “Text-to-Account Mapping” (source table)
Page 1254 “Text-to-Account Mapping Wksh.” (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.” (2 calls: InsertRec → Trim, InsertRecFromBankAccReconciliationLine → Trim)
Page 1251 “Text-to-Account Mapping” (2 calls: InsertRec → (object), InsertRecFromBankAccReconciliationLine → (object))

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.