Table 275 "Bank Account Statement"
Base Application · Microsoft.Bank.Statement
Across versions
- BC23present
- BC24declaration changed
- BC25-27unchanged
- BC286 fields changed
- BC29-30unchanged
Neighbourhood 11 connected objects and pages
Base Application · Microsoft.Bank.Statement · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 389 “Bank Account Statement List” (2 Learn pages).
Properties
| Property | Value |
|---|---|
| Caption | Bank Account Statement |
| 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. Δ BC28 | Code[20] | Specifies the number of the bank account that has been reconciled with this Bank Account Statement. | TableRelation Table 270 “Bank Account” (Bank Account); NotBlank |
| 2 | Statement No. Δ BC28 | Code[20] | Specifies the number of the bank’s statement that has been reconciled with the bank account. | NotBlank |
| 3 | Statement Ending Balance Δ BC28 | Decimal | Specifies the ending balance on the bank’s statement that has been reconciled with the bank account. | |
| 4 | Statement Date Δ BC28 | Date | Specifies the date on the bank’s statement that has been reconciled with the bank account. | |
| 5 | Balance Last Statement Δ BC28 | Decimal | Specifies the ending balance on the bank account statement from the last posted bank account reconciliation. | not editable |
| 50 | Bank Account Name Δ BC28 | Text[100] | Specifies the name of the bank account that has been reconciled. | FlowField: lookup(“Bank Account”.Name where(“No.” = field(“Bank Account No.”))) |
| 100 | G/L Balance at Posting Date | Decimal | — | not editable |
| 101 | Outstd. Payments at Posting | Decimal | Outstanding Payments at Posting Date caption | not editable |
| 102 | Outstd. Transact. at Posting | Decimal | Outstading Bank Transactions at Posting Date caption | not editable |
| 103 | Total Pos. Diff. at Posting | Decimal | Total Positive Difference at Posting Date caption | not editable |
| 104 | Total Neg. Diff. at Posting | Decimal | Total Negative Difference at Posting Date caption | not editable |
Keys
- Key1: Bank Account No., Statement No. (clustered)
Procedures
1 local procedures, no public ones.
Triggers
OnDelete, OnRename
Relations
- lookup page Page 389 “Bank Account Statement List”
- Bank Account Name: CalcFormula Table 270 “Bank Account”
- Bank Account No.: TableRelation Table 270 “Bank Account”
Referenced by
2 fields in 2 objects relate to this table (TableRelation or CalcFormula).
- Table 1693 “Bank Acc. Comment Line”: No.
- Table 276 “Bank Account Statement Line”: Statement No.
Pages and codeunits on this table
- Page 1300 “Pmt. Rec. Undo Statement” (source table)
- Page 383 “Bank Account Statement” (source table)
- Page 389 “Bank Account Statement List” (source table)
- Codeunit 1340 “Undo Bank Statement (Yes/No)” (codeunit runs on it)
- Codeunit 382 “BankAccStmtLines-Delete” (codeunit runs on it)
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 382 “BankAccStmtLines-Delete” (1 call:
OnDelete → (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: "Bank Account Statement"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.