--- id: object/table/272 type: object title: Table 272 "Check Ledger Entry" summary: Table 272 "Check Ledger Entry" in Base Application (Microsoft.Bank.Check). 27 fields, 5 public procedures, 2 events. Present since at least BC23, still in BC30, changed in BC24, BC26-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: 892ddfd3f3a13534fcaab821919596afa734931b5f80bea71d4039a16bb4abf8 evidence: - kind: code url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Bank/Check/CheckLedgerEntry.Table.al title: src/Layers/W1/BaseApp/Bank/Check/CheckLedgerEntry.Table.al (releases/29.x) date: null commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220 t: null quote: null links: learn: - https://learn.microsoft.com/dynamics365/business-central/finance-how-define-check-layouts - https://learn.microsoft.com/dynamics365/business-central/finance-how-positive-pay objects: [] features: [] topics: - topic/business-central/business-functionality/finance/manage-payables/make-payments - topic/business-central/business-functionality/set-up-business-central/set-up-banking localizations: - localization/au - localization/ca - localization/es - localization/mx - localization/nz - localization/ru - localization/us videos: [] posts: [] guidelines: [] object_type: table object_id: 272 name: Check Ledger Entry namespace: Microsoft.Bank.Check app: Base Application extends: null first_version: "23" last_version: "30" present_in: - "23" - "24" - "25" - "26" - "27" - "28" - "29" - "30" changed_in: - "24" - "26" - "27" - "28" source_major: "29" obsolete: null countries: - au - ca - es - mx - nz - ru - us ms_search_form_ids: [] counts: fields: 27 procedures: 7 events: 2 subscribers: 0 relations: out: 12 referenced_by: 2 pages: 3 extended_by: 1 event_subscribers: 2 calls: 1 called_by: 0 implements: 0 --- # Table 272 "Check Ledger Entry" > Table 272 "Check Ledger Entry" in Base Application (Microsoft.Bank.Check). 27 fields, 5 public procedures, 2 events. Present since at least BC23, still in BC30, changed in BC24, BC26-28. Base Application · Microsoft.Bank.Check · BC23-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Bank/Check/CheckLedgerEntry.Table.al) · facts from BC29 Learn documents this table through its pages: [Page 374 "Check Ledger Entries"](../page/374.md) (1 Learn page), [Page 1234 "Positive Pay Export Detail"](../page/1234.md) (1). ## Properties | Property | Value | |---|---| | Caption | Check Ledger Entry | | 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 | Entry No. | Integer | Specifies the number of the entry, as assigned from the specified number series when the entry was created. | | | 2 | Bank Account No. | Code[20] | Specifies the number of the bank account used for the check ledger entry. | TableRelation [Table 270 "Bank Account"](../table/270.md) (Bank Account) | | 3 | Bank Account Ledger Entry No. | Integer | Specifies the entry number of the bank account ledger entry from which the check ledger entry was created. | TableRelation [Table 271 "Bank Account Ledger Entry"](../table/271.md) (Bank Account Ledger Entry) | | 4 | Posting Date | Date | Specifies the posting date of the check ledger entry. | | | 5 | Document Type | Enum "Gen. Journal Document Type" | Specifies the document type linked to the check ledger entry. For example, Payment. | enum [Enum 6 "Gen. Journal Document Type"](../enum/6.md) | | 6 | Document No. | Code[20] | Specifies the document number on the check ledger entry. | | | 7 | Description | Text[100] | Specifies a printing description for the check ledger entry. | | | 8 | Amount | Decimal | Specifies the amount on the check ledger entry. | | | 9 | Check Date | Date | Specifies the check date if a check is printed. | | | 10 | Check No. | Code[20] | Specifies the check number if a check is printed. | | | 11 | Check Type | Option | Specifies the type check, such as Manual. | OptionCaption: Total Check,Partial Check | | 12 | Bank Payment Type | Enum "Bank Payment Type" | Specifies the code for the payment type to be used for the entry on the journal line. | enum [Enum 272 "Bank Payment Type"](../enum/272.md) | | 13 | Entry Status | Option | Specifies the printing (and posting) status of the check ledger entry. | OptionCaption: ,Printed,Voided,Posted,Financially Voided,Test Print,Exported,Transmitted | | 14 | Original Entry Status | Option | Specifies the status of the entry before you changed it. | OptionCaption: ,Printed,Voided,Posted,Financially Voided | | 15 | Bal. Account Type | Enum "Gen. Journal Account Type" | Specifies the type of account that a balancing entry is posted to, such as BANK for a cash account. | enum [Enum 81 "Gen. Journal Account Type"](../enum/81.md) | | 16 | Bal. Account No. | Code[20] | Specifies the number of the general ledger, customer, vendor, or bank account that the balancing entry is posted to, such as a cash account for cash purchases. | TableRelation [Table 15 "G/L Account"](../table/15.md), [Table 18 "Customer"](../table/18.md), [Table 23 "Vendor"](../table/23.md) (if ("Bal. Account Type" = const("G/L Account")) "G/L Account" else if ("Bal. Account Type" = const(Customer)) Customer else if ("Bal. Account Type" = const(Vendor)) Vendor else if ("Bal. Account Type" = const("Bank Account")) "Bank Account" else if ("Bal. Account Type" = const("Fixed Asset")) "Fixed...) | | 17 | Open | Boolean | Specifies whether the entry has been fully applied to. | | | 18 | Statement Status | Option | Specifies that the structure of the lines is based on the chart of cost types. You define up to seven cost centers and cost objects that appear as columns in the report. | OptionCaption: Open,Bank Acc. Entry Applied,Check Entry Applied,Closed | | 19 | Statement No. | Code[20] | Specifies the bank account statement that the check ledger entry has been applied to, if the Statement Status is Bank Account Ledger Applied or Check Ledger Applied. | TableRelation [Table 274 "Bank Acc. Reconciliation Line"](../table/274.md) ("Bank Acc. Reconciliation Line"."Statement No." where("Bank Account No." = field("Bank Account No."))) | | 20 | Statement Line No. | Integer | Specifies the statement line that the check ledger entry has been applied to, if the Statement Status is Bank Account Ledger Applied or Check Ledger Applied. | TableRelation [Table 274 "Bank Acc. Reconciliation Line"](../table/274.md) ("Bank Acc. Reconciliation Line"."Statement Line No." where("Bank Account No." = field("Bank Account No."), "Statement No." = field("Statement No."))) | | 21 | User ID | Code[50] | Specifies the ID of the user who posted the entry, to be used, for example, in the change log. | TableRelation User."User Name"; DataClassification EndUserIdentifiableInformation | | 22 | External Document No. | Code[35] | Specifies a document number that refers to the customer's or vendor's numbering system. | | | 23 | Data Exch. Entry No. | Integer | — | TableRelation [Table 1220 "Data Exch."](../table/1220.md) (Data Exch.); not editable | | 24 | Data Exch. Voided Entry No. | Integer | — | TableRelation [Table 1220 "Data Exch."](../table/1220.md) (Data Exch.); not editable | | 25 | Positive Pay Exported | Boolean | — | | | 26 | Record ID to Print | RecordId | — | obsolete Removed 27.0; #if not CLEANSCHEMA27; DataClassification SystemMetadata | | 27 | Print Gen Jnl Line SystemId | Guid | SystemId to Print caption | DataClassification SystemMetadata | ## 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."](../codeunit/1550.md) CheckPrintRestrictionsBeforeInsertCheckLedgerEntry - OnBeforeModifyEvent: [Codeunit 1550 "Record Restriction Mgt."](../codeunit/1550.md) 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"](../page/374.md) - lookup page [Page 374 "Check Ledger Entries"](../page/374.md) - Data Exch. Entry No.: TableRelation [Table 1220 "Data Exch."](../table/1220.md) - Data Exch. Voided Entry No.: TableRelation [Table 1220 "Data Exch."](../table/1220.md) - Bal. Account No.: TableRelation [Table 15 "G/L Account"](../table/15.md) (conditional) - Bal. Account No.: TableRelation [Table 18 "Customer"](../table/18.md) (conditional) - Bal. Account No.: TableRelation [Table 23 "Vendor"](../table/23.md) (conditional) - Bal. Account No.: TableRelation [Table 270 "Bank Account"](../table/270.md) (conditional) - Bank Account No.: TableRelation [Table 270 "Bank Account"](../table/270.md) - Bank Account Ledger Entry No.: TableRelation [Table 271 "Bank Account Ledger Entry"](../table/271.md) - Statement Line No.: TableRelation [Table 274 "Bank Acc. Reconciliation Line"](../table/274.md) - Statement No.: TableRelation [Table 274 "Bank Acc. Reconciliation Line"](../table/274.md) ## Referenced by 2 fields in 2 objects relate to this table (TableRelation or CalcFormula). - [Table 270 "Bank Account"](../table/270.md): Total on Checks - [Table 271 "Bank Account Ledger Entry"](../table/271.md): Check Ledger Entries ## Pages and codeunits on this table - [Page 1234 "Positive Pay Export Detail"](../page/1234.md) (source table) - [Page 374 "Check Ledger Entries"](../page/374.md) (source table) - [Page 382 "Apply Check Ledger Entries"](../page/382.md) (source table) - [Codeunit 1700 "Exp. Launcher Pos. Pay"](../codeunit/1700.md) (codeunit runs on it) - [Codeunit 1701 "Exp. Validation Pos. Pay"](../codeunit/1701.md) (codeunit runs on it) ## Extended by - [Table extension 6797 "WHT Check Ledg. Entry Ext"](../tableextension/6797.md) ## 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"](../codeunit/1700.md) (1 call: `ExportCheckFile → (object)`) ## Across versions - Present in: BC23-30 - Changed (declaration) in: BC24, BC26-28 ## Countries that replace it [AU](../../localizations/au.md), [CA](../../localizations/ca.md), [ES](../../localizations/es.md), [MX](../../localizations/mx.md), [NZ](../../localizations/nz.md), [RU](../../localizations/ru.md), [US](../../localizations/us.md) ## 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.