Table 273 Bank Acc. Reconciliation in 20

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

Source29

Fields, 28

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	Option	-
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	-
28	Bank Account Balance (LCY)	Decimal	-
29	Total Positive Adjustments	Decimal	-
30	Total Negative Adjustments	Decimal	-
31	Total Positive Difference	Decimal	-
32	Total Negative Difference	Decimal	-
33	Copy VAT Setup to Jnl. Line	Boolean	-
480	Dimension Set ID	Integer	-

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

Name	Parameters	Returns	Access	Obsolete
CreateDim	(Integer, Code[20])		public	Pending 20.0
Replaced by CreateDim(DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])
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	-

Kind	Name	Parameters	Obsolete
Integration event	OnAfterCreateDimTableIDs	(var Record Bank Acc. Reconciliation, var Integer, var Integer, var Code[20])	Pending 20.0
Temporary event for compatibility
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)	-