Table 273 Bank Acc. Reconciliation in 23

Jonas Paprotka, Base Application 23.5.16502.31399, checked 2026-09-20

Source29

Fields, 30

Id	Name	Type	Obsolete
1	Bank Account No.	Code[20]	-
2	Statement No.	Code[20]	-
3	Statement Ending Balance	Decimal	-
4	Statement Date	Date	-
5	Balance Last Statement	Decimal	-
6	Bank Statement	Blob	-
7	Total Balance on Bank Account	Decimal	-
8	Total Applied Amount	Decimal	-
9	Total Transaction Amount	Decimal	-
10	Total Unposted Applied Amount	Decimal	-
11	Total Difference	Decimal	-
12	Total Paid Amount	Decimal	-
13	Total Received Amount	Decimal	-
20	Statement Type	Enum Bank Acc. Rec. Stmt. Type	-
21	Shortcut Dimension 1 Code	Code[20]	-
22	Shortcut Dimension 2 Code	Code[20]	-
23	Post Payments Only	Boolean	-
24	Import Posted Transactions	Option	-
25	Total Outstd Bank Transactions	Decimal	-
26	Total Outstd Payments	Decimal	-
27	Total Applied Amount Payments	Decimal	Pending 21.0
Type is not used to determine if the bank rec. line is associated to a CLE, instead find explicitly CLEs with their corresponding BLE No. . See BankAccReconTest codeunit TotalOutstandingPayments for an example
28	Bank Account Balance (LCY)	Decimal	-
29	Total Positive Adjustments	Decimal	-
30	Total Negative Adjustments	Decimal	-
31	Total Positive Difference	Decimal	Pending 21.0
Difference is now tracked manually instead. Type field was redundant and error prone.
32	Total Negative Difference	Decimal	Pending 21.0
Difference is now tracked manually instead. Type field was redundant and error prone.
33	Copy VAT Setup to Jnl. Line	Boolean	-
50	Bank Account Name	Text[100]	-
51	Allow Duplicated Transactions	Boolean	-
480	Dimension Set ID	Integer	-

Name	Fields	Obsolete
Key1, clustered	Statement Type, Bank Account No., Statement No.	-

Name	Parameters	Returns	Access	Obsolete
MatchSingle	(Integer)		public	-
ImportBankStatement	()		public	-
ValidateShortcutDimCode	(Integer, var Code[20])		public	-
ShowDocDim	()		public	-
OpenNewWorksheet	()		public	-
ImportAndProcessToNewStatement	()		public	-
ImportStatement	(var Record Bank Acc. Reconciliation, Record Data Exch.)	Boolean	public	-
ProcessStatement	(var Record Bank Acc. Reconciliation)		public	-
CreateNewBankPaymentAppBatch	(Code[20], var Record Bank Acc. Reconciliation)		public	-
SelectBankAccountToUse	(var Record Bank Account, Boolean)	Boolean	public	-
OpenWorksheet	(Record Bank Acc. Reconciliation)		public	-
OpenList	(Record Bank Acc. Reconciliation)		public	-
SetFiltersOnBankAccReconLineTable	(Record Bank Acc. Reconciliation, var Record Bank Acc. Reconciliation Line)		public	-
DrillDownOnBalanceOnBankAccount	()		public	-
MatchCandidateFilterDate	()	Date	public	-
CreateDim	(List)		public	-
CreateDimFromDefaultDim	()		public	-
GetPaymentRecJournalTelemetryFeatureName	()	Text	internal	-
GetBankReconciliationTelemetryFeatureName	()	Text	internal	-
CreateBankAccountReconcillation	()		public	-

Kind	Name	Parameters	Obsolete
Integration event	OnAfterValidateShortcutDimCode	(var Record Bank Acc. Reconciliation, var Record Bank Acc. Reconciliation, Integer, var Code[20])	-
Integration event	OnBeforeImportAndProcessToNewStatement	(var Record Bank Acc. Reconciliation, var Record Data Exch., var Record Data Exch. Def, var Boolean)	-
Integration event	OnBeforeOpenWorksheetFromProcessStatement	(var Record Bank Acc. Reconciliation, var Boolean)	-
Integration event	OnBeforeValidateShortcutDimCode	(var Record Bank Acc. Reconciliation, var Record Bank Acc. Reconciliation, Integer, var Code[20])	-
Integration event	OnBeforeMatchSingle	(var Record Bank Acc. Reconciliation, Integer, var Boolean)	-
Integration event	OnAfterInitDefaultDimensionSources	(var Record Bank Acc. Reconciliation, var List)	-
Integration event	OnCreateDimOnAfterSetDimensionSetID	(var Record Bank Acc. Reconciliation, Integer, List)	-
Integration event	OnUpdateAllLineDimOnAfterUpdateGlobalDimFromDimSetID	(var Record Bank Acc. Reconciliation Line)	-