Table 273 Bank Acc. Reconciliation

Base Application, Microsoft.Bank.Reconciliation

Source AL, 1,099 lines

src/Layers/W1/BaseApp/Bank/Reconciliation/BankAccReconciliation.Table.allines 27 to 42 of 1,099, Copyright (c) Microsoft Corporation. MIT

table 273 "Bank Acc. Reconciliation"{    Caption = 'Bank Acc. Reconciliation';    DataCaptionFields = "Bank Account No.", "Statement No.";    LookupPageID = "Bank Acc. Reconciliation List";    Permissions = TableData "Bank Account" = rm,                  TableData "Data Exch." = rimd;    DataClassification = CustomerContent;    fields    {        /// <summary>        /// Bank account number that this reconciliation statement relates to.        /// Links the reconciliation to a specific bank account and drives currency and setup inheritance.        /// </summary>        field(1; "Bank Account No."; Code[20])

All 1,099 lines

Fields 27 in 29

1Bank Account No.Code[20]17-29
2Statement No.Code[20]17-29
3Statement Ending BalanceDecimal17-29
4Statement DateDate17-29
5Balance Last StatementDecimal17-29
6Bank StatementBlob17-29
7Total Balance on Bank AccountDecimal17-29
8Total Applied AmountDecimal17-29
9Total Transaction AmountDecimal17-29

All 30 fields in 17-29

Events 8 in 29

[IntegrationEvent] OnAfterValidateShortcutDimCode(var BankAccReconciliation: Record "Bank Acc. Reconciliation"; var xBankAccReconciliation: Record "Bank Acc. Reconciliation"; FieldNumber: Integer; var ShortcutDimCode: Code[20])17-29
[IntegrationEvent] OnBeforeImportAndProcessToNewStatement(var BankAccReconciliation: Record "Bank Acc. Reconciliation"; var DataExch: Record "Data Exch."; var DataExchDef: Record "Data Exch. Def"; var IsHandled: Boolean)17-29
[IntegrationEvent] OnBeforeOpenWorksheetFromProcessStatement(var BankAccReconciliation: Record "Bank Acc. Reconciliation"; var IsHandled: Boolean)17-29
[IntegrationEvent] OnBeforeValidateShortcutDimCode(var BankAccReconciliation: Record "Bank Acc. Reconciliation"; var xBankAccReconciliation: Record "Bank Acc. Reconciliation"; FieldNumber: Integer; var ShortcutDimCode: Code[20])17-29
[IntegrationEvent] OnBeforeMatchSingle(var BankAccReconciliation: Record "Bank Acc. Reconciliation"; DateRange: Integer; var IsHandled: Boolean)new in 19
[IntegrationEvent] OnAfterInitDefaultDimensionSources(var BankAccReconciliation: Record "Bank Acc. Reconciliation"; var DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])new in 20
[IntegrationEvent] OnCreateDimOnAfterSetDimensionSetID(var BankAccReconciliation: Record "Bank Acc. Reconciliation"; OldDimSetID: Integer; DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])new in 20

All 9 events in 17-29

Public procedures 18 in 29

MatchSingle(DateRange: Integer)17-29
ImportBankStatement()17-29
ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])17-29
ShowDocDim()17-29
OpenNewWorksheet()17-29
ImportAndProcessToNewStatement()17-29

All 22 procedures in 17-29

Trigger events 10

OnBeforeInsertEvent(var Rec: Record "Bank Acc. Reconciliation"; RunTrigger: Boolean)
OnAfterInsertEvent(var Rec: Record "Bank Acc. Reconciliation"; RunTrigger: Boolean)
OnBeforeModifyEvent(var Rec: Record "Bank Acc. Reconciliation"; var xRec: Record "Bank Acc. Reconciliation"; RunTrigger: Boolean)
OnAfterModifyEvent(var Rec: Record "Bank Acc. Reconciliation"; var xRec: Record "Bank Acc. Reconciliation"; RunTrigger: Boolean)
OnBeforeDeleteEvent(var Rec: Record "Bank Acc. Reconciliation"; RunTrigger: Boolean)
OnAfterDeleteEvent(var Rec: Record "Bank Acc. Reconciliation"; RunTrigger: Boolean)
OnBeforeRenameEvent(var Rec: Record "Bank Acc. Reconciliation"; var xRec: Record "Bank Acc. Reconciliation"; RunTrigger: Boolean)
OnAfterRenameEvent(var Rec: Record "Bank Acc. Reconciliation"; var xRec: Record "Bank Acc. Reconciliation"; RunTrigger: Boolean)
OnBeforeValidateEvent(var Rec: Record "Bank Acc. Reconciliation"; var xRec: Record "Bank Acc. Reconciliation"; CurrFieldNo: Integer)
per field, ElementName: field name
OnAfterValidateEvent(var Rec: Record "Bank Acc. Reconciliation"; var xRec: Record "Bank Acc. Reconciliation"; CurrFieldNo: Integer)
per field, ElementName: field name

Changes 3 in 26

List17181920212223242526272829
Fields25133
Procedures132111
Events141
field(27; "Total Applied Amount Payments"; Decimal)gone after 25
gone
field(31; "Total Positive Difference"; Decimal)gone after 25
gone
field(32; "Total Negative Difference"; Decimal)gone after 25
gone

All 29 changes in 17-29