Table 272 "Check Ledger Entry"

Base Application · Microsoft.Bank.Check · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 374 “Check Ledger Entries” (1 Learn page), Page 1234 “Positive Pay Export Detail” (1).

Properties

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.

Keys

• Key1: Entry No. (clustered)
• Key2: Bank Account No., Check Date
• Key3: Bank Account No., Entry Status, Check No., Statement Status
• Key4: Bank Account Ledger Entry No.
• Key5: Bank Account No., Open
• Key6: Document No., Posting Date
• Key7: Print Gen Jnl Line SystemId

Events published

• OnAfterCopyFromBankAccLedgEntry(var CheckLedgerEntry: Record "Check Ledger Entry"; BankAccountLedgerEntry: Record "Bank Account Ledger Entry") (integration): Integration event raised after copying data from bank account ledger entry to check ledger entry. Enables additional field initialization or custom processing during check entry creation.
• OnAfterGetPayee(CheckLedgerEntry: Record "Check Ledger Entry"; var Payee: Text[100]) (integration): Integration event raised after retrieving the payee name for a check. Enables custom logic for determining or modifying the payee name based on account type and number.

Trigger event subscribers

• OnBeforeInsertEvent: Codeunit 1550 “Record Restriction Mgt.” CheckPrintRestrictionsBeforeInsertCheckLedgerEntry
• OnBeforeModifyEvent: Codeunit 1550 “Record Restriction Mgt.” CheckPrintRestrictionsBeforeModifyCheckLedgerEntry

Procedures

• GetCurrencyCodeFromBank(): Code[10]: Retrieves the currency code from the associated bank account for formatting amounts.
• CopyFromBankAccLedgEntry(BankAccLedgEntry: Record "Bank Account Ledger Entry"): Initializes check ledger entry fields from corresponding bank account ledger entry data. Sets default values for check-specific fields and status information.
• ExportCheckFile(): Exports check entries to a positive pay file format for bank fraud prevention. Uses bank account configuration to determine export method and codeunit.
• GetPayee(): Text[100]: Determines the payee name based on the balancing account type and number. Returns the appropriate name from customer, vendor, G/L account, or other account types.
• SetFilterBankAccNoOpen(BankAccNo: Code[20]): Applies filter to show only open check entries for a specific bank account. Sets optimized key for efficient querying of open entries.

Relations

• drill-down page Page 374 “Check Ledger Entries”
• lookup page Page 374 “Check Ledger Entries”
• Data Exch. Entry No.: TableRelation Table 1220 “Data Exch.”
• Data Exch. Voided Entry No.: TableRelation Table 1220 “Data Exch.”
• Bal. Account No.: TableRelation Table 15 “G/L Account” (conditional)
• Bal. Account No.: TableRelation Table 18 “Customer” (conditional)
• Bal. Account No.: TableRelation Table 23 “Vendor” (conditional)
• Bal. Account No.: TableRelation Table 270 “Bank Account” (conditional)
• Bank Account No.: TableRelation Table 270 “Bank Account”
• Bank Account Ledger Entry No.: TableRelation Table 271 “Bank Account Ledger Entry”
• Statement Line No.: TableRelation Table 274 “Bank Acc. Reconciliation Line”
• Statement No.: TableRelation Table 274 “Bank Acc. Reconciliation Line”

Referenced by

2 fields in 2 objects relate to this table (TableRelation or CalcFormula).

• Table 270 “Bank Account”: Total on Checks
• Table 271 “Bank Account Ledger Entry”: Check Ledger Entries

Pages and codeunits on this table

• Page 1234 “Positive Pay Export Detail” (source table)
• Page 374 “Check Ledger Entries” (source table)
• Page 382 “Apply Check Ledger Entries” (source table)
• Codeunit 1700 “Exp. Launcher Pos. Pay” (codeunit runs on it)
• Codeunit 1701 “Exp. Validation Pos. Pay” (codeunit runs on it)

Extended by

• Table extension 6797 “WHT Check Ledg. Entry Ext”

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 1700 “Exp. Launcher Pos. Pay” (1 call: ExportCheckFile → (object))

Countries that replace it

AU, CA, ES, MX, NZ, RU, US

Deprecations

• field Record ID to Print: Removed 27.0 (#if not CLEANSCHEMA27), “Replaced by Print Gen Jnl Line SystemId field”

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: "Check Ledger Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.