Table 273 Bank Acc. Reconciliation

Base Application, Microsoft.Bank.Reconciliation

30 fields

IdNameTypeVersions
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
10Total Unposted Applied AmountDecimal17-29
11Total DifferenceDecimal17-29
12Total Paid AmountDecimalnew in 20
13Total Received AmountDecimalnew in 20
20Statement TypeEnum "Bank Acc. Rec. Stmt. Type"17-29changed in 23
21Shortcut Dimension 1 CodeCode[20]17-29
22Shortcut Dimension 2 CodeCode[20]17-29
23Post Payments OnlyBoolean17-29
24Import Posted TransactionsOption17-29
25Total Outstd Bank TransactionsDecimal17-29
26Total Outstd PaymentsDecimal17-29
27Total Applied Amount PaymentsDecimalgone after 25
Removed, tag 24.0, obsolete since 21: 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
28Bank Account Balance (LCY)Decimal17-29
29Total Positive AdjustmentsDecimal17-29
30Total Negative AdjustmentsDecimal17-29
31Total Positive DifferenceDecimalgone after 25
Removed, tag 24.0, obsolete since 21: Difference is now tracked manually instead. Type field was redundant and error prone.
32Total Negative DifferenceDecimalgone after 25
Removed, tag 24.0, obsolete since 21: Difference is now tracked manually instead. Type field was redundant and error prone.
33Copy VAT Setup to Jnl. LineBoolean17-29
50Bank Account NameText[100]new in 21
51Allow Duplicated TransactionsBooleannew in 21
480Dimension Set IDInteger17-29