Table 276 "Bank Account Statement Line"

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

Properties

Property	Value
Caption	Bank Account Statement Line
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	Bank Account No.	Code[20]	—	TableRelation Table 270 “Bank Account” (Bank Account)
2	Statement No.	Code[20]	—	TableRelation Table 275 “Bank Account Statement” (“Bank Account Statement”.“Statement No.” where(“Bank Account No.” = field(“Bank Account No.”)))
3	Statement Line No.	Integer	—
4	Document No. Δ BC28	Code[20]	Specifies the document number of this line.
5	Transaction Date Δ BC28	Date	Specifies the posting date of the bank account or check ledger entry that the transaction on this line has been applied to.
6	Description Δ BC28	Text[100]	Specifies a description for the transaction on this line.
7	Statement Amount Δ BC28	Decimal	Specifies the amount of the transaction on the bank’s statement on this line.
8	Difference Δ BC28	Decimal	Specifies the difference between the amount in the Statement Amount field and Applied Amount field on this line.
9	Applied Amount Δ BC28	Decimal	Specifies the amount on the bank account or check ledger entry that the transaction on this line has been applied to.	not editable
10	Type Δ BC28	Enum “Bank Acc. Statement Line Type”	Specifies the type of ledger entry, or a difference that has been reconciled with the transaction on the bank’s statement on this line.	enum Enum 1249 “Bank Acc. Statement Line Type”
11	Applied Entries Δ BC28	Integer	Specifies whether the transaction on this line has been applied to one or more ledger entries.	not editable
12	Value Date Δ BC28	Date	Specifies the value date of the transaction on this line.
14	Check No. Δ BC28	Code[20]	Specifies the check number for the transaction on this line.
70	Transaction ID	Text[50]	—

Keys

Key1: Bank Account No., Statement No., Statement Line No. (clustered)

Events published

OnAfterDisplayApplication(var BankAccountStatementLine: Record "Bank Account Statement Line") (integration): Integration event raised after displaying applied entries for a bank account statement line.
OnDisplayApplicationOnAfterBankAccLedgEntrySetFilters(var BankAccountStatementLine: Record "Bank Account Statement Line"; var BankAccLedgEntry: Record "Bank Account Ledger Entry") (integration): Integration event raised after setting filters on bank account ledger entries during application display.
OnDisplayApplicationOnAfterCheckLedgEntrySetFilters(var BankAccountStatementLine: Record "Bank Account Statement Line"; var CheckLedgEntry: Record "Check Ledger Entry") (integration): Integration event raised after setting filters on check ledger entries during application display.

Procedures

DisplayApplication(): Displays the entries that have been applied to this statement line. Shows either bank account ledger entries or check ledger entries based on the Type field.
GetCurrencyCode(): Code[10]: Gets the currency code for the bank account.
FilterManyToOneMatches(var BankAccRecMatchBuffer: Record "Bank Acc. Rec. Match Buffer"): Filters the match buffer to show many-to-one matches for this statement line.

Triggers

OnRename

Relations

Bank Account No.: TableRelation Table 270 “Bank Account”
Statement No.: TableRelation Table 275 “Bank Account Statement”

Pages and codeunits on this table

Page 384 “Bank Account Statement Lines” (source table)

Ask your agent

Procedure bodies are not stored here (D10). 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: "Bank Account Statement Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.